mysql1067 aborting,Mysql 1067 错误解决方案汇总 | 吴小强的博客

很久没有安装过xampp了,今天从官方网站下载一个最新的回来.启动apache非常成功,当启动mysql的时候提示 1067 错误.以前在winxp下都很正常的,难道在vista下还不一样?

当然首先到google搜索了一翻,发现很多答案.

1,mysql的目录必须有everyone的执行权限.

2,windows目录下的mysql.ini没有被删除,启动时用了这一个配置文件.

3,#设置basedir指向mysql的安装路径

basedir=d:\xampp\mysql

datadir=d:\xampp\mysql\data

4,my.ini(my.cnf)有问题,需要在指定的路径上面加上盘符.

我就是用第四种方法成功的,以下是我更改后的my.cnf文件其中的一段.

# The following options will be passed to all MySQL clients

[client]

# password = your_password

port = 3306

socket = "d:/xampp/mysql/mysql.sock"

# Here follows entries for some specific programs

# The MySQL server

[mysqld]

port= 3306

socket= "d:/xampp/mysql/mysql.sock"

basedir="d:/xampp/mysql"

tmpdir="d:/xampp/tmp"

datadir="d:/xampp/mysql/data"

skip-locking

key_buffer = 16M

max_allowed_packet = 1M

table_cache = 64

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 8M

# The following options will be passed to all MySQL clients

[client]

# password = your_password

port = 3306

socket = "d:/xampp/mysql/mysql.sock"

# Here follows entries for some specific programs

# The MySQL server

[mysqld]

port= 3306

socket= "d:/xampp/mysql/mysql.sock"

basedir="d:/xampp/mysql"

tmpdir="d:/xampp/tmp"

datadir="d:/xampp/mysql/data"

skip-locking

key_buffer = 16M

max_allowed_packet = 1M

table_cache = 64

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 8M