mysql热双机搭建--普通用户下安装mysql

一、在官网上下载直接解压可安装的mysql安装包

 mysql-5.6.20-linux-glibc2.5-x86_64.tar.gz

二、在双机上进行安装mysql

groupadd mysql
useradd -g mysql mysql
cd /usr/local/
tar zxvf mysql-5.6.20-linux-glibc2.5-x86_64.tar.gz
ln -s mysql-5.6.20-linux-glibc2.5-x86_64 mysql
cd mysql
chown -Rh mysql:mysql *
cd /usr/local/mysql
scripts/mysql_install_db --user=mysql

cp /user/local/mysql/my.cnf /etc/.

su - mysql

/usr/local/mysql/support-files/mysql.server start


/usr/localmysql/bin/mysqladmin -u root password 'Alicesso!!'

bin/mysql -u root -pAlicesso!!

use mysql;

update user set host='%' where user='root' and host='localhost';

三、配置双机

主机A:172.28.0.134
grant replication slave on *.* to 'replicate'@'172.28.0.135' identified by '123456';
主机B:172.28.0.135

grant replication slave on *.* to 'replicate'@'172.28.0.134' identified by '123456';

测试：

在135上执行： mysql  -h172.28.0.134 -ureplicate -p123456
在134上执行： mysql  -h172.28.0.135 -ureplicate -p123456

修改134的my.cnf   在[mysqld]下添加
server-id=1
log-bin=mysql-bin
binlog-do-db=test
binlog-ignore-db=information_schema,performance_schema,mysql
log-slave-updates
sync_binlog=1
skip-name-resolve
auto_increment_offset=1
auto_increment_increment=2
replicate-do-db=test
replicate-ignore-db=information_schema,performance_schema,mysql

修改135的my.cnf   在[mysqld]下添加
server-id=2
log-bin=mysql-bin
replicate-do-db=test
skip-name-resolve
replicate-ignore-db=information_schema,performance_schema,mysql
binlog-do-db=test
binlog-ignore-db=information_schema,performance_schema,mysql
log-slave-updates
sync_binlog=1
auto_increment_offset=2
auto_increment_increment=2

重启mysql

show master status\G;

stop slave
根据135上的查询信息，在134上执行change master to master_host='172.28.0.135',master_user='replicate',master_password='123456', master_log_file='mysql-bin.000005',master_log_pos=120;
根据134上的查询信息，在135上执行change master to master_host='172.28.0.134',master_user='replicate',master_password='123456', master_log_file='mysql-bin.000005',master_log_pos=120;
start slave

show slave status\G;查看IO状态

mysql忘记密码

mysqld_safe --skip-grant-tables

    >use mysql 

    >update user set password=password("new_pass") where user="root"; 

    >flush privileges;