Linux 如何通过shell命令删除mysql数据库

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/2050581/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-03 19:40:47  来源:igfitidea点击:

How to delete mysql database through shell command

mysqldatabaselinuxshellubuntu

提问by

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.

我使用 pylons 和 sqlalchemy。我不断更新架构文件并删除并重新创建数据库,以便可以创建新架构。

Every time I do this by opening the MySql Query Browser and login and delete the database/schema.

每次我通过打开 MySql 查询浏览器并登录和删除数据库/模式来执行此操作。

How do I delete the MySQL db/schema thorough linux shell commands in Ubuntu Linux?

如何在 Ubuntu Linux 中删除 MySQL db/schema 彻底的 linux shell 命令?

采纳答案by Alex Reisner

Try the following command:

尝试以下命令:

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

回答by gahooa

Another suitable way:

另一种合适的方式:

$ mysql -u you -p
<enter password>

>>> DROP DATABASE foo;

回答by gahooa

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

如果您厌倦了输入密码,请创建一个 (chmod 600) 文件~/.my.cnf,然后放入:

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

For the sake of conversation:

为了对话:

echo 'DROP DATABASE foo;' | mysql

回答by Yada

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

通常,您可以mysql使用 -e 选项将任何查询传递给来自 shell。

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

回答by engineerDave

No need for mysqladmin:

不需要 mysqladmin:

just use mysql command line

只需使用 mysql 命令行

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

这将发送 drop 命令,尽管我不会以这种方式传递密码,因为它会通过ps aux暴露给系统的其他用户

回答by iyad

[root@host]# mysqladmin -u root -p drop [DB]

Enter password:******

回答by Ilija

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

MySQL 已停止从 mysql 客户端 shell 执行 drop database 命令。需要使用 mysqladmin 删除数据库。

回答by Bhautik Nada

You can remove database directly as:

您可以直接删除数据库:

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

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

[Enter Password]

[输入密码]

Do you really want to drop the 'hairfree' database [y/N]: y

你真的想删除'hairfree'数据库吗[y/N]: y