# MAMP PRO for Mac mysql无法启动

**URL:** <https://www.shiqidu.com/t/topic/399>\
**Category:** 开发调优\
**Tags:** macOS\
**Created:** [2018 年4 月 6 日 09:30 UTC](https://www.shiqidu.com/t/topic/399 "2018-04-06T09:30:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

作者： ![Eureka](https://www.shiqidu.com/user_avatar/www.shiqidu.com/eureka/32/5_2.png) [@Eureka](https://www.shiqidu.com/u/Eureka)\
发布日期： [2018 年4 月 6 日 09:30 UTC](https://www.shiqidu.com/t/topic/399/1 "2018-04-06T09:30:33Z")

</div>

查看mysql\_error.log 如下：

```auto
2018-03-21 14:59:06 30264 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: ./mysql/slave_relay_log_info.ibd. Cannot open tablespace ecshop/ecs_device which uses space ID: 3 at filepath: ./ecshop/ecs_device.ibd
2018-04-06 14:41:17 53182 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: ./mysql/slave_relay_log_info.ibd. Cannot open tablespace ecshop/ecs_device which uses space ID: 3 at filepath: ./ecshop/ecs_device.ibd
2018-04-06 14:41:18 53743 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: ./mysql/slave_relay_log_info.ibd. Cannot open tablespace ecshop/ecs_device which uses space ID: 3 at filepath: ./ecshop/ecs_device.ibd
2018-04-06 14:54:52 54670 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: ./mysql/slave_relay_log_info.ibd. Cannot open tablespace ecshop/ecs_device which uses space ID: 3 at filepath: ./ecshop/ecs_device.ibd
2018-04-06 14:54:53 55190 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_relay_log_info uses space ID: 3 at filepath: ./mysql/slave_relay_log_info.ibd. Cannot open tablespace ecshop/ecs_device which uses space ID: 3 at filepath: ./ecshop/ecs_device.ibd
2018-04-06 14:54:53 55190 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_master_info uses space ID: 4 at filepath: ./mysql/slave_master_info.ibd. Cannot open tablespace ecshop/ecs_order_review which uses space ID: 4 at filepath: ./ecshop/ecs_order_review.ibd
2018-04-06 14:54:53 55190 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_worker_info uses space ID: 5 at filepath: ./mysql/slave_worker_info.ibd. Cannot open tablespace ecshop/ecs_push which uses space ID: 5 at filepath: ./ecshop/ecs_push.ibd
2018-04-06 14:54:53 55190 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at filepath: ./mysql/innodb_index_stats.ibd. Cannot open tablespace ecshop/ecs_cert which uses space ID: 2 at filepath: ./ecshop/ecs_cert.ibd
2018-04-06 14:54:53 55190 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_table_stats uses space ID: 1 at filepath: ./mysql/innodb_table_stats.ibd. Cannot open tablespace ecshop/ecs_config which uses space ID: 1 at filepath: ./ecshop/ecs_config.ibd

```

解决办法

![mamp_mysql.png](https://discourse.shiqidu.com/upload/discussion/20180406/6f34cf6e93393016c5824b6008e4d7a0_origin.png)

打开MAMP PRO，选择菜单栏File-\>Edit Template-\>MySQL(my.cnf)-\>5.6.38，这时打开了一个文本，找到`[mysqld]`在其下方添加一句:`innodb_force_recovery = 1`。

然后再尝试重启MySQL服务。