問題一:
因為裝的是新系統,是以遇到mysql啟動報錯:無法啟動此程式,因為計算機丢失MSVCP120.dll
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiI0gTMx81dsQWZ4lmZf1GLlpXazVmcvwFciV2dsQXYtJ3bm9CX9s2RkBnVHFmb1clWvB3MaVnRtp1XlBXe0xCMy81dvRWYoNHLwEzX5xCMx8FesU2cfdGLwMzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5yN1MTM1EmYycTO5MDO4IzYyYzX1AzNyQTM0AzLcdDMyIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjLyM3Lc9CX6MHc0RHaiojIsJye.png)
後來參考這篇文章,完美的得到了解決,原來是電腦上缺乏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