Connecting to AWS RDS DBInstance with MySQL workbench

Question

I am trying to evaluate AWS RDS to use as possible DB for our application. I have created a DBInstance(micro) and added IP security group. I am able to connect to the DBInstance from Xampp shell command line and i am able to run queries from that.

But when i try to connect with workbench to the same DBInstance, it gives me error that 'MySQL server has gone away'. Following are the steps i followed to connect with workbench:

1. Give the Endpoint address of DBInstance as Hostname.
2. Port : 3306
3. Set the username and password to master user and its password.

My database is completely new, I have just created a plain DB and trying to connect with workbench right away. I am using workbench version 5.2.25.

Any ideas on what am i missing? And yes, I am just a beginner with MySQL and AWS.

Edit: As asked by RolandoMySQLDBA, i have run the query SELECT USER(),CURRENT_USER(); and in the result i get one row with two columns USER()[email protected] and CURRENT_USER()=ei@%. ei is the master username for my RDS DBInstance. And the column USER() has my ip address after @.

I tried using both [email protected] and ei@% with workbench, but i get access denied error .

Answer 1

If you have instantiated a MySQL RDS Instance, you want to create a DB Security Group

• First Create a DB Security Group
• Under "Security Group Details", set one of the following connection types
  • CIDR/IP
  • EC2 Security Group
• Assign Address/Mask
• Make sure you do not have a proxy/firewall causing interference

Answer 2

Mine is working perfect on MySQL workbench. I remember following these steps mentioned on this link, maybe it helps:

http://thoughtsandideas.wordpress.com/2012/05/17/monitoring-and-managing-amazon-rds-databases-using-mysql-workbench/