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

2005-02-16 Thread Elliot Mackenzie
via mysql CLI but not MOD_PHP withsame username Date: Tue, 15 Feb 2005 15:59:09 -0600 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

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

2005-02-16 Thread Elliot Mackenzie
regards, Elliot. On Wed, 16 Feb 2005, Elliot Mackenzie wrote: 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

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

2005-02-16 Thread Elliot Mackenzie
instead of [EMAIL PROTECTED] when I specify both a username and password along with mysql_connect? There are no mysql-related defaults set in php.ini other than a path to the socket. Kind regards, Elliot. Martin Norland wrote: Elliot Mackenzie wrote: I have encountered a hidden database issue

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

2005-02-15 Thread Elliot Mackenzie
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 an issue with the SHOW