How to delete mysql database through shell command
MysqlDatabaseLinuxShellUbuntuMysql Problem Overview
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?
Mysql Solutions
Solution 1 - Mysql
Try the following command:
mysqladmin -h[hostname/localhost] -u[username] -p[password] drop [database]
Solution 2 - Mysql
In general, you can pass any query to mysql from shell with -e option.
mysql -u username -p -D dbname -e "DROP DATABASE dbname"
Solution 3 - Mysql
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
Solution 4 - Mysql
Another suitable way:
$ mysql -u you -p
<enter password>
>>> DROP DATABASE foo;
Solution 5 - Mysql
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
Solution 6 - Mysql
MySQL has discontinued drop database command from mysql client shell. Need to use mysqladmin to drop a database.
Solution 7 - Mysql
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
Solution 8 - Mysql
[root@host]# mysqladmin -u root -p drop [DB]
Enter password:******