離線安裝
軟體包下載地址：http://mirrors.sohu.com/mysql/MySQL-8.0/
這里使用8.0.18版本，對應各軟體包下載鏈接如下：
http://mirrors.sohu.com/mysql/MySQL-8.0/mysql-community-client-8.0.18-1.el7.x86_64.rpm
http://mirrors.sohu.com/mysql/MySQL-8.0/mysql-community-common-8.0.18-1.el7.x86_64.rpm
http://mirrors.sohu.com/mysql/MySQL-8.0/mysql-community-devel-8.0.18-1.el7.x86_64.rpm
http://mirrors.sohu.com/mysql/MySQL-8.0/mysql-community-embedded-compat-8.0.18-1.el7.x86_64.rpm
http://mirrors.sohu.com/mysql/MySQL-8.0/mysql-community-libs-8.0.18-1.el7.x86_64.rpm
http://mirrors.sohu.com/mysql/MySQL-8.0/mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm
http://mirrors.sohu.com/mysql/MySQL-8.0/mysql-community-server-8.0.18-1.el7.x86_64.rpm
?? 安裝步驟
?? 將軟體包上傳至服務器
# ll
total 514508
-rw-r--r--. 1 root root 40104640 Mar 17 17:08 mysql-community-client-8.0.18-1.el7.x86_64.rpm
-rw-r--r--. 1 root root 611436 Mar 17 17:07 mysql-community-common-8.0.18-1.el7.x86_64.rpm
-rw-r--r--. 1 root root 6915400 Mar 17 17:25 mysql-community-devel-8.0.18-1.el7.x86_64.rpm
-rw-r--r--. 1 root root 23683600 Mar 17 17:26 mysql-community-embedded-compat-8.0.18-1.el7.x86_64.rpm
-rw-r--r--. 1 root root 3877664 Mar 17 17:07 mysql-community-libs-8.0.18-1.el7.x86_64.rpm
-rw-r--r--. 1 root root 1363968 Mar 21 00:23 mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm
-rw-r--r--. 1 root root 450282440 Mar 17 17:20 mysql-community-server-8.0.18-1.el7.x86_64.rpm
?? 安裝
# yum localinstall ./mysql-community-*
...
Complete!
?? 啟動
# systemctl start mysqld
?? 查看初始密碼并修改密碼
# grep password /var/log/mysqld.log
2020-03-20T15:11:35.241552Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: W7.j*e<lfU_9
# mysql -u root -p
...
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY "NewPass#123";
Query OK, 0 rows affected (0.02 sec)
在線安裝
?? 安裝步驟
?? 安裝MySQL yum源
# wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
# yum -y localinstall mysql80-community-release-el7-1.noarch.rpm
?? 更新yum源
# yum clean all
# yum makecache
?? 安裝
# yum install mysql-community-server -y
?? 啟動
# systemctl start mysqld
?? 查看初始密碼并修改密碼
# grep password /var/log/mysqld.log
2020-03-20T15:11:35.241552Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: W7.j*e<lfU_9
# mysql -u root -p
...
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY "NewPass#123";
Query OK, 0 rows affected (0.02 sec)
賬戶密碼管理
MySQL8 賬戶密碼默認策略采用的是
caching_sha2_password，導致很多時候我們創建了用戶和密碼，在客戶端連接時一直提示密碼錯誤，修改認證方式可以通過組態檔修改，也可以修改單獨用戶的認證策略，
?? 示例不修改加密方式創建用戶
?? 創建用戶
這里我創建一個zabbix庫進行創建用戶和授權示例
mysql> create database zabbix character set utf8mb4;
Query OK, 1 row affected (0.01 sec)
mysql> create user 'zabbix'@'localhost' identified by 'Zabbix@123';
Query OK, 0 rows affected (0.01 sec)
mysql> grant all privileges on zabbix.* to 'zabbix'@'localhost' with grant option;
Query OK, 0 rows affected (0.01 sec)
mysql> select user,host,plugin from mysql.user where user='zabbix';
+--------+-----------+-----------------------+
| user | host | plugin |
+--------+-----------+-----------------------+
| zabbix | localhost | caching_sha2_password |
+--------+-----------+-----------------------+
1 row in set (0.00 sec)
?? 修改單個用戶的加密方式
#這條命令可以查詢用戶所使用的密碼插件模式
mysql> select user,host,plugin from mysql.user;
mysql> select user,host,plugin from mysql.user where user='zabbix';
mysql> alter user 'zabbix'@'localhost' identified with mysql_native_password by "Zabbix@123";
Query OK, 0 rows affected (0.01 sec)
mysql> select user,host,plugin from mysql.user where user='zabbix';
+--------+-----------+-----------------------+
| user | host | plugin |
+--------+-----------+-----------------------+
| zabbix | localhost | mysql_native_password |
+--------+-----------+-----------------------+
1 row in set (0.00 sec)
?? 示例，修改組態檔更改加密方式
?? 修改組態檔
# vim /etc/my.cnf
[mysqld]
......
default-authentication-plugin=mysql_native_password
# systemctl restart mysqld
?? 創建用戶查看
mysql> create user 'zabbix_test'@'localhost' identified by "Zabbix@321";
Query OK, 0 rows affected (0.01 sec)
mysql> select user,host,plugin from mysql.user where user='zabbix_test';
+-------------+-----------+-----------------------+
| user | host | plugin |
+-------------+-----------+-----------------------+
| zabbix_test | localhost | mysql_native_password |
+-------------+-----------+-----------------------+
1 row in set (0.00 sec)
通過上面可以查看，修改組態檔后，現在創建的新用戶默認加密方式即為mysql_native_password模式
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/16373.html
標籤：MySQL
上一篇：自建單機MySQL資料庫備份方案
下一篇：大佬們 幫幫小萌新吧 Oracle安裝成功了 可是登錄顯示無監聽 OracleNetServices的監聽程式配置也配了好多次了