mysql远程授权

• 登录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;