Mac Mysql mysql_secure_installation error:access denied for user ' root ' @ ' localhost ' (using Password:yes)

MySQL installed by brew, as if automatically updated once

Then execute mysql_secure_installation again, enter the root password error, reload MySQL or not

Error:access denied for user ' root ' @ ' localhost ' (using Password:yes)

The reason is that the previously installed MySQL configuration file was not completely erased

Reference Http://stackoverflow.com/questions/4359131/brew-install-mysql-on-mac-os

Execute sequentially

1. Brew Remove MySQL

2. Brew Cleanup--force

3. Rm-rf/usr/local/var/mysql

4. Brew Install MySQL

5. Mysql.server Start

6. Mysql_secure_installation

The previously not performed steps are 3, so just remove/usr/local/var/mysql and reinstall MySQL should also be possible, no additional testing

Mac Mysql mysql_secure_installation error:access denied for user ' root ' @ ' localhost ' (using Password:yes)