咨询热线:4006-75-4006
售前:9:00-23:30 备案:9:00-18:00 技术:7*24h
1.一般是为使用下面的命令
Mysql>use mysql;
Mysql>update user set host='%' where user='root';
Mysql>flush privileges
2.也可以执行下面命令
USE mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
flush privileges;
3.最后查看主机栏是否为%
Mysql> select host,user from user;