64位win7,用的是mysql-5.6.28-winx64免安装版,按网上的资料生成了my.ini放在c:/windows下注册服务成功。但是使用net start mysql命令启动服务时报1067错误。以下是错误日志:请帮大家帮本人看下是什么原因,谢谢。
2016-01-02 22:46:19 856 [Note] Plugin “FEDERATED” is disabled.
2016-01-02 22:46:19 1544 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB”s internal memory allocator.
2016-01-02 22:46:19 856 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-02 22:46:19 856 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-02 22:46:19 856 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-02 22:46:19 856 [Note] InnoDB: Memory barrier is not used
2016-01-02 22:46:19 856 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-02 22:46:19 856 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-02 22:46:19 1544 InnoDB: Error: unable to create temporary file; errno: 2
2016-01-02 22:46:19 856 [ERROR] Plugin “InnoDB” init function returned error.
2016-01-02 22:46:19 856 [ERROR] Plugin “InnoDB” registration as a STORAGE ENGINE failed.
2016-01-02 22:46:19 856 [ERROR] Unknown/unsupported storage engine: INNODB
2016-01-02 22:46:19 856 [ERROR] Aborting
2016-01-02 22:46:19 856 [Note] Binlog end
2016-01-02 22:46:19 856 [Note] Shutting down plugin “partition”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “PERFORMANCE_SCHEMA”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_DATAFILES”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_TABLESPACES”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_FOREIGN_COLS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_FOREIGN”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_FIELDS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_COLUMNS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_INDEXES”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_TABLESTATS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_TABLES”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_FT_INDEX_TABLE”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_FT_INDEX_CACHE”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_FT_CONFIG”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_FT_BEING_DELETED”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_FT_DELETED”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_FT_DEFAULT_STOPWORD”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_METRICS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_BUFFER_POOL_STATS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_BUFFER_PAGE_LRU”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_BUFFER_PAGE”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_CMP_PER_INDEX_RESET”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_CMP_PER_INDEX”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_CMPMEM_RESET”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_CMPMEM”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_CMP_RESET”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_CMP”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_LOCK_WAITS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_LOCKS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_TRX”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “BLACKHOLE”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “ARCHIVE”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “MRG_MYISAM”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “MyISAM”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “MEMORY”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “CSV”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “sha256_password”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “mysql_old_password”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “mysql_native_password”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “binlog”
2016-01-02 22:46:19 856 [Note] D:\Program Files\mysql-5.6.28-winx64\bin\mysqld: Shutdown complete
这是本人的my.ini内容
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
default-character-set=utf-8
[mysqld]
port = 3306
basedir=D:\Program Files\mysql-5.6.28-winx64
datadir=D:\Program Files\mysql-5.6.28-winx64/data
default-storage-engine=INNODB
socket = /tmp/mysql.sock
sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
#character-set-server=utf-8
max_connections=100
#table_cache=256
tmp_table_size=34M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=68M
key_buffer_size=54M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=3M
innodb_flush_log_at_trx_commit =1
innodb_log_buffer_size=2M
innodb_buffer_pool_size=105M
innodb_log_file_size=53M
innodb_thread_concurrency=9
2016-01-02 22:46:19 856 [Note] Plugin “FEDERATED” is disabled.
2016-01-02 22:46:19 1544 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB”s internal memory allocator.
2016-01-02 22:46:19 856 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-02 22:46:19 856 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-02 22:46:19 856 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-02 22:46:19 856 [Note] InnoDB: Memory barrier is not used
2016-01-02 22:46:19 856 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-02 22:46:19 856 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-02 22:46:19 1544 InnoDB: Error: unable to create temporary file; errno: 2
2016-01-02 22:46:19 856 [ERROR] Plugin “InnoDB” init function returned error.
2016-01-02 22:46:19 856 [ERROR] Plugin “InnoDB” registration as a STORAGE ENGINE failed.
2016-01-02 22:46:19 856 [ERROR] Unknown/unsupported storage engine: INNODB
2016-01-02 22:46:19 856 [ERROR] Aborting
2016-01-02 22:46:19 856 [Note] Binlog end
2016-01-02 22:46:19 856 [Note] Shutting down plugin “partition”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “PERFORMANCE_SCHEMA”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_DATAFILES”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_TABLESPACES”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_FOREIGN_COLS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_FOREIGN”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_FIELDS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_COLUMNS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_INDEXES”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_TABLESTATS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_SYS_TABLES”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_FT_INDEX_TABLE”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_FT_INDEX_CACHE”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_FT_CONFIG”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_FT_BEING_DELETED”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_FT_DELETED”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_FT_DEFAULT_STOPWORD”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_METRICS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_BUFFER_POOL_STATS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_BUFFER_PAGE_LRU”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_BUFFER_PAGE”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_CMP_PER_INDEX_RESET”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_CMP_PER_INDEX”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_CMPMEM_RESET”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_CMPMEM”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_CMP_RESET”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_CMP”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_LOCK_WAITS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_LOCKS”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “INNODB_TRX”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “BLACKHOLE”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “ARCHIVE”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “MRG_MYISAM”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “MyISAM”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “MEMORY”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “CSV”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “sha256_password”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “mysql_old_password”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “mysql_native_password”
2016-01-02 22:46:19 856 [Note] Shutting down plugin “binlog”
2016-01-02 22:46:19 856 [Note] D:\Program Files\mysql-5.6.28-winx64\bin\mysqld: Shutdown complete
这是本人的my.ini内容
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
default-character-set=utf-8
[mysqld]
port = 3306
basedir=D:\Program Files\mysql-5.6.28-winx64
datadir=D:\Program Files\mysql-5.6.28-winx64/data
default-storage-engine=INNODB
socket = /tmp/mysql.sock
sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
#character-set-server=utf-8
max_connections=100
#table_cache=256
tmp_table_size=34M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=68M
key_buffer_size=54M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=3M
innodb_flush_log_at_trx_commit =1
innodb_log_buffer_size=2M
innodb_buffer_pool_size=105M
innodb_log_file_size=53M
innodb_thread_concurrency=9
解决方案
5
2016-01-02 22:46:19 856 [ERROR] Plugin “InnoDB” init function returned error.
2016-01-02 22:46:19 856 [ERROR] Plugin “InnoDB” registration as a STORAGE ENGINE failed.
2016-01-02 22:46:19 856 [ERROR] Unknown/unsupported storage engine: INNODB
这句有问题:default-storage-engine=INNODB
去掉试下,mysql5.6的默认引擎就是innodb
2016-01-02 22:46:19 856 [ERROR] Plugin “InnoDB” registration as a STORAGE ENGINE failed.
2016-01-02 22:46:19 856 [ERROR] Unknown/unsupported storage engine: INNODB
这句有问题:default-storage-engine=INNODB
去掉试下,mysql5.6的默认引擎就是innodb
10
2016-01-02 22:46:19 1544 InnoDB: Error: unable to create temporary file; errno: 2
检查一下磁盘空间及文件夹访问权限。
检查一下磁盘空间及文件夹访问权限。
15
InnoDB: Error: unable to create temporary file; errno: 2
这个报错了。
在my.ini中增加一行
tmpdir=”D:/Program Files/MySQL/MySQL Server 5.1/DataFiles/Data/”
(目录可以随意)
这个报错了。
在my.ini中增加一行
tmpdir=”D:/Program Files/MySQL/MySQL Server 5.1/DataFiles/Data/”
(目录可以随意)
5
tmpdir=”临时目录”
增加一个可以访问的路径在配置文件中
增加一个可以访问的路径在配置文件中
5
权限问题 不能创建临时文件
2016-01-02 22:46:19 1544 InnoDB: Error: unable to create temporary file; errno: 2
2016-01-02 22:46:19 1544 InnoDB: Error: unable to create temporary file; errno: 2