mysql删除所有数据库命令

DROP DATABASE IF EXISTS database_name;

USE information_schema;

SELECT SCHEMA_NAME FROM SCHEMATA;

SET @db_name = (SELECT SCHEMA_NAME FROM SCHEMATA LIMIT 1);
WHILE @db_name IS NOT NULL DO
    SET @drop_query = CONCAT('DROP DATABASE ', @db_name);
    PREPARE stmt FROM @drop_query;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
    SET @db_name = (SELECT SCHEMA_NAME FROM SCHEMATA LIMIT 1 OFFSET 1);
END WHILE;

-- 登录到MySQL服务器
mysql -u root -p

-- 切换到information_schema数据库
USE information_schema;

-- 查询所有数据库的名称
SELECT SCHEMA_NAME FROM SCHEMATA;

-- 使用循环逐个删除数据库
SET @db_name = (SELECT SCHEMA_NAME FROM SCHEMATA LIMIT 1);
WHILE @db_name IS NOT NULL DO
    SET @drop_query = CONCAT('DROP DATABASE ', @db_name);
    PREPARE stmt FROM @drop_query;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
    SET @db_name = (SELECT SCHEMA_NAME FROM SCHEMATA LIMIT 1 OFFSET 1);
END WHILE;