Centos7.4 RPM 安裝 MySQL8.0.17

隻是安裝用于測試，沒有進行MySQL相關配置。

1. 解除安裝原裝SQL

rpm -qa | grep mariadb 
# mariadb-libs-5.5.52-1.el7.x86_64 

rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64 
rpm -qa | grep mysql           

2. 安裝

順序 ：common - libs - client - server

mysql-community-common-8.0.15-1.el7.x86_64.rpm 
mysql-community-libs-8.0.15-1.el7.x86_64.rpm 
mysql-community-client-8.0.15-1.el7.x86_64.rpm 
mysql-community-server-8.0.15-1.el7.x86_64.rpm           

3. 啟動

systemctl start mysqld 

# 開機啟動
systemctl enable mysqld           

4. 檢視臨時密碼

如果之前已經啟動過，但是沒有密碼，那麼先停止mysqld服務，删除日志檔案再啟動。

systemctl stop mysqld 

# 查找檔案 
find / -name mysql -print 

# 删除檔案 
rm -rf /var/log/mysqld.log 
rm -rf /var/lib/mysql 
rm -rf /usr/lib64/mysql 

# 重新開機 
systemctl start mysqld 

# 檢視密碼 
grep 'temporary password' /var/log/mysqld.log            

# 2020-07-08T19:04:43.896899Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ?#FYjMp;X3F/

5. 登入

mysql -uroot -p
#Enter password:            

6. 修改密碼

alter user 'root'@'localhost' identified by '123456';           

 提示密碼過于簡單

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

調整密碼強度後再設定 

# 設定密碼強度低
set global validate_password_policy=0;
 
# 設定密碼長度，最少4位
set global validate_password_length=4;           

use mysql; 
update user set host = "%" where user='root'; 
flush privileges;
quit;