教你如何正確重裝MySQL資料庫

來源:互聯網
上載者:User

1 卸載原來的MySQL資料庫

2 重起電腦;

3 在windows下:
開啟命令列視窗,停止MySQL服務: Net stop mysql
啟動MySQL,一般到MySQL的安裝路徑,找到 mysqld-nt.exe
執行:mysqld-nt --skip-grant-tables 當前視窗將會停止。
另外開啟一個命令列視窗,執行MySQL如果提示沒有這個命令,先進入MYSQL的安裝位置下BIN目錄再運行MySQL
>use mysql
>update user set password=password("new_password") where user="root";
>flush privileges;
>exit 

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.