1、在线下载安装包

[root@localhost ~]# wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.4.1-1.el9.x86_64.rpm-bundle.tar

2、新建解压文件夹

[root@localhost ~]#mkdir /root/sql

3、离线解压安装包安装配置MySQL8

上传安装包到home下

[root@localhost ~]#cd /home/

安装配置MySQL8

[root@localhost ~]#tar xf mysql-8.4.1-1.el9.x86_64.rpm-bundle.tar -C /root/sql/

4、安装SQL

[root@localhost ~]#cd /root/sql/

[root@localhost sql]# rpm -ivh mysql-community-* --force --nodeps

5、启动MYSQL，并开机启动

[root@localhost sql]# systemctl start mysqld

[root@localhost sql]# systemctl enable mysqld

6.数据库初始密码

[root@localhost sql]# cat /var/log/mysqld.log | grep password

7.修改简单密码

[root@localhost sql]# mysql -uroot -p

Enter password:

设置root用户密码与远程登录

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Xa%^3T%T4!';

set global validate_password.policy=0;

set global validate_password.length=5;

set global validate_password.mixed_case_count=0;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'rootroot';

flush privileges;

use mysql;

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

flush privileges;

quit