今天上班打开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 uou 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.”,屡次试验都不行,网上的办法也都试过,还是不行,最后我发现以前装的mysq的版本和现在的不一样,所以就抱着试一试的心态,重装了以前的mysq,结果就可以了,哇哇.....这个版本不兼容的问题真是让我头痛啊,浪费了大半天的时间!