View source for DROP ALL databases in MySQL

From DevOps Notebook

← DROP ALL databases in MySQL

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: Users.

You can view and copy the source of this page.

<pre>
SET SESSION group_concat_max_len = 1000000;

SELECT GROUP_CONCAT(
  DISTINCT CONCAT('DROP DATABASE ', table_schema, ';')
  SEPARATOR ''
)
FROM information_schema.tables
WHERE table_schema NOT IN ('mysql', 'information_schema');
</pre>

Return to DROP ALL databases in MySQL.

Retrieved from "https://devopsnotebook.com/DROP_ALL_databases_in_MySQL"