https://devopsnotebook.com/index.php?action=history&feed=atom&title=DROP_ALL_databases_in_MySQLDROP ALL databases in MySQL - Revision history2026-04-23T17:29:20ZRevision history for this page on the wikiMediaWiki 1.33.1https://devopsnotebook.com/index.php?title=DROP_ALL_databases_in_MySQL&diff=406&oldid=prevMilosZ: Created page with "<pre> SET SESSION group_concat_max_len = 1000000; SELECT GROUP_CONCAT( DISTINCT CONCAT('DROP DATABASE ', table_schema, ';') SEPARATOR '' ) FROM information_schema.tables..."2023-06-02T10:28:32Z<p>Created page with "<pre> SET SESSION group_concat_max_len = 1000000; SELECT GROUP_CONCAT( DISTINCT CONCAT('DROP DATABASE ', table_schema, ';') SEPARATOR '' ) FROM information_schema.tables..."</p>
<p><b>New page</b></p><div><pre><br />
SET SESSION group_concat_max_len = 1000000;<br />
<br />
SELECT GROUP_CONCAT(<br />
DISTINCT CONCAT('DROP DATABASE ', table_schema, ';')<br />
SEPARATOR ''<br />
)<br />
FROM information_schema.tables<br />
WHERE table_schema NOT IN ('mysql', 'information_schema');<br />
</pre></div>MilosZ