Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the difference between MySQL Server and MySQL Client

In Ubuntu I normally install both but what are the differences between the client and server for 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.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

like image 264
Luis Alvarado Avatar asked Aug 05 '11 21:08

Luis Alvarado


People also ask

Is MySQL server side or client side?

As a rule of thumb, PHP and MySQL are always server-side—they only run in a server environment.

What is the server in MySQL?

The MySQL server provides a database management system with querying and connectivity capabilities, as well as the ability to have excellent data structure and integration with many different platforms. It can handle large databases reliably and quickly in high-demanding production environments.

What's the difference between MySQL and SQL Server?

SQL is a query language, whereas MySQL is a relational database that uses SQL to query a database. You can use SQL to access, update, and manipulate the data stored in a database. However, MySQL is a database that stores the existing data in a database in an organized manner.

Is MySQL database a server?

The MySQL Database Software is a client/server system that consists of a multithreaded SQL server that supports different back ends, several different client programs and libraries, administrative tools, and a wide range of application programming interfaces (APIs).


2 Answers

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.

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.

like image 159
Baversjo Avatar answered Oct 18 '22 23:10

Baversjo


MySql Client :

The mysql-client package allows you to connect to a MySQL server. It will give you the "mysql" command-line program.

MySql Server :

The mysql-server package allows to run a MySQL server which can host multiple databases and process queries on those databases.

MySQL :

The "MySQL" package probably includes both of the above.

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.

like image 39
Sunny S.M Avatar answered Oct 18 '22 23:10

Sunny S.M