杂类

在logs文件中查看,报的是以下错误:2021-11-1617:49:210[Note]InnoDB:Mutexesandrw_locksuseWindowsinterlockedfunctions2021-11-1617:49:210[Note]InnoDB:Useseventmutexes2021-11-1617:49:210[Note]InnoDB:Compressedtablesusezlib1.2.112021-11-1617:49:210[Note]InnoDB:Numberofpools:12021-11-1617:49:210[Note]InnoDB:UsingSSE2crc32instructions2021-11-1617:49:210[Note]InnoDB:Initializingbufferpool,totalsize=16M,instances=1,chunksize=16M2021-11-1617:49:210[Note]InnoDB:Completedinitializationofbufferpool2021-11-1617:49:210[Note]InnoDB:128outof128rollbacksegmentsareactive.2021-11-1617:49:210[Note]InnoDB:Creatingsharedtablespacefortemporarytables2021-11-1617:49:210[Note]InnoDB:Settingfile'C:\xampp\mysql\data\ibtmp1'sizeto12MB.Physicallywritingthefilefull;Pleasewait...2021-11-1617:49:210[Note]InnoDB:File'C:\xampp\mysql\data\ibtmp1'sizeisnow12MB.2021-11-1617:49:210[Note]InnoDB:Waitingforpurgetostart2021-11-1617:49:210[Note]InnoDB:10.4.21started;logsequencenumber300610;transactionid1702021-11-1617:49:210[Note]Plugin'FEEDBACK'isdisabled.2021-11-1617:49:210[Note]InnoDB:Loadingbufferpool(s)fromC:\xampp\mysql\data\ib_buffer_pool2021-11-1617:49:210[Note]ServersocketcreatedonIP:'::'.解决办法:在一个cmd窗口中,输入以下命令:mysqld–-console–-skip-grant-tables–-skip-external-locking然后不要关闭刚刚打开的那个cmd窗口,接着在打开一个cmd窗口,输入以下命令:mysqlcheck-r--databasesmysql--use-frm接着,将两个cmd窗口全部关闭,重新在xmapp中开启mysql。