mysql删除库命令

DROP DATABASE [IF EXISTS] database_name;

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

DROP DATABASE IF EXISTS database_name;

-- 删除单个数据库
DROP DATABASE IF EXISTS mydatabase;

-- 通过脚本删除多个数据库（示例）
DELIMITER $$
CREATE PROCEDURE DropDatabases()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE dbname VARCHAR(255);
    DECLARE cur CURSOR FOR SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME LIKE 'test%';
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO dbname;
        IF done THEN
            LEAVE read_loop;
        END IF;
        SET @sql = CONCAT('DROP DATABASE ', dbname);
        PREPARE stmt FROM @sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
    END LOOP;

    CLOSE cur;
END$$
DELIMITER ;

CALL DropDatabases();