安裝MySQL8
MySQL Community Server 社群版本，開源免費，自由下載，但不提供官方技術支援，適用於大多數普通使用者。
MySQL Enterprise Edition 企業版本，需付費，不能線上下載，可以試用30天。提供了更多的功能和更完備的技術支援，更適合於對資料庫的功能和可靠性要求較高的企業客戶。
MySQL Cluster 叢集版，開源免費。用於架設叢集伺服器，可將幾個MySQL Server封裝成一個Server。需要在社群版或企業版的基礎上使用。
MySQL Cluster CGE 高階叢集版，需付費。
安裝 mysql yum源
[root@web ~]# wget https://repo.mysql.com//mysql84-community-release-el9-1.noarch.rpm
[root@web ~]# yum install ./mysql84-community-release-el9-1.noarch.rpm
[root@web ~]# 安裝成功後，檢視MySQL版本：
[root@web ~]# yum repolist all | grep mysql
mysql-8.4-lts-community MySQL 8.4 LTS Community Server 啟用
mysql-8.4-lts-community-debuginfo MySQL 8.4 LTS Community Server 禁用
mysql-8.4-lts-community-source MySQL 8.4 LTS Community Server 禁用
mysql-cluster-8.0-community MySQL Cluster 8.0 Community 禁用
mysql-cluster-8.0-community-debuginfo MySQL Cluster 8.0 Community - 禁用
mysql-cluster-8.0-community-source MySQL Cluster 8.0 Community - 禁用
mysql-cluster-8.4-lts-community MySQL Cluster 8.4 LTS Communit 禁用
mysql-cluster-8.4-lts-community-debuginfo MySQL Cluster 8.4 LTS Communit 禁用
mysql-cluster-8.4-lts-community-source MySQL Cluster 8.4 LTS Communit 禁用
mysql-cluster-innovation-community MySQL Cluster Innovation Relea 禁用
mysql-cluster-innovation-community-debuginfo MySQL Cluster Innovation Relea 禁用
mysql-cluster-innovation-community-source MySQL Cluster Innovation Relea 禁用
mysql-connectors-community MySQL Connectors Community 啟用
mysql-connectors-community-debuginfo MySQL Connectors Community - D 禁用
mysql-connectors-community-source MySQL Connectors Community - S 禁用
mysql-innovation-community MySQL Innovation Release Commu 禁用
mysql-innovation-community-debuginfo MySQL Innovation Release Commu 禁用
mysql-innovation-community-source MySQL Innovation Release Commu 禁用
mysql-tools-8.4-lts-community MySQL Tools 8.4 LTS Community 啟用
mysql-tools-8.4-lts-community-debuginfo MySQL Tools 8.4 LTS Community 禁用
mysql-tools-8.4-lts-community-source MySQL Tools 8.4 LTS Community 禁用
mysql-tools-community MySQL Tools Community 禁用
mysql-tools-community-debuginfo MySQL Tools Community - Debugi 禁用
mysql-tools-community-source MySQL Tools Community - Source 禁用
mysql-tools-innovation-community MySQL Tools Innovation Communi 禁用
mysql-tools-innovation-community-debuginfo MySQL Tools Innovation Communi 禁用
mysql-tools-innovation-community-source MySQL Tools Innovation Communi 禁用
mysql80-community MySQL 8.0 Community Server 禁用
mysql80-community-debuginfo MySQL 8.0 Community Server - D 禁用
mysql80-community-source MySQL 8.0 Community Server - S 禁用
[root@web ~]# 安裝MySQL
[root@web ~]# yum install mysql-community-server
啟動MySQL服務
[root@web ~]# systemctl start mysqld
確認MySQL正常啟動
[root@web ~]# systemctl status mysqld
設定MySQL開機自啟動
[root@web ~]# systemctl enable mysqld
檢視生成 MySQL root使用者臨時密碼：
[root@web ~]# grep 'temporary password' /var/log/mysqld.log修改root使用者密碼
# 登入資料庫
[root@web ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.4.3
Copyright (c) 2000, 2024, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql>
mysql>
# 修改root密碼
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Password@2024';
Query OK, 0 rows affected (0.01 sec)
mysql> 設定遠端登入
# 檢視預設庫
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql>
# 選擇使用mysql庫
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
# 查詢使用者表
mysql> select host, user, authentication_string, plugin from user;
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| host | user | authentication_string | plugin |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| localhost | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.session | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.sys | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | root | $A$005$@c%qYYPJ~F-qAGZDHB6e7/1eEIz5VmK2O87RS12HBQpiPrZ7nVNqHX/D3 | caching_sha2_password |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
4 rows in set (0.00 sec)
mysql>
# 修改root的授權
mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql>
# 需要執行倆次
mysql> Grant all privileges on *.* to 'root'@'%';
ERROR 1410 (42000): You are not allowed to create a user with GRANT
mysql>
mysql> Grant all privileges on *.* to 'root'@'%';
Query OK, 0 rows affected (0.01 sec)
mysql>
# 重新整理許可權
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql>
mysql>
# 再次檢視使用者表
mysql> select host, user, authentication_string, plugin from user;
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| host | user | authentication_string | plugin |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| % | root | $A$005$@c%qYYPJ~F-qAGZDHB6e7/1eEIz5VmK2O87RS12HBQpiPrZ7nVNqHX/D3 | caching_sha2_password |
| localhost | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.session | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.sys | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
4 rows in set (0.00 sec)
mysql>測試連線
# 使用其他主機進行登入資料庫
[root@k8s-master01 ~]# mysql -u root -p -h 192.168.1.130
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.4.3 MySQL Community Server - GPL
Copyright (c) 2000, 2024, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql>
mysql> 關於
https://www.oiox.cn/
https://www.oiox.cn/index.php/start-page.html
CSDN、GitHub、51CTO、知乎、開源中國、思否、掘金、簡書、華為雲、阿里雲、騰訊雲、嗶哩嗶哩、今日頭條、新浪微博、個人部落格
全網可搜《小陳運維》
文章主要釋出於微信公眾號