雖然是根據(jù)老徐的那篇（軟件測(cè)試從業(yè)者必備之MYSQL從零到入坑）來安裝，但是實(shí)際操作過程中還是遇到各種問題，最后還參考了其他文章（eg.http://www.linuxidc.com/Linux/2016-09/135288.htm）才算完全入坑成功。下面主要列一下我的安裝過程，以做記錄。
1.檢查自帶版本數(shù)據(jù)庫
[root@bogon ~]$ yum list installed |grep sql
注：我的系統(tǒng)是centos7.0，這里自帶的數(shù)據(jù)庫是sqlite，為了不安裝那么多，我把它也刪掉
2.刪除自帶版本
[root@bogon ~]$ yum -y remove sqlite
3.下載并安裝mysql 的rpm源
[root@bogon tools]$?wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm?--no-check-certificate
[root@bogon tools]$?yum localinstall mysql57-community-release-el7-8.noarch.rpm
4.驗(yàn)證本地mysql yum源是否安裝成功
[root@bogon ~]$ ?yum repolist all |grep mysql
mysql-connectors-community MySQL Connectors Community enabled: 42
mysql-connectors-community-source MySQL Connectors Community - So disabled
mysql-tools-community? ? ? ? ? ? MySQL Tools Community? ? ? ? ? enabled:? ? 55
mysql-tools-community-source? ? ? MySQL Tools Community - Source? disabled
mysql-tools-preview? ? ? ? ? ? ? MySQL Tools Preview? ? ? ? ? ? disabled
mysql-tools-preview-source? ? ? ? MySQL Tools Preview - Source? ? disabled
mysql55-community? ? ? ? ? ? ? ? MySQL 5.5 Community Server? ? ? disabled
mysql55-community-source? ? ? ? ? MySQL 5.5 Community Server - So disabled
mysql56-community? ? ? ? ? ? ? ? MySQL 5.6 Community Server? ? ? disabled
mysql56-community-source? ? ? ? ? MySQL 5.6 Community Server - So disabled
mysql57-community? ? ? ? ? ? ? ? MySQL 5.7 Community Server? ? ? enabled:? 247
mysql57-community-source? ? ? ? ? MySQL 5.7 Community Server - So disabled
5.安裝mysql
[root@bogon ~]$ ?yum install mysql-community-server
6.啟動(dòng)mysql
[root@bogon ~]$ systemctl start mysqld
查看mysql狀態(tài)
[root@bogon ~]$?systemctl status mysqld
7.開機(jī)自啟動(dòng)
[root@bogon ~]$?systemctl enable mysql
[root@bogon ~]$?systemctl?daemon-reload
至此mysql安裝成功，下面進(jìn)行登錄以及遠(yuǎn)程訪問
8.登錄mysql
[root@bogon ~]# mysql -uroot -p
Enter password:
或者：[root@bogon ~]#?grep 'temporary password' /var/log/mysqld.log
注：這里直接回車后或者通過查看臨時(shí)密碼并輸入臨時(shí)密碼后仍提示錯(cuò)誤：
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
解決方法http://blog.csdn.net/myth_xgx/article/details/50809645：
??$ sudo systemctl stop mysqld.service
? ? ?$ sudo?systemctl set-environment MYSQLD_OPTS="--user=mysql --skip-grant-tables --skip-networking"
? ? ?$?sudo systemctl start mysqld.service? ??
? ? ?$?mysql -u root mysql
? ? ?mysql > UPDATE mysql.user SET authentication_string=PASSWORD("abcdef")? WHERE user='root' and host='localhost';
? ? ?mysql >?flush privileges;
? ? ?mysql > quit
? ? ?$ sudo?systemctl unset-environment MYSQLD_OPTS
? ? ?$?sudo systemctl restart mysqld.service
然后再進(jìn)入mysql并修改密碼
[root@bogon ~]# ?mysql -uroot -p
Enter password:abcdef
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass11!';
之后密碼為修改后的密碼。
9，遠(yuǎn)程連接
mysql> GRANT ALL PRIVILEGES ON *.* TO 'emmalong'@'%' IDENTIFIED BY 'MyNewPass11!'?
mysql> FLUSH PRIVILEGES;
mysql> EXIT;
