Jump to content

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


webref.eu

Recommended Posts

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.