MYSQL远程访问设置

mysql远程访问权限设置

方法一：登录mysql直接授权
1.登录命令#mysql -u root -proot 。
2.mysql>GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
例：允许地址172.0.0.1上用root用户，密码dboomysql来连接mysql的所有数据库，付给select,insert,update,delete权限。
命令：GRANT select,insert,update,delete on *.* TO root@”172.0.0.1” IDENTIFIED BY “dboomysql”;

3.操作完之后刷新权限：mysql>FLUSH PRIVILEGES;

方法二：修改mysql中用户表user
mysql>UPDATE user SET host = ‘%’ WHERE user = ‘root’;
mysql>FLUSH PRIVILEGES;