操作系统版本： openEuler 24.03 LTS

前置部署

openEuler操作系统部署-CSDN博客

1、升级系统内核和软件

yum -y update

reboot

2、部署MySQL

yum -y install vim tar net-tools 
sudo yum -y install https://repo.mysql.com//mysql84-community-release-el9-1.noarch.rpm
sudo yum repolist enabled | grep mysql
sudo yum -y install mysql-community-server

3、启动MySQL

sudo systemctl start mysqld
sudo systemctl status mysqld
sudo systemctl enable mysqld

4、查看初始密码

sudo grep 'temporary password' /var/log/mysqld.log

5、登录MySQL

通过使用生成的临时密码登录并为超级用户帐户设置自定义密码，尽快更改 root 密码：

mysql -uroot -p

6、设置登陆密码复杂度

set global validate_password.length=4;
set global validate_password.policy=0;
SHOW VARIABLES LIKE 'validate_password%'; 

7、修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123';
flush privileges;

8、开放所有IP都能访问

use mysql;
select host, user, authentication_string, plugin from user;
CREATE USER 'root'@'%' IDENTIFIED BY 'root123';
grant all privileges ON *.* to 'root'@'%' with grant option;
flush privileges;

9、修改加密方式

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root123';
select host, user, authentication_string, plugin from user;

10、重启数据库

quit
systemctl restart mysqld.service

或：

systemctl start mysqld

设置开机自启动

systemctl enable mysqld.service

11、远程navicat连接测试

FAQ:

1、ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded

执行第九步更改加密方式出现以上问题

解决方案：

a、跳过（不受影响），密码无非是设置复杂一些，也是官方推荐

b、修改配置，参考地址

mysql8.4版本mysql_native_password无法连接问题处理-CSDN博客