mysql主从复制配置防火墙策略_Mysql主从复制配置及介绍

一，MySQL安装配置

1.下载 mysql 源安装包

$ curl -LO http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

2.安装 mysql 源

$ sudo yum localinstall mysql57-community-release-el7-11.noarch.rpm

注意：执行过程中如果报错如下

则通过修改python版本, 修改yum配置文件，将python版本指向以前的旧版本

# 修改yum配置文件，将python版本指向以前的旧版本

# vi /usr/bin/yum

#!/usr/bin/python2.7

# 修改urlgrabber-ext-down文件，更改python版本

# vi /usr/libexec/urlgrabber-ext-down

#!/usr/bin/python2.7

检查 yum 源是否安装成功

$ sudo yum repolist enabled|grep "mysql.*-community.*"

mysql-connectors-community/x86_64 MySQL Connectors Community 95

mysql-tools-community/x86_64 MySQL Tools Community 84

mysql57-community/x86_64 MySQL 5.7 Community Server 327

3.安装server

$ sudo yum install mysql-community-server

4.启动mysql服务

安装服务

$ sudo systemctl enable mysqld

启动服务

$ sudo systemctl start mysqld

查看服务状态

$ sudo systemctl status mysqld

● mysqld.service - MySQL Server

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

Active: active (running) since 一 2019-03-04 16:36:09 CST; 17s ago

Docs: man:mysqld(8)

http://dev.mysql.com/doc/refman/en/using-systemd.html

Process: 3126 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)

Process: 3053 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Main PID: 3129 (mysqld)

Tasks: 27

CGroup: /system.slice/mysqld.service

└─3129 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

3月 04 16:36:02 lvmama02 systemd[1]: Starting MySQL Server...

3月 04 16:36:09 lvmama02 systemd[1]: Started MySQL Server.

5.修改默认密码

MySQL 5.7启动后，在 /var/log/mysqld.log 文件中给 root 生成了一个默认密码。通过下面的方式找到 root 默认密码，然后登录 mysql 进行修改

$ grep 'password' /var/log/mysqld.log

2019-03-04T08:36:04.854935Z 1