一開始我用的普通安裝版本，一直卡在start severing，重新卸載了n次，也試過
還是不行，后面用了壓縮包版本，根據這個教程https://blog.csdn.net/Charonmomo/article/details/98440968
安裝到第五步出現error
D:\mysql-8.0.17-winx64\bin>mysqld --initialize --console
2019-09-14T07:50:06.020057Z 0 [System] [MY-013169] [Server] D:\mysql-8.0.17-winx64\bin\mysqld.exe (mysqld 8.0.17) initializing of server in progress as process 2212
2019-09-14T07:50:06.021790Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2019-09-14T07:50:06.035158Z 1 [ERROR] [MY-012576] [InnoDB] Unable to create temporary fi le; errno: 2
2019-09-14T07:50:06.035186Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
2019-09-14T07:50:06.035536Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-09-14T07:50:06.035548Z 0 [ERROR] [MY-013455] [Server] The newly created data directory D:\mysql-8.0.17-winx64\Data\ by --initialize is unusable. You can remove it.
2019-09-14T07:50:06.060472Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-09-14T07:50:06.061611Z 0 [System] [MY-010910] [Server] D:\mysql-8.0.17-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
D:\mysql-8.0.17-winx64\bin>mysqld --install
Service successfully installed.
D:\mysql-8.0.17-winx64\bin>net start mysql
MySQL 服務正在啟動 .
MySQL 服務無法啟動。
有大佬能幫我解決下嗎
————————————————————
后面重新安裝8.0.15版本
發現是initialing database 出錯 錯誤日志：
Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file
Beginning configuration step: Updating Windows Firewall rules
Attempting to delete a Windows Firewall rule with command: netsh.exe advfirewall firewall delete rule name="Port 3306" protocol=TCP localport=3306
已洗掉 1 規則。
確定。
Adding a Windows Firewall rule for MySQL80 on port 3306.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
確定。
Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules
Beginning configuration step: Adjusting Windows service
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service
Beginning configuration step: Initializing Database
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.11...
Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console --initialize-insecure=on...
2019-09-14T15:48:14.514856Z 0 [Warning] [MY-011071] [Server] option 'read_buffer_size': unsigned value 0 adjusted to 8192
2019-09-14T15:48:14.514893Z 0 [Warning] [MY-011071] [Server] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1
2019-09-14T15:48:14.514957Z 0 [Warning] [MY-010915] [Server] '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.
2019-09-14T15:48:14.515018Z 0 [System] [MY-013169] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 13532
2019-09-14T15:48:14.529831Z 1 [ERROR] [MY-012576] [InnoDB] InnoDB: Unable to create temporary file; errno: 2
2019-09-14T15:48:14.529969Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB: InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
2019-09-14T15:48:14.530383Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-09-14T15:48:14.530462Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-09-14T15:48:14.531275Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.
Process for mysqld, with ID 13532, was run successfully and exited with code 1.
Failed to start process for MySQL Server 8.0.11.
Database initialization failed.
Ended configuration step: Initializing Database
發現錯誤原因一樣，還不知道怎么解決
uj5u.com熱心網友回復：
軟體卸載后，注冊表中的檔案路徑有沒有洗掉。uj5u.com熱心網友回復：
完全洗掉mysql1、控制面板里洗掉mysql相關。
2、洗掉安裝目錄檔案夾。
3、清理注冊表http://jingyan.baidu.com/article/f96699bbaa8fc1894f3c1b5a.html。
4、C:\Windows 目錄下，如果有 my.cnf 或 my.ini ，也要洗掉。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/48432.html
標籤：MySQL
上一篇：DBeaver客戶端連接超時