Connection to the local database appears: 1045-access denied for user ' root ' @localhost ' (using Password:yes) Solution:

Direct yesterday or good today is not, the password is correct, is the local connection is not on, Linux MySQL can connect,

Find all kinds of solutions on the Internet, what permissions, what add a sentence, and this

If this is not going to go to the direct reload it, in fact, not a little bit better, I installed 2 times, may not be uninstalled clean, = = = Remember to back up the database file = =

First Control Panel uninstall MySQL service, then go to C:\ProgramData below there is a MySQL this is hidden file, click to check the hidden file can be seen, and then delete,

Then cmd: Enter regedit and go to the Registry Editor directory to find

Hkey_local_machine\system\controlset001\services\eventlog\application\mysql

Hkey_local_machine\system\controlset002\services\eventlog\application\mysql

Hkey_local_machine\system\currentcontrolset\services\eventlog\application\mysql

Delete this MySQL file, then restart your computer, unzip your MySQL installation package again,

Install again, because you've already installed it once, so that MySQL has to change a name,

This is my name after the successful installation.

Another is the last step of the installation did not respond to this problem is the registry and the C-drive path is not removed clean, and the name did not change, will appear, is not responding.

This is a personal experience, if you want to re-install directly, I hope to help everyone.

Connection to the local database appears: 1045-access denied for user ' root ' @localhost ' (using Password:yes) Solution: