mysql无法删除用户

-- 授予删除用户的权限
GRANT DROP USER ON *.* TO 'your_user'@'localhost';

-- 检查用户是否存在
SELECT User FROM mysql.user WHERE User = 'user_to_delete';

-- 删除用户
DROP USER IF EXISTS 'user_to_delete'@'localhost';

-- 查找并杀死该用户的所有活动连接
SELECT CONCAT('KILL ', id, ';') AS command
FROM information_schema.processlist
WHERE user = 'user_to_delete';

-- 执行生成的命令
-- 注意：执行前请仔细检查生成的命令

-- 删除用户拥有的触发器
SELECT CONCAT('DROP TRIGGER ', TRIGGER_NAME, ';') AS command
FROM information_schema.TRIGGERS
WHERE DEFINER = CONCAT('\'', 'user_to_delete', '\'@\'localhost\'' );

-- 删除用户拥有的存储过程
SELECT CONCAT('DROP PROCEDURE ', ROUTINE_NAME, ';') AS command
FROM information_schema.ROUTINES
WHERE DEFINER = CONCAT('\'', 'user_to_delete', '\'@\'localhost\'' );

-- 执行生成的命令
-- 注意：执行前请仔细检查生成的命令