Remote access to MySQL

BigCheese

I'm trying to connect remotely to MySQL but I don't find any options. Can someone tell me what is necessary to change?

Kaptain

You need to:

Open port 3306 TCP in your firewall.
Bind the MySQL service to your public interface (0.0.0.0 to listen in all interfaces).
Give remote permissions to the MySQL User.

If you require instructions for any of the steps, let us know the following:

What is the operating system?
Do you use any web control panel in particular?

BigCheese

Guys, I need some help with the binding the mysql service to the public interface. I used bind=0.0.0.0 within my.cnf and restarted the service, but then the mysql server didn't start. I followed Plesk instructions within their knowledge base. Am I doing anything wrong? Suggestions?

Kaptain

Try to use bind-address=0.0.0.0 instead and restart the mysql service.