I recently changed the size of my Amazon RDS instance size from micro to small. After it was finished, I could no longer login from workbench. I have been using the database all day and there have been no issues until now. I tried resetting the master password and rebooted the database as well. If anyone has any guidance on why I can no longer access the database. I created a small application and had been using it to add information to the database for hours. The endpoints and other information remain unchanged except instance type. Any help is appreciated.
If you allow me to share my story, my problem is even more strange: I could login with MySQL Workbench, but cannot query and export data. I tried logging out and then log back in, but it failed, even though I never had changed any settings and especially the password. My final solution was to change the master password and Apply that change immediately.
It is possible that there's something happened behind there that I could not possibly understand.
Try and check your RDS Instance's setting if resetting password did not work, especially the Security Group Rules setting under Network & Security. Then make sure that Public Accessibility setting is set to Yes if you are trying to access it from outside your VPC. Also try to restart your MySQL Workbench if after resetting and re-inputting your password does not work immediately.