After installing mysql, start the service tips "mysql service on local computer started after stop, some services when not used by other services or procedures will automatically stop," unable to start the service, strives for the advanced version, how to solve,

System: Windows 8.1 x64
Mysql version: the latest x64 community version
Service set in the logged in user is administrator,

An error screenshot is as follows:

CodePudding user response:

Baidu about the MYSQL error log, and then find the file, use notepad opens, the related content is copied to the posts for analysis,

CodePudding user response:

The mysql start automatically when you, you try to start the mysql in the DOS window, if you don't succeed, see the error log (my) ini)

CodePudding user response:

reference 1st floor ACMAIN_CHM response:

baidu the the MYSQL error log, and then find the file, use notepad opens, the related content is copied to the posts for analysis,

The error log as follows, please have a look, thanks a lot:

T14:2015-11-04 53:36. 271542 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 2015-11-04 T14:53:36. 271542 z 0 [Warning] Insecure configuration for - secure - file - priv: Current value does not restrict the location of generated files. Consider setting it to a valid, non - empty path.
The 2015-11-04 T14:53:36. 272543 z 0 [Note] E: \ mysql - 5.7.9 - winx64 \ bin \ mysqld (mysqld 5.7.9) starting as the process of 7864...
The 2015-11-04 T14:53:36. 286553 z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions provides
The 2015-11-04 T14:53:36. 287553 z 0 [Note] InnoDB: Uses the event mutexes
The 2015-11-04 T14:53:36. 288553 z 0 [Note] InnoDB: _mm_lfence () and _mm_sfence () are 2 for the memory barrier
The 2015-11-04 T14:53:36. 288553 z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
The 2015-11-04 T14:53:36. 289554 z 0 [Note] InnoDB: Number of pools: 1
The 2015-11-04 T14:53:36. 290554 z 0 [Note] InnoDB: Not using CPU crc32 instructions
The 2015-11-04 T14:53:36. 704832 z 0 [Note] InnoDB: Initializing buffer pool, the total size=128 m, the instances=1, the chunk size=128 m
The 2015-11-04 T14:53:36. 717840 z 0 [Note] InnoDB: Completed initialization of buffer pool
The 2015-11-04 T14: making it 53-37. 179150 z 0 [Note] InnoDB: Highest supported file format is Barracuda.
The 2015-11-04 T14: making it 53-37. 801564 z 0 [Note] InnoDB: Creating Shared in tablespace for temporary tables
The 2015-11-04 T14: making it 53-37. 802565 z 0 [Note] InnoDB: Setting the file 'E: \ mysql - 5.7.9 - winx64 \ data \ ibtmp1' size to 12 MB. Physically their file full; Both Please wait...
The T14:2015-11-04 53:38. 109771 z 0 [Note] InnoDB: the File 'E: \ mysql - 5.7.9 - winx64 \ data \ ibtmp1' size is now 12 MB.
The 2015-11-04 T14:53:38. 171811 z 0 [Note] InnoDB: 96 redo the rollback segment (s) found. 96 redo the rollback segment (s) are active.
The 2015-11-04 T14:53:38. 172812 z 0 [Note] InnoDB: 32 non - redo the rollback segment (s) are active.
The 2015-11-04 T14:53:38. 174816 z 0 [Note] InnoDB: Waiting for purge to start
The 2015-11-04 T14:53:38. 260872 z 0 [Note] InnoDB: 5.7.9 started; The log sequence number 1209961
The 2015-11-04 T14:53:38. 263877 z 0 [Note] the Plugin 'FEDERATED is disabled.
The 2015-11-04 T14:53:38. 263877 z 0 [Note] InnoDB: Loading buffer pool (s) the from E: \ mysql - 5.7.9 - winx64 \ data \ ib_buffer_pool
Mysqld: Table 'mysql. The plugin doesn' t exist2015-11-04 t14:53:38. 265875 z 0 [Note] InnoDB: not started

The 2015-11-04 T14:53:38. 266875 z 0 [ERROR] Can 't open the mysql. The plugin table. Both Please run mysql_upgrade to create it.
The 2015-11-04 T14:53:38. 268877 z 0 [Warning] Gtid table is not ready to be 2. The table 'mysql. Gtid_executed' always be the opened.
The 2015-11-04 T14:53:38. 270879 z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
The 2015-11-04 T14:53:38. 272880 z 0 [Note] Server hostname (bind - address) : '*'; Port: 3306
The 2015-11-04 T14:53:38. 273880 z 0 [Note] IPv6 is available.
The 2015-11-04 T14:53:38. [Note] 0-274880 z ': :' resolves to '... ';
The 2015-11-04 T14:53:38. 274880 z 0 [Note] Server socket created on IP: ':'.
The 2015-11-04 T14:53:38. 345929 z 0 [Note] InnoDB: Buffer pool (s) the load completed at 151104 22:53:38
The 2015-11-04 T14:53:38. 365943 z 0 [Warning] Failed to open optimizer cost constant tables

The 2015-11-04 T14:53:38. 370945 z 0 [ERROR] Fatal ERROR: Can 't open the lock and privilege tables: Table' mysql. The user 'doesn' t exist
The 2015-11-04 T14:53:38. 374948 z 0 [ERROR] Aborting

The 2015-11-04 T14:53:38. 374948 z 0 [Note] Binlog end
The 2015-11-04 T14:53:38. 375950 z 0 [Note] Shutting down the plugin 'ngram'
The 2015-11-04 T14:53:38. 376949 z 0 [Note] Shutting down the plugin 'partition'
The 2015-11-04 T14:53:38. 376949 z 0 [Note] Shutting down the plugin 'BLACKHOLE'
The 2015-11-04 T14:53:38. 376949 z 0 [Note] Shutting down the plugin 'ARCHIVE'
The 2015-11-04 T14:53:38. 377950 z 0 [Note] Shutting down the plugin 'PERFORMANCE_SCHEMA'
The 2015-11-04 T14:53:38. 378950 z 0 [Note] Shutting down the plugin 'MRG_MYISAM'
The 2015-11-04 T14:53:38. 378950 z 0 [Note] Shutting down the plugin 'MyISAM'
The 2015-11-04 T14:53:38. 379951 z 0 [Note] Shutting down the plugin 'INNODB_SYS_VIRTUAL'
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull