mysql -u root -h localhost -p #登錄

use mysql; #打開mysql數(shù)據(jù)庫

select host,user from user where user='root'; #查看user表里的root數(shù)據(jù)

update user set host='%' where user='root' and host='localhost'; #將host設(shè)置為%表示任何ip都能連接mysql，也可以將host指定為某個ip

update user set host='localhost' where user='root’; #關(guān)閉遠(yuǎn)程連接，重新設(shè)置為localhost

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; #給root進(jìn)行授權(quán)

flush privileges;  #刷新權(quán)限表，使配置生效