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
解决问题。