1.首先开启ssh允许root登录:
ee /etc/ssh/sshd_config
permitrootlogin yes (可能用到的crtl+y)
service sshd restart
2.安装mysql
pkg install -y mysql56-server
2.开启mysql
ee /etc/rc.conf
mysql_enable = "YES"
service mysql-server start
3.设置允许远程链接
mysql -u -root
update user set host = '192.168.1.188(可以是%即允许所有ip访问)' where user = 'root';
4.测试远程连接
在ip为192.168.1.188的web服务器上安装mysql的cilent端
pkg install -y mysql56-cilent
rehash
mysql -u root -h 192.168.1.168 -p
能够显示数据库表即为操作正确