mysql免安装版 1067_mysql免安装版window报1067错误解决

mysql的data路径尽量不要设置到其他地方，最好设置在mysql路径下的data目录，不然1067错误是不会消失的！

mysql配置文件内容如下：

[client]

port = 3306

default-character-set=utf8

[mysql]

default-character-set=utf8

[mysqld]

port = 3306

character-set-server = utf8

default-storage-engine = INNODB

key_buffer = 16K

max_allowed_packet = 1M

sort_buffer_size = 64K

read_buffer_size = 256K

read_rnd_buffer_size = 256K

net_buffer_length = 2K

thread_stack = 64K

basedir=D:\Green\mysql-5.6.22-winx64

datadir=D:\Green\mysql-5.6.22-winx64\data

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

cmd命令行，mysql服务的安装命令(切记以管理员身份打开命令行窗口)：

D:\Green\mysql-5.6.22-winx64\bin>mysqld -install

mysql服务的启动/关闭命令：

D:\Green\mysql-5.6.22-winx64\bin>net start mysql

D:\Green\mysql-5.6.22-winx64\bin>net stop mysql

mysql服务的删除：

D:\Green\mysql-5.6.22-winx64\bin>sc delete mysql

0

顶

0

踩

分享到：

2015-01-27 14:43

浏览 1400

分类:数据库

评论