mySQL无法启动服务，新手跪求大神指点

显示全部楼层 · 2021-1-27 07:16:22

分 -->

千问 · 2021-1-27 07:16:22

2016-11-17T03:20:27.318019Z0[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).
2016-11-17T03:20:27.318019Z0[Note]--secure-file-privissettoNULL.Operationsrelatedtoimportingandexportingdataaredisabled
2016-11-17T03:20:27.318019Z0[Note]mysqld(mysqld5.7.16)startingasprocess13640...
2016-11-17T03:20:27.328028Z0[Note]InnoDB:Mutexesandrw_locksuseWindowsinterlockedfunctions
2016-11-17T03:20:27.329028Z0[Note]InnoDB:Useseventmutexes
2016-11-17T03:20:27.329028Z0[Note]InnoDB:_mm_lfence()and_mm_sfence()areusedformemorybarrier
2016-11-17T03:20:27.330028Z0[Note]InnoDB:Compressedtablesusezlib1.2.3
2016-11-17T03:20:27.331029Z0[Note]InnoDB:Numberofpools:1
2016-11-17T03:20:27.332030Z0[Note]InnoDB:NotusingCPUcrc32instructions
2016-11-17T03:20:27.335031Z0[Note]InnoDB:Initializingbufferpool,totalsize=128M,instances=1,chunksize=128M
2016-11-17T03:20:27.342036Z0[Note]InnoDB:Completedinitializationofbufferpool
2016-11-17T03:20:27.356047Z0[Note]InnoDB:Thefirstinnodb_systemdatafile'ibdata1'didnotexist.Anewtablespacewillbecreated!
2016-11-17T03:20:27.357047Z0[Note]InnoDB:Settingfile'.\ibdata1'sizeto12MB.Physicallywritingthefilefull;Pleasewait...
2016-11-17T03:20:27.561389Z0[Note]InnoDB:File'.\ibdata1'sizeisnow12MB.
2016-11-17T03:20:27.574393Z0[Note]InnoDB:Settinglogfile.\ib_logfile101sizeto48MB
2016-11-17T03:20:28.437462Z0[Note]InnoDB:Settinglogfile.\ib_logfile1sizeto48MB
2016-11-17T03:20:29.313572Z0[Note]InnoDB:Renaminglogfile.\ib_logfile101to.\ib_logfile0
2016-11-17T03:20:29.315558Z0[Warning]InnoDB:Newlogfilescreated,LSN=45790
2016-11-17T03:20:29.315558Z0[Note]InnoDB:Creatingsharedtablespacefortemporarytables
2016-11-17T03:20:29.316567Z0[Note]InnoDB:Settingfile'.\ibtmp1'sizeto12MB.Physicallywritingthefilefull;Pleasewait...
2016-11-17T03:20:29.546945Z0[Note]InnoDB:File'.\ibtmp1'sizeisnow12MB.
2016-11-17T03:20:29.547950Z0[Note]InnoDB:Doublewritebuffernotfound:creatingnew
2016-11-17T03:20:29.812690Z0[Note]InnoDB:Doublewritebuffercreated
2016-11-17T03:20:29.846699Z0[Note]InnoDB:96redorollbacksegment(s)found.96redorollbacksegment(s)areactive.
2016-11-17T03:20:29.847699Z0[Note]InnoDB:32non-redorollbacksegment(s)areactive.
2016-11-17T03:20:29.848700Z0[Warning]InnoDB:Creatingforeignkeyconstraintsystemtables.
2016-11-17T03:20:29.912058Z0[Note]InnoDB:Foreignkeyconstraintsystemtablescreated
2016-11-17T03:20:29.912058Z0[Note]InnoDB:Creatingtablespaceanddatafilesystemtables.
2016-11-17T03:20:29.967137Z0[Note]InnoDB:Tablespaceanddatafilesystemtablescreated.
2016-11-17T03:20:29.967638Z0[Note]InnoDB:Creatingsys_virtualsystemtables.
2016-11-17T03:20:29.989826Z0[Note]InnoDB:sys_virtualtablecreated
2016-11-17T03:20:29.989826Z0[Note]InnoDB:Waitingforpurgetostart
2016-11-17T03:20:30.041816Z0[Note]InnoDB:5.7.16started;logsequencenumber0
2016-11-17T03:20:30.041816Z0[Note]Plugin'FEDERATED'isdisabled.
mysqld:Table'mysql.plugin'doesn'texist
2016-11-17T03:20:30.042814Z0[ERROR]Can'topenthemysql.plugintable.Pleaserunmysql_upgradetocreateit.
2016-11-17T03:20:30.042814Z0[ERROR]Toomanyarguments(firstextrais'initialize').
2016-11-17T03:20:30.043814Z0[Note]Use--verbose--helptogetalistofavailableoptions!
2016-11-17T03:20:30.043814Z0[ERROR]Aborting
2016-11-17T03:20:30.043814Z0[Note]Binlogend
2016-11-17T03:20:30.044815Z0[Note]Shuttingdownplugin'ngram'
2016-11-17T03:20:30.044815Z0[Note]Shuttingdownplugin'partition'
2016-11-17T03:20:30.044815Z0[Note]Shuttingdownplugin'BLACKHOLE'
2016-11-17T03:20:30.044815Z0[Note]Shuttingdownplugin'ARCHIVE'
2016-11-17T03:20:30.045816Z0[Note]Shuttingdownplugin'PERFORMANCE_SCHEMA'
2016-11-17T03:20:30.045816Z0[Note]Shuttingdownplugin'MRG_MYISAM'
2016-11-17T03:20:30.045816Z0[Note]Shuttingdownplugin'MyISAM'
2016-11-17T03:20:30.046829Z0[Note]Shuttingdownplugin'INNODB_SYS_VIRTUAL'
2016-11-17T03:20:30.046829Z0[Note]Shuttingdownplugin'INNODB_SYS_DATAFILES'
2016-11-17T03:20:30.046829Z0[Note]Shuttingdownplugin'INNODB_SYS_TABLESPACES'
2016-11-17T03:20:30.047830Z0[Note]Shuttingdownplugin'INNODB_SYS_FOREIGN_COLS'
2016-11-17T03:20:30.047830Z0[Note]Shuttingdownplugin'INNODB_SYS_FOREIGN'
2016-11-17T03:20:30.047830Z0[Note]Shuttingdownplugin'INNODB_SYS_FIELDS'
2016-11-17T03:20:30.047830Z0[Note]Shuttingdownplugin'INNODB_SYS_COLUMNS'
2016-11-17T03:20:30.048831Z0[Note]Shuttingdownplugin'INNODB_SYS_INDEXES'
2016-11-17T03:20:30.048831Z0[Note]Shuttingdownplugin'INNODB_SYS_TABLESTATS'
2016-11-17T03:20:30.048831Z0[Note]Shuttingdownplugin'INNODB_SYS_TABLES'
2016-11-17T03:20:30.049832Z0[Note]Shuttingdownplugin'INNODB_FT_INDEX_TABLE'
2016-11-17T03:20:30.049832Z0[Note]Shuttingdownplugin'INNODB_FT_INDEX_CACHE'
2016-11-17T03:20:30.049832Z0[Note]Shuttingdownplugin'INNODB_FT_CONFIG'
2016-11-17T03:20:30.050833Z0[Note]Shuttingdownplugin'INNODB_FT_BEING_DELETED'
2016-11-17T03:20:30.050833Z0[Note]Shuttingdownplugin'INNODB_FT_DELETED'
2016-11-17T03:20:30.050833Z0[Note]Shuttingdownplugin'INNODB_FT_DEFAULT_STOPWORD'
2016-11-17T03:20:30.050833Z0[Note]Shuttingdownplugin'INNODB_METRICS'
2016-11-17T03:20:30.051833Z0[Note]Shuttingdownplugin'INNODB_TEMP_TABLE_INFO'
2016-11-17T03:20:30.051833Z0[Note]Shuttingdownplugin'INNODB_BUFFER_POOL_STATS'
2016-11-17T03:20:30.051833Z0[Note]Shuttingdownplugin'INNODB_BUFFER_PAGE_LRU'
2016-11-17T03:20:30.052834Z0[Note]Shuttingdownplugin'INNODB_BUFFER_PAGE'
2016-11-17T03:20:30.052834Z0[Note]Shuttingdownplugin'INNODB_CMP_PER_INDEX_RESET'
2016-11-17T03:20:30.052834Z0[Note]Shuttingdownplugin'INNODB_CMP_PER_INDEX'
2016-11-17T03:20:30.053835Z0[Note]Shuttingdownplugin'INNODB_CMPMEM_RESET'
2016-11-17T03:20:30.053835Z0[Note]Shuttingdownplugin'INNODB_CMPMEM'
2016-11-17T03:20:30.053835Z0[Note]Shuttingdownplugin'INNODB_CMP_RESET'
2016-11-17T03:20:30.053835Z0[Note]Shuttingdownplugin'INNODB_CMP'
2016-11-17T03:20:30.054835Z0[Note]Shuttingdownplugin'INNODB_LOCK_WAITS'
2016-11-17T03:20:30.054835Z0[Note]Shuttingdownplugin'INNODB_LOCKS'
2016-11-17T03:20:30.054835Z0[Note]Shuttingdownplugin'INNODB_TRX'
2016-11-17T03:20:30.055836Z0[Note]Shuttingdownplugin'InnoDB'
2016-11-17T03:20:30.055836Z0[Note]InnoDB:FTSoptimizethreadexiting.
2016-11-17T03:20:30.055836Z0[Note]InnoDB:Startingshutdown...
2016-11-17T03:20:30.157058Z0[Note]InnoDB:Dumpingbufferpool(s)toD:\mysql\mysql-5.7.16-winx64\data\ib_buffer_pool
2016-11-17T03:20:30.158008Z0[Note]InnoDB:Bufferpool(s)dumpcompletedat16111711:20:30
2016-11-17T03:20:31.746457Z0[Note]InnoDB:Shutdowncompleted;logsequencenumber1209961
2016-11-17T03:20:31.747453Z0[Note]InnoDB:Removedtemporarytablespacedatafile:"ibtmp1"
2016-11-17T03:20:31.747453Z0[Note]Shuttingdownplugin'MEMORY'
2016-11-17T03:20:31.747453Z0[Note]Shuttingdownplugin'CSV'
2016-11-17T03:20:31.748444Z0[Note]Shuttingdownplugin'sha256_password'
2016-11-17T03:20:31.748444Z0[Note]Shuttingdownplugin'mysql_native_password'
2016-11-17T03:20:31.748444Z0[Note]Shuttingdownplugin'binlog'
2016-11-17T03:20:31.749454Z0[Note]mysqld:Shutdowncomplete
2016-11-17T03:20:39.086979Z0[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).
2016-11-17T03:20:39.086979Z0[Note]--secure-file-privissettoNULL.Operationsrelatedtoimportingandexportingdataaredisabled
2016-11-17T03:20:39.087479Z0[Note]MySQL(mysqld5.7.16)startingasprocess2760...
2016-11-17T03:20:39.094010Z0[Note]InnoDB:Mutexesandrw_locksuseWindowsinterlockedfunctions
2016-11-17T03:20:39.095011Z0[Note]InnoDB:Useseventmutexes
2016-11-17T03:20:39.095011Z0[Note]InnoDB:_mm_lfence()and_mm_sfence()areusedformemorybarrier
2016-11-17T03:20:39.095011Z0[Note]InnoDB:Compressedtablesusezlib1.2.3
2016-11-17T03:20:39.096011Z0[Note]InnoDB:Numberofpools:1
2016-11-17T03:20:39.096011Z0[Note]InnoDB:NotusingCPUcrc32instructions
2016-11-17T03:20:39.099003Z0[Note]InnoDB:Initializingbufferpool,totalsize=128M,instances=1,chunksize=128M
2016-11-17T03:20:39.107009Z0[Note]InnoDB:Completedinitializationofbufferpool
2016-11-17T03:20:39.319096Z0[Note]InnoDB:HighestsupportedfileformatisBarracuda.
2016-11-17T03:20:39.419173Z0[Note]InnoDB:Creatingsharedtablespacefortemporarytables
2016-11-17T03:20:39.419173Z0[Note]InnoDB:Settingfile'.\ibtmp1'sizeto12MB.Physicallywritingthefilefull;Pleasewait...
2016-11-17T03:20:39.637305Z0[Note]InnoDB:File'.\ibtmp1'sizeisnow12MB.
2016-11-17T03:20:39.639301Z0[Note]InnoDB:96redorollbacksegment(s)found.96redorollbacksegment(s)areactive.
2016-11-17T03:20:39.639301Z0[Note]InnoDB:32non-redorollbacksegment(s)areactive.
2016-11-17T03:20:39.640302Z0[Note]InnoDB:Waitingforpurgetostart
2016-11-17T03:20:39.703590Z0[Note]InnoDB:5.7.16started;logsequencenumber1209961
2016-11-17T03:20:39.704586Z0[Note]InnoDB:Loadingbufferpool(s)fromD:\mysql\mysql-5.7.16-winx64\data\ib_buffer_pool
2016-11-17T03:20:39.704586Z0[Note]Plugin'FEDERATED'isdisabled.
MySQL:Table'mysql.plugin'doesn'texist

千问 · 2021-1-27 07:16:22

2016-11-17T03:20:39.705587Z0[ERROR]Can'topenthemysql.plugintable.Pleaserunmysql_upgradetocreateit.
2016-11-17T03:20:39.706588Z0[Note]InnoDB:Bufferpool(s)loadcompletedat16111711:20:39
2016-11-17T03:20:39.706588Z0[Note]Saltinguuidgeneratorvariables,current_pid:2760,server_start_time:1479352839,bytes_sent:0,
2016-11-17T03:20:39.713582Z0[Note]Generateduuid:'d0974f95-ac74-11e6-81af-ac9e17286e46',server_start_time:1479355599,bytes_sent:2703222697968
2016-11-17T03:20:39.713582Z0[Warning]NoexistingUUIDhasbeenfound,soweassumethatthisisthefirsttimethatthisserverhasbeenstarted.GeneratinganewUUID:d0974f95-ac74-11e6-81af-ac9e17286e46.
2016-11-17T03:20:39.763668Z0[Warning]Gtidtableisnotreadytobeused.Table'mysql.gtid_executed'cannotbeopened.
2016-11-17T03:20:39.764636Z0[Warning]FailedtosetupSSLbecauseofthefollowingSSLlibraryerror:SSLcontextisnotusablewithoutcertificateandprivatekey
2016-11-17T03:20:39.766635Z0[Note]Serverhostname(bind-address):'*';port:3306
2016-11-17T03:20:39.767630Z0[Note]IPv6isavailable.
2016-11-17T03:20:39.767630Z0[Note]-'::'resolvesto'::';
2016-11-17T03:20:39.767630Z0[Note]ServersocketcreatedonIP:'::'.
2016-11-17T03:20:39.769622Z0[Warning]Failedtoopenoptimizercostconstanttables
2016-11-17T03:20:39.770622Z0[ERROR]Fatalerror:Can'topenandlockprivilegetables:Table'mysql.user'doesn'texist
2016-11-17T03:20:39.770622Z0[ERROR]Aborting
2016-11-17T03:20:39.771623Z0[Note]Binlogend
2016-11-17T03:20:39.771623Z0[Note]Shuttingdownplugin'ngram'
2016-11-17T03:20:39.771623Z0[Note]Shuttingdownplugin'partition'
2016-11-17T03:20:39.771623Z0[Note]Shuttingdownplugin'BLACKHOLE'
2016-11-17T03:20:39.771623Z0[Note]Shuttingdownplugin'ARCHIVE'
2016-11-17T03:20:39.772637Z0[Note]Shuttingdownplugin'PERFORMANCE_SCHEMA'
2016-11-17T03:20:39.772637Z0[Note]Shuttingdownplugin'MRG_MYISAM'
2016-11-17T03:20:39.772637Z0[Note]Shuttingdownplugin'MyISAM'
2016-11-17T03:20:39.772637Z0[Note]Shuttingdownplugin'INNODB_SYS_VIRTUAL'
2016-11-17T03:20:39.772637Z0[Note]Shuttingdownplugin'INNODB_SYS_DATAFILES'
2016-11-17T03:20:39.773637Z0[Note]Shuttingdownplugin'INNODB_SYS_TABLESPACES'
2016-11-17T03:20:39.773637Z0[Note]Shuttingdownplugin'INNODB_SYS_FOREIGN_COLS'
2016-11-17T03:20:39.773637Z0[Note]Shuttingdownplugin'INNODB_SYS_FOREIGN'
2016-11-17T03:20:39.773637Z0[Note]Shuttingdownplugin'INNODB_SYS_FIELDS'
2016-11-17T03:20:39.774638Z0[Note]Shuttingdownplugin'INNODB_SYS_COLUMNS'
2016-11-17T03:20:39.774638Z0[Note]Shuttingdownplugin'INNODB_SYS_INDEXES'
2016-11-17T03:20:39.774638Z0[Note]Shuttingdownplugin'INNODB_SYS_TABLESTATS'
2016-11-17T03:20:39.775627Z0[Note]Shuttingdownplugin'INNODB_SYS_TABLES'
2016-11-17T03:20:39.775627Z0[Note]Shuttingdownplugin'INNODB_FT_INDEX_TABLE'
2016-11-17T03:20:39.776145Z0[Note]Shuttingdownplugin'INNODB_FT_INDEX_CACHE'
2016-11-17T03:20:39.776145Z0[Note]Shuttingdownplugin'INNODB_FT_CONFIG'
2016-11-17T03:20:39.776633Z0[Note]Shuttingdownplugin'INNODB_FT_BEING_DELETED'
2016-11-17T03:20:39.776633Z0[Note]Shuttingdownplugin'INNODB_FT_DELETED'
2016-11-17T03:20:39.777145Z0[Note]Shuttingdownplugin'INNODB_FT_DEFAULT_STOPWORD'
2016-11-17T03:20:39.777145Z0[Note]Shuttingdownplugin'INNODB_METRICS'
2016-11-17T03:20:39.777650Z0[Note]Shuttingdownplugin'INNODB_TEMP_TABLE_INFO'
2016-11-17T03:20:39.777650Z0[Note]Shuttingdownplugin'INNODB_BUFFER_POOL_STATS'
2016-11-17T03:20:39.778145Z0[Note]Shuttingdownplugin'INNODB_BUFFER_PAGE_LRU'
2016-11-17T03:20:39.778145Z0[Note]Shuttingdownplugin'INNODB_BUFFER_PAGE'
2016-11-17T03:20:39.778646Z0[Note]Shuttingdownplugin'INNODB_CMP_PER_INDEX_RESET'
2016-11-17T03:20:39.778646Z0[Note]Shuttingdownplugin'INNODB_CMP_PER_INDEX'
2016-11-17T03:20:39.779146Z0[Note]Shuttingdownplugin'INNODB_CMPMEM_RESET'
2016-11-17T03:20:39.779146Z0[Note]Shuttingdownplugin'INNODB_CMPMEM'
2016-11-17T03:20:39.779647Z0[Note]Shuttingdownplugin'INNODB_CMP_RESET'
2016-11-17T03:20:39.779647Z0[Note]Shuttingdownplugin'INNODB_CMP'
2016-11-17T03:20:39.779647Z0[Note]Shuttingdownplugin'INNODB_LOCK_WAITS'
2016-11-17T03:20:39.780147Z0[Note]Shuttingdownplugin'INNODB_LOCKS'
2016-11-17T03:20:39.780147Z0[Note]Shuttingdownplugin'INNODB_TRX'
2016-11-17T03:20:39.780647Z0[Note]Shuttingdownplugin'InnoDB'
2016-11-17T03:20:39.780647Z0[Note]InnoDB:FTSoptimizethreadexiting.
2016-11-17T03:20:39.781147Z0[Note]InnoDB:Startingshutdown...
2016-11-17T03:20:39.881846Z0[Note]InnoDB:Dumpingbufferpool(s)toD:\mysql\mysql-5.7.16-winx64\data\ib_buffer_pool
2016-11-17T03:20:39.884348Z0[Note]InnoDB:Bufferpool(s)dumpcompletedat16111711:20:39
2016-11-17T03:20:41.277176Z0[Note]InnoDB:Shutdowncompleted;logsequencenumber1209980
2016-11-17T03:20:41.278189Z0[Note]InnoDB:Removedtemporarytablespacedatafile:"ibtmp1"
2016-11-17T03:20:41.278189Z0[Note]Shuttingdownplugin'MEMORY'
2016-11-17T03:20:41.278691Z0[Note]Shuttingdownplugin'CSV'
2016-11-17T03:20:41.278691Z0[Note]Shuttingdownplugin'sha256_password'
2016-11-17T03:20:41.279190Z0[Note]Shuttingdownplugin'mysql_native_password'
2016-11-17T03:20:41.279190Z0[Note]Shuttingdownplugin'binlog'
2016-11-17T03:20:41.279691Z0[Note]MySQL:Shutdowncomplete

千问 · 2021-1-27 07:16:22

那位大神来带带我

千问 · 2021-1-27 07:16:22

5.7总会出现这个问题
在cmd安装好MySQL之后，输入mysqld--initialize进行初始化
然后就会发现目录下多了一个data文件夹，再启动应该就没问题了