Remote MySQL Connecton Problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello everyone,

I've run into a bit of a sticky situation trying to connect to a remote MySQL database. Here's the background:

Connecting from the command line on the web server works.

Connecting from a different vhost works.

There's no information in mysql_error. In fact, mysql_select_db('db') or die(mysql_error()); doesn't produce any output.

The only way I know this isn't working is when I try to run a query, the result resource is NULL.

If I copy the contents of the query and run it on the command line, from the web server, I get the results I expected.

I manage both servers. I added the new login on the MySQL server and also ran flush privileges. I've gone so far as to reboot both the MySQL process and the apache process.

The versions of MySQL are slightly different 5.0.24a (web) vs 5.0.36(db).

It's getting late and I'm just grasping for straws.

Thanks!
Ray

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux