转载:设立mysql的远程访问

转载:设置mysql的远程访问

1.登陆Mysql
mysql -u root -p
2.允许任何IP访问,其中密码为admin
grant all privileges on *.* to root@"%" identified by "admin" with grant option;
3.允许特定IP访问,其中密码为admin
grant all privileges on *.* to root@"192.168.0.1" identified by "passw0rd" with grant option; flush privileges;
转载:设立mysql的远程访问

相关文章:

你感兴趣的文章:

标签云: