EasyPHP-DevServer 13.1 “Unexpected end of mysql”

2020-06-17 05:20发布

Every time I install EasyPHP 13.1VC9 it works for a few days and then at random points when I go to turn it on I get this error and I am unable to start MySQL. I have tried running as Admin, and I have tried editing the permissions. Also, when I go to access MYSQL through PHPadmin I get the following error:

#2002 - No connection could be made because the target machine actively refused it.

This is what the log files say:

2013-06-12 23:47:18 4148 [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 userauth/userinfo which uses space ID: 2 at filepath: .\userauth\userinfo.ibd

InnoDB: Error: could not open single-table tablespace file .\userauth\userinfo.ibd

InnoDB: We do not continue the crash recovery, because the table may become

InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.

InnoDB: To fix the problem and start mysqld:

InnoDB: 1) If there is a permission problem in the file and mysqld cannot

InnoDB: open the file, you should modify the permissions.

InnoDB: 2) If the table is not needed, or you can restore it from a backup,

InnoDB: then you can remove the .ibd file, and InnoDB will do a normal

InnoDB: crash recovery and ignore that table.

标签: easyphp
7条回答
小情绪 Triste *
2楼-- · 2020-06-17 05:58

From Official EasyPHP FAQ:

*3. [5.3.3, Vista/Seven] Unexpected end of MySql... See log file?

You need to change the user s permission for the EasyPHP directory

1. Go to 'Computer', open/view Drive C, then double click 'Program Files (x86)'.
2. Right click on 'EasyPHP5.3.0' folder then click 'Properties'.
3. On 'Security' tab click 'Edit' button.
4. Select the user that you are currently using.
5. Under 'Permissions for Users' box, tick 'Full control' on 'Allow' column.
6. And then click 'OK' button to apply the changes.*

http://www.easyphp.org/faq.php#2

查看更多
登录 后发表回答