Need help. Remote access to my MySQL database.

[TheWatcher]

This is the first I will try to manage a MySQL database remotely, so I have no idea.

I have LAMPP setup, Plesk is my management software which I find out with limitation to open large queries through phpmyadmin. I previously used cPanel and no problem with it.

I want to use a third party MySQL database software to connect remotely to my database, so I can perform quick table queries, monitoring and backup.

Questions:
How to connect remotely to my MySQL Database, I already configured the port in firewall. But still can't connect remotely. I can login to MySQL through SSH.

What do I need to configure in my Linux/Plesk/MySQL so I can connect remotely?

Thanks in advance.
EM @ KING.NET

 

[mediaseller]

I'm interested in any responses from the pros....

 

[mrjohn]

Have you checked that the specific database user is set to respond to a remote request? It may just be set to localhost.

I generally create an additional users with limited privileges for the remote. Just a precaution, since a remote user can always be a target for a brute force attack.