ERROR 1045: Access denied for user

[Bruce A. Julseth]

What am I doing wrong? Do I have something set up (config file, et.al)
wrong? The following is the senerio:



Login as: mysql -u root

Run cmd: grant all on * to fred identified by 'julebj';

Return: Query ok, 0 rows affected (0.90 sec)

Run cmd: use mysql;

Run cmd: Select User from user where user = "fred";

Fred is in the table..

Run cmd: quit;

Mysql is terminated;

Run cmd: mysql -u fred -p

Enter password: julebj

Response is: ERROR 1045: Access denied for user: 'fred@localhost ' (Using
password: YES)



A search of the MySQL reference manual on '1045'showed only the error code
and it's enum name..



Thanks..



Bruce

[Bruce A. Julseth]

Re: ERROR 1045: Access denied for user(solved)


"Bruce A. Julseth" <bruceaj@attglo bal.net> wrote in message
news:40e22c52_4 @news1.prserv.n et...[color=blue]
> What am I doing wrong? Do I have something set up (config file, et.al)
> wrong? The following is the senerio:
>
>
>
> Login as: mysql -u root
>
> Run cmd: grant all on * to fred identified by 'julebj';
>
> Return: Query ok, 0 rows affected (0.90 sec)
>
> Run cmd: use mysql;
>
> Run cmd: Select User from user where user = "fred";
>
> Fred is in the table..
>
> Run cmd: quit;
>
> Mysql is terminated;
>
> Run cmd: mysql -u fred -p
>
> Enter password: julebj
>
> Response is: ERROR 1045: Access denied for user: 'fred@localhost ' (Using
> password: YES)
>
>
>
> A search of the MySQL reference manual on '1045'showed only the error code
> and it's enum name..
>
>
>
> Thanks..
>
>
>
> Bruce
>
>
>
>[/color]

Solved my own problem by issuing the grant command with user as
"fred@localhost "

[Alvaro G Vicario]

Re: ERROR 1045: Access denied for user

*** Bruce A. Julseth wrote/escribió (Tue, 29 Jun 2004 22:50:31 -0400):[color=blue]
> Run cmd: grant all on * to fred identified by 'julebj';[/color]

Try:

grant all on *.* to 'fred'@'localho st' identified by 'julebj';
flush privileges;


--
--
-- Álvaro G. Vicario - Burgos, Spain
--