mysqladmin mysql_mysql，mysqladmin，mysqld之间的区别

最新推荐文章于 2023-04-21 11:07:17 发布

护城河河长

最新推荐文章于 2023-04-21 11:07:17 发布

阅读量311

点赞数

文章标签： mysqladmin mysql

本文链接：https://blog.csdn.net/weixin_36089077/article/details/113171477

版权

本文详细解释了MySQL生态系统中三个核心工具的作用：mysql（命令行客户端），用于执行SQL查询；mysqladmin（管理工具），进行服务器维护任务；mysqld（服务器进程），提供数据库服务。通过类比螺丝刀与锤子的关系，形象地说明了这三者针对不同任务所扮演的角色。

摘要由CSDN通过智能技术生成

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

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.