安裝MYSQL的時候一直卡在starting server這里，求破
之前在網上看到過一個帖子說是到這里的時候禁用某個服務就可以了，然后當時也成功了
但是現在找不到這個帖子了
求破 先謝謝了
詳情請看截圖
uj5u.com熱心網友回復：
在MYSQL的安裝目錄下找到MYSQL的錯誤日志，然后用記事本打開，并復制內容貼到貼子中以供分析。uj5u.com熱心網友回復：
太高深了，我只想要一個簡單的解決辦法
uj5u.com熱心網友回復：
讓你找到檔案，把檔案中的內容貼出來，否則別人怎么分析是什么問題？uj5u.com熱心網友回復：
點旁邊的log按鈕，看卡在什么地方了uj5u.com熱心網友回復：
前面的東西沒有安完整，在安裝的時候需要將所有東西都安裝到本地硬碟uj5u.com熱心網友回復：
below are the logs:
Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]
Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file
Beginning configuration step: Updating firewall
Adding firewall rule for MYSQL56 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall
Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]
Beginning configuration step: Starting Server
Starting MySQL as a service
uj5u.com熱心網友回復：
同求
Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]
Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file
Beginning configuration step: Updating firewall
Adding firewall rule for MySQL56 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall
Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]
Beginning configuration step: Starting Server
Starting MySQL as a service
uj5u.com熱心網友回復：
和樓主遇到一樣問題，安裝到在這步的時候總是卡在starting server，取消的話后面又會有問題。卸載并且清理C盤mysql相關檔案和注冊表再重裝還是這樣。
難道除了重裝系統沒有別的辦法？有沒有大神幫忙解決一下？
uj5u.com熱心網友回復：
，LZ的問題解決了嗎？uj5u.com熱心網友回復：
我安裝時也出現這個情況，搞了一天沒搞懂，最后我看到別人說把所有的防火墻關了，就裝好了，還不知道什么情況呢。。。 之前是一直安裝都出現無法啟動服務。關了防火墻和安全衛士裝一次就可以了。。。。。uj5u.com熱心網友回復：
我也遇到同樣問題了，怎么破！uj5u.com熱心網友回復：
麻煩問下您的問題解決沒有，怎么解決的，遇到同樣的問題，很煩人！uj5u.com熱心網友回復：
問題還木有解決，我裝到linux上去了uj5u.com熱心網友回復：
在阿里云服務器上安裝也是遇到這個問題，快瘋了。
系統重置還是這樣。WHY～！！！！防火墻我也沒有打開的。
uj5u.com熱心網友回復：
表示也出現同樣的問題，防火墻也沒開 ，注冊表和相關的檔案都洗掉了，XP系統的 裝了N遍 請問有大牛幫忙解決下么~~~~~uj5u.com熱心網友回復：
樓主我和你一樣的問題，今天解決了，你安裝到這一步卡住之后打開C:\ProgramData\MySQL\MySQL Server 5.5\data下面的.err檔案看看，用記事本打開，內容是否類似于：150318 10:33:48 [Note] Plugin 'FEDERATED' is disabled.
150318 10:33:48 InnoDB: The InnoDB memory heap is disabled
150318 10:33:48 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150318 10:33:48 InnoDB: Compressed tables use zlib 1.2.3
150318 10:33:48 InnoDB: Error: unable to create temporary file; errno: 2
150318 10:33:48 [ERROR] Plugin 'InnoDB' init function returned error.
150318 10:33:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150318 10:33:48 [ERROR] Unknown/unsupported storage engine: INNODB
150318 10:33:48 [ERROR] Aborting
如果是的話，那就在C:\ProgramData\MySQL\MySQL Server 5.5下面的my.ini最后加入一句：
tmpdir="E:/MySqltemp"
這個檔案夾必須是已經建好的，然后再配置或者再裝，再弄的時候就修改my.ini檔案就可以成功執行了！
uj5u.com熱心網友回復：
那個my.ini檔案得等到問題出現了才會出現呀，然后加上tmpdir="E:/MySqltemp"又怎么能繼續運行呢，我依然是卡在相同的位置啊，淚奔了。修改后怎么再配置啊？我的.err檔案確實跟你說的一樣的問題。可是還是不知道怎么弄啊。本人很菜，求指教，在線等
uj5u.com熱心網友回復：
就是等他出現，然后在最后一行改！
uj5u.com熱心網友回復：
LZ問題解決了嗎？求指點uj5u.com熱心網友回復：
這個問題，我是這樣解決的：安裝到最后，不是一直啟動中嗎？不是啟動不起來嗎？那好，咱就手動啟動它，打開服務，找到你的mysql服務，這時，應該是未啟動的，右鍵，啟動，成功后，回到安裝頁面，你會驚奇的發現，好了，一切都進展順利，安裝完成！希望，這個辦法，也可以幫到你們！uj5u.com熱心網友回復：
沒有用，同遇相同問題uj5u.com熱心網友回復：
根本原因是服務里面啟動不了，手動啟動還是自動啟動都不行，IIS都刪了，也沒有舊檔案，一樣不行，真麻煩Mysqluj5u.com熱心網友回復：
只有使用開發模式才可以使用，其它模式都啟動不了uj5u.com熱心網友回復：
我也啟動不了，一直是1047錯誤
uj5u.com熱心網友回復：
這樣還是會卡住，這時可以手動開啟服務，在服務中查找mysql然后啟動即可。
若發現后面還是會卡主，就取消，重新打開安裝程式，點擊Reconfigure等待my.ini出現后再重新配置，然后再手動啟動服務即可
uj5u.com熱心網友回復：
再順便提一下，這樣啟動后root賬號是不需要密碼的
uj5u.com熱心網友回復：
我昨天也是一直安裝沒有成功，提示這個資訊，樓上的方法也試了，貌似不好用，我在C盤里把所有關于mysql檔案刪掉和清掉注冊表里所有關于mysql的注冊資訊都不管用，期間安裝洗掉重啟了n次都不管用，實在沒轍，我從官網上下載了mysql的免安裝zip包，按照這個百度經驗：http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html，一次安裝就成功了……uj5u.com熱心網友回復：
mysql卸載不徹底，再次安裝就會出現這種情況。解決方法http://jingyan.baidu.com/article/22a299b51a43d49e19376aee.htmluj5u.com熱心網友回復：
此問題本人已經破解，嘿嘿嘿uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
NIce
uj5u.com熱心網友回復：
我想問下,用MYSQL為啥不用linux的服務器，怎么都用windowsuj5u.com熱心網友回復：
手動啟動成功后 starting server 這一步好了 但是不繼續安裝了阿。
uj5u.com熱心網友回復：
同樣遇到這個問題，不過把mysql server卸載了重新來一次就好啦。
uj5u.com熱心網友回復：
xp系統不支持mysql5.7以上的uj5u.com熱心網友回復：
這么久遠的帖子還能回吶uj5u.com熱心網友回復：
mysql服務手動啟動不成功 還有別的方法解決嗎？ 求大神uj5u.com熱心網友回復：
@qq_34897254如果想高效地問問題，解決問題，請提供足夠的資訊。
uj5u.com熱心網友回復：
2016-07-23T21:39:36.800300Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-07-23T21:39:38.820672Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-07-23T21:39:39.307969Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-07-23T21:39:39.558646Z 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: f5786c18-511d-11e6-bbe7-4ccc6a3caba9.
2016-07-23T21:39:39.629853Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-07-23T21:39:39.715077Z 1 [Note] A temporary password is generated for root@localhost: uy!Ch+eHv0wo
uj5u.com熱心網友回復：
請問這個怎么解uj5u.com熱心網友回復：
Beginning configuration step: Stopping Server [if necessary]Ended configuration step: Stopping Server [if necessary]
Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file
Beginning configuration step: Updating firewall
Adding firewall rule for MySQL57 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall
Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]
Beginning configuration step: Initializing Database [if necessary]
Deleting Data folder shipped
Attempting to run MySQL Server with --Initialize-insecure
Running process: C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
Waiting for the server stops: C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
2016-10-19T12:53:56.992807Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-10-19T12:53:56.992807Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2016-10-19T12:54:03.080116Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-10-19T12:54:04.660279Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
mysqld: File '.\鏉庡€?slow.log' not found (Errcode: 2 - No such file or directory)
2016-10-19T12:54:04.905418Z 0 [ERROR] Could not use 鏉庡€?slow.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
2016-10-19T12:54:04.923429Z 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: 1db6cdae-95fb-11e6-832b-40167e95efb6.
2016-10-19T12:54:05.033505Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-10-19T12:54:05.073536Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
Finished initialize database
Ended configuration step: Initializing Database [if necessary]
Beginning configuration step: Starting Server
Starting MySQL as a service
這個也是卡在這里
uj5u.com熱心網友回復：
慢慢等著可以的我就是uj5u.com熱心網友回復：
還是沒有解決啊，我也碰到同樣問題，請問怎么搞啊？uj5u.com熱心網友回復：
Beginning configuration step: Stopping Server [if necessary]Ended configuration step: Stopping Server [if necessary]
Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file
Beginning configuration step: Updating firewall
Adding firewall rule for MySQL57 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall
Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]
Beginning configuration step: Initializing Database [if necessary]
Deleting Data folder shipped
Attempting to run MySQL Server with --Initialize-insecure
Running process: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
Waiting for the server stops: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
2016-12-05T05:01:21.331782Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-12-05T05:01:21.331782Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2016-12-05T05:01:24.644370Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-12-05T05:01:25.488084Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
mysqld: File '.\鍛嗙惔鐞?slow.log' not found (Errcode: 2 - No such file or directory)
2016-12-05T05:01:25.675634Z 0 [ERROR] Could not use 鍛嗙惔鐞?slow.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
2016-12-05T05:01:25.691205Z 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: dfb744d7-baa7-11e6-8b42-28d2442fc148.
2016-12-05T05:01:25.753757Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-12-05T05:01:25.753757Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
Finished initialize database
Ended configuration step: Initializing Database [if necessary]
Beginning configuration step: Starting Server
Starting MySQL as a service
大神們，怎么解決啊，欲哭無淚
uj5u.com熱心網友回復：
我的也是這個問題。但是我的是重裝的時候出現的，第一次是沒出問題的uj5u.com熱心網友回復：
沒有.err檔案 手動打開也打不開。我是第一次裝MySql 怎么就有這種問題啊？ 大神求助啊 弄了好幾天了uj5u.com熱心網友回復：
安裝不成功一定是沒有卸載干凈！安裝不成功一定是沒有卸載干凈！安裝不成功一定是沒有卸載干凈！重要的事情說三遍，連續安裝了幾次都不行，換了好幾個安裝包也不行，都打算裝系統了，最后放手一搏，按照http://www.jb51.net/article/43789.htm的方式痛痛快快的刪了一波，尤其是最后洗掉檔案的時候，直接在計算機中檢索mysql，將檔案都刪干凈，然后重新安裝，一次成功uj5u.com熱心網友回復：
用最新版的，沒有這個問題。uj5u.com熱心網友回復：
最新版的也還是會有這個問題uj5u.com熱心網友回復：
也是遇到這個問題，自動執行到啟動服務時卡住，手動啟動失敗，控制臺未記錄失敗原因，且無法找到mysql錯誤檔案。百度資料了一個半小時，重裝了3次，在windows設定里切換到'開發者模式'后，一次性通過。
uj5u.com熱心網友回復：
一開始我也是安裝到那里卡住了，試了上面的所有方法都不可以，最后用mysql5.6的zip包安裝的，直接就裝上了，拿去用，不用謝我。uj5u.com熱心網友回復：
Beginning configuration step: Initializing Database [if necessary]Deleting Data folder shipped
Attempting to run MySQL Server with --Initialize-insecure
Running process: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
Waiting for the server stops: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
2017-06-17T06:19:21.282693Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-06-17T06:19:21.282693Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-06-17T06:19:22.383304Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.
2017-06-17T06:19:22.383304Z 0 [ERROR] InnoDB: File .\ib_logfile101: 'aio write' returned OS error 187. Cannot continue operation
2017-06-17T06:19:22.383304Z 0 [ERROR] InnoDB: Cannot continue operation.
The attempt to initialize the database Failed
Ended configuration step: Initializing Database [if necessary]
Beginning configuration step: Starting Server
Starting MySQL as a service
各種方法都嘗試了 依然失敗。mysql就不能高級點么。。安裝搞這么費勁
uj5u.com熱心網友回復：
通過綠色版可以安裝成功，程序中依然會報錯錯誤資訊：File .\ib_logfile101: 'aio write' returned OS error 187.Cannot continue operation
my.ini檔案最后一行加上
innodb_flush_method=normal
再重新執行初始化命令后成功在data下創建了相應檔案，啟動成功
uj5u.com熱心網友回復：
還有一種超級惡心的情況被我遇到了，問題是相同的問題，但是產生問題的原因不一樣啊。如果上面的各種方法都解決不了的，有可能就是mysql埠跟其他埠chonguj5u.com熱心網友回復：
還有一種超級惡心的情況被我遇到了，問題是相同的問題，但是產生問題的原因不一樣啊。如果上面的各種方法都解決不了的，有可能就是mysql埠跟其他埠沖突了，我的就是這種情況，解決方法：cmd命令運行：netsh winsock reset 完美解決uj5u.com熱心網友回復：
5.7版本的安裝日志Beginning configuration step: Initializing Database [if necessary]
Deleting Data folder shipped
Attempting to run MySQL Server with --Initialize-insecure
Running process: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
Waiting for the server stops: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
2017-06-17T06:19:21.282693Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-06-17T06:19:21.282693Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-06-17T06:19:22.383304Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.
2017-06-17T06:19:22.383304Z 0 [ERROR] InnoDB: File .\ib_logfile101: 'aio write' returned OS error 187. Cannot continue operation
2017-06-17T06:19:22.383304Z 0 [ERROR] InnoDB: Cannot continue operation.
The attempt to initialize the database Failed
Ended configuration step: Initializing Database [if necessary]
Beginning configuration step: Starting Server
Starting MySQL as a service
5.6版本的log安裝日志
Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]
Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file
Beginning configuration step: Updating firewall
Adding firewall rule for MySQL56 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall
Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]
Beginning configuration step: Initializing Database [if necessary]
Initialize is only compatible for 5.7.7 or above, no need for Initialize the Database
Ended configuration step: Initializing Database [if necessary]
Beginning configuration step: Starting Server
Starting MySQL as a service
請問有大佬們解決沒，求救
uj5u.com熱心網友回復：
http://www.devnote.cn/article/262.html這上有解決方法，好像是系統盤里已經有了記錄，所以啟動不了。我就是這么解決的uj5u.com熱心網友回復：
以前沒有卸載干凈，在安裝的時候不是提示提示了data路徑已經存在，里面是有資料的，你直接把那個目錄下的MySQL的檔案夾洗掉掉再安裝就行uj5u.com熱心網友回復：
OK，書接上文，兩個小時左右搞定的把，阿里云像屎一樣，要不是半小時就能搞定，中途死機好幾次，就是我說的那個問題，防火墻添加入站規則，本機的mysql卸載干凈，我就直接卸載的，連重啟都沒有，馬上繼續裝，OK了，記得，是防火墻添加3306入站規則，當然阿里云安全組策略不開放3306的，遠程肯定是訪問不了的，但是我的專案就在本機把資料都出來再展示到頁面，那還是沒問題的。
uj5u.com熱心網友回復：
暈。。。前面回復的登陸后竟然沒發出來。。。書接上文接到空氣里去了。。。開始配置步驟:更新防火墻在埠3306上為MySQL57添加防火墻規則。這是我復制日志里的一段話，我的也是卡在starting 那一步，大概就在我回復上樓這條帖子的兩小時前，然后我覺得就是入站規則搞得鬼，然后就用這個辦法解決了，翻了太多帖子沒個定論，前面幾位老哥給了我思路，看日志，看不懂英文那就翻譯嘛。。哈哈，總算搞定了。對了，我安裝的server only，所以幾乎沒有任何管理工具，要從控制臺進入的話要配置環境變數。
uj5u.com熱心網友回復：
我win7安裝5.7.17，也是每次卡在這里，后來我點取消，然后安裝成功了。在cmd中mysqld --install,mysqld --initialize,net start mysql,mysql -u root -p都是一次通過，很順利。其實根本不需要配置。uj5u.com熱心網友回復：
安裝了整整兩天，今天終于成功！步驟如下：1. 卸載干凈之前安裝的所有斑斑的MySQL及殘余檔案，控制面板-卸載程式；注冊表中洗掉相關注冊表；電腦里面搜索MySQL 檔案全部洗掉干凈；
2. 下載5.6版本的MySQL https://blog.csdn.net/xiaobing_122613/article/details/54693332
3. 配置環境 https://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html
uj5u.com熱心網友回復：
請問那我這種呢，瀏覽了這么多問題好像都沒有我這個Unknown error: 呼叫的目標發生了例外。
Waiting 3 seconds before the next connection attempt...
Retry 10: Attempting to connect to Mysql@localhost:3306 with user root with no password...
uj5u.com熱心網友回復：
看看這個，以后千萬不能用中文路徑了https://blog.csdn.net/liaosiqian/article/details/78307293轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/75226.html
標籤：MySQL
上一篇：如何禁止mysql跳過權限驗證