MYSQL安装的步骤和主从复制，相关配置

#环境：centos7
#主：192.168.0.0
#从：192.168.0.1
#MYSQL版本：  5.6.36
#mysql安装步骤及相关命令
rpm -qa | grep mariadb   #检查系统自带mariadb(mysql)
rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64 #删除避免冲突
#使用yum预先安装mysql初始化使用的插件，避免报错；
yum -y install autoconf
yum install libaio* -y
#创建mysql的用户和属组
groupadd mysql
useradd -r -g mysql  mysql
#mysql下载地址
#mysql下载地址
ftp://ftp.mirrorservice.org/sites/ftp.mysql.com/Downloads/MySQL-5.6/
#解压mysql压缩包
tar xf mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz 
#修改mysql解压后名称
mv mysql-5.6.46-linux-glibc2.12-x86_64  mysql
#移动mysql到安装目录：
mv mysql  /usr/local/
cd /usr/local/mysql
#复制mysql的配置文件：
cp support-files/my-default.cnf   /etc/my.cnf
vim /etc/my.cnf
#以下为mysql的基本配置
[mysql]
default-character-set=utf8
socket      = /tmp/mysql.sock
[mysqld]
port        = 3306
socket      = /tmp/mysql.sock
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
max_connections = 200
character-set-server = utf8
default-storage-engine = INNODB
lower_case_table_name = 1
max_allowed_packet = 16M
#改变mysql的所属组和所属用户
cd /usr/local/
chown -R  mysql:mysql   mysql/
#下面开始初始化mysql
cd /mysql/scripts
./mysql_install_db --user=mysql  --basedir=/usr/local/mysql/  --datadir=/usr/local/mysql/data
#配置mysql的快捷启动方式和开机自启
cd support-files/
cp mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
chkconfig mysql  on
chkconfig   --add mysql
chkconfig   --list mysql
#将mysql加入到系统变量
vim /etc/profile
export PATH=$PATH:/usr/local/mysql/bin
#运行文件使其生效
source  /etc/profile
#启动mysql
/etc/init.d/mysql start


#主库在[mysqld]模块下配置文件添加一下配置(192.168.0.0)
vim   /etc/mycnf
[mysqld]
log-bin=mysql-bin    
log-slave-updates=true
server-id      =1

#从数据库在[mysqld]模块下配置添加以下配置（192.168.0.1）
[mysqld]
server-id       = 2   #切记不能和主库id一样
relay-log = slave-relay-bin
relay-log-index = slave-relay-bin.index

#重启两个数据库
/etc/init.d/mysql   restart
#登录主库
mysql    -uroot    -p  
GRANT REPLICATION SLAVE ON *.* to 'cong'@'192.168.0.1' identified by ‘123123’;  #为从数据库授权
show master  status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000031 |      120 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+

#登录从数据库
mysql  -uroot  -p

change master to master_host='192.168.0.0',master_user='cong',master_password='123123',master_log_file='mysql-bin.000031',master_log_pos=120;


show   slave  status\G

如果结果如下则表示主从完成：

必须全部为：yes

现在可以在主库新建数据库查看从库是否会同步；