1.配置MySQL的repo源
# wget http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm
# rpm -ivh mysql57-community-release-el7-7.noarch.rpm
2.安裝
# yum install mysql-server
# yum install mysql-devel
# yum install mysql
安裝完檢查軟件命令：
rpm -qa|grep -i mysql
3.啟動(dòng)與關(guān)閉MySQL服務(wù)
# service mysqld status? ? 查看mysql當(dāng)前的狀態(tài)
# service mysqld stop? ? ? 停止mysql
# service mysqld restart? ? 重啟mysq
l# service mysqld start? ? ? 啟動(dòng)mysql
4.修改密碼
1.查看日志/var/log/mysqld.log文件撮执，找到關(guān)鍵字A temporary password，最后的字符串就是臨時(shí)密碼舷丹，使用臨時(shí)密碼登錄
2.設(shè)置新密碼命令：
SET PASSWORD = PASSWORD('Qwe123&%%');
本機(jī)登錄命令為 mysql -u root -p
新密碼必須包含英文字母大小寫(xiě)抒钱，數(shù)字與特殊符號(hào)，至少八位
5.授予遠(yuǎn)程連接權(quán)限
mysql> use mysql;
Database changed
mysql> grant all privileges? on *.* to root@'%' identified by "登錄密碼";
Query OK, 0 rows affected (0.00 sec)
遠(yuǎn)程連接命令：mysql -h ip -P 3306 -u root -p
