解决mysql安装报错:无法启动此程序,因为计算机丢失MSVCP120.dll
问题一:
因为装的是新系统,所以遇到mysql启动报错:无法启动此程序,因为计算机丢失MSVCP120.dll
后来参考这篇文章https://blog.csdn.net/huacode/article/details/79557871,完美的得到了解决,原来是电脑上缺乏Visual C++ Redistributable Packages for Visual Studio 2013,去微软官网下载一个即可
问题二:
查询报错: You must reset your password using ALTER USER statement before executing this statement.
解决办法:
alter user 'root'@'localhost' identified by '123456'; flush privileges;
参考文章
Mysql 安装问题一:无法启动此程序,因为计算机丢失MSVCP120.dll,MSVCR120.dll
mysql 报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin