1、设置mysql服务允许外网访问
修改mysql的配置文件,有的是my.ini,有的是my.cnf【linux】,找到bind-address变量,这个值默认是127.0.0.1,设置为0.0.0.0;重新启动mysql服务。
- service mysql stop
- service mysql start
2、设置mysql用户支持外网访问
root权限登录mysql,更新mysql.user表,设置指定用户的Host字段为%,默认一般为127.0.0.1或者localhost
- Host字段说明:
- % 允许从任何ip登录
- X.X.X.X 允许从指定的ip访问
- mysql -u root -pvmwaremysql>use mysql;
- mysql>update user set host = '%' where user ='root';
- mysql>select host, user from user;
- mysql>flush privileges;
任意主机以用户root和密码mypwd连接到mysql服务器
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypwd' WITH GRANT OPTION;
mysql> flush privileges;
IP为192.168.1.102的主机以用户myuser和密码mypwd连接到mysql服务器
mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.102' IDENTIFIED BY 'mypwd' WITH GRANT OPTION;
mysql> flush privileges;