Re: [PHP-DB] Access denied for user...sometimes???
Peter Beckman wrote: > 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 And, as it's only you using mysql from the current machine, you don't need a network connection to your own machine - use localhost instead of your dynamic(?) IP, and set skip-networking (or whatever it is called) to on in your my.cnf file. Cheers -- David Robley Useless Invention: Checkered paint. Today is Pungenday, the 53rd day of Chaos in the YOLD 3173. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Access denied for user...sometimes???
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
Re: [PHP-DB] access denied
I did set the veriables just in another script that includes this swcript "Mikhail U. Petrov" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi! > I think you not set this variables. Try to read your full errorlog but > not only one part. > > > Saturday, June 26, 2004, 7:37:36 PM, water_foul wrote: > > w> i get this error: > w> Warning: Access denied for user: '[EMAIL PROTECTED]' (Using > w> password: YES) in > w> C:\Inetpub\localroot\aichlmayr.net\sites\aaron\module\runescape\runerunner\s > w> ervices.php on line 3 > w> and the code up to line 3 is: > w> w> //Database Querys > w> $connection=Mysql_connect($dbHost , $dbName , $dbPassword); > w> > w> i have included this in another script that sets $dbHost, $dbName and, > w> $dbPassword to the correct things to connect to the db > > > > -- > Best regards, > Mikhail U. Petrov > mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] access denied
Hi! I think you not set this variables. Try to read your full errorlog but not only one part. Saturday, June 26, 2004, 7:37:36 PM, water_foul wrote: w> i get this error: w> Warning: Access denied for user: '[EMAIL PROTECTED]' (Using w> password: YES) in w> C:\Inetpub\localroot\aichlmayr.net\sites\aaron\module\runescape\runerunner\s w> ervices.php on line 3 w> and the code up to line 3 is: w> //Database Querys w> $connection=Mysql_connect($dbHost , $dbName , $dbPassword); w> w> i have included this in another script that sets $dbHost, $dbName and, w> $dbPassword to the correct things to connect to the db -- Best regards, Mikhail U. Petrov mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php