I have used RDS for many years, and MySQL for even longer, so I am very familiar with both -- yet, I am running into an odd thing that I cannot figure out. Wondering if someone can help.
I have 2 databases (production, staging) on RDS. They are separate DB instances. I have applications running on EC2 instances that access the respective DBs. They are working fine and never have lost a DB connection, etc.
I normally make schema updates and do specialized queries by connecting from one of my application EC2 hosts (which has connectivity rights to RDS of course), via command line MySQL. This works fine for many days. Then, suddenly, one day, while trying to access my production DB, I get:
ERROR 1045 (28000): Access denied for user ...
I try connecting from another one of my app hosts. No dice. I try connecting on one of my staging EC2 hosts to the staging RDS instance. Same result! Crazy! Two different RDS instances. Multiple EC2 hosts, all with network access to the RDS instance.
Has anyone else ever run into this? I have tried rebooting the RDS instance, but to no avail. And then I run a simple Java program on the EC2 host that connects to the DB via JDBC, and it works fine!
I'm baffled. Almost like something is wrong with the mysql client.
Any help would be appreciated.