Remote MySQL connection problem

ialex03

Well-Known Member
May 15, 2003
56
0
156
Hello.

I hope somebody can help me.

A customer wants to connect to mysql at our server via ODBC from his own computer.
Here is his sessions log:

Resolving domain.com...
Found IP address for ptacekjones.com...
Trying xxx.xxx.xxx.xxx (PORT:3306)...
Connected to xxx.xxx.xxx.xxx...

Connection closed...
His IP is added to "allowed hosts", also I do can connect from my computer without a problem.
Can somebody point me to where I can start to track the problem from?

Thank you.

cPanel.net Support Ticket Number:
 

rsaylor

Well-Known Member
Mar 27, 2003
160
1
168
I was having a simular problem.

1. I wanted to connect to a remote MySQL database from another server.

2. I did not want to have to keep entering IP's as multiple servers would connect.

Goto cPanel for the user that hosts the DB.

In the add host input "%" and save. Now, all remote servers should be able to connect to your IP address instead of using localhost

Hope this helps for somebody, I searched and never found this info so here it is.