mysql，mysqladmin，mysqld之间的区别 [英] Difference between mysql, mysqladmin, mysqld

问题描述

有人可以给我清楚地解释mysql(命令行工具)，mysqladmin(用于执行管理任务的客户端工具)和mysqld(mysql服务器)之间的区别.

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).

推荐答案

通过阅读有关以下三个命令的手册页，您可以轻松地发现自己的问题:

You could easily find that out yourself by just reading the man pages about the three commands:

• mysqld是 server 可执行文件(其中之一)
• mysql是命令行 client
• mysqladmin是维护或管理实用程序

• mysqld is the server executable (one of them)
• mysql is the command line client
• mysqladmin is a maintainance or administrative utility

它们有不同的用途.它们之间不仅仅存在差异".对于不同的任务，您具有不同的实用程序.就像您用螺丝起子拧螺丝，用锤子拧钉子一样.

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.

如果要查询数据库服务器，则需要使用 client 连接到该服务器.客户端连接到服务mysql服务的服务器.如果您需要在服务器中进行管理调整，则需要一个管理实用程序.

If you want to query a database server you need to connect to it using a client. The client connects to the server which serves the mysql service. If you need to do administrative adjustments in the server you need an administration utility.

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

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.

这篇关于mysql，mysqladmin，mysqld之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！