Mysql UNIX域套接字

在linux系统中可以通过Unix域套接字连接本机的mysql实例。
需要在mysql配置文件中指定套接字文件路径，如socket=/tmp/mysql.sock。https://www.cndba.cn/hbhe0316/article/22197https://www.cndba.cn/hbhe0316/article/22197

1.通过mysql命令查找套接字文件：https://www.cndba.cn/hbhe0316/article/22197https://www.cndba.cn/hbhe0316/article/22197https://www.cndba.cn/hbhe0316/article/22197

https://www.cndba.cn/hbhe0316/article/22197

https://www.cndba.cn/hbhe0316/article/22197

https://www.cndba.cn/hbhe0316/article/22197

mysql> show variables like 'socket';
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| socket        | /tmp/mysql.sock |
+---------------+-----------------+
1 row in set (0.00 sec)

2.使用套接字进入MYSQL

https://www.cndba.cn/hbhe0316/article/22197

https://www.cndba.cn/hbhe0316/article/22197

[root@mysql8 ~]# mysql -uroot -pwwwwww -S /tmp/mysql.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or /g.
Your MySQL connection id is 9
Server version: 8.0.27 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.

mysql>

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL