日期:2014-05-16  浏览次数:20683 次

Mysql服务启动1067错误
64位win7,用的是mysql-5.5.28-winx64免安装版,按网上的资料生成了my.ini放在c:/windows下注册服务成功。但是使用net start mysql命令启动服务时报1067错误。以下是错误日志:请帮大家帮我看下是什么原因,谢谢。
121020 9:44:01 [Note] Plugin 'FEDERATED' is disabled.
121020 9:44:01 InnoDB: The InnoDB memory heap is disabled
121020 9:44:01 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121020 9:44:01 InnoDB: Compressed tables use zlib 1.2.3
121020 9:44:01 InnoDB: Initializing buffer pool, size = 128.0M
121020 9:44:01 InnoDB: Completed initialization of buffer pool
121020 9:44:01 InnoDB: highest supported file format is Barracuda.
121020 9:44:01 InnoDB: Waiting for the background threads to start
121020 9:44:02 InnoDB: 1.1.8 started; log sequence number 1595675
121020 9:44:02 [ERROR] E:\Program Files\mysql\bin\mysqld: unknown variable 'default-character-set=utf8'
121020 9:44:02 [ERROR] Aborting

121020 9:44:02 InnoDB: Starting shutdown...
121020 9:44:03 InnoDB: Shutdown completed; log sequence number 1595675
121020 9:44:03 [Note] E:\Program Files\mysql\bin\mysqld: Shutdown complete

------解决方案--------------------
引用121020 9:44:02 [ERROR] E:\Program Files\mysql\bin\mysqld: unknown variable 'default-character-set=utf8'