How to delete mysql database through shell command

Question

I use the pylons and sqlalchemy  I constantly update the schema files and delete and recreate the database so that new schema can be made    Every time I do this by opening the MySql Query Browser and login and delete the database schema   How do I delete the MySQL db schema thorough linux shell commands in Ubuntu Linux

User · Answer

MySQL has discontinued drop database command from mysql client shell  Need to use mysqladmin to drop a database

User · Answer

You can remove database directly as     mysqladmin -h  host  -u  user  -p drop  database name    Enter Password   Do you really want to drop the  hairfree  database  y N   y

User · Answer

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

User · Answer

In general  you can pass any query to mysql from shell with -e option   mysql -u username -p -D dbname -e  DROP DATABASE dbname

User · Answer

Try the following command   mysqladmin -h hostname localhost  -u username  -p password  drop  database

User · Answer

root host   mysqladmin -u root -p drop  DB   Enter password

User · Answer

Another suitable way     mysql -u you -p  lt enter password gt    gt  gt  gt  DROP DATABASE foo

User · Answer

No need for mysqladmin   just use mysql command line  mysql -u  username  -p password  -e  drop database db-name     This will send the drop command although I wouldn t pass the password this way as it ll be exposed to other users of the system via ps aux

[mysql] How to delete mysql database through shell command

Examples related to mysql

Examples related to database

Examples related to linux

Examples related to shell

Examples related to ubuntu