Question

How to connect via mysql workbench

Posted July 21, 2014 6.9k 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)

Add a comment
admin694517
By:
admin694517

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
larry July 21, 2014

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.

Reply Report
john.luckcuck July 22, 2014

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.

Reply Report

Looking for something else?

Ask a new question Search for more help