1 網絡下載rpm包
wget -c https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-5.7.37-1.el7.x86_64.rpm-bundle.tar
2 解壓
tar xf mysql-5.7.37-1.el7.x86_64.rpm-bundle.tar
3 數據庫之間會沖突因此需要卸載mariadb-libs
yum remove mariadb-libs
4 安裝
如果沒有net-tools需要先安裝
yum install net-tools -y
rpm -ivh mysql-community-client-5.7.37-1.el7.x86_64.rpm mysql-community-common-5.7.37-1.el7.x86_64.rpm mysql-community-libs-5.7.37-1.el7.x86_64.rpm mysql-community-server-5.7.37-1.el7.x86_64.rpm
5 啟動mysql
systemctl start mysqld
6 臨時密碼登錄并修改密碼
P=`awk '/temporary password/ {print $NF}' /var/log/mysqld.log`
mysql -uroot -p$P
7 登陸進入后,改變MySQL密碼策略(密碼強度默認為中等,大小寫字母、數字、特殊符號,只有修改成功后才能設置更簡單的密碼):
set global validate_password_policy=0;
set global validate_password_length=6;
8 修改root密碼,紅色部分為設置的用戶名和密碼:
alter user 'root'@'localhost' IDENTIFIED BY '12345678';
9 開啟root遠程訪問權限(會降低安全性):
use mysql;
select host,user from user;
update user set host='%' where user='root';
flush privileges;
10 修改/etc/my.cnf文件
vim /etc/my.cnf
[mysqld] 下面添加文件內容:
#設置表名忽略??寫,增加??
lower_case_table_names =1
11 重啟mysql服務
啟動MySQL:
systemctl start mysqld
查看MySQL服務狀態:
systemctl status mysqld
參考:linux系統中三種方法安裝MySQL5.7(rhel7/centos7)