mysql远程访问权限

mysql> GRANT ALL PRIVILEGES ON . TO ‘root’ @ ‘192.168.1.100’ IDENTIFIED BY ‘rootpassword’ WITH GRANT OPTION;

mysql> – @’192.168.1.100’可以替换为@‘%’就可任意ip访问

mysql> GRANT ALL PRIVILEGES ON . TO ‘root’ @ ‘%’ IDENTIFIED BY ‘rootpassword’ WITH GRANT OPTION;

mysql>FLUSH PRIVILEGES; –刷新系统权限相关表，重要，一定要执行！！