1.将root用户设置为任意IP地址都可以访问
mysql> grant all privileges on *.* to 'root'@'%';
mysql> flush privileges;
2.设置root用户的远程访问密码为"111111"
mysql> grant all privileges on *.* to 'root'@'%' identified by '111111';
mysql> flush privileges;
1.将root用户设置为任意IP地址都可以访问
mysql> grant all privileges on *.* to 'root'@'%';
mysql> flush privileges;
2.设置root用户的远程访问密码为"111111"
mysql> grant all privileges on *.* to 'root'@'%' identified by '111111';
mysql> flush privileges;
本文标题:3.配置MySQL网络访问权限
本文链接:https://www.haomeiwen.com/subject/faoklqtx.html
网友评论