Error: Access denied for user 'root'@'localhost' (using password: YES) error when securing mysql on CentOS 7

January 3, 2017 7.6k views
MySQL CentOS

Hello I use CentOS 7.3 x64 and when I use command sudo mysql_secure_installation it returns with this error Error: Access denied for user 'root'@'localhost' (using password: YES) any got any suggestion to fix this?

1 Answer

MySQL creates a temp password on install, you will need to use that when it asks for the password. You can find it in /var/log/mysqld.log.

  • I could not find a /var/log/mysqld.log in my Ubuntu machine.

    • This was based on a install after you run mysql_secure_installation After that you should get a password and if you run grep 'temporary password' /var/log/mysqld.log it should display via terminal.

      This only works on new installs, not older installs or installs not using mysql_secure_installation.

Have another answer? Share your knowledge.