When installing the MySQL database, if you reinstall it, it is easy to meet the Apply security setting error (Access denied for user '[email protected]' (using Password:yes), that is, when configuring the MySQL boot service, the error occurs when you start the Apply security setting because the files are not completely deleted when you uninstall MySQL, so it is necessary to manually clear these, the files to be purged mainly:
First, the installation directory of MySQL, generally c:/program files directory.
Second, the MySQL data storage directory, generally in C:/Documents and Settings/all users/application Data directory (need to note that application data this folder is hidden by default, to pass the tool- > Folder Options, view, show all files and folders to set hidden files visible).
Third, delete the registry data, through Regedit, delete the following several files:
Reference Hkey_local_machine/system/controlset001/services/eventlog/applications/mysql
Hkey_local_machine/system/controlset002/services/eventlog/applications/mysql
Hkey_local_machine/system/currentcontrolset/services/eventlog/applications/mysql
Apply security settings error during MySQL installation