HOW TO: Enable MySQL remote access?

[Roberto]

How do I setup my client so he can access his databases remotely? What are the commands for doing this?

Thanks!

[nickn]

Originally posted by Roberto
How do I setup my client so he can access his databases remotely? What are the commands for doing this?

Thanks!

In the MySQL menu in CPanel make sure his IP is listed on the access list (or do % for wildcard...not recommended)

And make sure if you use a firewall (APF etc) that it isn't blocking port 3306.

That should do it

[BrightAdmin]

Hi Roberto,

There is a Grant privilege to the user for his database only , using "grant" commands. Then open the mysql port - "3306", your client can access his database remotely by

#mysql -h hostname -D databasename -u username -p

Hope it will sort out your problem.

Regards,

[jfcube]

ok, but what do I do if my server has both apf and socks being used and my client is trying to connect from windows?

can I send him the socks file that i am using? if so, how does he implement it?