Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 .

share|improve this question
    
Please go to the XAMPP Shell Command Line and run this Query : SELECT USER(),CURRENT_USER(); and post the results of the query in the question. –  RolandoMySQLDBA Dec 27 '12 at 21:53
    
Added result to the question. –  Ruchit Rami Dec 28 '12 at 4:12
    
Have you tried using ei as the username in the Workbench config of the connection? –  ypercube Dec 29 '12 at 13:18
    
@ypercube Yes I have tried that also. –  Ruchit Rami Dec 29 '12 at 15:25

2 Answers 2

up vote 0 down vote accepted

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
share|improve this answer
    
I have already done that and i am able to connect to RDS instance with my local shell command line. But can't connect with workbench. –  Ruchit Rami Dec 29 '12 at 3:52

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/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.