CentOS7安裝和配置MySQL

標籤：upd   unity   community   port   permanent   server   add   gre   comm   

  1. 下載MySQL Yum Repositoryhttp://dev.mysql.com/downloads/repo/yum/  2. 本地安裝MySQL Yum Repositorysudo yum localinstall platform-and-version-specific-package-name.rpm  3. 安裝MySQLsudo yum -y install mysql-community-server  4. 查看root初始密碼sudo grep ‘temporary password‘ /var/log/mysqld.log  5. 執行安全性設定mysql_secure_installation  6.設定字元集vi /etc/my.cnf[mysql]default-character-set=utf8[mysqld]character_set_server=utf8  7. 設定開機啟動chkconfig --levels 235 mysqld on  8. 關閉CentOS防火牆firewall-cmd --permanent --zone=public --add-port=3306/tcpfirewall-cmd --permanent --zone=public --add-port=3306/udpfirewall-cmd --reload  9. 建立遠端存取使用者CREATE USER ‘bounter‘@‘%‘ IDENTIFIED BY ‘[email protected]‘;GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO ‘bounter‘@‘%‘;flush privileges;  10. 啟動和關閉MySQL服務sudo service mysqld startsudo service mysqld stop

CentOS7安裝和配置MySQL