MySQL改

mysql> use mysql;

mysql> update user set host = ‘%’ where user =’root’;

mysql> flush privileges;

mysql> exit

5.7 创建用户并允许远程

mysql> GRANT ALL PRIVILEGES ON *.* TO ‘me’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;

mysql8

mysql> CREATE USER ‘me’@’%’ IDENTIFIED BY ‘password’;

mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ WITH GRANT OPTION;

mysql> FLUSH PRIVILEGES;

mysql> use mysql;

mysql> select host,user,plugin from user;