423,484 Members | 2,471 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,484 IT Pros & Developers. It's quick & easy.

ERROR 1045: Access denied for user

P: n/a
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


Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"Bruce A. Julseth" <br*****@attglobal.net> wrote in message
news:40********@news1.prserv.net...
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


Solved my own problem by issuing the grant command with user as
"fred@localhost"
Jul 17 '05 #2

P: n/a
*** Bruce A. Julseth wrote/escribió (Tue, 29 Jun 2004 22:50:31 -0400):
Run cmd: grant all on * to fred identified by 'julebj';


Try:

grant all on *.* to 'fred'@'localhost' identified by 'julebj';
flush privileges;
--
--
-- Álvaro G. Vicario - Burgos, Spain
--
Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.