MySQL安装好后服务启动不起来

lujunhua 发布于 2011/10/18 08:43
阅读 2K+
收藏 0

鄙人刚刚接触到MySQL不久

MySQL安装好后服务启动不起来,提示进程意外终止 错误代号:1067

希望高人给予指点

加载中
0
hnynes
hnynes

给出来的那个链接文档上有哦.你的这个错误刚好就属于初始化错误了.

f something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all ib_logfile files. If you already created some InnoDB tables, also delete the corresponding .frm files for these tables, and any .ibd files if you are using multiple tablespaces, from the MySQL database directories. Then try the InnoDB database creation again. For easiest troubleshooting, start the MySQL server from a command prompt so that you see what is happening.

0
红薯
红薯
看 mysql 的日志,linux 下默认在 /var/lib/mysql 目录下,windows 就在数据目录下的 xxx.err 文件
0
l
lujunhua

我看了以下主要是以下日志,不是太懂  是不是安装有错误啊

111019  8:17:24 [Note] Plugin 'FEDERATED' is disabled.
111019  8:17:25 InnoDB: The InnoDB memory heap is disabled
111019  8:17:25 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111019  8:17:25 InnoDB: Compressed tables use zlib 1.2.3
111019  8:17:26 InnoDB: Initializing buffer pool, size = 225.0M
111019  8:17:27 InnoDB: Completed initialization of buffer pool
111019  8:17:27 InnoDB: highest supported file format is Barracuda.
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/error-creating-innodb.html
111019  8:17:27 [ERROR] Plugin 'InnoDB' init function returned error.
111019  8:17:27 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111019  8:17:27 [ERROR] Unknown/unsupported storage engine: INNODB
111019  8:17:27 [ERROR] Aborting

111019  8:17:27 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

0
l
lujunhua

问题解决了,就是把原来的数据删除,重新安装

返回顶部
顶部