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即可
转载请注明:六特网 » mysql 1067错误