一、安装MySQL
1、卸载mariadb:yum remove mariadb-libs
1、安装wget:yum -y install wget
2、下载官方 Mysql 包:wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
3、安装 Mysql 包:yum -y install mysql57-community-release-el7-10.noarch.rpm
4、安装 Mysql:yum install mysql-community-server --nogpgcheck
5、启动MySQL:service mysqld restart
6、查看MySQL初始密码:cat /var/log/mysqld.log|grep temp
7、修改密码、设置权限
降低密码复杂度限制:set global validate_password_policy=0;
降低密码长度限制:set global validate_password_length=4;
修改root用户的初始密码:alter user 'root'@'localhost' identified by 'qwer';
授权:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' identified by 'qwer';
刷新权限:flush privileges;
8、创建访问用户txdev:grant all privilegs on *.* to 'txdev'@'%' identfield by 'txdev
二、主机配置
1、开启mysql的binlog日志,vim /etc/my.cnf 插入配置
2、重启mysql
service mysqld restart
3、在MySQL中重新查看bin-log日志文件:Show variables like '%log_bin%':log-bin为on表示开启。
4、创建用户:txdev
grant all privilegs on *.* to ''txdev'@'%' identfield by 'txdev'
刷新权限:Flush privileges
三、从机配置
1、开启中继日志
配置中继日志:vim /etc/my.cnf,输入一下命令
重启MySQL:service mysqld restart,出现下图框中内容即可
2、配置访问节点的参数。在从机中输入MySQL中输入
a、先关闭线程:stop slave;
b、在从机中输入MySQL中输入
CHANGE MASTER TO
MASTER_HOST='主机IP',MASTER_USER='访问者账号',MASTER_PASSWORD='访问者密码',
MASTER_LOG_FILE='mysql-bin.000002',MASTER_LOG_POS=154;
(注:这个图是在主机的MySQL中输入show master status\G;)
c、开启线程:start slave;
d、输入show slave status\G,出现框中内容即可: