Previously installed after a uninstalled, until an error is likely due to not delete clean, now has been delete folders and registry, there should be no remaining things, restart the computer after or display program cannot be started, please help me answer the next great god what to do...

CMD command results:

D: \ mysql - 5.7.19 - winx64 \ bin> Mysqld - install
Service successfully installed.

D: \ mysql - 5.7.19 - winx64 \ bin> Net start mysql
The MySQL service is starting.
The MySQL service cannot be started,

Service report no errors,

Please type the NET HELPMSG 3534 for more help,


D: \ mysql - 5.7.19 - winx64 \ bin> Mysqld -- the console
Mysqld: Can 't read dir of' C: \ ProgramData/MySQL/MySQL Server 5.7 \ Uploads \ '(Errcode: 2 - to a file or directory)
The 2017-09-18 T09:08:28. 680749 z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Do use - explicit_defaults_for_timestamp server option (see documentation for more details).
The 2017-09-18 T09:08:28. 681836 z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO SQL modes should be 2 with strict mode. They will be merged with strict mode in a future release.
The 2017-09-18 T09:08:28. 683479 z 0 [ERROR] Failed to access the directory for - secure - file - priv. Do make sure that the directory exists and is accessible by the MySQL Server. The Supplied value: C:/ProgramData/MySQL/MySQL Server 5.7/Uploads
The 2017-09-18 T09:08:28. 683479 z 0 [ERROR] Aborting

The 2017-09-18 T09:08:28. 684776 z 0 [Note] Binlog end

D: \ mysql - 5.7.19 - winx64 \ bin>

CodePudding user response:

Net start mysql after check the mysql error log,

CodePudding user response:

C: \ ProgramData/MySQL/MySQL Server 5.7 \ Uploads \ built on this folder

CodePudding user response:

Mysqld: Table 'mysql. The plugin doesn' t exist
The 2017-09-21 T06:48:40. 532550 z 0 [ERROR] Can 't open the mysql. The plugin table. Both Please run mysql_upgrade to create it.

The 2017-09-21 T06:48:40. 590703 z 0 [ERROR] Fatal ERROR: Can 't open the lock and privilege tables: Table' mysql. The user 'doesn' t exist
The 2017-09-21 T06:48:40. 591707 z 0 [ERROR] Aborting

The inside of the error log two main error
How to break...