1、修改localhost

更改 “mysql” 数据库里的 “user” 表里的 “host” 项，从“localhost”改成“%”

mysql>use mysql;

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

mysql>select host, user from user;

mysql>FLUSH PRIVILEGES;

2、指定授权

mysql -h localhost -u root

mysql>GRANT ALL ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘root’; //赋予任何主机上以root身份访问数据的权限

mysql>FLUSH PRIVILEGES;

打赏

微信扫一扫，打赏作者吧～

本文固定链接: https://www.cxy163.net/archives/880 | 绝缘体