mysql服务启动 错误1067问题解决

1:mysql服务启动 错误提示1067 错误代码

“InnoDB: Attempted to open a previously opened tablespace. Previoustablespace bugfree/bf_user_group uses space ID: 

2 at filepath:.\bugfree\bf_user_group.ibd. Cannot open tablespace mysql/innodb_index_statswhich uses space ID:

 2 at filepath: .\mysql\innodb_index_stats.ibd”

 解决：在mysql安装目录下bin文件夹下mysql.ini文件打开

       在添加“innodb_log_file_size = 5M

innodb_log_buffer_size= 8M

innodb_flush_log_at_trx_commit= 1

innodb_lock_wait_timeout= 50“

下添加innodb_force_recovery=1

解决问题。