树莓派4b使用centos8安装mysql以及2003错误问题

1.安装mysql和mysql-server

yum -y install mysql-server mysql mysql-devel

2.启动mysql

启动

systemctl start mysqld.service

查看启动状态

systemctl status mysqld.service

3.空密码登录root

查询root初始密码

grep "password" /var/log/mysql/mysqld.log

改密码

use mysql;

alter user 'root'@'localhost' identified with mysql_native_password by '123456';

update user set Host='%' where User='root';

commit;

FLUSH PRIVILEGES;

4.sqlyog远程连接报2003错误代码

关闭防火墙

service firewalld stop