RE: ERROR 1045: Access denied for user:

From: Hamilton, Andrew (Andrew.Hamilton_at_afccc.af.mil)
Date: 03/30/04

  • Next message: Michael Gargiullo: "Re: ERROR 1045: Access denied for user:" 
    To: General Red Hat Linux discussion list <redhat-list@redhat.com>
Date: Tue, 30 Mar 2004 14:00:47 -0500

    When you select user from users what does the username say? Are you sure
    the username is correct? When you select user,password from users what does
    it say?

    Regards,

    Drew

    -----Original Message-----
    From: Michael S. Dunsavage [mailto:mikesd@frontiernet.net]
    Sent: Tuesday, March 30, 2004 1:48 PM
    To: redhat-list@redhat.com
    Cc: Richardson, Gary
    Subject: ERROR 1045: Access denied for user:

    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



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

    Relevant Pages

    • new debian user question about mysql on debian
      ... I've install mysql on a etch box e I've noticed a debian-sys-maint user. ... Shouldnt this user have grant privileges? ... Access denied for user 'debian-sys-maint'@'localhost' to database 'vhcs2' ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx with a subject of "unsubscribe". ...
      (Debian-User)
    • RE: ERROR 1045: Access denied for user:
      ... Where is the mysql instance running? ... mysql> GRANT ALL PRIVILEGES ON *.* TO 'mikesd'@'localhost' ... unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe ... This electronic transmission contains confidential information intended only ...
      (RedHat)
    • Re: intalling mysql on bsd5.0
      ... > Installing all prepared tables ... > Installation of grant tables failed ... Becouse the precompiled version of mysql for 5.0 ... To unsubscribe, ...
      (freebsd-questions)
    • 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)