1.進(jìn)入mysql數(shù)據(jù)庫
mysql>update user set password=PASSWORD(‘123456’) where User='root';
2.執(zhí)行語句
mysql -u root –p
use mysql;
update user set host = '%' where user = 'root';
select host, user from user;
3.授權(quán)烙无。
例如，你想root使用密碼123456從任何主機(jī)連接到mysql服務(wù)器瞳浦。
GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
