Did you FLUSH PRIVILEGES after creating your user? > -----Original Message----- > From: Larry Sandwick [mailto:lgs@sarreid.com] > Sent: Monday, July 14, 2003 11:33 AM > To: php-db@lists.php.net > Subject: Connect User from website does not work. > > > I have created a user "webuser" with the following line. > > > > mysql> grant all privileges on *.* to webuser@Sarreid2 identified by > 'xxxxxx'; > > mysql> grant all privileges on *.* to webuser@localhost 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: 'webuser@www.Sarreid2.com' (Using > password: YES) in /var/www/html/count/get_conf.inc.php on line 4 > > Warning: MySQL Connection Failed: Access denied for user: > 'webuser@www.Sarreid2.com' (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
