（1）创建用户 启动主MySQL服务器，登入主MySQL客户端，在主服务器上创建复制数据的账号并授权： # 登录主mysql客户端 mysql> mysql -S /opt/software/mysql/3306/tmp/mysql_3306.sock -p mysql> grant replication slave on *.* to 'slave'@'%' identified by 'mysql@123'; 创建一个MySQL用户，该用户是主服务器专门给从服务器拷贝数据用的 ...
实验环境 操作系统 ：CentOS Linux release 7.9.2009 (Core) 数据库版本：5.7.36-log 预计划安装3个MySQL实例，规划信息为： 实例一 实例二 实例三 port=3306socket=/opt/software/mysql/3306/tmp/mysql_3306.sockdatadir=/opt/software/mysql/3306/datalog-error =/opt/software/mysql/3306/error_3306.logpid-file=/opt/software/mysql/3306/mysql.pid port=3307socket=/opt/software/mysql/3307/tmp/mysql_3307.sockdatadir=/opt/software/mysql/3307/datalog-error =/opt/software/mysql/3307/error_3307.logpid-file=/opt/software/mysql/3307/mysql.pid port=3308socket=/opt/software/mysql/3308/tmp/mysql_3308.sockdatadir=/opt/software/mysql/3308/datalog-error =/opt/software/mysql/3308/error_3308.logpid-file=/opt/software/mysql/3308/mysql.pid 解压包地址 ...