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 read many questions/answers here but they are from a different interface from AWS Console. I created a DB Instance but can't create a rule in the security groups that's allows me to connect from my computer. I tried these rules :

  • All tcp with my IP
  • All traffic with my IP
  • MySQL with my IP

By the way I'm using MySQL Query Browser

Anyone knows the right rule to use ?

share|improve this question
    
Sorry I couldn't help –  RolandoMySQLDBA Feb 6 at 0:02
    
no problem, thanks for the tip –  user2804947 Feb 6 at 0:03
    
Any of those three rules would allow you to access the database, so I suspect that either those rules were set on the wrong security group or that you are trying to connect to the wrong hostname. Anonymize the hostname but leave the basic format intact so that we can see to what host you are trying to connect. Also, mention the name of the security group that you are adding the rule to. At a minimum, I can show you how to tunnel your connection through an EC2 instance if need be. –  dotancohen Mar 20 at 13:40
    
Going to try that, thanks –  user2804947 Apr 28 at 20:46

1 Answer 1

I dealt with this question with reference to MySQL Workbench

If it can be done with MySQL Workbench, it definitely has to work from MySQL Query Browser.

At the very least, make you open port 3306. Also, make sure you have user defined in the MySQL instance where host = 'your ip' or 'your netblock' in mysql.user.

Give it a Try !!!

share|improve this answer
    
I solved it. Neither was the first or the second one. The first one mentions the CIDR/IP connections types, but I looked it several times and couldn't find it. Here is what worked out for me : created two rules Inbound and Outbound both with "All Traffic" setup and my IP Address like this : X.X.X.X/32 –  user2804947 Feb 6 at 0:00
    
I'm going to look at that host='my ip' for sure. Thanks ! –  user2804947 Feb 6 at 0:02

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.