mysql5.7 多级主从+multisource

mysqlday5 mysql5.7 多级主从+multisource


1.安装软件
# 操作系统 RHEL7.2 
# 下载软件（rpm；本地yum源； 在线yum源；）
http://classroom.example.com/materials/mysql-5.7.repo
# /etc/yum.repos.d/ 
# yum clean all;yum makecache
# yum list|grep mysql
mysql-community-server 5.7
# yum install ----报错，软件冲突：mariadb-libs 5.5 /var/lib/mysql/*
# rpm -e --nodeps mariadb-libs 
# 服务器端
软件名 mysql-community-server 5.7
service mysqld
daemon mysqld
配置文件 /etc/my.cnf
/etc/my.cnf.d/*.cnf
数据文件 /var/lib/mysql
启动日志 /var/log/mysqld.log


# 客户端
软件名 mysql-community-client 5.7 
命令 mysql
mysqladmin
mysqlbinlog
mysqldump
-------------------------------------------------------------------
# 启动服务
查看进程 ps -ef|grep mysqld
systemctl status mysqld
查看端口 netstat -lunpt|grep mysqld
3306
-------------------------------------------------------------------
# mysql 5.7 初始密码
grep password /var/log/mysqld.log
mysqladmin -uroot -p'' password ''


------------------------------------------------------------
# 登陆数据库
mysql -uroot -p''
mysql.user表的结构变化了，原先的password列改为了authentication_string列
-----------------------------------------------------------------------------
服务器 ip 功能 软件
mastera 172.25.0.11 主服务器 mysql-community-client 5.7
masterb 172.25.0.12 从 mysql-community-client 5.7
slavea 172.25.0.13 从 mysql-community-client 5.7
slaveb 172.25.0.14 从 mysql-community-client 5.7
------------------------
主服务器
systemctl stop firewalld #
setenforce 0
1.configure  /etc/my.cnf 修改配置文件
---------------------------------------------------------------  
log-bin=/var/lib/mysql-log/mastera
server-id=1
# master_log_file master_log_pos===>master_auto_position=1 
gtid_mode = ON
enforce_gtid_consistency = 1
-----------------------------------------------------------------------------
创建二进制日志存放目录mkdir /var/lib/mysql-log/
修改UGO权限  selinux权限 chown mysql. /var/lib/mysql-log/ 
systemctl restart mysqld #重启服务
2.grant replication slave@'172.25.X.%' #授权
##grant replication slave on *.* to slave@'172.25.8.%' identified by '(Uploo00king)';
3.mysqldump\tar\lvm\innobackupex  #全备份
从服务器
1.configure
server-id=2
server-id=3
server-id=4
gtid_mode = ON
enforce_gtid_consistency = 1
2.mysql -uroot -p'' < mysql.all.sql
3.change mastert to 
master_host='ip'
master_user='slave'
master_password=''
master_auto_position=1
##change master to master_host='172.25.8.12',master_user='slave',master_password='(Uploo00king)',master_auto_position=1;
4.start slave; 
5.show slave status\G;
-------------------------------------------------
多主从在配置文件/etc/my.cnf
master-info-repository = TABLE
relay-log-info-repository = TABLE
**********************************************************
mysql5.7 多级主从、Multi-Source
servera
M1
172.25.0.10
serverb
M2
172.25.0.11
serverc
S1
172.25.0.12
serverd
S2
172.25.0.13
==============================================
systemctl stop firewalld
setenforce 0
==============================================
servera~d
1.install
# mount 172.25.254.250:/content /mnt
# cd /mnt/uplooking/mysql/mysql5.7
# rpm -e --nodeps mariadb-libs
# yum localinstall -y *.rpm
2.start service
# systemctl start mysqld
3.change password
# grep password /var/log/mysqld.log
2016-05-04T07:37:31.642343Z 1 [Note] A temporary password is generated for root@localhost:
&ig:,eto:7:T
# mysqladmin -uroot -p'&ig:,eto:7:T' password "U:pl:oo00king:"
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password
safety.
===============================================
servera
1.create database
# mysql -uroot -pU:pl:oo00king:
>create database db1;
>use db1;
>create table t1 (no int);
>insert into t1 values (1);
>\q
2.mysqldump
# mysqldump -uroot -pU:pl:oo00king: --all-databases --single-transaction > /tmp/mysql.all.sql
# for i in 11 12 13 ;do scp /tmp/mysql.all.sql root@172.25.15.$i:/tmp;done
serverb~d
1. 导入全备份
# mysql -uroot -pU:pl:oo00king: < /tmp/mysql.all.sql
2. 刷新授权
15# mysql -uroot -pU:pl:oo00king
>flush privileges;
===============================================
1./etc/my.cnf
servera~serverb
*****************
#vim etc/my.cnf
log-bin=/var/lib/mysql-log/servera
server-id=1(server-id=2)
gtid_mode = ON
enforce_gtid_consistency = 1
serverc~serverd
****************
#vim etc/my.cnf
server-id=3
gtid_mode = ON
enforce_gtid_consistency = 1
master-info-repository = TABLE
relay-log-info-repository = TABLE
2. 重新启动服务
servera~serverd
# systemctl restart mysqld
================================================
M1-->M2
1.servera M1 授权 M2
# mysql -uroot -pU:pl:oo00king
>grant replication slave on *.* to slave@172.25.0.11 identified by "uplooking";
>flush privileges;
2.serverb M2 change master
# mysql -uroot -pU:pl:oo00king
>change
master
to
master_host="172.25.0.10",master_user="slave",master_password="uplooking",master_auto_position=
1;
>start slave;
>show slave status\G;
==========================================================
M2-->M1
161.servera M2 授权 M1
>grant replication slave on *.* to slave@172.25.0.10 identified by "uplooking";
>flush privileges;
>change
master
to
master_host="172.25.0.11",master_user="slave",master_password="uplooking",master_auto_position=
1;
>slave start;
>show slave status\G;
==========================================================
M1&M2-->Slaves
1.servera M1 授权 Slaves
# mysql -uroot -pU:pl:oo00king
>grant replication slave on *.* to slave@172.25.0.12 identified by "uplooking";
>grant replication slave on *.* to slave@172.25.0.13 identified by "uplooking";
>flush privileges;
2.serverc~d
# mysql -uroot -pU:pl:oo00king
mysql>
change
master
to
master_host="172.25.0.11",master_user="slave",master_password="(Uploo00king)",master_log_file='
mastera.000002',master_log_pos=1634 for channel 'mastera';
Query OK, 0 rows affected, 2 warnings (0.24 sec)
mysql>
change
master
to
master_host="172.25.0.12",master_user="slave",master_password="(Uploo00king)",master_log_file='
serverb.000002',master_log_pos=894 for channel 'masterb';
>slave start;
>show slave status\G;
========================================================
测试
1.M1 写,Slaves 是否同步到
2.M1 坏了,M2 写,slaves 是否同步到了
-------------------------------------------------
[root@slaveb0 ~]# mysql -uroot -p'(Uploo00king)' 
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.10 MySQL Community Server (GPL)


Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> stop slave;
Query OK, 0 rows affected (0.07 sec)


mysql> change master to master_host='172.25.0.11',master_user='slave',master_password='(Uploo00king)',master_auto_position=0;
Query OK, 0 rows affected, 2 warnings (0.19 sec)


mysql> change master to master_host=' ';
Query OK, 0 rows affected (0.22 sec)


mysql> change master to master_host='172.25.0.11',master_user='slave',master_password='(Uploo00king)',master_log_file='mastera.000002',master_log_pos=356 for channel 'mastera';
Query OK, 0 rows affected, 2 warnings (0.36 sec)


mysql> change master to master_host='172.25.0.12',master_user='slave',master_password='(Uploo00king)',master_log_file='masterb.000001',master_log_pos=154 for channel 'masterb';
Query OK, 0 rows affected, 2 warnings (0.36 sec)


mysql> start slave;
Query OK, 0 rows affected (0.09 sec)


mysql> show slave status\G;
*************************** 1. row ***************************
               Slave_IO_State: Connecting to master
                  Master_Host:  
                  Master_User: slave
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: 
          Read_Master_Log_Pos: 4
               Relay_Log_File: slaveb0-relay-bin.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File: 
             Slave_IO_Running: Connecting
            Slave_SQL_Running: Yes
              Replicate_Do_DB: 
          Replicate_Ignore_DB: 
           Replicate_Do_Table: 
       Replicate_Ignore_Table: 
      Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                   Last_Errno: 0
                   Last_Error: 
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 0
              Relay_Log_Space: 154
              Until_Condition: None
               Until_Log_File: 
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File: 
           Master_SSL_CA_Path: 
              Master_SSL_Cert: 
            Master_SSL_Cipher: 
               Master_SSL_Key: 
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 2005
                Last_IO_Error: error connecting to master 'slave@ :3306' - retry-time: 60  retries: 1
               Last_SQL_Errno: 0
               Last_SQL_Error: 
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 0
                  Master_UUID: 
             Master_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind: 
      Last_IO_Error_Timestamp: 160902 16:09:51
     Last_SQL_Error_Timestamp: 
               Master_SSL_Crl: 
           Master_SSL_Crlpath: 
           Retrieved_Gtid_Set: 
            Executed_Gtid_Set: c9b0fabb-70be-11e6-87c2-52540000000b:1-3
                Auto_Position: 0
         Replicate_Rewrite_DB: 
                 Channel_Name: 
           Master_TLS_Version: 
*************************** 2. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 172.25.0.11
                  Master_User: slave
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mastera.000002
          Read_Master_Log_Pos: 356
               Relay_Log_File: slaveb0-relay-bin-mastera.000002
                Relay_Log_Pos: 318
        Relay_Master_Log_File: mastera.000002
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB: 
          Replicate_Ignore_DB: 
           Replicate_Do_Table: 
       Replicate_Ignore_Table: 
      Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                   Last_Errno: 0
                   Last_Error: 
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 356
              Relay_Log_Space: 535
              Until_Condition: None
               Until_Log_File: 
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File: 
           Master_SSL_CA_Path: 
              Master_SSL_Cert: 
            Master_SSL_Cipher: 
               Master_SSL_Key: 
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error: 
               Last_SQL_Errno: 0
               Last_SQL_Error: 
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 1
                  Master_UUID: c9b0fabb-70be-11e6-87c2-52540000000b
             Master_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind: 
      Last_IO_Error_Timestamp: 
     Last_SQL_Error_Timestamp: 
               Master_SSL_Crl: 
           Master_SSL_Crlpath: 
           Retrieved_Gtid_Set: 
            Executed_Gtid_Set: c9b0fabb-70be-11e6-87c2-52540000000b:1-3
                Auto_Position: 0
         Replicate_Rewrite_DB: 
                 Channel_Name: mastera
           Master_TLS_Version: 
*************************** 3. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 172.25.0.12
                  Master_User: slave
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: masterb.000001
          Read_Master_Log_Pos: 154
               Relay_Log_File: slaveb0-relay-bin-masterb.000002
                Relay_Log_Pos: 318
        Relay_Master_Log_File: masterb.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB: 
          Replicate_Ignore_DB: 
           Replicate_Do_Table: 
       Replicate_Ignore_Table: 
      Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                   Last_Errno: 0
                   Last_Error: 
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 154
              Relay_Log_Space: 535
              Until_Condition: None
               Until_Log_File: 
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File: 
           Master_SSL_CA_Path: 
              Master_SSL_Cert: 
            Master_SSL_Cipher: 
               Master_SSL_Key: 
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error: 
               Last_SQL_Errno: 0
               Last_SQL_Error: 
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 2
                  Master_UUID: 0aca83bf-70d6-11e6-9d7c-52540000000c
             Master_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind: 
      Last_IO_Error_Timestamp: 
     Last_SQL_Error_Timestamp: 
               Master_SSL_Crl: 
           Master_SSL_Crlpath: 
           Retrieved_Gtid_Set: 
            Executed_Gtid_Set: c9b0fabb-70be-11e6-87c2-52540000000b:1-3
                Auto_Position: 0
         Replicate_Rewrite_DB: 
                 Channel_Name: masterb
           Master_TLS_Version: 
3 rows in set (0.00 sec)








































































=======================================
# 详细步骤（重置mastera）
[root@mastera0 ~]# yum install -y wget vim net-tools
[root@mastera0 ~]# wget http://classroom.example.com/materials/mysql-5.7.repo -P /etc/yum.repos.d/
--2016-09-02 11:25:09--  http://classroom.example.com/materials/mysql-5.7.repo
Resolving classroom.example.com (classroom.example.com)... 172.25.254.254
Connecting to classroom.example.com (classroom.example.com)|172.25.254.254|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 141 [application/x-troff-man]
Saving to: ‘/etc/yum.repos.d/mysql-5.7.repo’


100%[==========================================================>] 141         --.-K/s   in 0s      


2016-09-02 11:25:09 (18.1 MB/s) - ‘/etc/yum.repos.d/mysql-5.7.repo’ saved [141/141]


[root@mastera0 ~]# ll /etc/yum.repos.d/
total 12
-rw-r--r--. 1 root root 141 May  4 02:57 mysql-5.7.repo
-rw-r--r--. 1 root root 358 Apr 24 14:28 redhat.repo
-rw-r--r--. 1 root root 135 Apr 24 14:41 rhel_dvd.repo
[root@mastera0 ~]# yum clean all
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Cleaning repos: mysql5.7 rhel_dvd
Cleaning up everything
[root@mastera0 ~]# yum makecache
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
mysql5.7                                                                     | 2.9 kB  00:00:00     
rhel_dvd                                                                     | 4.1 kB  00:00:00     
(1/7): mysql5.7/filelists_db                                                 | 3.7 kB  00:00:00     
(2/7): mysql5.7/other_db                                                     | 2.5 kB  00:00:00     
(3/7): mysql5.7/primary_db                                                   | 6.8 kB  00:00:00     
(4/7): rhel_dvd/group_gz                                                     | 136 kB  00:00:00     
(5/7): rhel_dvd/filelists_db                                                 | 3.2 MB  00:00:00     
(6/7): rhel_dvd/primary_db                                                   | 3.6 MB  00:00:00     
(7/7): rhel_dvd/other_db                                                     | 1.4 MB  00:00:00     
Metadata Cache Created
[root@mastera0 ~]# yum makecache
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
mysql5.7                                                                     | 2.9 kB  00:00:00     
rhel_dvd                                                                     | 4.1 kB  00:00:00     
Metadata Cache Created
[root@mastera0 ~]# 
[root@mastera0 ~]# yum list|grep mysql
akonadi-mysql.x86_64                    1.9.2-4.el7                rhel_dvd     
dovecot-mysql.x86_64                    1:2.2.10-5.el7             rhel_dvd     
libdbi-dbd-mysql.x86_64                 0.8.3-16.el7               rhel_dvd     
mysql-community-client.x86_64           5.7.10-1.el7               mysql5.7     
mysql-community-common.x86_64           5.7.10-1.el7               mysql5.7     
mysql-community-libs.x86_64             5.7.10-1.el7               mysql5.7     
mysql-community-server.x86_64           5.7.10-1.el7               mysql5.7     
mysql-connector-java.noarch             1:5.1.25-3.el7             rhel_dvd     
mysql-connector-odbc.x86_64             5.2.5-6.el7                rhel_dvd     
pcp-pmda-mysql.x86_64                   3.10.6-2.el7               rhel_dvd     
php-mysql.x86_64                        5.4.16-36.el7_1            rhel_dvd     
qt-mysql.i686                           1:4.8.5-11.el7             rhel_dvd     
qt-mysql.x86_64                         1:4.8.5-11.el7             rhel_dvd     
rsyslog-mysql.x86_64                    7.4.7-12.el7               rhel_dvd     
[root@mastera0 ~]# yum install -y mysql-community-server
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.10-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.10-1.el7 for package: mysql-community-server-5.7.10-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) = 5.7.10-1.el7 for package: mysql-community-server-5.7.10-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.10-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) = 5.7.10-1.el7 for package: mysql-community-client-5.7.10-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.7.10-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.44-2.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
---> Package mysql-community-libs.x86_64 0:5.7.10-1.el7 will be obsoleting
--> Finished Dependency Resolution
Error: Package: 2:postfix-2.10.1-6.el7.x86_64 (@anaconda/7.2)
           Requires: libmysqlclient.so.18(libmysqlclient_18)(64bit)
           Removing: 1:mariadb-libs-5.5.44-2.el7.x86_64 (@anaconda/7.2)
               libmysqlclient.so.18(libmysqlclient_18)(64bit)
           Obsoleted By: mysql-community-libs-5.7.10-1.el7.x86_64 (mysql5.7)
               Not found
Error: Package: 2:postfix-2.10.1-6.el7.x86_64 (@anaconda/7.2)
           Requires: libmysqlclient.so.18()(64bit)
           Removing: 1:mariadb-libs-5.5.44-2.el7.x86_64 (@anaconda/7.2)
               libmysqlclient.so.18()(64bit)
           Obsoleted By: mysql-community-libs-5.7.10-1.el7.x86_64 (mysql5.7)
              ~libmysqlclient.so.20()(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[root@mastera0 ~]# 
[root@mastera0 ~]# rpm -e --nodeps mariadb-libs
[root@mastera0 ~]# rpm -qa|grep mariadb
[root@mastera0 ~]# yum install -y mysql-community-server
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.10-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.10-1.el7 for package: mysql-community-server-5.7.10-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) = 5.7.10-1.el7 for package: mysql-community-server-5.7.10-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.10-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) = 5.7.10-1.el7 for package: mysql-community-client-5.7.10-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.7.10-1.el7 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.7.10-1.el7 will be installed
--> Finished Dependency Resolution


Dependencies Resolved


====================================================================================================
 Package                          Arch             Version                 Repository          Size
====================================================================================================
Installing:
 mysql-community-server           x86_64           5.7.10-1.el7            mysql5.7           142 M
Installing for dependencies:
 mysql-community-client           x86_64           5.7.10-1.el7            mysql5.7            24 M
 mysql-community-common           x86_64           5.7.10-1.el7            mysql5.7           269 k
 mysql-community-libs             x86_64           5.7.10-1.el7            mysql5.7           2.2 M


Transaction Summary
====================================================================================================
Install  1 Package (+3 Dependent packages)


Total download size: 169 M
Installed size: 773 M
Downloading packages:
(1/4): mysql-community-common-5.7.10-1.el7.x86_64.rpm                        | 269 kB  00:00:00     
(2/4): mysql-community-libs-5.7.10-1.el7.x86_64.rpm                          | 2.2 MB  00:00:00     
(3/4): mysql-community-client-5.7.10-1.el7.x86_64.rpm                        |  24 MB  00:00:00     
(4/4): mysql-community-server-5.7.10-1.el7.x86_64.rpm                        | 142 MB  00:00:05     
----------------------------------------------------------------------------------------------------
Total                                                                30 MB/s | 169 MB  00:00:05     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:
2:postfix-2.10.1-6.el7.x86_64 has missing requires of libmysqlclient.so.18()(64bit)
2:postfix-2.10.1-6.el7.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_18)(64bit)
  Installing : mysql-community-common-5.7.10-1.el7.x86_64                                       1/4 
  Installing : mysql-community-libs-5.7.10-1.el7.x86_64                                         2/4 
  Installing : mysql-community-client-5.7.10-1.el7.x86_64                                       3/4 
  Installing : mysql-community-server-5.7.10-1.el7.x86_64                                       4/4 
  Verifying  : mysql-community-server-5.7.10-1.el7.x86_64                                       1/4 
  Verifying  : mysql-community-common-5.7.10-1.el7.x86_64                                       2/4 
  Verifying  : mysql-community-libs-5.7.10-1.el7.x86_64                                         3/4 
  Verifying  : mysql-community-client-5.7.10-1.el7.x86_64                                       4/4 


Installed:
  mysql-community-server.x86_64 0:5.7.10-1.el7                                                      


Dependency Installed:
  mysql-community-client.x86_64 0:5.7.10-1.el7     mysql-community-common.x86_64 0:5.7.10-1.el7    
  mysql-community-libs.x86_64 0:5.7.10-1.el7      


Complete!
[root@mastera0 ~]# 
[root@mastera0 ~]# rpm -ql mysql-community-server
/etc/logrotate.d/mysql
/etc/my.cnf
/etc/my.cnf.d
/usr/bin/innochecksum
/usr/bin/lz4_decompress
/usr/bin/my_print_defaults
/usr/bin/myisam_ftdump
/usr/bin/myisamchk
/usr/bin/myisamlog
/usr/bin/myisampack
/usr/bin/mysql_install_db
/usr/bin/mysql_plugin
/usr/bin/mysql_secure_installation
/usr/bin/mysql_ssl_rsa_setup
/usr/bin/mysql_tzinfo_to_sql
/usr/bin/mysql_upgrade
/usr/bin/mysqld_pre_systemd
/usr/bin/mysqldumpslow
/usr/bin/perror
/usr/bin/replace
/usr/bin/resolve_stack_dump
/usr/bin/resolveip
/usr/bin/zlib_decompress
/usr/lib/systemd/system/mysqld.service
/usr/lib/tmpfiles.d/mysql.conf
/usr/lib64/mysql/mecab
/usr/lib64/mysql/mecab/dic
/usr/lib64/mysql/mecab/dic/ipadic_euc-jp
/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/char.bin
/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/dicrc
/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/left-id.def
/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/matrix.bin
/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/pos-id.def
/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/rewrite.def
/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/right-id.def
/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/sys.dic
/usr/lib64/mysql/mecab/dic/ipadic_euc-jp/unk.dic
/usr/lib64/mysql/mecab/dic/ipadic_sjis
/usr/lib64/mysql/mecab/dic/ipadic_sjis/char.bin
/usr/lib64/mysql/mecab/dic/ipadic_sjis/dicrc
/usr/lib64/mysql/mecab/dic/ipadic_sjis/left-id.def
/usr/lib64/mysql/mecab/dic/ipadic_sjis/matrix.bin
/usr/lib64/mysql/mecab/dic/ipadic_sjis/pos-id.def
/usr/lib64/mysql/mecab/dic/ipadic_sjis/rewrite.def
/usr/lib64/mysql/mecab/dic/ipadic_sjis/right-id.def
/usr/lib64/mysql/mecab/dic/ipadic_sjis/sys.dic
/usr/lib64/mysql/mecab/dic/ipadic_sjis/unk.dic
/usr/lib64/mysql/mecab/dic/ipadic_utf-8
/usr/lib64/mysql/mecab/dic/ipadic_utf-8/char.bin
/usr/lib64/mysql/mecab/dic/ipadic_utf-8/dicrc
/usr/lib64/mysql/mecab/dic/ipadic_utf-8/left-id.def
/usr/lib64/mysql/mecab/dic/ipadic_utf-8/matrix.bin
/usr/lib64/mysql/mecab/dic/ipadic_utf-8/pos-id.def
/usr/lib64/mysql/mecab/dic/ipadic_utf-8/rewrite.def
/usr/lib64/mysql/mecab/dic/ipadic_utf-8/right-id.def
/usr/lib64/mysql/mecab/dic/ipadic_utf-8/sys.dic
/usr/lib64/mysql/mecab/dic/ipadic_utf-8/unk.dic
/usr/lib64/mysql/mecab/etc
/usr/lib64/mysql/mecab/etc/mecabrc
/usr/lib64/mysql/plugin
/usr/lib64/mysql/plugin/adt_null.so
/usr/lib64/mysql/plugin/auth_socket.so
/usr/lib64/mysql/plugin/debug
/usr/lib64/mysql/plugin/debug/adt_null.so
/usr/lib64/mysql/plugin/debug/auth_socket.so
/usr/lib64/mysql/plugin/debug/ha_example.so
/usr/lib64/mysql/plugin/debug/innodb_engine.so
/usr/lib64/mysql/plugin/debug/libmemcached.so
/usr/lib64/mysql/plugin/debug/libpluginmecab.so
/usr/lib64/mysql/plugin/debug/locking_service.so
/usr/lib64/mysql/plugin/debug/mypluglib.so
/usr/lib64/mysql/plugin/debug/mysql_no_login.so
/usr/lib64/mysql/plugin/debug/rewrite_example.so
/usr/lib64/mysql/plugin/debug/rewriter.so
/usr/lib64/mysql/plugin/debug/semisync_master.so
/usr/lib64/mysql/plugin/debug/semisync_slave.so
/usr/lib64/mysql/plugin/debug/validate_password.so
/usr/lib64/mysql/plugin/debug/version_token.so
/usr/lib64/mysql/plugin/ha_example.so
/usr/lib64/mysql/plugin/innodb_engine.so
/usr/lib64/mysql/plugin/libmemcached.so
/usr/lib64/mysql/plugin/libpluginmecab.so
/usr/lib64/mysql/plugin/locking_service.so
/usr/lib64/mysql/plugin/mypluglib.so
/usr/lib64/mysql/plugin/mysql_no_login.so
/usr/lib64/mysql/plugin/rewrite_example.so
/usr/lib64/mysql/plugin/rewriter.so
/usr/lib64/mysql/plugin/semisync_master.so
/usr/lib64/mysql/plugin/semisync_slave.so
/usr/lib64/mysql/plugin/validate_password.so
/usr/lib64/mysql/plugin/version_token.so
/usr/sbin/mysqld
/usr/sbin/mysqld-debug
/usr/share/doc/mysql-community-server-5.7.10
/usr/share/doc/mysql-community-server-5.7.10/COPYING
/usr/share/doc/mysql-community-server-5.7.10/ChangeLog
/usr/share/doc/mysql-community-server-5.7.10/INFO_BIN
/usr/share/doc/mysql-community-server-5.7.10/INFO_SRC
/usr/share/doc/mysql-community-server-5.7.10/README
/usr/share/doc/mysql-community-server-5.7.10/my-default.cnf
/usr/share/man/man1/innochecksum.1.gz
/usr/share/man/man1/lz4_decompress.1.gz
/usr/share/man/man1/my_print_defaults.1.gz
/usr/share/man/man1/myisam_ftdump.1.gz
/usr/share/man/man1/myisamchk.1.gz
/usr/share/man/man1/myisamlog.1.gz
/usr/share/man/man1/myisampack.1.gz
/usr/share/man/man1/mysql.server.1.gz
/usr/share/man/man1/mysql_install_db.1.gz
/usr/share/man/man1/mysql_plugin.1.gz
/usr/share/man/man1/mysql_secure_installation.1.gz
/usr/share/man/man1/mysql_ssl_rsa_setup.1.gz
/usr/share/man/man1/mysql_tzinfo_to_sql.1.gz
/usr/share/man/man1/mysql_upgrade.1.gz
/usr/share/man/man1/mysqld_multi.1.gz
/usr/share/man/man1/mysqld_safe.1.gz
/usr/share/man/man1/mysqldumpslow.1.gz
/usr/share/man/man1/mysqlman.1.gz
/usr/share/man/man1/perror.1.gz
/usr/share/man/man1/replace.1.gz
/usr/share/man/man1/resolve_stack_dump.1.gz
/usr/share/man/man1/resolveip.1.gz
/usr/share/man/man1/zlib_decompress.1.gz
/usr/share/man/man8/mysqld.8.gz
/usr/share/mysql/dictionary.txt
/usr/share/mysql/fill_help_tables.sql
/usr/share/mysql/innodb_memcached_config.sql
/usr/share/mysql/install_rewriter.sql
/usr/share/mysql/magic
/usr/share/mysql/my-default.cnf
/usr/share/mysql/mysql-log-rotate
/usr/share/mysql/mysql_security_commands.sql
/usr/share/mysql/mysql_sys_schema.sql
/usr/share/mysql/mysql_system_tables.sql
/usr/share/mysql/mysql_system_tables_data.sql
/usr/share/mysql/mysql_test_data_timezone.sql
/usr/share/mysql/uninstall_rewriter.sql
/var/lib/mysql
/var/lib/mysql-files
/var/run/mysqld
[root@mastera0 ~]# ll /var/log/mysqld.log 
-rw-r--r--. 1 root root 0 Sep  2 11:29 /var/log/mysqld.log
[root@mastera0 ~]# 
[root@mastera0 ~]# rpm -ql mysql-community-client
/usr/bin/mysql
/usr/bin/mysql_config
/usr/bin/mysql_config-64
/usr/bin/mysql_config_editor
/usr/bin/mysqladmin
/usr/bin/mysqlbinlog
/usr/bin/mysqlcheck
/usr/bin/mysqldump
/usr/bin/mysqlimport
/usr/bin/mysqlpump
/usr/bin/mysqlshow
/usr/bin/mysqlslap
/usr/share/doc/mysql-community-client-5.7.10
/usr/share/doc/mysql-community-client-5.7.10/COPYING
/usr/share/doc/mysql-community-client-5.7.10/README
/usr/share/man/man1/mysql.1.gz
/usr/share/man/man1/mysql_config_editor.1.gz
/usr/share/man/man1/mysqladmin.1.gz
/usr/share/man/man1/mysqlbinlog.1.gz
/usr/share/man/man1/mysqlcheck.1.gz
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysqlimport.1.gz
/usr/share/man/man1/mysqlpump.1.gz
/usr/share/man/man1/mysqlshow.1.gz
/usr/share/man/man1/mysqlslap.1.gz
[root@mastera0 ~]# 












[root@mastera0 ~]# systemctl start mysqld
[root@mastera0 ~]# systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2016-09-02 11:39:30 CST; 7s ago
  Process: 9540 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 9466 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 9543 (mysqld)
   CGroup: /system.slice/mysqld.service
           └─9543 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.p...


Sep 02 11:38:58 mastera0.example.com systemd[1]: Starting MySQL Server...
Sep 02 11:39:30 mastera0.example.com systemd[1]: Started MySQL Server.
[root@mastera0 ~]# ps -ef|grep mysqld
mysql     9543     1  0 11:39 ?        00:00:00 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
root      9573  2368  0 11:40 pts/0    00:00:00 grep --color=auto mysqld
[root@mastera0 ~]# netstat -luntp|grep mysqld
tcp6       0      0 :::3306                 :::*                    LISTEN      9543/mysqld         
[root@mastera0 ~]# 






[root@mastera0 ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@mastera0 ~]# grep password /var/log/mysqld.log 
2016-09-02T03:39:01.230715Z 1 [Note] A temporary password is generated for root@localhost: piBUQLFXh7%x
2016-09-02T03:42:27.789548Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
[root@mastera0 ~]# mysql -uroot -p'piBUQLFXh7%x'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.10


Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> \q
Bye
[root@mastera0 ~]# 














[root@mastera0 ~]# mysqladmin -uroot -p'piBUQLFXh7%x' password '(Uploo00king)'
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
[root@mastera0 ~]# ls -a
.   anaconda-ks.cfg  .bash_logout   .bashrc  .mysql_history
..  .bash_history    .bash_profile  .cshrc   .tcshrc
[root@mastera0 ~]#  ls 
anaconda-ks.cfg
[root@mastera0 ~]# mysql -uroot -p'(Uploo00king)'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.10 MySQL Community Server (GPL)


Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)


mysql> desc mysql.user;
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Field                  | Type                              | Null | Key | Default               | Extra |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Host                   | char(60)                          | NO   | PRI |                       |       |
| User                   | char(32)                          | NO   | PRI |                       |       |
| Select_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Insert_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Update_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Delete_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Create_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Drop_priv              | enum('N','Y')                     | NO   |     | N                     |       |
| Reload_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Shutdown_priv          | enum('N','Y')                     | NO   |     | N                     |       |
| Process_priv           | enum('N','Y')                     | NO   |     | N                     |       |
| File_priv              | enum('N','Y')                     | NO   |     | N                     |       |
| Grant_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| References_priv        | enum('N','Y')                     | NO   |     | N                     |       |
| Index_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| Alter_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| Show_db_priv           | enum('N','Y')                     | NO   |     | N                     |       |
| Super_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| Create_tmp_table_priv  | enum('N','Y')                     | NO   |     | N                     |       |
| Lock_tables_priv       | enum('N','Y')                     | NO   |     | N                     |       |
| Execute_priv           | enum('N','Y')                     | NO   |     | N                     |       |
| Repl_slave_priv        | enum('N','Y')                     | NO   |     | N                     |       |
| Repl_client_priv       | enum('N','Y')                     | NO   |     | N                     |       |
| Create_view_priv       | enum('N','Y')                     | NO   |     | N                     |       |
| Show_view_priv         | enum('N','Y')                     | NO   |     | N                     |       |
| Create_routine_priv    | enum('N','Y')                     | NO   |     | N                     |       |
| Alter_routine_priv     | enum('N','Y')                     | NO   |     | N                     |       |
| Create_user_priv       | enum('N','Y')                     | NO   |     | N                     |       |
| Event_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| Trigger_priv           | enum('N','Y')                     | NO   |     | N                     |       |
| Create_tablespace_priv | enum('N','Y')                     | NO   |     | N                     |       |
| ssl_type               | enum('','ANY','X509','SPECIFIED') | NO   |     |                       |       |
| ssl_cipher             | blob                              | NO   |     | NULL                  |       |
| x509_issuer            | blob                              | NO   |     | NULL                  |       |
| x509_subject           | blob                              | NO   |     | NULL                  |       |
| max_questions          | int(11) unsigned                  | NO   |     | 0                     |       |
| max_updates            | int(11) unsigned                  | NO   |     | 0                     |       |
| max_connections        | int(11) unsigned                  | NO   |     | 0                     |       |
| max_user_connections   | int(11) unsigned                  | NO   |     | 0                     |       |
| plugin                 | char(64)                          | NO   |     | mysql_native_password |       |
| authentication_string  | text                              | YES  |     | NULL                  |       |
| password_expired       | enum('N','Y')                     | NO   |     | N                     |       |
| password_last_changed  | timestamp                         | YES  |     | NULL                  |       |
| password_lifetime      | smallint(5) unsigned              | YES  |     | NULL                  |       |
| account_locked         | enum('N','Y')                     | NO   |     | N                     |       |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
45 rows in set (0.00 sec)


mysql>