[client]
#客户端编码方式,最好和服务端保存一致
loose-default-character-set = utf8
[mysqld]
#端口
port=3306
#mysql根目录
basedir ="D:\IDE\mysql-5.6.25-winx64"
#数据文件存放目录
datadir ="D:\IDE\mysql-5.6.25-winx64\data"
#sql mode
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
#服务端的编码方式
character-set-server=utf8
#优化Mysqld 占用内存过高
table_open_cache=256
#优化Mysqld 占用内存过高
table_definition_cache=400
max_connections=100
innodb_flush_log_at_trx_commit=0
#表名不区分大小写
lower_case_table_names=1
[WinMySQLadmin]
Server = "D:\IDE\mysql-5.6.25-winx64\bin\mysqld.exe"
#客户端编码方式,最好和服务端保存一致
loose-default-character-set = utf8
[mysqld]
#端口
port=3306
#mysql根目录
basedir ="D:\IDE\mysql-5.6.25-winx64"
#数据文件存放目录
datadir ="D:\IDE\mysql-5.6.25-winx64\data"
#sql mode
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
#服务端的编码方式
character-set-server=utf8
#优化Mysqld 占用内存过高
table_open_cache=256
#优化Mysqld 占用内存过高
table_definition_cache=400
max_connections=100
innodb_flush_log_at_trx_commit=0
#表名不区分大小写
lower_case_table_names=1
[WinMySQLadmin]
Server = "D:\IDE\mysql-5.6.25-winx64\bin\mysqld.exe"