HOW TO: Enable MySQL remote access?

Roberto

Active Member
Jul 9, 2003
36
0
156
How do I setup my client so he can access his databases remotely? What are the commands for doing this?

Thanks!
 

nickn

Well-Known Member
PartnerNOC
Jun 15, 2003
616
1
168
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

Well-Known Member
Feb 29, 2004
204
0
166
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,:p
 

jfcube

Registered
Apr 9, 2004
1
0
151
Remote Connection to mySQL

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?