Phenomenon: the table cannot be opened and deleted
Solution:
>show full processlist; // List the processes, find the processes that are waiting, to kill them
......
......
>kill ID; // The ID number is the first column of "Id" listed
Read More:
- How to Solve MYSQL ERROR: relation “table_name” does not exist
- ORA-29913 ORA-06512 external table query prompt: error
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- MySQL 8.0 error 1114 (HY000): the table’sbtest1’is full (Fixed)
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- ERROR 1075 (42000) Incorrect table definition; there can be only one auto column and it must be defi
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- Docker mysql8 modify password
- [Solved] Error Code: 2013. Lost connection to MySQL server during query
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- How to Fix MySQL error 1005: can’t create table (errno: 150)
- MySQL | ERROR : Every derived table must have its own alias [Solved]
- MySQL Build table error: You have an error in your SQL syntax； check the manual that corresponds to your MySQL ser
- [Solved] MySQL Error: Can‘t find record in ‘order_form‘
- [Solved] flicksql cdc mysql to kafka Connect Error: org.apache.flink.table.api.ValidationException…
- [SQL ERROR] SQL Error: could not execute statement & query did not return a unique result: 2； nested excepti
- [Mybatis] How to Solve the problem of Oracle query processing more than 1000 in conditions
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- MySQL Error: [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file