ubuntu16安装MySQL
ubuntu16安装MySQL
sudo apt-get install mysql-server
sudo apt install mysql-client
sudo apt install libmysqlclient-dev
登陆
mysql -uroot -p你的密码
设置mysql允许远程访问
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
注释掉bind-address = 127.0.0.1
保存退出，然后进入mysql服务，执行授权命令
rant all on . to [email protected]’%’ identified by ‘你的密码’ with grant option;
flush privileges;
重启mysql
service mysql restart
外部连接mysql
连接成功