mysql5.7.22rpm_MYSQL5.7.20的安装和主从配置（rpm安装包）

一&＃xff0c;下载解压(包含全部的rpm包)

如果防火墙有屏蔽&＃xff0c;先安装rz

yum install lrzsz -y

二&＃xff0c;安装

安装的过程如果和mariadb包有冲突&＃xff0c;如果要有先卸载

rpm -qa|grep mariadb

查看已安装的mariadb包

rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64

rpm-e --nodeps mariadb-5.5.44-2.el7.centos.x86_64

rpm-e --nodeps mariadb-devel-5.5.44-2.el7.centos.x86_64

依次先后安装

rpm -ivh mysql/mysql-community-common-5.7.20-1.el7.x86_64.rpm

rpm-ivh mysql/mysql-community-libs-5.7.20-1.el7.x86_64.rpm

rpm-ivh mysql/mysql-community-client-5.7.20-1.el7.x86_64.rpm

rpm-ivh mysql/mysql-community-server-5.7.20-1.el7.x86_64.rpm

三&＃xff0c;配置/etc/my.cnf 文件

[mysqld]

character-set-server&＃61;utf8

[mysql]

default-character-set &＃61;utf8

[mysql.server]

default-character-set &＃61;utf8

[mysqld_safe]

default-character-set &＃61;utf8

[client]

default-character-set &＃61; utf8

查看修改后的效果

SHOW VARIABLES LIKE &＃39;character%&＃39;;

四&＃xff0c;初始化mysql

mysqld --initialize --user&＃61;mysql

如有必要指定路径可以加上下面的参数--basedir&＃61;/usr/local/mysql --datadir&＃61;/data/mysql

root 用户随机密码保留在/var/log/mysqld.log 文件中

五&＃xff0c;启动mysql

systemctl start mysqld (启动mysql)

systemctl restart mysqld (重启mysql)

systemctl status mysqld (查看状态)

六&＃xff0c;修改root 初始密码

mysql -u root -p (使用刚才的随机密码)

或者 使用下面命令初始化mysql&＃xff0c;则不需要密码登录

mysqld --initialize-insecure --user&＃61;mysql

mysql-u root --skip-password

alter user&＃39;root&＃39;&＃64;&＃39;localhost&＃39; identified by &＃39;pwd456&＃39;;

如果无法登录&＃xff0c;再修改/etc/my.cnf 文件 加入以下参数

skip-grant-tables

再 systemctl restart mysqld (重启mysql) 就可以无密码登录了&＃xff0c;修改密码

update user set authentication_string&＃61;password("pwd456") where user&＃61;"root";

flush privileges;

七&＃xff0c;配置主从

1&＃xff0c;修改master /etc/my.cnf 文件

log-bin&＃61;mysql-bin

server-id&＃61;1

--------下面可以忽略

binlog-ignore-db&＃61;information_schema

binlog-ignore-db&＃61;mysql-----------------------

2&＃xff0c;登录master

GRANT FILE ON *.* TO replicate&＃64;&＃39;xx.xx.xx.xx&＃39; IDENTIFIED BY &＃39;pwd123&＃39;;

GRANT REPLICATION SLAVE,RELOAD,SUPER ON*.* TO replicate&＃64;&＃39;xx.xx.xx.xx&＃39; IDENTIFIED BY &＃39;pwd123&＃39;;

查看状态

SHOW MASTER STATUS \G;

3&＃xff0c;修改slave的配置 /etc/my.cnf 文件

log-bin&＃61;mysql-bin (非必须项,当slave需要同步的时候才必须)

server-id&＃61;2log_slave_updates&＃61; 1read_only&＃61; 1slave-skip-errors &＃61;all

slave-net-timeout &＃61; 60

--------下面可以忽略

binlog-ignore-db&＃61;information_schema

binlog-ignore-db&＃61;cluster

binlog-ignore-db&＃61;mysql

replicate-do-db&＃61;ufind_db

replicate-ignore-db&＃61;mysql

4&＃xff0c;修改同步选项&＃xff0c; 重启slave

change master to master_host&＃61;&＃39;xx.xx.xx.01&＃39;,master_user&＃61;&＃39;replicate&＃39;,master_password&＃61;&＃39;pwd123&＃39;,master_log_file&＃61;&＃39;mysql-bin.000001&＃39;, master_log_pos&＃61;760;

查看 slave 状态

START SLAVE;

SHOW SLAVE STATUS \G;

可以看到

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

参考