mysql 1067错误 | 六特网
最新消息:网站于2015.9.9日正式改名六特网,网站将继续为大家分享知识与共同进步,网站开启投稿页面,欢迎大家投稿.    

mysql 1067错误

学习笔记 六特网 62浏览 0评论

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错误

 
 

第 1 页,共 1 页1