[SOLVED] How Do You Get More Info on MySQL Server Connection Error?

[webref.eu]

Hi All

 

I am trying to connect to my MySQL database from a remote host.  I have the standard PHP database connection code.  I have added the remote IP address as an allowed one in cPanel.  At the moment the remote host can't connect to the server. 

 

Is there a way to get more detailed info about the type of server connection error?  I am thinking if I alter the PHP code I might be able to display a more detailed connection error message.

 

Thanks

[abazoskib]

try echo mysql_error();

 

or post the code

[Mchl]

Make sure your host allows for remote MySQL connections. Even if you enabled it in cPanel, they might be blocking it somewhere else.

Do you get 'Access denied for user...' message, or do you timeout?

[webref.eu]

Thanks guys, I used mysql_error() and it turns out its a versioning problem.  The MySQL server is v5 and the remote host I want to connect to it is v4.  This means the password can't be recognised.  The error I get is: 

 

Client does not support authentication protocol

 

So it wasn't an IP access issue like I thought initially. 

 

Thanks for your help. 

 

Rgds