1. 下載 mysql 離線包
下載mysql 離線包：mysql-5.7.32-1.el7.x86_64.rpm-bundle.tar
官網地址：https://dev.mysql.com/downloads/mysql/
2. 上傳解壓
我的上傳解壓路徑：/home/mysql
tar -xvf mysql-5.7.32-1.el7.x86_64.rpm-bundle.tar
3. 查詢并卸載系統(tǒng)自帶的Mariadb
rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
4. 解壓包安裝
rpm -ivh mysql-community-common-5.7.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.32-1.el7.x86_64.rpm
5. 啟動mysql 服務
查看mysql服務是否啟動(默認沒有啟動藐石，需要手動啟動)
service mysqld status
啟動服務：
systemctl start mysqld
6. 查看生產隨機密碼
MySQL5.7會在安裝后為root用戶生成一個隨機密碼排抬，而不是像以往版本的空密碼都弹。 可以安全模式修改root登錄密碼或者用隨機密碼登錄修改密碼珠月。下面用隨機密碼方式
MySQL為root用戶生成的隨機密碼通過mysqld.log文件可以查找到：
grep 'temporary password' /var/log/mysqld.log
7. 修改用戶密碼
mysql> set password = password("Szfore_68638");
或者方式二：
alter user 'root'@'localhost' identified by '123456';
如果出現(xiàn)以下錯誤：
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
解決方案：
set global validate_password_policy=0;
set global validate_password_length=1;
8. 如果上面的方式不能修改可以使用下面安全模式修改root
編輯 vim /etc/my.cnf 添加
skip-grant-tables
systemctl restart mysqld.service
進入mysql ，通過下面語句修改數(shù)據(jù)庫
alter user 'root'@'localhost' identified by '123456';
9. 開發(fā)遠程訪問權限
mysql> use mysql;
Database changed
mysql> grant all privileges on *.* to root@'%' identified by "password";
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
grant all privileges on . to root@'%' identified by "password"; password 需要修改為自己的密碼
10. 防火墻配置3306端口允許外部訪問
查詢防火墻狀態(tài) systemctl status firewalld.service
開啟防火墻mysql 3306端口的外部訪問：
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
或者直接關閉防火墻：
systemctl stop firewalld.service
參考文檔：
https://blog.csdn.net/weixin_41238134/article/details/99707670
https://www.cnblogs.com/weifeng1463/p/7941625.html
https://blog.csdn.net/ai_64/article/details/100557530
