Mac 下MAMP Pro MySQL无法启动报 Error: could not open single-table tablespace file ./mysql/innodb_table_sta
来源:互联网 发布:图片识别手写数字算法 编辑:程序博客网 时间:2024/05/17 01:39
解决办法:
一、打开MAMP PRO,选择菜单栏File->Edit Template->MySQL->5.6.35(选择你的版本)),这时打开了一个文本,找到
[mysqld]
注意带上中括号,在这行下面加一行
innodb_force_recovery = 1 (可换1-6 进行尝试)
二、启动mySQL,成功后再关闭;
三、重新打开那个文本,删除添加的 innodb_force_recovery = 1 行;
四、再打开mySQL,完毕。
原文地址:http://blog.csdn.net/svendson/article/details/76423270
阅读全文
0 0
- Mac 下MAMP Pro MySQL无法启动报 Error: could not open single-table tablespace file ./mysql/innodb_table_sta
- 无法启动Mysql服务 could not open single-table tablespace file
- Mac下MAMP Pro 启动数据库MySQL出错导致无法启动的问题
- mac版的mysql 报错ERROR! MySQL server PID file could not be found!
- mysql无法启动ERROR! MySQL is running but PID file could not be found ?
- mysql无法启动ERROR! MySQL is running but PID file could not be found
- mysql无法启动ERROR! MySQL is running but PID file could not be found ?
- mysql无法启动ERROR! MySQL is running but PID file could not be found ?
- mysql无法启动ERROR! MySQL is running but PID file could not be found ?
- mysql无法启动ERROR! MySQL is running but PID file could not be found ?
- Mysql5.6启动报错, [ERROR] InnoDB: Could not find a valid tablespace file for 'pa
- Nginx启动报错: could not open error log file: open()
- mac+mamp mysql无法连接
- mamp pro中mysql报错解决
- mamp pro无法打开mysql解决办法
- MAMP PRO的mySQL启动失败
- mac os mysql启动报错 Can't open the mysql.plugin table
- linux安装mysql 报 ERROR! MySQL manager or server PID file could not be found!
- Java知识:HashSet详解
- css居中,进度条
- css的各种居中
- 数据结构之双向链表
- STM32F429HAL库ADCDMA学习笔记
- Mac 下MAMP Pro MySQL无法启动报 Error: could not open single-table tablespace file ./mysql/innodb_table_sta
- 详解内部类
- 关于eclipse中部署到service中时显示部署名称不正确的解决办法
- Java 集合框架(转载)
- Photoshop-iPhone x适配
- 微信门店小程序接口文档
- C++面试必知必会(3)-程序改错
- 空格导致数据库查不到数据
- Image Processing——图像处理教程(一)