HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Connecting to AWS RDS DBInstance with MySQL workbench

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
workbenchwithconnectingdbinstancemysqlawsrds

Problem

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:

  • Give the Endpoint address of DBInstance as Hostname.



  • Port : 3306



  • 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 .

Solution

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

Context

StackExchange Database Administrators Q#31067, answer score: 2

Revisions (0)

No revisions yet.