mysql服务启动不了，下面是mysql日志

答案:2 悬赏:80 手机版

解决时间 2021-03-02 09:44

提问者网友：夢醒日落
2021-03-01 15:14

120502 10:10:38 [Note] Plugin 'FEDERATED' is disabled.
120502 10:10:38 InnoDB: The InnoDB memory heap is disabled
120502 10:10:38 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120502 10:10:38 InnoDB: Compressed tables use zlib 1.2.3
120502 10:10:38 InnoDB: Initializing buffer pool, size = 128.0M
120502 10:10:38 InnoDB: Completed initialization of buffer pool
120502 10:10:38 InnoDB: highest supported file format is Barracuda.
120502 10:10:39 InnoDB: Waiting for the background threads to start
120502 10:10:40 InnoDB: 1.1.8 started; log sequence number 2733591
120502 10:10:40 [ERROR] wampmysqld: unknown variable 'default-character-set=utf8'
120502 10:10:40 [ERROR] Aborting

120502 10:10:40 InnoDB: Starting shutdown...
120502 10:10:40 InnoDB: Shutdown completed; log sequence number 2733591
120502 10:10:40 [Note] wampmysqld: Shutdown complete

最佳答案

五星知识达人网友：woshuo
2021-03-01 16:04

'default-character-set=utf8'
这个参数有问题，你这个mysql应该是5.5的高版本，打开my.ini(my.cnf)在[client]和[mysqld]下找到这段参数，然后改成 character-set-server=utf8，重启

全部回答

1楼网友：人類模型
2021-03-01 16:50

1、注意存储引擎错误 unknown/unsupported storage engine: innodb 2、检查一下配置文件中关于innodb的参数，如果有skip-innodb注释掉 3、如果重新设置了innodb_log_file_size之类的，需要删除几个ib_logfile，然后重启数据库

我要举报

如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！