ubuntu安装mysql，配置root用户密码，配置远程登录

1. 安装mysql

sudo apt update
sudo apt install mysql-server

2. 查看mysql运行状态

sudo systemctl status mysql

3. 设置开机自启动

sudo systemctl enable mysql

4. 进入mysql配置root用户密码，配置远程登录

sudo mysql

use mysql;
select host,user from user;
# 配置root远程登录
update user set host='%' where user='root';
# 配置root用户密码为123456
alter user root@'%' identified with mysql_native_password by '123456';
# 退出mysql命令行
exit;

# 使用root账号密码登录
mysql -u root -p
# 如果出现报错ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)使用一下命令
mysql -u root -h 127.0.0.1 -p

use mysql;
# 刷新配置立即生效
flush privileges;
exit;

# 使用localhost可以连接
telnet localhost 3306
# 发现使用ip连接不行
telnet 10.80.80.215 3306

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
# 修改绑定地址
bind-address            = 0.0.0.0
mysqlx-bind-address     = 0.0.0.0

# 重启mysql
sudo systemctl restart mysql
# 使用ip可以连接
telnet 10.80.80.215 3306