patternsqlMinor
Connecting to AWS RDS DBInstance with MySQL workbench
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:
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
I tried using both
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.