Ubuntu安装mysql以及配置远程连接

1、安装mysql

apt-get install mysql-server

查看mysql是否安装成功
dpkg -l | grep mysql-server

2、修改mysql root密码

进入mysql
   mysql -u root -p;

进入mysql数据库
   use mysql;

修改root密码
   ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by '密码';

刷新mysql
   flush privileges;

3、配置允许远程连接mysql

先进入mysql数据库，查看当前的root连接host
	select User,Host from user;

允许任意ip远程连接
    update user set host = '%' where user ='root';

退出mysql修改配置文件
    vi /etc/mysql/mysql.conf.d/mysqld.cnf

将bind-address和mysqlx-bind-address改为0.0.0.0 

重启mysql

service mysql restart