转载：设立mysql的远程访问

转载：设置mysql的远程访问

1.登陆Mysqlmysql -u root -p2.允许任何IP访问,其中密码为admingrant all privileges on *.* to root@"%" identified by "admin" with grant option;3.允许特定IP访问,其中密码为admingrant all privileges on *.* to root@"192.168.0.1" identified by "passw0rd" with grant option; flush privileges;