error nr.1045 access denied for user 'root'@'localhost' (using passwd:no)

时间:2023-03-08 23:56:15
error nr.1045 access denied for user 'root'@'localhost' (using passwd:no)

在windows上卸载了mysql,再次重新安装的时候运行失败,并报以下错误:

error nr.1045 access denied for user 'root'@'localhost' (using passwd:no)

解决办法:

1.服务里面停止Mysql服务。

2.卸载Mysql,删除MySQL的安装目录。

3.此外还要删除以下目录的mysql相关文件

error nr.1045 access denied for user 'root'@'localhost' (using passwd:no)

4.删除注册表里的HEKY_LOCAL_MACHINE相关目录

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 目录