【一】Linux安装mysql
环境ubuntu16.04
apt-get install mysql-server
apt install mysql-client
apt install libmysqlclient-dev
验证mysql工作状态
systemctl status mysql.service
netstat -tap | grep mysql
修改配置文件
vi /etc/mysql/mysql.conf.d/mysqld.cnf
注释掉bind-address = 127.0.0.1
#bind-address = 127.0.0.1
登录交互界面
mysql -u root -p
授权
grant all privileges on *.* to 'root'@'%' identified by '密码' with grant option
flush privileges;
exit;
退出mysql
重启mysql
测试远程连接