mysql 数据库-启动mysql服务报ERROR:1067错误

问题描述

启动mysql服务报ERROR:1067错误

这里是日志：
2014-09-01T06:12:49.816554Z 0 [Note] Plugin 'FEDERATED' is disabled.
2014-09-01T06:12:49.818554Z 0 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-09-01T06:12:49.820554Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-09-01T06:12:49.822554Z 0 [Note] InnoDB: Uses system mutexes
2014-09-01T06:12:49.824554Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-09-01T06:12:49.825555Z 0 [Warning] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2014-09-01T06:12:49.830555Z 0 [Note] InnoDB: Number of pools: 1
2014-09-01T06:12:49.832555Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-01T06:12:49.834555Z 0 [ERROR] InnoDB: Unable to create temporary file; errno: 2
2014-09-01T06:12:49.835555Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2014-09-01T06:12:49.837555Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-09-01T06:12:49.840555Z 0 [ERROR] Unknown/unsupported storage engine: innodb
2014-09-01T06:12:49.841555Z 0 [ERROR] Aborting

2014-09-01T06:12:49.842556Z 0 [Note] Binlog end
2014-09-01T06:12:50.010565Z 0 [Note] Shutting down plugin 'partition'
2014-09-01T06:12:50.015565Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-09-01T06:12:50.021566Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-09-01T06:12:50.027566Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-09-01T06:12:50.033566Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-09-01T06:12:50.039567Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-09-01T06:12:50.043567Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-09-01T06:12:50.045567Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-09-01T06:12:50.048567Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-09-01T06:12:50.050567Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-09-01T06:12:50.052568Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-09-01T06:12:50.054568Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-09-01T06:12:50.057568Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-09-01T06:12:50.059568Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-09-01T06:12:50.061568Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-09-01T06:12:50.064568Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-09-01T06:12:50.066568Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-09-01T06:12:50.068568Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2014-09-01T06:12:50.071569Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2014-09-01T06:12:50.073569Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-09-01T06:12:50.074569Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-09-01T06:12:50.076569Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-09-01T06:12:50.078569Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-09-01T06:12:50.079569Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-09-01T06:12:50.081569Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-09-01T06:12:50.083569Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-09-01T06:12:50.084569Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-09-01T06:12:50.086569Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2014-09-01T06:12:50.087570Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-09-01T06:12:50.089570Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-09-01T06:12:50.091570Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2014-09-01T06:12:50.092570Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2014-09-01T06:12:50.094570Z 0 [Note] Shutting down plugin 'ARCHIVE'
2014-09-01T06:12:50.096570Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2014-09-01T06:12:50.097570Z 0 [Note] Shutting down plugin 'MyISAM'
2014-09-01T06:12:50.099570Z 0 [Note] Shutting down plugin 'MEMORY'
2014-09-01T06:12:50.100570Z 0 [Note] Shutting down plugin 'CSV'
2014-09-01T06:12:50.101570Z 0 [Note] Shutting down plugin 'sha256_password'
2014-09-01T06:12:50.103570Z 0 [Note] Shutting down plugin 'mysql_old_password'
2014-09-01T06:12:50.105571Z 0 [Note] Shutting down plugin 'mysql_native_password'
2014-09-01T06:12:50.107571Z 0 [Note] Shutting down plugin 'binlog'
2014-09-01T06:12:50.108571Z 0 [Note] F:mysqlpathMySQLMySQL Server 5.7binmysqld: Shutdown complete

有谁知道的吗？谢谢。。。

时间： 2024-10-02 18:09:15

mysql 数据库-启动mysql服务报ERROR:1067错误的相关文章

mysql数据库报ERROR 104错误解决

今天在安装完毕mysql,连接mysql数据库时,提示:ERROR 1045(2800)错误,如下图: 查询相关资料,可以进行如下的处理: 停用mysql服务: /etc/rc.d/init.d/mysqld stop或者service mysqld stop 输入命令: mysqld_safe –skip-grant-tables & (加入&是为了让mysql数据库后台运行) 登入数据库:mysql -u root mysql mysql> use mysql; 输入如下SQL语

C++连接Mysql数据库，mysql_real_connect总是报错：访问内存冲突

问题描述 C++连接Mysql数据库,mysql_real_connect总是报错:访问内存冲突 C++连接本地Mysql数据库,配置按照网上来的:c/c++使用VS2013连接mysql数据库 访问数据库的代码也是按照网上来的: #include <winsock.h> #include <iostream> #include <string> #include <mysql.h> using namespace std; #pragma comment(

MySql 5.7.14 服务没有报告任何错误的解决方法(推荐)_Mysql

参照网上MySql 5.6的安装步骤,安装MySql服务后,使用net start mysql命令启动服务时,报错: MySQL 服务正在启动 .MySQL 服务无法启动. 服务没有报告任何错误. 请键入 NET HELPMSG 3534 以获得更多的帮助. 经过查找,找到了解决方法. 方法和步骤如下所示: 1.从官网下载MySQL http://dev.mysql.com/downloads/mysql/ ZIP Archive版本:mysql-5.7.14-winx64 2.解压到想安装到的

mybatis-使用MyBatis框架向MySQL数据库增加数据使用浏览器访问出现错误

问题描述 使用MyBatis框架向MySQL数据库增加数据使用浏览器访问出现错误 org.apache.ibatis.binding.BindingException: Parameter 'name' not found. Available parameters are [2, 1, 0, param1, param2, param3] at org.apache.ibatis.binding.MapperMethod$ParamMap.get(MapperMethod.java:165)

eclipse使用debug模式启动web服务报错

问题描述 eclipse使用debug模式启动web服务报错,使用run方式就正常.报错异常如下:SEVERE: Catalina.start: org.apache.catalina.LifecycleException: Failed to start component [StandardServer[8005]]at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:152)at org.apache.cata

excel-用ADO将Excel导入sql server 2008 报error# 3092错误

问题描述 用ADO将Excel导入sql server 2008 报error# 3092错误 我用ADO将一张excel表导入到sql server中去,代码如下: hr=m_pConnection->Open(_bstr_t("Provider=SQLOLEDB;server=TOUCH;Database=MR_NXT;Uid=touch0413;Pwd=LJm_1989915"),"","",adModeUnknown); m_pCo

windows无法启动MySQL服务报错1067的解决方法

突然登陆MySQL时,出现禁止访问或者无法连接到数据库,回到服务,去打开wampmysqld ,发现 "windows无法启动MySQL服务 错误1067" ,死活启动不了,咋办?虾苗我来给大家分享下经验! 方法一: 1.打开my.ini文件,找到default-storage-engine=InnoDB这一行,把它改成default-storage-engine=MyISAM. 2.删除在MySQL安装目录下的Data目录中的ib_logfile0和ib_logfile1 3.找到在

【技术贴】解决Mysql启动服务报错1067 进程意外终止

   无法启动MYSQL服务错误1067 进程意外终止.   我使用2013-10-25_appserv-win32-2.6.0.exe安装的MySql,结果服务起不来.   于是细心机智的我发现,在F:\study\mysql\AppServ\MySQL\my.ini里面,有个bug哦~~     [mysqld] # The TCP/IP Port the MySQL Server will listen on port=3306 #Path to installation director

MySQL数据库启动失败1067进程意外终止的解决办法总结

问题现象: 前天对MYSQL数据库进行迁移操作,B机(新机子)的MYSQL和A机的版本不同,为方便B机安装好MYSQL直接COPY了A机的DATA目录 启动MYSQL,"MYSQL 1067 进程意外终止"错误,以前遇到过此错误,惯性地去按上次的方法尝试解决,结果问题依旧,于是google,搜索了许久...无果 最后查看系统应用程序日志:找到最近的MYSQL报错,都是E文: Error message file 'D:＼system＼MySQL＼MySQL Server 5.0＼sha