1首先通过密码登录 2. ``` use mysql; select host,user from user; update user set host='%' where user ='root'; FLUSH PRIVILEGES; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION; ...
1首先通过密码登录 2. ``` use mysql; select host,user from user; update user set host='%' where user ='root'; FLUSH PRIVILEGES; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION; ...
设置请求头 封装axios的时候，给它全局设置 application/x-www-form-urlencoded 或者application/json;charset=utf-8 ``` axios.defaults.baseURL = 'https://www.172u.cn'; axios.defaults.headers.common['Authorization'] = ...
配置这情况默认就会自动分流到这2台服务器上 server 127.0.0.1:8080; server 127.0.0.2:8080; ``` # 反向代理配置 upstream server_list{ # 这个是tomcat的访问路径 server 127.0.0.1:8080; server 127.0.0.2:8080;...
先查询 ``` SELECT CONCAT('KILL ', id, ';') AS kill_statement FROM information_schema.processlist WHERE command = 'Sleep' AND time > 50; ``` 后复制 运行 ![1.png][1] 然后把kill复制出来运行 [1]: https://w...
这样假如程序写的不够完善会出现大量sleep超过几千的进程，这样会引起性能变差，链接中断, 所以建议如下修改. 全局和会话变量一起改 具体多少变量自己决定。 ``` show VARIABLES like '%timeout%' ; set wait_timeout=600; set interactive_timeout=600; set global wait_time...