mysql 服务无法启动

༺ཌༀཉི浮华背后༃ༀད༻ 2013-07-29 11:32:43

继win7环境下mysql5卸载后服务安装不上又出现mysql server无法启动的问题：



D:\PHP\MySQL Server 5.6\bin>net start mysql

MySQL 服务正在启动 .

MySQL 服务无法启动。



系统出错。



发生系统错误 1067。



进程意外终止。

mysql错误日志：



2013-07-29 10:58:03 a10  InnoDB: File name D:\PHP\MySQL Server 5.5\ibdata1

2013-07-29 10:58:03 a10  InnoDB: File operation call: 'create' returned OS error 103.

2013-07-29 10:58:03 a10  InnoDB: Cannot continue operation.

2013-07-29 11:20:48 1776 [Note] Plugin 'FEDERATED' is disabled.

2013-07-29 11:20:48 804 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.

2013-07-29 11:20:48 1776 [Note] InnoDB: The InnoDB memory heap is disabled

2013-07-29 11:20:48 1776 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2013-07-29 11:20:48 1776 [Note] InnoDB: Compressed tables use zlib 1.2.3

2013-07-29 11:20:48 1776 [Note] InnoDB: Not using CPU crc32 instructions

2013-07-29 11:20:48 1776 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2013-07-29 11:20:48 1776 [Note] InnoDB: Completed initialization of buffer pool

2013-07-29 11:20:48 804  InnoDB: Operating system error number 3 in a file operation.

InnoDB: The error means the system cannot find the path specified.

InnoDB: If you are installing InnoDB, remember that you must create

InnoDB: directories yourself, InnoDB does not create them.

2013-07-29 11:20:48 804  InnoDB: File name D:\PHP\MySQL Server 5.5\ibdata1

2013-07-29 11:20:48 804  InnoDB: File operation call: 'create' returned OS error 103.

2013-07-29 11:20:48 804  InnoDB: Cannot continue operation.

但是，我的MySQL安装目录中没有ibdata1目录或文件……

针对以上错误报告，都有哪些原因造成？如何解决？

...全文

444 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

rucypli 2013-07-29

打赏
举报

搜my.ini文件然后删除都用默认的

༺ཌༀཉི浮华背后༃ༀད༻ 2013-07-29

打赏
举报

总算弄出来了：


D:\PHP\MySQL Server 5.6\bin>mysql_config_editor.exe set -u root -p

༺ཌༀཉི浮华背后༃ༀད༻ 2013-07-29

打赏
举报

感谢楼上建议，确实有多个my.ini冲突了。但是现在mysql server启动后，没有mysql表：


D:\PHP\MySQL Server 5.6\bin>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.12 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| test               |
+--------------------+
2 rows in set (0.08 sec)

如何加载数据表？