Mysql 安装及主从设置

安装

1.解压缩下载的zip文件。
2.拷贝my-default.ini为my.ini文件
[mysqld]
port=3301
character_set_server=utf8
max_connections=100
3.注册服务：mysqld --install MySQLm
　移除mysql服务：mysqld –remove MySQLm
　启动mysql服务的命令：net start MySQLm
　停止mysql服务的命令：net stop MySQLm
4.修改mysql root密码：mysqladmin -u root --port=3301 password "123"
5.登陆mysql -u root --port=3301 -p

主从配置

1.安装从

同上安装slave 端口为3302

2.主上授权

GRANT REPLICATION SLAVE ON *.* TO 'slave001'@'127.0.0.1' IDENTIFIED BY '123';

 3.主上my.ini下添加如下行，打开binlog

log-bin = C:\\mysqltest\\mysql-5.6.11-winx64-master\\binlog\\mysql-bin.log
server-id=1

 4.查看状态

show master status

 5.从上打开binlog,my.ini添加如下

server-id=2
log-bin=C:\\mysqltest\\mysql-5.6.11-winx64-slave\\binlog\\mysql-bin.log

 6.从上执行配置主的信息

change master to master_host='127.0.0.1',master_user='slave001',master_password='123',master_log_file='mysql-bin.,000001',master_log_pos=0; 

 7.从上检查

mysql> start slave; 
mysql> SHOW SLAVE STATUS; 

 

 在主上插入记录查看，如果出现错误请show master/slave status查看错误原因并解决。