## mysql安裝 ``` su wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm rpm -ivh mysql-community-release-el7-5.noarch.rpm yum install mysql-community-server service mysqld restart ``` ## 設置密碼 ``` mysql -u root mysql> set password for 'root'@'localhost' =password('你的新密碼'); --把在所有數據庫的所有表的所有權限賦值給位于所有IP地址的root用戶。 mysql> grant all privileges on *.* to root@'%'identified by '你的密碼'; --新建用戶 --mysql>create user 'username'@'%' identified by 'password'; ``` ## 測試 ``` mysql -u root -p mysql> show databases; ``` ## 最后，開放防火墻策略 ``` firewall-cmd --zone=public --add-port=3306/tcp --permanent ```