centos7安裝mysql5.7

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

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

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

4、啟動mysql：service mysqld start（systemctl start mysqld.service）

5、設置開機啟動：systemctl enable mysqld.service

6、查看啟動狀態：systemctl status mysqld.service

7、查看密碼：grep 'temporary password' /var/log/mysqld.log

7、跳過密碼複雜程度，進入/etc/my.cnf文件在末尾添加：validate_password = off，（設置mysql不區分大小寫在[mysqld]之後添加：lower_case_table_names=1）重啟mysql服務

8、修改密碼：set password =password('root');

9、開啟遠程訪問：grant all privileges on *.* to 'root' @'%' identified by 'root';

10、刷新權限：flush privileges;

11、查看mysql數據庫編碼： show variables like 'character%';

12、設置編碼格式為utf8:在/etc/my.cnf文件中的[mysqld]之前添加[client] default-character-set=utf8,在[mysqld]之後添加 character-set-server=utf8

13、重啟mysql:systemctl restart mysqld.service

/**********防火牆**********/

1、查看開放端口：firewall-cmd --list-ports

2、開啟端口號：firewall-cmd --zone=public --add-port=80/tcp --permanent

# –zone #作用域

# –add-port=80/tcp #添加端口，格式為：端口/通訊協議

# –permanent #永久生效，沒有此參數重啟後失效

3、刷新權限：firewall-cmd --reload

4、啟動防火牆：systemctl start firewalld

5、設置開機啟動防火牆：systemctl enable firewalld

6、關閉防火牆：systemctl stop firewalld.service

7、禁止開機自啟動：systemctl disable firewalld.service

8、查看防火牆狀態：firewall-cmd --state