CentOS安裝MySQL

　　官方指南：https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/

　　檢視yum源

　　下載下傳安裝包，tips：tab鍵自動補全檔案名

wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm      

sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm      

　　安裝mysql-server

sudo yum install -y mysql-community-server      

　　啟動mysql

sudo systemctl start mysqld
sudo systemctl enable mysqld      

　　檢視預設密碼

grep 'temporary password' /var/log/mysqld.log      

　　登入mysql

mysql -u root -p      

　　登入之後第一件事就是更改密碼

　　修改預設密碼

ALTER USER 'root'@'localhost' IDENTIFIED BY 'pswd4root@L';      

　　檢視使用者表

show database;
use mysql;
select host,user from user;      

　　修改允許通路的來源

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pwd4root' WITH GRANT OPTION;
FLUSH PRIVILEGES;      

　　也可以通過修改user表的host來設定允許通路的來源，host='%'是允許任何來源，也可以修改為指定ip。

use mysql;
update user set host = '%' where user = 'root';
flush privileges;      

　　退出mysql

quit      

　　開放防火牆端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload      

　　遠端連接配接mysql