Need help. remote access to my MySQL database.

TheWatcher · 02-07-2010, 12:28 AM

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.
????: NamePros.com http://www.namepros.com/website-development/638412-need-help-remote-access-my-mysql.html

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 · 02-11-2010, 08:47 PM

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

mrjohn · 02-12-2010, 06:20 AM

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.

02-07-2010, 12:28 AM	THREAD STARTER #1 (permalink)
TheWatcher Senior Member Join Date: May 2003 Location: KING.NET Posts: 3,478	Need help. remote access to my MySQL database. 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. ????: NamePros.com http://www.namepros.com/website-development/638412-need-help-remote-access-my-mysql.html 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 __________________ Get your own .CO $28/yr http://NeedName.com KING.NET Advertise your products and services. Got Facebook, connect with me. http://facebook.com/domainnetwork WebeW.com - YA.NET Alternative Domain Name!. Use it for your site or blog.

02-11-2010, 08:47 PM	#2 (permalink)
mediaseller New Member Join Date: Jan 2010 Location: Texas Posts: 16	I'm interested in any responses from the pros.... __________________ Almost Cyber Media

02-12-2010, 06:20 AM	#3 (permalink)
mrjohn NamePros Regular Join Date: Jan 2010 Location: Pennsylvania Posts: 403	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.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)