N久没重做win7系统了,昨天重做了一下,之后就是设置情况。apache/PHP都很顺利,唯独mysql,装到最后提示:
The security settings could not be applied to the database because the connection has failed with the following error.
Error Nr. 1045
Access denied for user 'root'@'localhost' (using
password: YES)
If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise
no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.
If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed
automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.
封锁各类防火墙依旧无效,无奈点了跳过。然后到节制面板里做了一次修复操纵,发明mysql也可以正常利用了。
越日开电脑,发明mysql无法启动了。。修复无效,无奈,卸载,重装,依旧如此提示……
上网查询各类诸如清理注册表,删清洁安装目次。均无效!
最后终于让我找到了靠谱的方案!
1、mysql -u root 2、use mysql 3、update user set password=old_password('scf') where user='root' and host='localhost' ; 4、FLUSH PRIVILEGES;注:这个不是通过开始菜单进入的,要通过cmd,然后转移路径到mysql的bin文件夹下执行!
执行完这个再点方才谁人错误提示的重试,就会显示通过了~~~