How to delete mysql database through shell command

mysql database linux shell ubuntu
user90150 picture user90150 · Jan 12, 2010 · Viewed 166.3k times · Source

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?

Answer

Alex Reisner picture Alex Reisner · Jan 12, 2010

Try the following command:

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

Related questions

How to find the mysql data directory from command line in windows

In linux I could find the mysql installation directory with the command which mysql. But I could not find any in windows. I tried echo %path% and it resulted many paths along with path to mysql bin. I wanted to …

Read More
Rename MySQL database

I created a database with the name of hrms. Now I need to change database name to sunhrm. But, It is disabled in MySQL workbench. Can I do that on the Linux server itself?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More