Did you flush the privileges? Using either flush privileges or mysqladmin
reload? And besides, you really should be using a GRANT query to do this.
-Rasmus
On Thu, 28 Mar 2002, hamish wrote:
> Hello all,
> I am using php and mysql with phpmyadmin. I am trying to set up a username
> and password in mysql so that when I use
>
> if(!$db_conn = mysql_connect('localhost', 'username', "password")) {
> echo 'Could not connect to the Database Server';
> }
>
> with the correct username and password it will connect me. I used phpmyadmin
> to add the user to the users table in the mysql database. I used the
> following sql statement:
>
> INSERT INTO user (Host,User,Password)
> VALUES('localhost','jeffrey',PASSWORD('biscuit'));
>
> and the record was created in the table.
>
> When I try to connect to the db via the php
>
> if(!$db_conn = mysql_connect('localhost', 'jeffrey', "biscuit")) {
> echo 'Could not connect to the Database Server';
> }
>
> it tells me:
>
> Warning: Access denied for user: 'jeffrey@localhost' (Using password: YES)
> in /home/httpd/htdocs/helpdesk/test.php
>
>
> What have I done wrong?
>
> cheers
>
> Hamish
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
