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 = 
   
   16
   
   K
  
  
  
  

   
   max_allowed_packet = 
   
   1
   
   M
  
  
  
  

   
   sort_buffer_size = 
   
   64
   
   K
  
  
  
  

   
   read_buffer_size = 
   
   256
   
   K
  
  
  
  

   
   read_rnd_buffer_size = 
   
   256
   
   K
  
  
  
  

   
   net_buffer_length = 
   
   2
   
   K
  
  
  
  

   
   thread_stack = 
   
   64
   
   K
  
  
  
  

   
   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

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