I have a mysql database in an amazon rds instance. After yesterday's backup, I am unable to login to the server and I am unable to change the master password.
When I try to change it, this message appears in db logs :
Your password reset workflow failed due to this error: unable to: set password for ?@'%' = PASSWORD(?), caused: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't find any matching row in the user table
I tried rebooting machine, nothing changed.
As far as I understand from the error message, our master user does not exist. (Since there is quiestion mark right before '@' sign).And AWS does not let us change master username.
Any help is much appreciated.