MySQL的一些常用命令
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)限表,使配置生效

浙公網(wǎng)安備 33010602011771號