How to connect via mysql workbench

  • Posted July 21, 2014

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)


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

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.

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.