MySQL error forcing close of thread two ways to resolve

1, modify the MySQL configuration file

If the configuration file is My.ini, you can add the following two items to the My.ini:

Skip-locking

Skip-name-resolve

Note: In the new version of MySQL, skip-locking has been replaced with skip-external-locking, if you use skip-locking, you may report the following error:

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

Be careful to view the log. So the new version of MySQL should be written:

Skip-external-locking

Skip-name-resolve

2, in the MySQL service to set up

Start Menu-> Run-> services.msc, find the MySQL service and double-click, click on the Recovery tab.

First failure: Default is "Do not operate", change to "restart service".

The "Restart Service: () minutes" add "0" below to indicate that if the service terminates unexpectedly, it will restart immediately.

Click OK to make the settings effective.

But a problem arises: if you do this, you cannot end the MYSQL-NT process in Task Manager. All if you need to stop the process, first change back to the operation can be.