rockylinux8安装mysql8

1：安装mysql8官方仓库

dnf install -y https://dev.mysql.com/get/mysql80-community-release-el8-4.noarch.rpm

2：检查mysql仓库情况

[root@localhost ~]# dnf repolist all | grep mysql

3：禁用 MySQL 模块过滤

dnf module disable mysql -y

4：导入较新的GPG

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023

5：安装Mysql

dnf install -y mysql-community-server   #默认安装的是8.0.32

dnf install -y mysql-community-server-8.2.*    #指定安装mysql8.2

6：启动数据库

systemctl start mysqld

7：查初始密码

grep pass /var/log/mysqld.log

8：修改初始密码

mysql> alter user 'root'@'localhost' identified by 'Zhongguo@0755';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

###非交互式修改 
[root@liuguohua ~]# mysqladmin -u'root' -p'r#q=vg5eo<)C' password 'liuguohua@com123'

9：新建一个远程管理帐户

CREATE USER 'liuguohua'@'%' IDENTIFIED BY 'Zhongguo@0755';
GRANT ALL PRIVILEGES ON *.* TO 'liuguohua'@'%' WITH GRANT OPTION;
flush privileges;