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
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
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