On Thu, Aug 23, 2001 at 12:24:53AM -0700, Dave Walcott wrote:
> Greetings list,
>
> I'm having a MySQL login problem that I cannot figure out, and
> (surprise surprise), I'm something of a newcomer to MySQL. I have
> read two decent MySQL books, searched the MySQL.com online manual,
> and searched the web for everything I can think of, to no avail.
>
> Here is my problem:
>
> I am running MySQL version 3.23.36 on a RedHat Linux 7.1 server. I
> am using version 3.23.22-4 of the client. I can log in to MySQL as
> root just fine by issuing:
>
> mysql -u root -p
>
> and then entering the admin password I set up. Next, I create a
> database (and a few tables) called "dbname," and then issue (again
> as root):
>
> >grant all
> >on dbname.*
> >to user identified by 'password';
>
> I get a "Query OK" message. Then when I logout and try to log back
> in using:
>
> >mysql -u user -p
>
> and then issuing the password, I get the following message:
>
> Error 1045: Access Denied for user: 'user@localhost' (Using password: YES)
Try granting that to user@localhost. In MySQL, localhost has a sort
of special meaning that isn't documented as clearly as it really
should be. If you want the full explanation, let us know. But that
should solve the problem for you.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 6 days, processed 77,339,717 queries (148/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
