ubuntu16.04上安装mysql

执行命令

1. sudo apt-get install mysql-server2. apt-get isntall mysql-client3.  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