openEuler操作系统部署MySQL8

操作系统版本： 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连接测试