MySQL Forums
Forum List  »  Replication

problem of replication
Posted by: ittoronto
Date: August 04, 2005 05:54PM

Hi there,

I am trying to configure a replication of MySql. The master and the slave are running MySql 4.1.9. I have added an user repl at master with password. While I restart the slave, I got the following error message in the log file.

050804 16:41:03 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\vidal-relay-bin.000008' position: 4
050804 16:41:03 [ERROR] Slave I/O thread: error connecting to master 'repl@"192.168.0.@rum:3306': Error: 'Access denied for user 'repl@"192.168.0.'@'VIDAL' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400

rum and vidal are computer names. Please pay attention to the stuff between repl and computer name. It is weird to see something between them. It is not a valid IP address. I guest probably, it is something wrong with the network configuration, but do not know how to fix it. The two coputers are connected at home without domain. One runs win98 and the other one runs Win2k in the workgroup. There is no problem for connection between these to hosts (including ping and share files), and there is no problem for logining to the MySql server from one to the other with user repl. Anyone who know this problem and send reply will be greate appreciated.

Another question here. It seems there is no problem for MySql server to replicate between two server throught internet connection with the host qualified IP address. Who can ocnfirm this question is also great appreciated.

Thank you in advance for answering.

Best Regards.

Options: ReplyQuote


Subject
Views
Written By
Posted
problem of replication
3433
August 04, 2005 05:54PM
2421
August 04, 2005 07:05PM
5517
August 04, 2005 10:25PM
3542
August 05, 2005 12:12AM
3006
August 05, 2005 12:36AM
3094
August 05, 2005 12:38AM
2688
August 05, 2005 10:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.