How to delete mysql database through shell command

Question

I use pylons and sqlalchemy. I constantly update the schema files and delete and recreate the database so that a new schema can be created.

Each time I do this, opening the MySql query browser and logging in and deleting the database / schema.

How to remove MySQL db / schema linux shell commands in Ubuntu Linux?

Answer 1

Try the following command:

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

Answer 2

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

 mysql -u username -p -D dbname -e "DROP DATABASE dbname" 

Answer 3

If you are tired of entering a password, create a file (chmod 600) ~/.my.cnf and paste it:

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

To talk:

 echo 'DROP DATABASE foo;' | mysql 

Answer 4

Another suitable way:

 $ mysql -u you -p <enter password> >>> DROP DATABASE foo; 

Answer 5

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 will not pass the password this way, since it will be available to other users of the system via ps aux

Answer 6

MySQL stopped the command to drop the database from the mysql client shell. You must use mysqladmin to delete the database.

Answer 7

You can delete the database directly as:

$ mysqladmin -h [host] -u [user] -p drop [database_name]

[Enter password]

Are you sure you want to reset the hairless database [y / N]: y

Answer 8

 [root@host]# mysqladmin -u root -p drop [DB] Enter password:******