Ubuntu16.04 安装mysql5.7

安装mysql

sudo apt-get install mysql-server
sudo apt install mysql-client
sudo apt install libmysqlclient-dev

开放远程访问

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

注释掉bind-address = 127.0.0.1

进入mysql，授予root用户在任何主机（%）访问任何数据库（.）的所有权限（ALL PRIVILEGES）

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;
flush privilege;