MySQL Server和MySQL Client有什么区别 [英] What is the difference between MySQL Server and MySQL Client

问题描述

在Ubuntu中，我通常会同时安装两者，但是MySQL的客户端和服务器之间有什么区别.

In Ubuntu I normally install both but what are the differences between the client and server for MySQL.

作为奖励，当一个新的声明提到它需要MySQL 5.x时，这表示客户机，服务器或两者.例如，此链接 https://dev.mysql.com /doc/refman/5.7/en/json-search-functions.html 提到它需要5.7.x才能支持json_extract，这是否意味着客户端，服务器或两者都必须为5.7.x

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.html mentions 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服务器软件包将安装mysql数据库服务器，您可以使用mysql客户端与之交互.您可以使用mysql客户端将命令发送到任何mysql服务器.在远程计算机上还是在您自己的计算机上.

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服务器用于保存数据并为其提供查询接口(SQL). 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.

客户端软件包还附带了实用程序，可让您轻松备份/还原数据并管理服务器.

The client package also comes with utilities that allows you to easily backup/restore data and administer the server.

这篇关于MySQL Server和MySQL Client有什么区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！