ubuntu16.04上安装mysql

执行命令

1. sudo apt-get install mysql-server
2. apt-get isntall mysql-client
3.  sudo apt-get install libmysqlclient-dev

查看是否安装成功

sudo netstat -tap | grep mysql

看到有mysql 的socket处于 listen 状态则表示安装成功

编辑mysql配置文件，把其中bind-address = 127.0.0.1注释了

vi /etc/mysql/mysql.conf.d/mysqld.cnf 

设置远程连接

mysql -u root -p       
mysql> use mysql; 
mysql> select 'host' from user where user='root';
mysql> update user set host = '%' where user = 'root';
mysql> flush privileges;
mysql> select 'host' from user where user='root';

重启mysql

/etc/init.d/mysql restart

资料来源参考
在ubuntu16.04上安装mysql
linux下安装mysql