MySQL安装

MySQL安装{

1.安装wget：
yum install wget

2.获取mysql源：
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

3.安装mysql：
yum localinstall mysql57-community-release-el7-8.noarch.rpm

4.用WinSCP打开用WinSCP打开：
/var/cache/yum/x86_64/7/mysql57-community/packages

5.把里面五个文件丢到里面去:
MySQL.rpm包{

mysql-community-client-5.7.19-1.el7.x86_64.rpm
mysql-community-common-5.7.19-1.el7.x86_64.rpm
mysql-community-libs-5.7.19-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.19-1.el7.x86_64.rpm

}

6.安装mysql服务:
yum install mysql-community-server

7.修改配置文件:
vim /etc/my.cnf
{
7.1进入编辑：
i

7.2关闭MySQL密码：
validate_password=off

7.3修改字符编码:
character_set_server=utf8

7.4修改字符编码:
init_connect='SET NAMES utf8'
Shift+:

7.5退出：
wq

}
8.启动MySQL服务:
（重启MySQL服务： systemctl start mysqld
service mysql restart
）

9.MySQL默认密码：Q5?j,riXjt/9
要查看MySQL日志获得

10.查看MySQL日志：
grep 'temporary password' /var/log/mysqld.log

11.登陆MySQL：
mysql -uroot -p

输入MySQL默认密码
12.1修改密码（因为默认密码没有最高权限）:
set password for 'root'@'localhost'=password('root');

12.2刷新权限:
flush privileges;
12.3查看库:
show databases;
12.4选择mysql库:
use mysql;

show tables;
12.5查看表:
1select host,user from user where user='root';

update user set host ='%'where user ='root';

flush privileges;

quit;
）
{
防火墙firewalld
1.关闭防火墙： {
systemctl stop firewalld.service

（开启防火墙：
）
systemctl start firewalld.service

2.关闭防火墙自启：
systemctl disable firewalld.service

3.安装防火墙；
yum install iptables-services

4.开启防火墙自启：
systemctl enable iptables

5.开启防火墙：
service iptables start

6.安装nmap：
yum install nmap

7.修改端口：
vim /etc/sysconfig/iptables

-A INPUT -p tcp -m state --state NEW -m tcp --dport 8080 -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 80 -j ACCEPT

8.重启防火墙：
service iptables restart

}