// shall I write some keywords here to boost search engine ranking?

Friday, September 21, 2007

Solution to MySQL Replication Problems: CREATE USER failed

After setup replication, I start to create a few database login. And the next day, I found that the database replication is stopped. The error code is 1396 which indicate the failure of create user.

However, when i checked into the database, the database login is created successfully. I restart the slave a few time but replication still failed to start.

Then I google and found this solution.

The workaround is add the following line into my.cnf, then restart the slave database:

slave_skip_errors=1396

No comments: