mysql 指定socket

# 检查socket文件是否存在
ls -l /path/to/socket/file

# 如果不存在，检查MySQL配置文件（通常是my.cnf或my.ini）
# 确保socket路径配置正确
[mysqld]
socket=/path/to/socket/file

# 重启MySQL服务
sudo systemctl restart mysql

# 更改socket文件的权限
sudo chown mysql:mysql /path/to/socket/file
sudo chmod 660 /path/to/socket/file

# 确保MySQL服务以正确的用户运行
sudo systemctl status mysql

# 打开MySQL配置文件（通常是my.cnf或my.ini）
sudo nano /etc/mysql/my.cnf

# 检查并修正socket路径配置
[mysqld]
socket=/path/to/socket/file

# 重启MySQL服务
sudo systemctl restart mysql

import mysql.connector

config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': 'localhost',
    'database': 'your_database',
    'unix_socket': '/path/to/socket/file'
}

try:
    cnx = mysql.connector.connect(**config)
    cursor = cnx.cursor()
    query = ("SELECT * FROM your_table")
    cursor.execute(query)
    for row in cursor:
        print(row)
except mysql.connector.Error as err:
    print(f"Something went wrong: {err}")
finally:
    cursor.close()
    cnx.close()