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; –刷新系统权限相关表,重要,一定要执行!!