Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP with

2005-02-16 Thread Elliot Mackenzie
I have an update for this. I used mysql_connect to connect to the database and then ran the query "select current_user()". I discovered that despite using mysql_connect specifying a username and password, it still insisted on connecting as "@localhost", but with no user. The @localhost user do

Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP with

2005-02-16 Thread Elliot Mackenzie
Agh! GLOBALS GLOBALS GLOBALS. For a future suckers' reference, the variable was not available in its scope, and was thus passing null as the username to mysql_connect, which in turn was connecting to the database as "@localhost". Thanks for your help, pardon my stupidity :) Kind regar

Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP with same username

2005-02-15 Thread Martin Norland
Elliot Mackenzie wrote: I have encountered a "hidden database" issue with mod_php, apache2 and mySQL that I have thus far been unable to resolve. I am able to connect to the mysql socket using mysql_connect, but then find that mysql_list_dbs only returns the "test" database. This *sounded* like