Linux MySQL 服务器和 MySQL 客户端有什么区别
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6962890/
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
What is the difference between MySQL Server and MySQL Client
提问by Luis Alvarado
In Ubuntu I normally install both but what are the differences between the client and server for MySQL.
在 Ubuntu 中，我通常会同时安装两者，但 MySQL 的客户端和服务器之间有什么区别。
As a bonus, when a new statement mentions that it needs MySQL 5.x does it mean the client, the server or both. For example this link https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.htmlmentions that it need 5.7.x for it to support json_extract, does this mean the client, server or both need to be 5.7.x
作为奖励，当一个新语句提到它需要 MySQL 5.x 时，它是否意味着客户端、服务器或两者。例如这个链接https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html提到它需要 5.7.x 才能支持 json_extract，这是否意味着客户端、服务器或两者都需要是 5.7.x
采纳答案by Baversjo
The mysql server package will install the mysql database server which you can interact with using a mysql client. You can use the mysql client to send commands to any mysql server; on a remote computer or your own.
mysql 服务器包将安装 mysql 数据库服务器，您可以使用 mysql 客户端与之交互。您可以使用 mysql 客户端向任何 mysql 服务器发送命令；在远程计算机或您自己的计算机上。
The mysql server is used to persist the data and provide a query interface for it (SQL). The mysql clients purpose is to allow you to use that query interface.
mysql 服务器用于持久化数据并为其提供查询接口（SQL）。mysql 客户端的目的是允许您使用该查询接口。
The client package also comes with utilities that allows you to easily backup/restore data and administer the server.
客户端软件包还附带实用程序，可让您轻松备份/恢复数据和管理服务器。
回答by Sunny S.M
MySql Client :
MySql 客户端：
The mysql-client package allows you to connect to a MySQL server. It will give you the "mysql" command-line program.
mysql-client 包允许您连接到 MySQL 服务器。它将为您提供“mysql”命令行程序。
MySql Server :
数据库服务器：
The mysql-server package allows to run a MySQL server which can host multiple databases and process queries on those databases.
mysql-server 包允许运行 MySQL 服务器，该服务器可以托管多个数据库并处理对这些数据库的查询。
MySQL :
MySQL：
The "MySQL" package probably includes both of the above.
“MySQL”包可能包括上述两个。
If you just need to connect to a remote server and run queries, install just mysql-client. If you need to host a database, install the client and server.
如果您只需要连接到远程服务器并运行查询，只需安装 mysql-client。如果需要托管数据库，请安装客户端和服务器。
回答by ashok_khuman
MYSQL operates in a networked environment using a client/server architecture. A central program acts as a server and a various client programs connect to the server to make request.
MYSQL 在使用客户端/服务器架构的网络环境中运行。中央程序充当服务器，各种客户端程序连接到服务器以发出请求。
MYSQL Server, or mysqldis the database server program.It manages access to the actual databases on disk or in the memory.
MYSQL Server 或mysqld是数据库服务器程序。它管理对磁盘或内存中实际数据库的访问。
MYSQL Client are programs for communicating with the server to manipulate the information in the databases that the server manages. Example : mysqlis the command line program that acts as a text-based front end for the server.
MYSQL 客户端是用于与服务器通信以操作服务器管理的数据库中的信息的程序。示例：mysql是作为服务器基于文本的前端的命令行程序。
