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?