”Can't connect to MySQL server on localhost (10061)”錯誤 ? ?---?問題原因是mysql沒有啟動。

將mysql加入到Windows的服務中

做法：命令行運行"mysqld --install"

發現：

?1、為什么呢？權限不夠，我用的是普通用戶權限，恩再次打開cmd.exe，不過這次要右擊“Run as administrator”，然后再鍵入mysqld --install ? 可以了！！！

? 2、初始化mysql數據庫，輸入“mysqld --initialize --user=root --console”。下面紅色文字為初始化后的root 密碼

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld --initialize --user=root --console 2016-10-29T01:35:44.309833Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc umentation for more details). 2016-10-29T01:35:46.659968Z 0 [Warning] InnoDB: New log files created, LSN=457902016-10-29T01:35:47.154996Z 0 [Warning] InnoDB: Creating foreign key constraintsystem tables. 2016-10-29T01:35:47.362008Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 043563f4-9d78-11e6-a8c8-606dc79c383c. 2016-10-29T01:35:47.388009Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-10-29T01:35:47.401010Z 1 [Note] A temporary password is generated for root@localhost: u).ig.Gd.7hW

?3、此時使用“net start mysql”成功啟動msyql

?4、使用生成的密碼登錄mysql，通過“set password=password('123456')”修改密碼。此處將root密碼設置為123456

mysql> set password=password('123456'); Query OK, 0 rows affected, 1 warning (0.00 sec)

總結

以上是生活随笔為你收集整理的”Can't connect to MySQL server on localhost (10061)”的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。