mysql 1449 The user specified as a definer (‘root’@’%’) does not exist
Published on in Posts
1.登录mysql，执行命令，将权限赋给root
Posts
go 交叉编译
Published on in Posts
armv5
nginx 代理vue项目
Published on in Posts
Updated on
location /h5/ { alias /www/wwwroot/1256/public/h5/; try_files $uri $uri/ /h5/index.html; index index.html index.htm; }
路由器DDNS脚本 获取本机IP ASUS DDNS & CF DDNS
Published on in Posts
Updated on
#!/bin/sh # 获取本机IP ipv4=$(ifconfig 'ppp0' | grep "inet addr" | cut -f 2 -d ":" | cut -f 1 -d " " ) ipv6=$(ifconfig 'ppp0' | grep "inet6 addr" |head -n 1| cut -f 13 -d " "|cut -d'/' -f1) arg="${ipv4}-${ipv6}"
MySQL binlog查看筛选
Published on in Posts
Updated on
查看信息 mysqlbinlog –start-datetime=‘2023-11-01 23:54:21’ –stop-datetime=‘2023-11-01 23:55:21’ -vv -d {databasename} mysql-bin.000004;
MySQL 创建定时任务
Published on in Posts
Updated on
CREATE DEFINER = `swcd1243`@`%` EVENT `1243`.`del_custom` ON SCHEDULE EVERY '1' DAY ON COMPLETION PRESERVE DO update fa_custom set deletetime=2 where lasttime+90*86400<unix_timestamp() and deletetime is null;
shell 进程检测常驻
Published on in Posts
Updated on
ps |grep ffmpeg |grep -v grep if [ $? -ne 0 ] then
MySQL dump
Published on in Posts
mysqldump --column-statistics=0 -uroot -P 3307 -pqwe123456789 ysh_two > heizhu.sql
MySQL JSON查询
Published on in Posts
Updated on
查询json_array包含指定内容
脚本delfile
Published on in Posts
Updated on
#!/bin/sh lastdate=`/opt/bin/date -d "20 days ago" +%Y-%m-%d` echo $lastdate candelfile=`rm -rf /tmp/mnt/media/video/${lastdate}*` echo $candelfile