授权指定ip访问访问
授权ROOT使用密码1234从应用服务器主机连接到mysql服务器
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'xxx.xxx.xxx.xxx' IDENTIFIED BY '1234' WITH GRANT OPTION;
mysql> flush privileges;
mysql授权任意地址访问
授权ROOT使用1234从任何主机连接到mysql服务器
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIEDBY '1234'WITH GRANT OPTION;
mysql> flush privileges;