MySQL database size

How do I find out how large my MySQL database is?¶

To find out how much space the current database is using, start a MySQL console on the database in question, then run this:

SELECT table_schema "Database Name"
     , SUM(data_length + index_length) / (1024 * 1024) "Database Size in MB"
FROM information_schema.TABLES
GROUP BY table_schema;

How to delete a database I don't need any more?¶

Start a MySQL console and run the following command:

drop database `<your_username>$<your_database_name>`;

replacing placeholders in brackets respectively with your username and the database name that should be deleted. See "Using MySQL" help page or more details.