Shulou(Shulou.com)06/01 Report--

Next, let's learn about the difference between mysql-server and mysql-client. I believe you will benefit a lot after reading it. The text is not much in essence. I hope you want to know the difference between mysql-server and mysql-client.

Ask a question, how to use mysql container in docker to start two service instances: mysql-server, and their data exchange, and then start a mysql-client?

Detailed explanation:

First of all, there is a link to explain the difference between mysql-client and server:

Https://stackoverflow.com/questions/6962890/what-is-the-difference-between-mysql-server-and-mysql-client

Then let's talk about the content and conclusion of the discussion:

The point that I was puzzled before is that it is said that client should be logged in (host-u-p), but when I use server, I also have to log in (- u-p), so of course I have an idea, that is, the difference between client and server is whether or not to connect host, and server without host is server, but this view is not quite right.

The essential difference is that server performs a crud operation and client sends a crud operation.

Server translates sql statements into operations on memory and files, that is, server manipulates files directly.

Client operates on the database / table, not directly on the file.

For example:

① client: I use a Navicat to link to a database, and this Navicat is client.

② server: I have multiple mysql service instances, which can be on different ports (this is not important), but they are mounted in the same directory of the host (this is important, memory / files are manipulated), and data sharing (this is not important).

Small knowledge points:

① sql is just going to know how server manipulates the data.

②, even if they are on the same machine, they communicate through the network.

After reading this article about the difference between mysql-server and mysql-client, many readers will want to know more about it. If you need more industry information, you can follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.