Mysql 实例连接

1. socket 连接

   MySQL 模式为 C/S 模式 。

   如果 cliet 连接到服务器主机与服务器同一主机的服务器, cliet 通过套接字连接到服务器 。

   为了了解它们是如何联系在一起的,请使用以下命令:

[liyajuan@localhost ~]$ mysql -uroot -p
(root@localhost)[mysql]> status;
--------------
mysql  Ver 14.14 Distrib 5.7.34, for Linux (x86_64) using  EditLine wrapper

Connection id:          34
Current database:       mysql
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.7.34 MySQL Community Server (GPL)
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 1 day 2 hours 9 min 2 sec

2. TCP/IP 连接

   当阴蒂和服务器不在同一个主机上时,通过 TCP/IP 连接。

   (1) 联系应确定如下:

mysql -h192.168.159.140 -udavid -p

终端连接方式

见TCP/IP连接

(david@192.168.159.140)[(none)]> status;
--------------
mysql  Ver 14.14 Distrib 5.7.34, for Linux (x86_64) using  EditLine wrapper

Connection id:          36
Current database:
Current user:           david@192.168.159.140
SSL:                    Cipher in use is ECDHE-RSA-AES128-GCM-SHA256
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.7.34 MySQL Community Server (GPL)
Protocol version:       10
Connection:             192.168.159.140 via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 1 day 2 hours 32 min 6 sec

(2) mysql workbench

(3) navicat

本文由 在线网速测试 整理编辑，转载请注明出处，原文链接：https://www.wangsu123.cn/news/11702.html。