Ubuntu20.04 配置mysql

1.配置root密码
use mysql;
UPDATE user SET plugin=‘mysql_native_password’ WHERE User=‘root’;

SHOW VARIABLES LIKE ‘validate_password%’;
set global validate_password.policy=LOW;
set global validate_password.length=6;
SET PASSWORD = ‘123456’;
FLUSH PRIVILEGES;

2.配置远程登录
mysql> create user ‘root’@’%’ identified by ‘你自己的mysql密码’;
mysql> grant all privileges on . to ‘root’@’%’;
mysql> flush privileges;

重启服务
修改配置文件
cd /etc/mysql/mysql.conf.d
vi mysqld.cnf
把bind 改成0.0.0.0