On Wed, 21 Feb 2007, James Garfield wrote:

I've got 5.0.27-standard installed on an Intel Mac, using the preinstalled version of Apache and my own installation of PHP 4.4.4. I use this machine for development work and don't make it available to anyone else. I've got an instance of a PHP application running, and it works...but not all of the time!!! I created the user that accesses my MySQL via the following commands;


use [web_db_name];
grant select, insert, update, delete on *.* to '[new_user]'@'%' identified by '[new_password]';

I'm able to do everything expected from the command line mysql tool, but on the PHP side it fails more than half of the time:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user '[new_user]'@'[my_current_dhcp_ip]' (using password: YES) in /[path]/[to]/[page]/[on]/[server]/index.php on line 66

This leaves the question: since MySQL is behaving normally otherwise, I'm using a host of '%' and my IP isn't changing, does anybody know what the problem is with PHP???

TIA,
James

 flush privileges

---------------------------------------------------------------------------
Peter Beckman                                                  Internet Guy
[EMAIL PROTECTED]                             http://www.purplecow.com/
---------------------------------------------------------------------------

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

Reply via email to