Hi,

Running CPanel/WHM and wondering how I can allow one of my users to connect remotely to Mysql - They have the Mysql ODBC kit from mysql.com and would like to maintain their database with access.

How can I allow them to remotely connect and keep things secure?

Thanks for any help.

Steve

I was just about to post this same question. How would one keep it secure? Also I was thinking about adding JDBC support.

if they have a static ip its no big deal. If there ip is changing i think mysql will handle a netmask.. ie 145.34.34. or something. If not let them connect from anywhere using a password.

Thanks but how do I set the permissions to allow them to connect?

Cheers

Steve

They can now do this themselves through their mSQL options if you run one of the default cPanel themes and build 75+. A % will be the wildcard for their remote connections from anywhere.

just to direct your attention to a similar post:
http://www.webhostingtalk.com/showthread.php?s=&threadid=40741

Thanks guys,

I just saw this in WHM news -
Mysql Access Hosts Users can not setup their mysql databases to be accessible from any host they choose (4.5.0 build 74 or later only)
I'm running build later than 74 so can't they connect?

Steve

This was really simple,

Upgraded CPanel to latest build and the option to connect remotely is within the users CPanel :-)

Great, thanks for your help guys!

Steve

For more security, also only let that one host through the firewall to access the mysql database service port. Don't rely on mysql's authentication system, if you don't have to. You do have a firewall, right?