Results 1 to 6 of 6

Thread: MySql Error

  1. #1
    Associate
    Join Date
    Jan 2005
    Location
    SLC, UT, USA
    Posts
    11

    MySql Error

    MySql 3.23.58 on FC1 was running fine until something (what?) changed and now I can't login to "mysql>". The error message is "ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)". Which will come up regardless of whether I log in using a password or, regardless of using root or some other user. If I add "skip-grant-tables" to my "/etc/my.cnf" then I can get in.

    Any ideas?

  2. #2
    Senior Member
    Join Date
    May 2004
    Location
    Pakistan
    Posts
    253

    Re: MySql Error

    Dear paleogryph,
    Hello,

    Quote Originally Posted by paleogryph
    MySql 3.23.58 on FC1 was running fine until something (what?) changed and now I can't login to "mysql>". The error message is "ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)". Which will come up regardless of whether I log in using a password or, regardless of using root or some other user. If I add "skip-grant-tables" to my "/etc/my.cnf" then I can get in.

    Any ideas?
    Sounds seems to that you forgot your root password for MySQL Server !!

    to reset MySQL Password please check this link.

    http://dev.mysql.com/doc/mysql/en/re...rmissions.html

    Best Regards.
    Frrkh hmd

  3. #3
    I've found that if I'm logging into MySQL, I need to access it with a password flag, or it will assume that I'm trying to log in with no password provided (giving me an error just like the one you got.) Try using

    shell> mysql -u root -p

    to have it prompt you for a password OR

    shell> mysql -u root -p password

  4. #4
    I believe if you add "skip-grant-tables" to "/etc/my.cnf" then sucessfully started up mysql you can use

    `mysqladmin -u root -p 'newpassword'`

    to reset it....i could be wrong though...

  5. #5
    Member
    Join Date
    Apr 2004
    Location
    Kennesaw, GA
    Posts
    217
    or he's using the wrong user.

    Been known to happen before....

  6. #6
    root@localhost' (Using password: NO)
    root user is being used, looks like there was no password set.

Similar Threads

  1. Problem starting mysql conflicts with the RPM "mysql-5.0.27-1.fc6"
    By kamakshiganesh in forum Redhat / Fedora
    Replies: 2
    Last Post: 10-26-2007, 04:35 AM
  2. Yum error while installing mysql
    By omidkamangar in forum Redhat / Fedora
    Replies: 2
    Last Post: 09-14-2007, 10:54 AM
  3. mysql access error
    By Muddafarker in forum Linux - Hardware, Networking & Security
    Replies: 2
    Last Post: 01-18-2004, 08:27 AM
  4. MySQL database creation error
    By Compunuts in forum Linux - Hardware, Networking & Security
    Replies: 6
    Last Post: 10-24-2003, 06:09 AM
  5. MySQL Error msgs
    By gmoreno in forum Announcements and Suggestions
    Replies: 4
    Last Post: 01-31-2003, 10:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •