How to connect via mysql workbench

Posted July 21, 2014 7k views

Hi there

I have just installed mysql (Mariadb) to my digital ocean box using fedora 20. I would like now to try and configure this so as to be able to connect to it from Mysql workbench on my mac. Please can someone provide some easy to follow instructions on how to configure as so far i keep getting the following error

failed to connect to MySQL at (ip) with user root. Can’t connect to MySQL server on (ip) (61)

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
2 answers

When you set up your installation, you probably configured it to accept connections only from localhost. Rejecting outside connections is a common security precaution.

Set up your MySQL Workbench connection using the “Standard TCP/IP over SSH” connection method. That should do it for you.

If you’re on the Fedora 20 droplet … you’ll probably find like me that the IPTables on fedora are blocking connections when you try to access externaly. Temporarily I dropped the firewall using “iptables -F”, which opened up everything. This will revert back to the default settings when you reboot the droplet, so longer term you should also look at configuring some appropriate rules for your IP Tables.