> I have created a user "webuser" with the following line. > > > > mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by > 'xxxxxx'; > > mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by > 'xxxxxx'; > > > > 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