56,679
社区成员
发帖
与我相关
我的任务
分享数据库不能同步
错误信息如下：
090318 14:03:18 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090318 14:03:18 InnoDB: Started; log sequence number 0 43655
090318 14:03:18 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090318 14:03:18 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090318 14:03:18 [Note] Slave SQL thread initialized, starting replication in log 'binlog_name.000002' at position 98, relay log '/var/run/mysqld/mysqld-relay-bin.000002' position: 98
090318 14:03:18 [ERROR] Slave I/O thread: error connecting to master 'test@:3306': Error: 'Access denied for user 'test'@'localhost' (using password: NO)' errno: 1045 retry-time: 60 retries: 86400
在从库上执行 如下命令信息：
mysql> show slave status\G;
Empty set (0.00 sec)
ERROR:
No query specified
请知道的朋友指点一下,谢谢！！！
090318 14:03:18 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
090318 14:03:18 InnoDB: Started; log sequence number 0 43655
090318 14:03:18 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
090318 14:03:18 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
090318 14:03:18 [Note] Slave SQL thread initialized, starting replication in log 'binlog_name.000002' at position 98, relay log '/var/run/mysqld/mysqld-relay-bin.000002' position: 98
090318 14:03:18 [ERROR] Slave I/O thread: error connecting to master 'test@:3306': Error: 'Access denied for user 'test'@'localhost' (using password: NO)' errno: 1045 retry-time: 60 retries: 86400
在从库上执行 如下命令信息：
mysql> show slave status\G;
Empty set (0.00 sec)
ERROR:
No query specified
请知道的朋友指点一下,谢谢！！！
...全文
请发表友善的回复…
发表回复
jxaudfm 2009-03-19
- 打赏
- 举报
我重新配置了一下，问题终于 解决了 。还是要谢谢两位
fcoolx 2009-03-18
- 打赏
- 举报
090318 14:03:18 [ERROR] Slave I/O thread: error connecting to master 'test@:3306': Error: 'Access denied for user 'test'@'localhost' (using password: NO)' errno: 1045 retry-time: 60 retries: 86400
主要问题在最后一行 [ERROR]
显然是权限问题 检查你的 my.ini
master-host = xxx
master-user = xx
master-password =
master-port=3306
并且看msaster上有无相应的用户能在从的机器上访问
主要问题在最后一行 [ERROR]
显然是权限问题 检查你的 my.ini
master-host = xxx
master-user = xx
master-password =
master-port=3306
并且看msaster上有无相应的用户能在从的机器上访问
