1.安裝wget

?yum install -y wget

【資料圖】

2、下載rpm安裝包

[root@nifi1 home]# wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

2.1 yum安裝mysql 5.7

yum -y install mysql57-community-release-el7-10.noarch.rpm

2.2yum安裝mysql-community-server

yum -y install mysql-community-server

安裝失敗由于MySQL GPG 密鑰已過期導致的需要運行命令, 以2022年為例

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

yum -y install mysql-community-server

至此yum安裝MySQL服務結束！

3.MySQL數據庫設置

3.1啟動MySQL

systemctl start mysqld.service

3.2查看MySQL運行狀態

systemctl status mysqld.service

4.在日志文件中找出密碼

grep "password" /var/log/mysqld.log

5.進入數據庫

mysql -uroot -p # 回車后會提示輸入密碼

6.在日志文件中找出密碼

grep "password" /var/log/mysqld.log

7.進入數據庫

mysql -uroot -p # 回車后會提示輸入密碼

8.設置mysql密碼

8.1修改變更，便于修改簡單密碼

set global validate_password_policy=0;

set global validate_password_length=1;

8.2修改密碼

ALTER USER "root"@"localhost" IDENTIFIED BY "root";

8.3遠程授權，便于使用navicat等遠程客戶端連接

grant all on *.* to root@"%" identified by "root";

9.登錄測試

mysql -uroot -p