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