Mysql – Connecting to AWS RDS DBInstance with MySQL workbench

amazon-rdsMySQLmysql-workbench

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()=ei@xxx.xx.xxx.xxx 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 ei@xxx.xx.xxx.xxx and ei@% with workbench, but i get access denied error .

Best Answer

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
Related Question