ERROR 1045: Access denied for user:

From: Michael S. Dunsavage (mikesd_at_frontiernet.net)
Date: 03/30/04

  • Next message: Srinivas Koppisetti: "RE: ERROR 1045: Access denied for user:" 
    Date: Tue, 30 Mar 2004 13:48:01 -0500
To: redhat-list@redhat.com

    I get the following error when I do

    mysql -u mikesd -p

    ERROR 1045: Access denied for user: 'mikesd@localhost' (Using password: YES)

    the user mikesd exists.

    I did

    mysql> GRANT ALL PRIVILEGES ON *.* TO 'mikesd'@'localhost'
         -> IDENTIFIED BY 'pass' WITH GRANT OPTION;
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'mikesd'@'%'
         -> IDENTIFIED BY 'pass' WITH GRANT OPTION;
    mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
    mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';

    What else? 

    -- 
Michael S. Dunsavage
-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list
  • Next message: Srinivas Koppisetti: "RE: ERROR 1045: Access denied for user:"

    Relevant Pages

    • Re: select ... into outfile: Berechtigung?!
      ... Danke, hab' grad' auf die harte Tour rausgefunden, dass in MySql ... GRANT file ON *.* TO web@localhost; ... Prev by Date: ... Next by Date: ...
      (de.comp.datenbanken.mysql)
    • Re: Access denied for user: username@%
      ... Deon H wrote: ... 2)Change the directory to the directory of mysql. ... To access the root account type mysql -u root -p ... To grant rights, use the grant command. ...
      (comp.lang.php)
    • Re: mysql ??
      ... >>Mike I seem to be making some head way, I have the server running a sock ... > Definitely looks like a grant table problem. ... this is the weakest point in the mysql install procedure - you ... > the whole permission system while I muck with getting mysqld set up ...
      (alt.os.linux.suse)
    • Re: mysql ??
      ... >> essentially disables all the user based security. ... >Can you give me some help on setting access, and how do I config the grant ... "Grant tables" = there's a mysql database named 'mysql' that contains ... including access - to mysqld databases. ...
      (alt.os.linux.suse)
    • Re: mysql ??
      ... >> Definitely looks like a grant table problem. ... >> the whole permission system while I muck with getting mysqld set up ... The mysql module in webin should allow you to set up ... site-wide spam filters at catherders.com. ...
      (alt.os.linux.suse)