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
ei is the master username for my RDS DBInstance. And the column
USER() has my ip address after
I tried using both
ei@% with workbench, but i get access denied error .
SELECT USER(),CURRENT_USER();and post the results of the query in the question.
eias the username in the Workbench config of the connection?