redhat中mysql服务无法启动

[复制链接]
查看11 | 回复5 | 2021-1-27 07:08:13 | 显示全部楼层 |阅读模式
[root@localhostlog]#servicemysqlstart
StartingMySQL...............ERROR!TheserverquitwithoutupdatingPIDfile(/var/lib/mysql/localhost.pid).
运行环境:
os:rhel-server-6.4-i386
MySQL-client-5.6.14-1.linux_glibc2.5.i386.rpm
MySQL-server-5.6.14-1.linux_glibc2.5.i386.rpm
上面这两个安装包已经正确安装。
这个问题我已经搞了三天了就是解决不了。在网上也找也许多方法,也不成。希望大家帮助。
[root@localhostmysql]#nllocalhost.err
113111606:59:00mysqld_safeStartingmysqlddaemonwithdatabasesfrom/var/lib/mysql
22013-11-1606:59:480[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).
32013-11-1606:59:486745[Note]Plugin'FEDERATED'isdisabled.
42013-11-1606:59:486745[Note]InnoDB:TheInnoDBmemoryheapisdisabled
52013-11-1606:59:486745[Note]InnoDB:Mutexesandrw_locksuseInnoDB'sownimplementation
62013-11-1606:59:486745[Note]InnoDB:Compressedtablesusezlib1.2.3
72013-11-1606:59:486745[Note]InnoDB:UsingLinuxnativeAIO
82013-11-1606:59:486745[Note]InnoDB:NotusingCPUcrc32instructions
92013-11-1606:59:486745[Note]InnoDB:Initializingbufferpool,size=128.0M
102013-11-1606:59:496745[Note]InnoDB:Completedinitializationofbufferpool
112013-11-1606:59:496745[ERROR]InnoDB:auto-extendingdatafile./ibdata1isofadifferentsize640pages(roundeddowntoMB)thanspecifiedinthe.cnffile:initial768pages,max0(relevantifnon-zero)pages!
122013-11-1606:59:496745[ERROR]InnoDB:Couldnotopenorcreatethesystemtablespace.Ifyoutriedtoaddnewdatafilestothesystemtablespace,anditfailedhere,youshouldnoweditinnodb_data_file_pathinmy.cnfbacktowhatitwas,andremovethenewibdatafilesInnoDBcreatedinthisfailedattempt.InnoDBonlywrotethosefilesfullofzeros,butdidnotyetusetheminanyway.Butbecareful:donotremoveolddatafileswhichcontainyourpreciousdata!
132013-11-1606:59:496745[ERROR]Plugin'InnoDB'initfunctionreturnederror.
142013-11-1606:59:496745[ERROR]Plugin'InnoDB'registrationasaSTORAGEENGINEfailed.
152013-11-1606:59:496745[ERROR]Unknown/unsupportedstorageengine:InnoDB
162013-11-1606:59:496745[ERROR]Aborting
172013-11-1606:59:496745[Note]Binlogend
182013-11-1606:59:496745[Note]Shuttingdownplugin'partition'
192013-11-1606:59:496745[Note]Shuttingdownplugin'BLACKHOLE'
202013-11-1606:59:496745[Note]Shuttingdownplugin'ARCHIVE'
212013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_SYS_DATAFILES'
222013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_SYS_TABLESPACES'
232013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_SYS_FOREIGN_COLS'
242013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_SYS_FOREIGN'
252013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_SYS_FIELDS'
262013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_SYS_COLUMNS'
272013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_SYS_INDEXES'
282013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_SYS_TABLESTATS'
292013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_SYS_TABLES'
302013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_FT_INDEX_TABLE'
312013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_FT_INDEX_CACHE'
322013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_FT_CONFIG'
332013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_FT_BEING_DELETED'
342013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_FT_DELETED'
352013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_FT_DEFAULT_STOPWORD'
362013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_METRICS'
372013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_BUFFER_POOL_STATS'
382013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_BUFFER_PAGE_LRU'
392013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_BUFFER_PAGE'
402013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_CMP_PER_INDEX_RESET'
412013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_CMP_PER_INDEX'
422013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_CMPMEM_RESET'
432013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_CMPMEM'
442013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_CMP_RESET'
452013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_CMP'
462013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_LOCK_WAITS'
472013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_LOCKS'
482013-11-1606:59:496745[Note]Shuttingdownplugin'INNODB_TRX'
492013-11-1606:59:496745[Note]Shuttingdownplugin'PERFORMANCE_SCHEMA'
502013-11-1606:59:496745[Note]Shuttingdownplugin'MRG_MYISAM'
512013-11-1606:59:496745[Note]Shuttingdownplugin'CSV'
522013-11-1606:59:496745[Note]Shuttingdownplugin'MyISAM'
532013-11-1606:59:496745[Note]Shuttingdownplugin'MEMORY'
542013-11-1606:59:496745[Note]Shuttingdownplugin'sha256_password'
552013-11-1606:59:496745[Note]Shuttingdownplugin'mysql_old_password'
562013-11-1606:59:496745[Note]Shuttingdownplugin'mysql_native_password'
572013-11-1606:59:496745[Note]Shuttingdownplugin'binlog'
582013-11-1606:59:496745[Note]/usr/sbin/mysqld:Shutdowncomplete
5913111606:59:49mysqld_safemysqldfrompidfile/var/lib/mysql/localhost.pidended
分 -->
回复

使用道具 举报

千问 | 2021-1-27 07:08:13 | 显示全部楼层
rm-rf/var/lib/mysql/ibdata1
rm-rf/var/lib/mysql/ib_log*

回复

使用道具 举报

千问 | 2021-1-27 07:08:13 | 显示全部楼层
删掉以上两个文件后重启数据库
回复

使用道具 举报

千问 | 2021-1-27 07:08:13 | 显示全部楼层
StartingMySQL................................ERROR!TheserverquitwithoutupdatingPIDfile(/var/lib/mysql/localhost.pid).
依然是报这个错。方便的话可以加我QQ帮我远程看一下。viking1379182570
回复

使用道具 举报

千问 | 2021-1-27 07:08:13 | 显示全部楼层
其实这个错就是MySQL没有正确安装。
回复

使用道具 举报

千问 | 2021-1-27 07:08:13 | 显示全部楼层
重装了好几次,各种版本也试过了。安装时没有任何错误。就是启动服务时报这个错。如果可以,加我的QQ帮我远程看一下。viking1379182570
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行