Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Jan 2011
    Posts
    42
    Thanks
    5
    Thanked 0 Times in 0 Posts

    mysql_secure_installation issues

    Hi,
    This is the first time I've tried setting up a mysql server so bare with me...

    After installation, and starting the mysqld service I've run mysql_secure_installation. However I can't get past step 2, removing the anonymous user.

    As soon as I confirm the removal I'm get the following error..

    ERROR: 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    ... Failed!

    I can still login to root using 'mysql -u root -p'

    But if I try running mysql_secure_installation again to finish it off then it won't accept the password for root and I can't login...

    Any suggestions I'm confused as to why it won't let me finish the secure installation.

    Thanks in advance

  • #2
    New Coder
    Join Date
    Jan 2011
    Posts
    42
    Thanks
    5
    Thanked 0 Times in 0 Posts
    SOLVED

    This problem happens when you try using a hash in the password.. using a password without a hash stops this from happening.


  •  

    Posting Permissions

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