1. Download MySQL Yum Repositoryhttp://dev.mysql.com/downloads/repo/yum/
2. Install MySQL Yum Repository locallysudo yum localinstall platform-and-version-specific-package-name.rpm
3. Install MySQLsudo yum-y install Mysql-community-server
4. View Root initial passwordsudo grep ' temporary password '/var/log/mysqld.log
5. Perform security settingsMysql_secure_installation
6. Setting the character setVi/etc/my.cnf[mysql]default-character-set=utf8[mysqld]character_set_server=utf8
7. Set boot upChkconfig--levels 235 mysqld on
8. Turn off the CentOS firewallFirewall-cmd--permanent--zone=public--add-port=3306/tcpfirewall-cmd--permanent--zone=public--add-port=3306/ Udpfirewall-cmd--reload
9. Create a remote access userCREATE USER ' bounter ' @ '% ' identified by ' [email protected] '; GRANT select,insert,update,delete on * * to ' bounter ' @ '% '; flush privileges;
10. Start and close the MySQL servicesudo service mysqld Startsudo service mysqld Stop
CentOS7 Installing and configuring MySQL
