• 登錄mysql

mysql -P 端口號 -h 主機\IP -u root -p;

• 選擇數據庫

use mysql;

• 查看現有用戶

SELECT HOST,USER,PASSWORD FROM USER;

• 修改數據

UPDATE USER SET HOST='%' WHERE HOST=''

• 授權法

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.100' IDENTIFIED BY '密碼' WITH GRANT OPTION;

• 刷新

flush privileges;