RE: [PHP-DB] Connect User from website does not work.
| From: | Hutchins, Richard | Date: | Mon, 14 Jul 2003 15:36:19 +0000 |
| Subject: | RE: [PHP-DB] Connect User from website does not work. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29235@lists.php.net to get a copy of this message | ||
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: [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 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
>
>
>
>