当前位置: > 数据库 > MySQL >

mysql报错错误代码1067解决方法(免安装版window版)

时间:2015-02-22 14:47来源:linux.it.net.cn 作者:IT

mysql免安装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 


(责任编辑:IT)
------分隔线----------------------------
栏目列表
推荐内容