1

I want to create external read replica for my RDS instance using this doc: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html

My old instance is running mysql 5.5.27. So i started from upgrade. I tried two ways: upgrade from read replica (create replica, upgrade, promote) and upgrade from snapshot (create, upgrade). Upgrade was successful in both ways.

After that i tried create user for replica access (via doc). And got access error.
mysql> CREATE USER 'repl'@'%' IDENTIFIED BY '123';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT REPLICATION SLAVE,REPLICATION CLIENT ON *.* TO 'repl'@'%' WITH GRANT OPTION;
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)

After than i tried to create new clean instance wit mysql 5.6 and create new user. Just for test. It works like a charm!

So, where can be problem? And how can I solve it?

1

Try to execute mysql_upgrade in your imported instance. This command should upgrade your grant tables.

Take a look to

http://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.