Temporarily modify the fields of the database table , I met this problem , To put it bluntly, it’s the watch lock , As a result, it cannot be modified successfully .
SSH Remote to server , Log in to MySQL
mysql -uroot -plalalalThen use the following command to see what you are doing:
show processlist;Find a lot of sleep under the same connection
kill id;Kill a few days later , It’s finally normal .
Similar Posts:
- ERROR 2006 (HY000): MySQL server has gone away No
- MySQL Lock Error: Lock wait timeout exceeded [How to Solve]
- MySQL Error: Waiting for table metadata lock [How to Solve]
- MySql Host is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’ [How to Solve]
- [Solved] MySql Host is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts…
- MySql Host is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts…
- MySQL Reading table information for completion of table and column names
- E: Unable to get lock / var / lib / apt / lists / lock – Open (11 resources temporarily unavailable)
- MySQL Error: the solution of command not found
- Mysqldump backup problems got error: 1045, error 1045 (28000), got error: 1449