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