社区
MySQL
帖子详情
CHANGE MASTER TO MASTER_HOST=""
曾经的阿飞
2011-01-14 05:25:07
CHANGE MASTER TO MASTER_HOST=""在5.0里面可以清空slave的信息,在5.1中不行了,被当bug改了,谁知道怎么样可以清空?
...全文
805
3
打赏
收藏
CHANGE MASTER TO MASTER_HOST=""
CHANGE MASTER TO MASTER_HOST=""在5.0里面可以清空slave的信息,在5.1中不行了,被当bug改了,谁知道怎么样可以清空?
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
3 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
zhaoyp1985
2013-08-07
打赏
举报
回复
reset slave all
rucypli
2011-01-14
打赏
举报
回复
stop slave不得了吗
小小小小周
2011-01-14
打赏
举报
回复
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.1.77
Master_User: rep
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000003
Read_Master_Log_Pos: 224272132
Relay_Log_File: mysqld-relay-bin.000111
Relay_Log_Pos: 1946071
Relay_Master_Log_File: mysql-bin.000003
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 224272132
Relay_Log_Space: 4247909
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> slave stop;
Query OK, 0 rows affected (0.00 sec)
mysql> change master to master_host=''
-> ;
Query OK, 0 rows affected (0.01 sec)
mysql> slave start;
ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO
mysql> select version();
+------------+
| version() |
+------------+
| 5.1.45-log |
+------------+
1 row in set (0.00 sec)
没问题呢.
Mysql配置主从时,一般遇到错误,大部分都是
change
master
to语句写错了(80%),解决方案
mysql>...
change
master
to
master
_
host
='10.1.1.10',
master
_user='slave',
master
_password='123',
master
_port=3306,
master
_log_file='binlog.000002',
master
_log_pos=597; mysql> start slave
mysql
master
_log_file_
change
master
未指定
master
_log_file
change
时未指定
master
_log_file,
master
_log_pos那么会从
MASTER
_LOG_FILE='' and
MASTER
_LOG_POS=4开始同事要实现一个东西:原来是 A->...
change
master
master
_
host
='10.19.140.142',
master
_user=...
mysql主从同步
change
master
to配置
CHANGE
MASTER
TO
MASTER
_
HOST
='10.0.0.52',
MASTER
_PORT=3308,
MASTER
_AUTO_POSITION=1,
MASTER
_USER='repl',
MASTER
_PASSWORD='123'; 转载于:https://www.cnblogs.com/xiaoyaoren/p/9625731.html
change
master
mysql_mysql主从复制-
CHANGE
MASTER
TO 语法详解
配置mysql主从复制时,在从机上需要进行
CHANGE
MASTER
TO操作,以确定需要同步的主机IP,用户名...
CHANGE
MASTER
TOoption[,option]...option:
MASTER
_BIND='interface_name'
MASTER
_
HOST
='
host
_name'
MASTER
_USER='user...
MySQL 复制
CHANGE
MASTER
TO
[code="
change
的格式"...
master
_
host
='10.20.20.11',
master
_user='cpmysql',
master
_password='cpmysql',
master
_log_file='mysql-bin.000024',
master
_port=3306,
master
_log_pos=1026786299[/...
MySQL
56,679
社区成员
56,709
社区内容
发帖
与我相关
我的任务
MySQL
MySQL相关内容讨论专区
复制链接
扫一扫
分享
社区描述
MySQL相关内容讨论专区
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章