Re: [PHP-DB] Connect User from website does not work.
> Did you FLUSH PRIVILEGES after creating your user? We're off the subject of PHP, but you don't have to do this with the GRANT command, btw. :) ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Connect User from website does not work.
> I have created a user "webuser" with the following line. > > > > mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by > 'xx'; > > mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by > 'xx'; > > > > I would think that this should have unlimited access to the database > from the website.? > > I can connect to mysql from the command line using the user webuser. I > received no errors when I created the user and verified that the user > exist in the user database. > > > > When I try to connect to the database I get the following error: > > > > Warning: Access denied for user: '[EMAIL PROTECTED]' (Using > password: YES) in /var/www/html/count/get_conf.inc.php on line 4 > > Warning: MySQL Connection Failed: Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) in > /var/www/html/count/get_conf.inc.php on line 4 As you can see from the error message, you're not connecting from "localhost". When trying to connect from a PHP script, MySQL sees you as coming from a host www.Sarreid2.com. So, use another GRANT command to also grant your user permission from this host. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Connect User from website does not work.
Did you FLUSH PRIVILEGES after creating your user? > -Original Message- > From: Larry Sandwick [mailto:[EMAIL PROTECTED] > Sent: Monday, July 14, 2003 11:33 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Connect User from website does not work. > > > I have created a user "webuser" with the following line. > > > > mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by > 'xx'; > > mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by > 'xx'; > > > > I would think that this should have unlimited access to the database > from the website.? > > I can connect to mysql from the command line using the user webuser. I > received no errors when I created the user and verified that the user > exist in the user database. > > > > When I try to connect to the database I get the following error: > > > > Warning: Access denied for user: '[EMAIL PROTECTED]' (Using > password: YES) in /var/www/html/count/get_conf.inc.php on line 4 > > Warning: MySQL Connection Failed: Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) in > /var/www/html/count/get_conf.inc.php on line 4 > > > > Any suggestions ? > > > > I am using php 4.2.2 apache 2.0 and mysql 3.23.52 on Redhat 8 > > > > The script is trying to connect to the database and create a table. > > > > TIA > > > > Larry Sandwick > > Sarreid, Ltd. > > Network/System Administrator > > phone: (252) 291-1414 x223 > > fax : (252) 237-1592 > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php