Win+R ,输入cmd,回车
进入mysql
mysql -uroot -p
运行mysql:
use mysql;
查看用户表:
SELECT `Host`,`User` FROM user;
更新用户表:
UPDATE user SET `Host` = '%' WHERE `User` = 'root'
强制刷新权限:
flush privileges;
Win+R ,输入cmd,回车
mysql -uroot -p
use mysql;
查看用户表:
SELECT `Host`,`User` FROM user;
更新用户表:
UPDATE user SET `Host` = '%' WHERE `User` = 'root'
强制刷新权限:
flush privileges;