linux 下mysql安装完毕，应用正常，正常关机重启后服务不能启动

yj411

linux 下mysql安装完毕，应用正常，正常关机重启后服务不能启动：
使用： mysql  -u root -p 12345678
报错误： Can't connect to local MySQL server throungh socket '/var/lib/mysql/mysql.sock




使用：/etc/init.d/mysqld start
错误：Timeout error occurred trying to start MySQL Daemon

请高手指教如何解决？？？？？

renxiao2003

日志。

yangyang1581

回复 1# yj411


    报错误： Can't connect to local MySQL server throungh socket '/var/lib/mysql/mysql.sock

yj411

mysql运行日志为：

110830 09:35:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110830  9:35:01 [Note] Flashcache bypass: disabled
110830  9:35:01 [Note] Flashcache setup error is : ioctl failed

110830  9:35:01 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
110830  9:35:01  InnoDB: Initializing buffer pool, size = 1.0G
110830  9:35:02  InnoDB: Completed initialization of buffer pool
110830  9:35:02  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110830  9:35:02  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 21 of name './citic/atm_info.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 21 of name './citiczj/newweb_xcdeh.ibd' already exists in the tablespace
InnoDB: memory cache!
110830 09:35:02 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

wuxb45

遇到同样的问题，fedora mysql5.5.15、5.5.14

yj411

高手呢？

小版主杀手

进入安装目录 启动看下

yj411

试过了还不行

小版主杀手

Database was not shut down normally
好像是数据库坏了，有备份的话 个人觉得重新安装授权表吧

yj411

有没有不需要重装的方法？？？？？？？