问题描述

windows 以 zip 安装 mysql 5.7.9 innodb 一直无法启用

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:datamysql-5.7.10-winx64"
datadir ="E:datamysql-5.7.10-winx64data"
tmpdir ="E:datamysql-5.7.10-winx64 emp"
port = 3306

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:datamysql-5.7.10-winx64mysql.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

解决方案

mysql windows 下zip安装
Mysql zip 安装（windows）
windows 64位 mysql-5.6.11-winx64.zip安装

解决方案二：

Log中没有看到什么错误信息，你具体问题要提供更详细的信息