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