## 安裝MySQL
打開MySQL官網的下載頁`https://www.mysql.com/downloads/`,點擊圖示中的Yum Repository菜單
:-: 
往下拉,找到適合MySQL80的下載鏈接,點進去,不用注冊登錄,在頁面最下端找到“No thanks, just start my download.”,右鍵復制下載鏈接。

~~~
https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
~~~
該頁面也提供了MySQL Yum源的使用手冊,點擊鏈接進去就可以查看了:
:-: 
導入Yum源:
~~~
[root@localhost ~]# rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
[root@localhost ~]# yum makecache fast
~~~
Yum源導入成功,可以安裝MySQL8.0了
~~~
[root@localhost ~]# yum install mysql-community-server
~~~
顯示:
~~~
===========================================================================================================
Package Arch Version Repository Size
===========================================================================================================
Installing:
mysql-community-server x86_64 8.0.12-1.el7 mysql80-community 349 M
Transaction Summary
===========================================================================================================
Install 1 Package
Total download size: 349 M
Installed size: 1.5 G
Is this ok [y/d/N]:
~~~
> 注:為什么默認會安裝最新版本,而且沒有提供其它版本的MySQL供你選擇?因為在`/etc/yum.repos.d/mysql-community.repo`中已經設置其它版本`disabled`了。如果你要安裝其它版本的MySQL,只需要設置這個版本的`enabled=1`即可。
確認是MySQL8.0.12無誤,輸入`y`確認執行安裝。
349M,需要一點時間安裝。安裝完成后,檢查版本:
~~~
[root@localhost ~]# mysql -V
~~~
輸出:
~~~
mysql Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL)
~~~
版本正確。現在配置MySQL服務:
檢查mysqld服務是否啟動:
~~~
[root@localhost ~]# systemctl status mysqld.service
~~~
返回:
~~~
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: inactive (dead)
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
~~~
沒有啟動,我們啟動它:
~~~
[root@localhost ~]# systemctl enable mysqld.service
[root@localhost ~]# systemctl start mysqld.service
[root@localhost ~]# systemctl status mysqld.service
~~~
結果:
~~~
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2018-08-15 12:31:09 CST; 10s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 1703 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 1773 (mysqld)
Status: "SERVER_OPERATING"
CGroup: /system.slice/mysqld.service
└─1773 /usr/sbin/mysqld
Aug 15 12:31:00 localhost.localdomain systemd[1]: Starting MySQL Server...
Aug 15 12:31:09 localhost.localdomain systemd[1]: Started MySQL Server.
~~~
小綠燈閃耀,天氣真好。
安裝程序為`root@localhost`創建了初始密碼,通過下面的命令查看:
~~~
[root@localhost log]# grep 'temporary password' /var/log/mysqld.log
~~~
輸出:
~~~
2018-08-15T06:11:28.416464Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 8Ftm8eb!S9/(
~~~
這里就是你的初始密碼了,需要先修改它:
~~~
[root@localhost log]# mysql -uroot -p
~~~
輸入初始密碼:
~~~
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
~~~
~~~
Query OK, 0 rows affected (0.01 sec)
~~~
~~~
mysql> show databases;
~~~
~~~
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.02 sec)
~~~
~~~
mysql> quit';
~~~
關閉虛擬機,拍個快照吧
由于MySQL 8.0 開始改變了身份驗證插件,使用以前版本的客戶端連接時,可能會報Authentication plugin 'caching\_sha2\_password' cannot be loaded錯誤,如果出現這種情況,參考下面文章的方案解決:
[http://www.cnblogs.com/hlhx/p/mysqlsha2.html](http://www.cnblogs.com/hlhx/p/mysqlsha2.html)
[https://blog.csdn.net/faye0412/article/details/80396113](https://blog.csdn.net/faye0412/article/details/80396113)