使用命名pipe道无法在Windows上启动MySQL

我已经在Windows上安装了MySQL服务器,虽然在configuration中已经select不运行MySQL作为服务器,并已禁用TCP / IP访问,所以只能使用命名pipe道,我现在有问题让服务器运行。 在尝试以独立模式启动后,以下是输出。 任何知道一两件关于MySQL的人都可以提出一些build议,告诉我如何运行它?

谢谢。

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqld --standalone --console 110723 9:09:54 [Note] Plugin 'FEDERATED' is disabled. 110723 9:09:54 InnoDB: The InnoDB memory heap is disabled 110723 9:09:54 InnoDB: Mutexes and rw_locks use Windows interlocked functions 110723 9:09:54 InnoDB: Compressed tables use zlib 1.2.3 110723 9:09:54 InnoDB: Initializing buffer pool, size = 107.0M 110723 9:09:54 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file D:\Work\MySQLDB\ibdata1 did not exist: InnoDB: a new database to be created! 110723 9:09:54 InnoDB: Setting file D:\Work\MySQLDB\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... InnoDB: Error: log file .\ib_logfile0 is of different size 0 359661568 bytes InnoDB: than specified in the .cnf file 0 56623104 bytes! 110723 9:09:54 [ERROR] Plugin 'InnoDB' init function returned error. 110723 9:09:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 110723 9:09:54 [ERROR] Unknown/unsupported storage engine: INNODB 110723 9:09:54 [ERROR] Aborting 110723 9:09:54 [Note] mysqld: Shutdown complete 

 InnoDB: The first specified data file D:\Work\MySQLDB\ibdata1 did not exist: InnoDB: a new database to be created! 110723 9:09:54 InnoDB: Setting file D:\Work\MySQLDB\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... InnoDB: Error: log file .\ib_logfile0 is of different size 0 359661568 bytes InnoDB: than specified in the .cnf file 0 56623104 bytes! 

这里看起来不合适的是关于ib_logfile0的大小不同的投诉。 这肯定会把InnoDB拿走。

在DOS命令行,运行这个:

 del D:\Work\MySQLDB\ib_logfile* 

重新启动mysqld和ib_logfile0和ib_logfile1应该被重build为正确的大小。

试一试 !!!