mysql开放远程连接权限

1.开放远程登录权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

2.刷新权限

FLUSH PRIVILEGES;