我在 Windows 上安装了 MySQL 服务器，尽管在配置中选择不将 MySQL 作为服务器运行，并禁用了 TCP/IP 访问，因此只能使用命名管道，但现在我无法运行服务器。下面是在尝试以独立模式启动后的输出。任何对 MySQL 有所了解的人能否就如何运行它提出一些建议？
谢谢。
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
答案1
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 应该以适当的大小重建。
试一试 ！！！