Two solutions for MySQL error Forcing close of thread

Two solutions for MySQL error Forcing close of thread

1. Modify the mysql configuration file

If the configuration file is my. ini, you can add the following two content in my. ini:

Skip-locking

Skip-name-resolve

Note: In the new mysql version, skip-locking has been replaced by skip-external-locking. If you use skip-locking, the following error may be reported:

[Warning] '-- skip-locking' is deprecated and will be removed in a future release. Please use '-- skip-external-locking 'instead.

Check the logs. Therefore, the new mysql version should be written as follows:

Skip-external-locking

Skip-name-resolve

2. Set in mysql Service

Choose "start"> "run"> "services. msc". Find the mysql service and double-click the "Restore" tab.

First failure: the default value is "no operation", which is changed to "Restart service ".

In the following "restart the service: () minutes later," 0 "indicates that the service will be restarted immediately if it is accidentally terminated.

Click OK to make the settings take effect.

However, there is a problem: if you do this, you cannot end the mysql-nt process in the task manager. If you need to stop the process, change it back before you can perform the operation.