简介：一、安装MySQL 5.7如果安装过mysql,删除停掉mysql进程:pkill -9 mysqld1删除mysql:rpm -qa|grep -i mysqlyum -y removemysql-community-client-5.6.38-2.el7.x86_64123依次卸载 直到没有yum安装cd /usr/local/src/wg ...
| 一、安装MySQL 5.7如果安装过mysql,删除停掉mysql进程:pkill -9 mysqld1删除mysql:rpm -qa|grep -i mysqlyum -y removemysql-community-client-5.6.38-2.el7.x86_64123依次卸载 直到没有yum安装cd /usr/local/src/wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm rpm -ivh mysql57-community-release-el7-8.noarch.rpm yum -y install mysql-server1234567默认配置文件路径：配置文件：/etc/my.cnf日志文件：/var/log/mysqld.log服务启动脚本：/usr/lib/systemd/system/mysqld.servicesocket文件：/var/run/mysqld/mysqld.pid启动mysqlservice mysqld restart1查看临时密码:$ grep "password" /var/log/mysqld.log临时密码信息如下:[Note] A temporary password is generated for root@localhost: M:sd6OoNZkz112345用临时密码登录:mysql -uroot -p1修改密码(密码8位以上,大小写字母+数字+特殊符号):set password for root@localhost = password("Node2018!");1二、Navicat连接mysql登录mysql,查看现有的user:mysql -uroot -pNode2018!mysql> select host,user from mysql.user;+-----------+---------------+| host | user |+-----------+---------------+| localhost | mysql.session || localhost | mysql.sys || localhost | root |+-----------+---------------+3 rows in set (0.01 sec)12345678910创建一个新的账号:CREATE USER "root"@"%" IDENTIFIED BY "Node2018!";GRANT ALL PRIVILEGES ON *.* TO "root"@"%";12刷新权限:FLUSH PRIVILEGES;1三、主从复制配置编辑mysql的配置文件: vim /etc/my.cnf192.168.7.2:log-bin=mysql-bin #binlog文件的前缀,可以修改binlog-format=ROW #选择row模式 server_id=2 #必须,不同mysql不能重复log_slave_updates=1 #开启以后从库会记录主库同步的binlog。auto_increment_increment=2 #步进值,一般有n台主MySQL就填n。auto_increment_offset=1 #起始值。一般填第n台主MySQL。123456192.168.7.3:log-bin=mysql-bin #binlog文件的前缀,可以修改binlog-format=ROW #选择row模式 server_id=3 #必须,不同mysql不能重复log_slave_updates=1 #开启以后从库会记录主库同步的binlog。auto_increment_increment=2 #步进值,一般有n台主MySQL就填n。auto_increment_offset=1 #起始值。一般填第n台主MySQL。123456192.168.7.4:log-bin=mysql-bin #binlog文件的前缀,可以修改binlog-format=ROW #选择row模式 server_id=4 #必须,不同mysql不能重复log_slave_updates=1 #开启以后从库会记录主库同步的binlog。1234分别重启192.168.7.2、192.168.7.3、192.168.7.4上的mysql:service mysqld restart1在192.168.7.2新建复制账号:CREATE USER user73 IDENTIFIED BY "Node2018!";GRANT ALL PRIVILEGES ON *.* TO "user73"@"%" ; FLUSH PRIVILEGES;CREATE USER user74 IDENTIFIED BY "Node2018!";GRANT ALL PRIVILEGES ON *.* TO "user74"@"%" ; FLUSH PRIVILEGES;1234567在192.168.7.3上配置复制的master信息:CHANGE MASTER TOMASTER_HOST="192.168.7.2",MASTER_USER="user73",MASTER_PASSWORD="Node2018!",MASTER_LOG_FILE="mysql-bin.000002",MASTER_LOG_POS=2340;123456在192.168.7.4上配置复制的master信息:CHANGE MASTER TOMASTER_HOST="192.168.7.2",MASTER_USER="user74",MASTER_PASSWORD="Node2018!",MASTER_LOG_FILE="mysql-bin.000002",MASTER_LOG_POS=2340;123456开启复制并查看复制状态:START SLAVE;SHOW SLAVE STATUSG;12四、主主复制配置7.2 和7.5 配置主主复制配置node5的my.cnf:log-bin=mysql-bin #binlog文件的前缀,可以修改binlog-format=ROW #选择row模式 server_id=5 #必须,不同mysql不能重复log_slave_updates=1 #开启以后从库会记录主库同步的binlog。auto_increment_increment=2 #步进值,一般有n台主MySQL就填n。auto_increment_offset=2 #起始值。一般填第n台主MySQL。123456在72上创建一个75上能访问的账号:CREATE USER user75 IDENTIFIED BY "Node2018!";GRANT ALL PRIVILEGES ON *.* TO "user75"@"%" ; FLUSH PRIVILEGES;123在75上创建一个72上能访问的账号:CREATE USER user72 IDENTIFIED BY "Node2018!";GRANT ALL PRIVILEGES ON *.* TO "user72"@"%" ; FLUSH PRIVILEGES;123互相change master:CHANGE MASTER TOMASTER_HOST="192.168.7.5",MASTER_USER="user72",MASTER_PASSWORD="Node2018!",MASTER_LOG_FILE="mysql-bin.000003",MASTER_LOG_POS=154;CHANGE MASTER TOMASTER_HOST="192.168.7.2",MASTER_USER="user75",MASTER_PASSWORD="Node2018!",MASTER_LOG_FILE="mysql-bin.000005",MASTER_LOG_POS=1761;--------------------- 作者：mydpp 原文：https://blog.csdn.net/napoay/article/details/85227607
|
