"mysql.sock" is the socket file of mysql. When the mysql host and client are on the same host, unix socket is used as the carrier of the communication protocol. There are two ways to connect to MySQL locally under UNIX series systems: TCP connection and UNIX domain socket. The UNIX domain socket method requires a socket file, and you can use the "show variables like 'socket'\G;" command. Check the local socket file location.
The operating environment of this tutorial: linux7.3 system, mysql8 version, Dell G3 computer.
"mysql.sock" is the socket file of mysql.
When connecting to MySQL locally under a UNIX system, you can use the UNIX domain socket method. This method requires a socket file.
The socket file can be controlled by the parameter socket. Use the following command to view the location of the file:
show variables like 'socket'\G;
mysql.sock is when the mysql host and client are on the same host, using unix domain socket as the communication protocol carrier, it is faster than tcp.
MySQL has two main connection methods:
(1) TCP/IP
(2) socket
The most commonly used connection is TCP connection:
[root@mysql8 data]# mysql -h 192.168.103.67 -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 Server version: 8.0.15 MySQL Community Server - GPL Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. 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>
Another way is this unix socket connection. It is faster than using tcp, but it is only applicable to mysql and the application on the same PC, relying on the local .sock file. If they are not on the same PC, there is no way to connect.
For mysql.sock, its function is that the program and MySQL Server are on the same machine and can be used when initiating a local connection.
For example, you do not need to define the specific IP to connect to the host, as long as it is empty or localhost.
In this case, even if you change the external port of MySQLl, it is still possible to connect normally.
Because after you change the port in my.ini or my.cnf, mysql.sock is generated every time MySQL Server starts. It has been regenerated once when you restarted mysql after changing my.cnf, and the information has been changed accordingly.
So for external connections, the port must be changed to connect.
When installing MySQL connection under Linux, I often get a prompt saying that the mysql.sock file cannot be found. The solution is very simple:
If it is a newly installed MySQL and it prompts that the file cannot be found, just Under Search, specify the correct location.
If the mysql.sock file is accidentally deleted, you need to restart the MySQL service. If the restart is successful, mysql.sock will be generated in the datadir directory and you can specify it at that time.
If that still doesn’t work, just choose to use TCP connection. In fact, pipe connection is also supported under Windows.
[Related recommendations: mysql video tutorial]
The above is the detailed content of what is mysql.sock. For more information, please follow other related articles on the PHP Chinese website!

本篇文章给大家带来了关于mysql的相关知识,其中主要介绍了关于架构原理的相关内容,MySQL Server架构自顶向下大致可以分网络连接层、服务层、存储引擎层和系统文件层,下面一起来看一下,希望对大家有帮助。

mysql的msi与zip版本的区别:1、zip包含的安装程序是一种主动安装,而msi包含的是被installer所用的安装文件以提交请求的方式安装;2、zip是一种数据压缩和文档存储的文件格式,msi是微软格式的安装包。

方法:1、利用right函数,语法为“update 表名 set 指定字段 = right(指定字段, length(指定字段)-1)...”;2、利用substring函数,语法为“select substring(指定字段,2)..”。

在mysql中,可以利用char()和REPLACE()函数来替换换行符;REPLACE()函数可以用新字符串替换列中的换行符,而换行符可使用“char(13)”来表示,语法为“replace(字段名,char(13),'新字符串') ”。

转换方法:1、利用cast函数,语法“select * from 表名 order by cast(字段名 as SIGNED)”;2、利用“select * from 表名 order by CONVERT(字段名,SIGNED)”语句。

本篇文章给大家带来了关于mysql的相关知识,其中主要介绍了关于MySQL复制技术的相关问题,包括了异步复制、半同步复制等等内容,下面一起来看一下,希望对大家有帮助。

在mysql中,可以利用REGEXP运算符判断数据是否是数字类型,语法为“String REGEXP '[^0-9.]'”;该运算符是正则表达式的缩写,若数据字符中含有数字时,返回的结果是true,反之返回的结果是false。

本篇文章给大家带来了关于mysql的相关知识,其中主要介绍了mysql高级篇的一些问题,包括了索引是什么、索引底层实现等等问题,下面一起来看一下,希望对大家有帮助。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SublimeText3 English version
Recommended: Win version, supports code prompts!

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

Zend Studio 13.0.1
Powerful PHP integrated development environment

Atom editor mac version download
The most popular open source editor

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
