服务器：ubuntu server 16.04 LSS

客户机：ubuntu 16.04 LTS

服务器配置

服务器安装mysql

# eric @ userver in ~ [14:00:31]
$ sudo apt install mysql-server install mysql-client libmysqlclient-dev

检查是否成功SET PASSWORD FOR ‘pig'@'%' = PASSWORD(“123456”);

# eric @ userver in ~ [14:10:55]
$ sudo netstat -tap / grep mysql
tcp 0 0 localhost:mysql *:* LISTEN 5287/mysqld

修改远程连接配置文件

# eric @ userver in ~ [14:16:26]
$ sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
#注释掉 bind-address = 127.0.0.1