I am using mac os x mountain lion. I need to configure
MySQL Workbench to access my db on AWS.
MySQL Workbench and trying to connect I get the error
"Host ..... is not allowed to connect to this mysql server". After searching online for answers, I found someone had a similar problem where the apparent solution is
- Mysql needs to be up and running and bound to listen on any IP.
- Software firewalls need to be disabled or configured to allow external traffic (iptables on linux, windows firewall on windows)
- Security group needs to have a rule to allow your ip address to access the instance on port 3306
So I got step one working. But I don't know how to check whether my
iptable is configured to allow external traffic or how to set it to do so. Is anyone here able to help me out?