how to delete mysql database through shell command

Question

I use the pylons and sqlalchemy. I constantly update the schema files and delete the old db content (means db itself) and recreate the database so that new schema shall take place. Every time I do this by opening the MySql Query Browser and login & delete the database/schema.

How to delete the mysql db/schema thorough linux shell commands? I use ubuntu linux.

Answer 1

mysqladmin -u[username] -p[password] drop [database]

Answer 2

Another suitable way:

$ mysql -u you -p
<enter password>

>>> DROP DATABASE foo;

Answer 3

If you are tired of typing your password, create a (chmod 600) file ~/.my.cnf, and put in it:

[client]
user = "you"
password = "your-password"

For the sake of conversation:

echo 'DROP DATABASE foo;' | mysql

Answer 4

In general, you can pass any query to mysql from shell with -e option.

mysql -u username -ppassword -D dbname -e "DROP DATABASE" > outputfile.txt