How to drop database with # in name in MySQL

By default any folders inside the mysql data directories will be read as database and will be shown in "show databases".

You can escape database names using backtick quotes to drop it:

DROP DATABASE `#mysql50#lost+found`;

Comments