mysql 1067错误

MySQL数据库的启动过程中，出现了错误：数据库启动失败，1067进程意外终止。

 

1.解决办法：修改mysql的配置文件my.ini。

2.查看错误：

my.ini配置文件的部分代码： 

 

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306

#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.5/"

#Path to the database root
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"

# The default character set that will be used when a new schema or table is
# created and no character set is defined
character-set-server=utf8

# The default storage engine that will be used when create new tables when
default-storage-engine=MYISAM

 

datadir的路径改成下面的路径，路径对应basedir

C:/Program Files/MySQL/MySQL Server 5.5/Data/

 

default-storage-engine后面改成MYISAM
改好后然后重新启动mysql即可