ERROR 1045: Access denied for user

From: Bruce A. Julseth (bruceaj_at_attglobal.net)
Date: 06/30/04


Date: Tue, 29 Jun 2004 22:50:31 -0400

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



Relevant Pages

  • Re: SQL and CSV
    ... unless you're suggesting that the "config file" is in fact ... now I can query the CSV file. ... The remaining lines of your SELECT statement are incredibly redundant ...
    (comp.lang.python)
  • ASP performance issues
    ... I have a page that is linked into by other pages that pass it query ... strings, it then reads a config file, displays 1 of several forms, gets ... then use applicationto reference it. ... i also want to take the initial query strings and load them into session ...
    (microsoft.public.inetserver.asp.general)
  • Xorg/Modes issue
    ... I have tried googling around to find the answer to my query but seem ... I have followed the handbook guide on ... copy of the config file I am using too and am currently runng the 5.3 ...
    (freebsd-questions)
  • Re: ERROR 1045: Access denied for user(solved)
    ... Do I have something set up (config file, ... The following is the senerio: ... Solved my own problem by issuing the grant command with user as ...
    (comp.lang.php)
  • Re: Installing Borland C++ 3.1
    ... Use the help to query for a Config file. ... You will need to include the Bin folder in the PATH so that ... it can be exexuted from other folders. ...
    (comp.lang.cpp)