1、下載rpm包：wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

2、執(zhí)行rpm包：rpm -Uvh mysql57-community-release-el7-11.noarch.rpm

3、安裝mysql:yum install mysql-community-server

4、啟動(dòng)mysql：service mysqld start（systemctl start mysqld.service）

5、設(shè)置開(kāi)機(jī)啟動(dòng)：systemctl enable mysqld.service

6、查看啟動(dòng)狀態(tài)：systemctl status mysqld.service

7、查看密碼：grep ‘temporary password’ /var/log/mysqld.log7、跳過(guò)密碼復(fù)雜程度，進(jìn)入/etc/my.cnf文件在末尾添加：validate_password = off，（設(shè)置mysql不區(qū)分大小寫(xiě)在［mysqld］之后添加：lower_case_table_names=1）重啟mysql服務(wù)

8、修改密碼：set password =password（‘root’）;

9、開(kāi)啟遠(yuǎn)程訪(fǎng)問(wèn)：grant all privileges on *.* to ‘root’ @‘%’ identified by ‘root’;

10、刷新權(quán)限：flush privileges;

11、查看mysql數(shù)據(jù)庫(kù)編碼： show variables like ‘character%’;

12、設(shè)置編碼格式為utf8：在/etc/my.cnf文件中的［mysqld］之前添加［client］ default-character-set=utf8，在［mysqld］之后添加 character-set-server=utf8

13、重啟mysql:systemctl restart mysqld.service/**********防火墻**********/1、查看開(kāi)放端口：firewall-cmd --list-ports2、開(kāi)啟端口號(hào)：firewall-cmd --zone=public --add-port=80/tcp --perman