655 阿里云技术社区[云栖]

更改mysql连接权限

/usr/local/mysql/bin/mysql -u root -p

mysql> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> update user set host='%' where user='mysql' limit 1;

Query OK, 0 rows affected (0.01 sec)

Rows matched: 0 Changed: 0 Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

最后更新：2017-08-13 22:42:10