mysql my.ini

# CLIENT SECTION

#-----------------------------------------------------

[client]

#端口号

port = 3306

default-character-set = utf8 

 

 

#SERVER SECTION

#-----------------------------------------------------

[mysqld]

port = 3306

 

basedir=E:\\resource\\work\\project\\mysql-5.6.16-win32

 

datadir=E:\\resource\\work\\project\\mysql-5.6.16-win32\\data

 

#Server=D:\\mysql\\mysql5.6.16win32\\mysql-5.6.16-win32\\bin\\mysqld.exe

#default-character-set=utf8

 

character_set_server=utf8

 

default-storage-engine = INNODB

 

max_connections = 100

max_allowed_packet = 16M 

 

innodb_buffer_pool_size = 128M

 

skip-grant-tables

 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES