Showing posts with label Replication. Show all posts
Showing posts with label Replication. Show all posts

Friday, 23 March 2012

MySql Replication - Error 1045

Fighting with a simple test-bed MySql replication between 2 Ubuntu 10.04 LTS servers.

It turned out you need to use the domain name, not the IP address when specifying the MASTER_HOST in the following MySql command on the Slave:

CHANGE MASTER TO MASTER_HOST='192.168.0.100', MASTER_USER='[username]', MASTER_PASSWORD='[password]', MASTER_LOG_FILE='mysql-bin.NNNNNN', MASTER_LOG_POS=N;