手动启动mysql服务出错，1067错误，如何解决呢?

Question

这是我的my.ini

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[client]
port=3306


[mysqld]
port=3306
lower_case_table_names=1
socket        = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
explicit_defaults_for_timestamp=true
basedir="D:\software\wnmp-MH\mysql"
datadir="D:\software\wnmp-MH\mysql\data" 




[mysqldump]
quick
max_allowed_packet = 16M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

Answer 1

谢谢邀请。你看看错误日志里面有什么信息，根据日志信息找原因

Answer 2

尝试进入MySql的安装目录找到my.ini里有一句：default-storage-engine=INNODB改成MYISAM。