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

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

Difference between mysql, mysqladmin, mysqld

mysqlmysqladmin

提问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:

只需阅读有关三个命令的手册页,您就可以轻松找到自己的答案:

  • mysqldis the serverexecutable (one of them)
  • mysqlis the command line client
  • mysqladminis 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.

通常,服务器由运行它的操作系统启动和停止,因此在启动和关闭时也是如此。客户端(有不同类型的客户端)由处理服务器内部数据的用户或程序启动和使用。管理人员使用管理工具来管理他们系统上的服务器。