mysql报错,错误代码为1067,出现这个mysql错误的原因一般是修改了data目录,本文以免安装版window版的mysql,教大家如何解决mysql 1067错误的问题。
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
ba
sedir=D:Greenmysql-5.6.22-winx64
datadir=D:Greenmysql-5.6.22-winx64data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
cmd命令行,mysql服务的安装命令(切记以管理员身份打开命令行窗口):
D:Greenmysql-5.6.22-winx64bin>mysqld -install
mysql服务的启动/关闭命令:
D:Greenmysql-5.6.22-winx64bin>net start mysql
D:Greenmysql-5.6.22-winx64bin>net stop mysql
mysql服务的删除:
D:Greenmysql-5.6.22-winx64bin>sc delete mysql