1. SQL服务端
只需要一行命令:
apt-get install mysql-server
,安装过程中还需要设置root用户的密码
2. 更改root用户绑定的连接地址
- 登陆MySQL数据库:
,输入刚刚设置的密码后登陆进数据库mysql -u root -p
- 更新权限:
mysql> grant all privileges on *.* to 'root'@'%' identified by '*你的密码*' with grant option;
- 刷新权限:
mysql>flush privileges;
3. 更改配置文件允许远程ip地址连接
MySQL最新版中和远程ip地址连接有关的配置文件已经改到了
/etc/mysql/mysql.conf.d/mysqld.cnf
所以输入命令:
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
,找到这一段:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# * Fine Tuning
注释掉这一行:
bind-address = 127.0.0.1
,如下:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
#
#* Fine Tuning
4. 最后,重启MySQL: sudo service mysql restart
sudo service mysql restart