之前安裝過一次之后卸載了,之前一直報錯可能是因為沒有刪干凈,現在已經刪過檔案夾和注冊表,應該沒有殘留的東西了,重啟電腦之后還是顯示無法啟動程式,求大神幫忙解答一下接下來該怎么辦....
CMD執行命令結果:
D:\mysql-5.7.19-winx64\bin>mysqld -install
Service successfully installed.
D:\mysql-5.7.19-winx64\bin>net start mysql
MySQL 服務正在啟動 .
MySQL 服務無法啟動。
服務沒有報告任何錯誤。
請鍵入 NET HELPMSG 3534 以獲得更多的幫助。
D:\mysql-5.7.19-winx64\bin>mysqld --console
mysqld: Can't read dir of 'C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\' (Errcode: 2 - No such file or directory)
2017-09-18T09:08:28.680749Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-18T09:08:28.681836Z 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-09-18T09:08:28.683479Z 0 [ERROR] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : C:/ProgramData/MySQL/MySQL Server 5.7/Uploads
2017-09-18T09:08:28.683479Z 0 [ERROR] Aborting
2017-09-18T09:08:28.684776Z 0 [Note] Binlog end
D:\mysql-5.7.19-winx64\bin>
uj5u.com熱心網友回復:
net start mysql 后檢查一下MYSQL的錯誤日志。uj5u.com熱心網友回復:
C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\ 這個檔案夾建上uj5u.com熱心網友回復:
mysqld: Table 'mysql.plugin' doesn't exist2017-09-21T06:48:40.532550Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-09-21T06:48:40.590703Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2017-09-21T06:48:40.591707Z 0 [ERROR] Aborting
錯誤日志里面的兩個主要錯誤
腫么破...
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/110880.html
標籤:MySQL
下一篇:請教怎么優化查詢效率
