mysql、mysqladmin、mysqld的区别
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/22132780/
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
Difference between mysql, mysqladmin, mysqld
提问by Preom
Can someone give me a clear explanation of the differences between mysql
(command line tool), mysqladmin
(client tool for performing administrative tasks) and mysqld
(mysql server).
有人可以清楚地解释一下mysql
(命令行工具)、mysqladmin
(用于执行管理任务的客户端工具)和mysqld
(mysql 服务器)之间的区别。
回答by arkascha
You could easily find that out yourself by just reading the man pages about the three commands:
只需阅读有关三个命令的手册页,您就可以轻松找到自己的答案:
mysqld
is the serverexecutable (one of them)mysql
is the command line clientmysqladmin
is a maintainanceor administrative utility
mysqld
是服务器可执行文件(其中之一)mysql
是命令行客户端mysqladmin
是维护或管理实用程序
They serve different purposes. There is not simply a "difference" between them. For different task you have different utilities. Just like you use a screwdriver for a screw and a hammer for a nail.
它们用于不同的目的。它们之间不只是简单的“区别”。对于不同的任务,您有不同的实用程序。就像你用螺丝刀拧螺丝,用锤子拧钉子一样。
If you want to query a database server you need to connect to it using a client. The client connects to the serverwhich serves the mysql service. If you need to do administrative adjustments in the server you need an administration utility.
如果要查询数据库服务器,则需要使用客户端连接到它。客户端连接到为 mysql 服务提供服务的服务器。如果您需要在服务器中进行管理调整,您需要一个管理实用程序。
Typically the server is started and stopped by the operating system it runs on, so at bootup and shutdown times. The clients (there are different types of clients) are started and used by users or programs handling with data inside the server. And the administrative staff uses the administrative tool to administer the servers on their systems.
通常,服务器由运行它的操作系统启动和停止,因此在启动和关闭时也是如此。客户端(有不同类型的客户端)由处理服务器内部数据的用户或程序启动和使用。管理人员使用管理工具来管理他们系统上的服务器。