Home >Database >Mysql Tutorial >mysql服务启动报1607error_MySQL

mysql服务启动报1607error_MySQL

WBOY
WBOYOriginal
2016-06-01 13:04:221291browse

【问题说明】

mysql以前还是好好的,突然就不行了...不知道是否使用了腾讯C盘搬家工具引起的...

\

*.err文件中日志如下:

 

2014-11-10 15:09:20 2070  InnoDB: Error: unable to create temporary file; errno: 2
2014-11-10 15:09:20 696 [ERROR] Plugin 'InnoDB' init function returned error.
2014-11-10 15:09:20 696 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-11-10 15:09:20 696 [ERROR] Unknown/unsupported storage engine: INNODB
2014-11-10 15:09:20 696 [ERROR] Aborting

【暴力实验过程】

一开始以为default-storage-engine=INNODB,默认INNODB是不对的,改成MyISAM,不对

然后改回INNODB,然后调整各种innodb参数,innodb_buffer_pool_size等,不对

然后又按照网上的说法,设置basedir...删除logfile...,不对

后来卸载重装mysql,问题依旧

【解决方案】

 Error: unable to create temporary file; errno: 2

看来是某临时文件创建失败了...于是在[mysqld]节点下添加tempdir,如下

[mysqld]

# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking
# enable-named-pipe
# The Pipe the MySQL Server will use
# socket=mysql

#指定的临时文件目录
tmpdir="D:\mysqldata\"
#skip-grant-tables
开始依旧不对...额...D:\mysqldata\这个目录不存在,需要手动创建之...就这样问题解决了

    
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn