mysql客户端与服务器的区别_MySQL运维---客户端与服务器模型

一、MySQL客户端与服务器模型

1、mysql是一个典型的C/S服务结构

1.1 mysql自带的客户端程序(/application/mysql/bin)

mysql

mysqladmin

mysqldump

1.2 mysqld一个二进制程序，后台的守护进程

二、应用程序连接MySQL方式

1、TCP/IP连接方式

2、套接字的连接方式

三、查看连接状态

1、查看命令

[root@computer ~]# mysql -uroot -p123456

Warning: Using a password on the command lineinterfacecan be insecure.

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection idis 2Server version:5.6.40Source distribution

Copyright (c)2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracleis a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective