MYSQL-5.7.20的安装和主从配置（rpm安装包）

　　再在本地下载，再上传 https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar

二，安装

　　安装的过程如果和mariadb包有冲突，如果要有先卸载

　　rpm -qa|<span style="color: #0000ff;">grep</span> mariadb

　　查看已安装的mariadb包

　　rpm -e --nodeps mariadb-libs-<span style="color: #800080;">5.5</span>.<span style="color: #800080;">44</span>-<span style="color: #800080;">2</span><span style="color: #000000;">.el7.centos.x86_64
　　rpm </span>-e --nodeps mariadb-<span style="color: #800080;">5.5</span>.<span style="color: #800080;">44</span>-<span style="color: #800080;">2</span><span style="color: #000000;">.el7.centos.x86_64
　　rpm </span>-e --nodeps mariadb-devel-<span style="color: #800080;">5.5</span>.<span style="color: #800080;">44</span>-<span style="color: #800080;">2</span>.el7.centos.x86_64

　　依次先后安装

　　rpm -ivh mysql/mysql-community-common-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">20</span>-<span style="color: #800080;">1</span><span style="color: #000000;">.el7.x86_64.rpm
　　rpm </span>-ivh mysql/mysql-community-libs-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">20</span>-<span style="color: #800080;">1</span><span style="color: #000000;">.el7.x86_64.rpm 
　　rpm </span>-ivh mysql/mysql-community-client-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">20</span>-<span style="color: #800080;">1</span><span style="color: #000000;">.el7.x86_64.rpm 
　　rpm </span>-ivh mysql/mysql-community-server-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">20</span>-<span style="color: #800080;">1</span>.el7.x86_64.rpm

三，配置/etc/my.cnf 文件　

<span style="color: #000000;">[mysqld] 
character</span>-set-server=<span style="color: #000000;">utf8 
[mysql] 
default</span>-character-set =<span style="color: #000000;"> utf8
[mysql.server]
default</span>-character-set =<span style="color: #000000;"> utf8
[mysqld_safe]
default</span>-character-set =<span style="color: #000000;"> utf8
[client]
default</span>-character-set = utf8

<code class="hljs"><span class="zh-hans">　　查看修改后的效果<br></span></code>

SHOW VARIABLES LIKE <span style="color: #800000;">‘</span><span style="color: #800000;">character%</span><span style="color: #800000;">‘</span>;

四，初始化mysql

mysqld --initialize --user=<span style="color: #000000;">mysql
如有必要指定路径可以加上下面的参数
</span>--basedir=/usr/local/mysql --datadir=/data/mysql<br><br><em>root 用户随机密码保留在/var/log/mysqld.log 文件中</em>

五，启动mysql

<span style="color: #000000;">systemctl  start  mysqld （启动mysql）
systemctl  restart  mysqld （重启mysql）
systemctl  status  mysqld （查看状态）</span>

六，修改root 初始密码

mysql  -u  root  -p  （使用刚才的随机密码）

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

mysqld --initialize-insecure --user=<span style="color: #000000;">mysql
mysql </span>-u root --skip-<span style="color: #000000;">password
alter user </span><span style="color: #800000;">‘</span><span style="color: #800000;">root</span><span style="color: #800000;">‘</span>@<span style="color: #800000;">‘</span><span style="color: #800000;">localhost</span><span style="color: #800000;">‘</span>  identified  by  <span style="color: #800000;">‘</span><span style="color: #800000;">pwd456</span><span style="color: #800000;">‘</span>;

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

skip-grant-tables

　　再 systemctl restart mysqld （重启mysql） 就可以无密码登录了，修改密码

update user set authentication_string=password(<span style="color: #800000;">"</span><span style="color: #800000;">pwd456</span><span style="color: #800000;">"</span>) where user=<span style="color: #800000;">"</span><span style="color: #800000;">root</span><span style="color: #800000;">"</span><span style="color: #000000;">;
flush privileges;</span>

七，配置主从

　　1，修改master /etc/my.cnf 文件

log-bin=mysql-<span style="color: #000000;">bin
server</span>-<span style="color: #0000ff;">id</span>=<span style="color: #800080;">1</span>
--------<span style="color: #000000;">下面可以忽略
binlog</span>-ignore-db=<span style="color: #000000;">information_schema
binlog</span>-ignore-db=<span style="color: #000000;">mysql
</span>-----------------------　

　　2，登录master

GRANT FILE ON *.* TO replicate@<span style="color: #800000;">‘</span><span style="color: #800000;">xx.xx.xx.xx</span><span style="color: #800000;">‘</span> IDENTIFIED BY <span style="color: #800000;">‘</span><span style="color: #800000;">pwd123</span><span style="color: #800000;">‘</span><span style="color: #000000;">;
GRANT REPLICATION SLAVE,RELOAD,SUPER ON </span>*.* TO replicate@<span style="color: #800000;">‘</span><span style="color: #800000;">xx.xx.xx.xx</span><span style="color: #800000;">‘</span> IDENTIFIED BY <span style="color: #800000;">‘</span><span style="color: #800000;">pwd123</span><span style="color: #800000;">‘</span><span style="color: #000000;">;
查看状态
SHOW MASTER STATUS \G;</span>

　　3，修改slave的配置 /etc/my.cnf 文件

log-bin=mysql-<span style="color: #000000;">bin                 (非必须项,当slave需要同步的时候才必须)
server</span>-<span style="color: #0000ff;">id</span>=<span style="color: #800080;">2</span><span style="color: #000000;">
log_slave_updates </span>= <span style="color: #800080;">1</span><span style="color: #000000;">
read_only         </span>= <span style="color: #800080;">1</span><span style="color: #000000;">
slave</span>-skip-errors =<span style="color: #000000;"> all
slave</span>-net-timeout = <span style="color: #800080;">60</span>
--------<span style="color: #000000;">下面可以忽略
binlog</span>-ignore-db=<span style="color: #000000;">information_schema
binlog</span>-ignore-db=<span style="color: #000000;">cluster
binlog</span>-ignore-db=<span style="color: #000000;">mysql
replicate</span>-<span style="color: #0000ff;">do</span>-db=<span style="color: #000000;">ufind_db
replicate</span>-ignore-db=mysql

　　4，修改同步选项， 重启slave

change master to master_host=<span style="color: #800000;">‘</span><span style="color: #800000;">xx.xx.xx.01</span><span style="color: #800000;">‘</span>,master_user=<span style="color: #800000;">‘</span><span style="color: #800000;">replicate</span><span style="color: #800000;">‘</span>,master_password=<span style="color: #800000;">‘</span><span style="color: #800000;">pwd123</span><span style="color: #800000;">‘</span>,master_log_file=<span style="color: #800000;">‘</span><span style="color: #800000;">mysql-bin.000001</span><span style="color: #800000;">‘</span>, master_log_pos=<span style="color: #800080;">760</span>;

　　查看 slave 状态

<span style="color: #000000;">START SLAVE;
SHOW SLAVE STATUS \G;</span>

　　可以看到

<span style="color: #000000;">Slave_IO_Running: Yes
Slave_SQL_Running: Yes</span>

参考

mysql的安装 参考 https://jingyan.baidu.com/article/93f9803f010d8fe0e56f555e.html

MYSQL-5.7.20的安装和主从配置（rpm安装包）

标签：unity   roo   local   variable   改密码   emc   alter   for   log