1、下載YUM源文件
http://dev.mysql.com/downloads/repo/yum/
或者
sudo rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
2.安裝MySQL
sudo yum -y install mysql-community-server
3.安全設(shè)置
sudo /usr/bin/mysql_secure_installation
選擇相應(yīng)的Yes NO
Set root password? [Y/n] Y
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y
4.啟動(dòng)MySQL
sudo /usr/bin/systemctl enable mysqld#開(kāi)機(jī)啟動(dòng)
sudo /usr/bin/systemctl start mysqld #啟動(dòng)服務(wù)
5.防火墻設(shè)置
firewall-cmd --permanent --zone=trusted --add-source=192.0.2.10/32
firewall-cmd --permanent --zone=trusted --add-port=3306/tcp
firewall-cmd --reload
6.創(chuàng)建用戶
mysql -u root -p mysql
mysql> create database newdb;
mysql> grant all on newdb.* to 'newuser'@'localhost' identified by 'password';
mysql> quit
登錄用戶
mysql -u newuser-p -h localhost newdb