View Single Post
  #2 (permalink)  
Old 06-26-2008, 11:09 AM
wige's Avatar
wige wige is offline
Moderator
WebProWorld Moderator
 
Join Date: Jun 2006
Location: United States
Posts: 2,629
wige RepRank 9wige RepRank 9wige RepRank 9wige RepRank 9wige RepRank 9wige RepRank 9wige RepRank 9wige RepRank 9wige RepRank 9wige RepRank 9wige RepRank 9
Default Re: MySQL connect error to an outside database

If you can access your server's command line, I would suggest using one of the built in MySQL tools which should give you more feedback on the problem. First, try the mysqlshow client app to get a list of databases on the remote server which you can access.

shell> mysqlshow -h hostname -u username -p password

You should get either a list of databases you can access, or a connection error message. This information should give you more details for when you contact support.

If the tables you need to access are listed, try running queries directly, using the MySQL client.

shell > mysql -h hostname -u username -p password database_name

You should be able to test various queries directly once you are connected. The error messages you encounter can help your support correct the issues.
__________________
The best way to learn anything, is to question everything.
Reply With Quote