2015-12-08t04:29:25.523685z 0 [warning] insecure configuration for --secure-file
-priv: current value does not restrict location of generated files. consider set
ting it to a valid, non-empty path.
2015-12-08t04:29:25.524685z 0 [note] mysqld (mysqld 5.7.10) starting as process
8524 ...
2015-12-08t04:29:25.536686z 0 [note] innodb: mutexes and rw_locks use windows in
terlocked functions
2015-12-08t04:29:25.537686z 0 [note] innodb: uses event mutexes
2015-12-08t04:29:25.538686z 0 [note] innodb: _mm_lfence() and _mm_sfence() are u
sed for memory barrier
2015-12-08t04:29:25.539686z 0 [note] innodb: compressed tables use zlib 1.2.3
2015-12-08t04:29:25.540686z 0 [note] innodb: number of pools: 1
2015-12-08t04:29:25.541686z 0 [note] innodb: not using cpu crc32 instructions
2015-12-08t04:29:25.589689z 0 [note] innodb: initializing buffer pool, total siz
e = 80m, instances = 1, chunk size = 80m
2015-12-08t04:29:25.606690z 0 [note] innodb: completed initialization of buffer
pool
2015-12-08t04:29:25.640692z 0 [note] innodb: highest supported file format is ba
rracuda.
2015-12-08t04:29:25.692695z 0 [note] innodb: creating shared tablespace for temp
orary tables
2015-12-08t04:29:25.695695z 0 [note] innodb: setting file '.\ibtmp1' size to 12
mb. physically writing the file full; please wait ...
2015-12-08t04:29:25.728697z 0 [note] innodb: file '.\ibtmp1' size is now 12 mb.

下面是 my.ini

For advice on how to change settings please see

http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

*** DO NOT EDIT THIS FILE. It's a template which will be copied to the

*** default location during install, and will be replaced if you

*** upgrade to a newer version of MySQL.

[mysqld]

Remove leading # and set to the amount of RAM for the most important data

cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

innodb_buffer_pool_size = 128M

Remove leading # to turn on a very important data integrity option: logging

changes to the binary log between backups.

log_bin

These are commonly set, remove the # and set as required.

basedir ="E:\data\mysql-5.7.10-winx64"
datadir ="E:\data\mysql-5.7.10-winx64\data"
tmpdir ="E:\data\mysql-5.7.10-winx64\temp"
port = 3306

Uniform Server

Uniform Server是一个免费的轻量级WAMP服务器解决方案，适用于Windows。采用模块化设计方法构建，包括最新版本的Apache、MySQL或MariaDB、PHP（支持版本切换）、phpMyAdmin或Adminer。无需安装！无需注册表垃圾！只需解压并启动！-------注意：Uniform Server的最新版本需要**64位版本**的Windows。-------

7

查看详情

server_id = .....

Remove leading # to set options mainly useful for reporting servers.

The server defaults are faster for transactions and fast SELECTs.

Adjust sizes as needed, experiment to find the optimal values.

join_buffer_size = 128M

sort_buffer_size = 2M

read_rnd_buffer_size = 2M

socket="E:\data\mysql-5.7.10-winx64\mysql.sock"
#skip_innodb
innodb_data_file_path=idbdata1:200M:autoextend
innodb_buffer_pool_size=80M
#innodb_additional_mem_pool_size=2M
innodb_log_file_size=20M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
default_password_lifetime=0