centos8 下mysql安装后配置远程登录和修改密码

//开启远程登录

//如果防火墙是开启状态的话，那我们先需要打开端口，才能远程登录，使用下面命令开放指定端口，然后重启防火墙
//允许3306端口通过防火墙

[root@localhost local]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
[root@localhost local]# firewall-cmd --reload

select host,user,authentication_string,plugin from user;

//设置可以远程访问
update user set host = "%" where user = "root";

//设置root的密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root_passwd';

//设置MySQL服务开机不启动
systemctl disable mysqld.service
//设置MySQL服务开机不启动
systemctl enable mysqld.service