An APPLY security settings error occurred during installation. After a long period of speculation, I found that such an error would not occur during the first installation. However, when reinstalling, an apply security setting error (access denied for user 'root@localhost'(using password: YES)), that is, when configuring mysql to start service, an error will occur when starting apply security setting. The reason is that when uninstalling mysql, there is no Completely delete the files, so it is necessary to manually clear these. The main files to be cleared are: 1. The installation directory of mysql, usually under the C:/Program Files directory.
2. The mysql data storage directory is usually in the C:/Documents and Settings/All Users/Application Data directory.
3. Delete the registry data. Through regedit, delete the following files:
3.1 HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQL 3.2HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Applications/MySQL 3.3HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications/MySQL
At this point, you will no longer get an error when you continue the installation! !
The above is the detailed content of MySQL-Solution to APPLY security settings error during installation. For more information, please follow other related articles on the PHP Chinese website!