mysql
浮生若水11100
.......
展开
-
mysql 开放远程访问
1.mysql> use mysql2.mysql> update db set host = '%' where user = 'root';3.mysql> flush privileges;4.mysql> grant all privileges on *.* to 'yourusername'@'%' identified by 'yourpassword' with gra原创 2017-11-08 10:09:26 · 195 阅读 · 0 评论 -
mysql “Host is blocked because of many connection errors”
1.提高允许的max_connection_errors数量,首先查看该属性设置为多大 命令:show global variables like '%max_connect_errors%';2.当客户端连接服务端超时(超过connect_timeout), 服务端就会给这个客户端记录一次error,当出错的次数达到max_connect_errors的时候,这个客户端就会被锁定。所以根转载 2017-12-05 10:56:57 · 487 阅读 · 0 评论