Results 1 to 5 of 5

Thread: MySql Error

  1. #1
    Join Date
    May 2013
    Beans
    12

    MySql Error

    I have recently installed mysql on my server using putty. I created a password for the "root" user when it prompted me to create one.

    When I type in the command:
    mysql -u root -p
    It asks me for my password. When I type it in and hit enter, it give me this message:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

    I am sure that the password is correct, so what am I doing incorrectly?
    Last edited by TheMattVid; May 29th, 2013 at 03:13 AM.

  2. #2
    Join Date
    Sep 2006
    Beans
    8,623
    Distro
    Ubuntu 14.04 Trusty Tahr

    Re: MySql Error

    The syntax looks ok. Maybe you mistyped your root password when you entered it the first time. You can reset the mysql root password but have to hop through a few easy hoops to do so:

    https://help.ubuntu.com/community/MysqlPasswordReset

    Later, looking ahead you might think about MariaDB. It's a drop in replacement and works with MySQL databases as-is. It's not in the Ubuntu repositories yet though.

  3. #3
    Join Date
    May 2013
    Beans
    12

    Re: MySql Error

    Thanks for the suggestion. It asked me to verify the password when I made it, and I even had it written down, so I am absolutely sure that it is correct, but I will try the password reset anyway. If anybody has any different explanations for this error (because I have heard that error messages can mean multiple possibilities), please help me out.

  4. #4
    Join Date
    May 2013
    Beans
    7

    Re: MySql Error

    You said you used putty to install and set it up. This helped me out tons
    http://dev.mysql.com/doc/refman/5.1/...ss-denied.html
    Last edited by remeny; May 28th, 2013 at 02:20 AM.

  5. #5
    Join Date
    May 2013
    Beans
    12

    Re: MySql Error

    The problem ended up being the characters I was using in my password.

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
  •