1、参考:https://www.cnblogs.com/2020javamianshibaodian/p/windows10mysql.html
2、拷贝压缩包到指定目录下(注意不要用中文路径)
3、在目录上建Data目录和my.ini文件
4、ini文件
5、配置环境变量,D:\DEVTOOLS\mysql8022\bin
6、电脑用管理员命令模式进入mysql/bin目录,进行mysql初始化安装
1)、mysqld --initialize --console
构建data目录以及其他设置。用鼠标选中下面的密码,按ctrl+c复制。
这里注意,如果后续my.ini文件有修改,而重启mysql后不生效,需要删除data目录,删除mysql服务,
命令sc delete 服务名,然后重新执行该命令
2)、mysqld --install
3)、net start mysql
7、登录,修改密码
mysql -u root -p
alter user root@localhost identified by 'root';
enter键后成功改密码为root,这里sql语句后面的分号不要丢
8、is not allowed to connect to this mysql server
参考:https://blog.csdn.net/iiiiiilikangshuai/article/details/100905996
mysql -u root -p
use mysql;
select host from user where user='root';
update user set host='%' where user='root';
flush privileges;
9、主从配置,
参考:https://blog.51cto.com/369369/790921
https://blog.csdn.net/u013589153/article/details/112480121
配置如下:
## 主从配置
## 主配置
## [必须]启用二进制日志
#log-bin=mysql-bin
## [必须]服务器唯一ID,默认是1,一般取IP最后一段
#server-id=20
## 不开启binlog的数据库
#binlog-ignore-db=information_schema
#binlog-ignore-db=sys
#binlog-ignore-db=performance_schema
#binlog-ignore-db=mysql
## 开启binlog的数据库,不能用逗号隔开
#binlog-do-db=kj
## binlog格式
#binlog_format=MIXED
# 从配置
# [不是必须]启用二进制日志
log-bin=mysql-bin
# [必须]服务器唯一ID,默认是1,一般取IP最后一段
server-id=19
#需要同步的数据库
replicate_do_db=kj912_pls
# 不开启binlog的数据库
binlog-ignore-db=information_schema
binlog-ignore-db=sys
binlog-ignore-db=performance_schema
binlog-ignore-db=mysql
# 开启binlog的数据库,不能用逗号隔开
binlog-do-db=kj
# binlog格式
binlog_format=MIXED
9、服务器A登录数据库后,执行:
# 服务器1
CREATE USER 'mscopy'@'%' identified by 'xxx';
GRANT REPLICATION SLAVE ON *.* TO 'mscopy'@'%';
flush privileges;
show master status
CHANGE MASTER TO
MASTER_HOST='192.168.2.19',
MASTER_USER='mscopy',
MASTER_PASSWORD='xxxx',
MASTER_LOG_FILE='mysql-bin.000003',
MASTER_LOG_POS=156;
start slave;
show slave status\G;
10、服务器B登录数据库后,执行:
# 服务器2
CREATE USER 'mscopy'@'%' identified by 'xxx';
GRANT REPLICATION SLAVE ON *.* TO 'mscopy'@'%';
flush privileges;
show master status
CHANGE MASTER TO
MASTER_HOST='192.168.2.20',
MASTER_USER='mscopy',
MASTER_PASSWORD='xxxxx',
MASTER_LOG_FILE='mysql-bin.000002',
MASTER_LOG_POS=156;
start slave;
show slave status\G;
11、互为主从,
参考:https://www.cnblogs.com/voiphudong/p/3334078.html
https://blog.csdn.net/weixin_49725095/article/details/109748903
https://www.cnblogs.com/hyydeali/p/12844870.html
12、锁表及解锁
FLUSH TABLES WITH READ LOCK;
UNLOCK TABLES;