What is the way to delete MySQL database through a shell command?

Question

I am using pylons and sqlalchemy. I update the schema files and delete and recreate the database on a daily basis so that I can make a new schema.

I do it everytime by opening the MySql Query Browser and login and delete the database/schema.

Please tell me how can I delete MySQL db/schema thorough linux shell commands in Ubuntu Linux?

Answer 1

The following command has worked for me well. 

mysqladmin -h[hostname/localhost] -u[username] -p[password] drop [database]

If you want to get more insights into SQL, checkout this SQL Course from Intellipaat.