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