mysql 无法drop表

SHOW OPEN TABLES WHERE In_use > 0;

SHOW GRANTS FOR 'username'@'host';

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'host';
FLUSH PRIVILEGES;

SELECT * FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name';

ALTER TABLE table_name DROP FOREIGN KEY constraint_name;
DROP TABLE table_name;

SHOW TRIGGERS WHERE EVENT_OBJECT_SCHEMA = 'database_name' AND EVENT_OBJECT_TABLE = 'table_name';
SHOW PROCEDURE STATUS WHERE Db = 'database_name' AND Name LIKE '%table_name%';

DROP TRIGGER trigger_name;
DROP PROCEDURE procedure_name;
DROP TABLE table_name;

-- 检查表是否被锁定
SHOW OPEN TABLES WHERE In_use > 0;

-- 检查权限
SHOW GRANTS FOR 'username'@'host';

-- 检查外键约束
SELECT * FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'users';

-- 删除外键约束
ALTER TABLE users DROP FOREIGN KEY constraint_name;

-- 检查触发器和存储过程
SHOW TRIGGERS WHERE EVENT_OBJECT_SCHEMA = 'database_name' AND EVENT_OBJECT_TABLE = 'users';
SHOW PROCEDURE STATUS WHERE Db = 'database_name' AND Name LIKE '%users%';

-- 删除触发器和存储过程
DROP TRIGGER trigger_name;
DROP PROCEDURE procedure_name;

-- 删除表
DROP TABLE users;