centos7安裝mysql5.6(2018-10)

多參考官方文檔:https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/

1.安裝mysql的yum源

rpm包的地址參考:
https://dev.mysql.com/downloads/repo/yum/

wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

rpm安裝你下載的包

rpm -Uvh mysql80-community-release-el7-1.noarch.rpm

2.安裝mysql

列出可安裝版本

yum repolist all | grep mysql

選擇你要安裝的版本更換為enable

sudo yum-config-manager --disable mysql80-community
sudo yum-config-manager --enable mysql56-community/x86_64

yum install mysql-community-server

3.配置mysql

shell設(shè)置root密碼，此命令僅對(duì)mysql5.6有效

mysql_secure_installation

登陸mysql

mysql -u root -p

授權(quán)任意IP遠(yuǎn)程以root身份訪問

GRANT ALL PRIVILEGES ON *.* to 'root'@'%' IDENTIFIED BY '你的密碼';

刷新

flushprivileges;

shell設(shè)置防火墻

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