[MY-010273] [Server] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.问题解决

最新推荐文章于 2025-10-20 15:20:10 发布
原创 最新推荐文章于 2025-10-20 15:20:10 发布 · 7.6k 阅读 · 2 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

博文背景

本人在Ubuntu20.04系统下使用apt安装MySQL8后直接使用mysqld命令启动会发现无法启动成功，查看日志遇到[MY-010273] [Server] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.的报错。

日志分析
2020-09-25T01:23:33.191419Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 1712
2020-09-25T01:23:33.206763Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-09-25T01:23:33.476816Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-09-25T01:23:33.593919Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2020-09-25T01:23:33.594205Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2020-09-25T01:23:33.698046Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self s
最低0.47元/天 解锁文章
mysql 启动报错 ‘/var/run/mysqld/mysqld.sock‘
CXY00000的博客
10-27 1194
Docker 拉去Ubuntu镜像，启动ubuntu容器后 在里边安装mysql。
Docker更改默认存储路径后mysql容器启动不起来报mysqld:Can‘t create/write to file ‘/tmp/ib8cWqRv‘ (Errcode :13 - Permis)
MO_JM的博客
07-24 6955
1.docker 默认存储路径为根目录，存储空间爆了，导致各个docker服务都启动不起来，所以要做docker更改默认存储路径，使用的是宝塔的linux面板环境。 2.根据度娘资料进行存储路径迁移。 a.容器存储路径都位于/var/lib/docker中 b.停止docker systemctl stop docker c.创建要迁移的目录路径 ，本人迁移到了/www/lib/docker目录下的。使用命令复制文件到目标文件夹里面：...
Conmi的正确答案——PVE下使用“docker compose”创建MySQL数据库报错“can‘t create UNIX Socket: Permission denied (13)”
最新发布
Conmi的博客
10-20 121
Docker版本：28.5.1。MySQL版本：8.0.30。PVE系统版本：9.0.3。
[ERROR] Could not create unix socket lock file /var/run/mysql/mysql.sock.lock
雅冰石的专栏
04-03 4万+
在日志文件 /var/log/mysql/error.log 中可以看到具体的ERROR 信息：Could not create unix socket lock file /var/run/mysql/mysql.sock.lock。这种错误一般都是目录不存在或者权限不足，所以我们直接使用命令 mkdir -p /var/log/mysql/ 创建该目录即可，然后可以设置目录权限 cho
Could not create unix socket lock file /usr/local/mysql/mysql.sock.lock
lppl010_的专栏
12-03 1万+
在日志文件/usr/local/mysql/error.log中可以看到具体的ERROR信息：Could not create unix socket lock file /usr/local/mysql/mysql.sock.lock。 这种错误一般都是目录不存在或者权限不足，所以我们直接使用命令mkdir -p /usr/local/mysql/创建该目录即可，然后可以设置目录权限...
mysql lock file,docker mysql Could not write unix socket lock file /var/run/mysqld/mysqld.sock.lock
weixin_39772352的博客
03-17 1314
昨天在用docker部署mysql的时候一直报错2020-06-23T09:59:47.339758Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.2020-06-23T09:59:47.340593Z 0 [Warning] CA certi...
mysql不生成socket_不能创建 mysql.sock.lock是怎么回事
weixin_39849070的博客
02-07 1049
150520 03:26:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data2015-05-20T03:26:58.070269Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --ex...
docker启动mysql报错[error]plugin mysqlx reported:'setup of socket:' 'var/run/mysqld/mysqlx.sock' failed , can't open lock file /var/run/mysqld/mysqlx.sock.lock [error]could not open unix socket lock file /var/run/mysqld/mysqld.sock.lock [error]unable to setup unix socket lock file.
07-19
- `Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock` 这通常与文件系统权限、目录挂载配置或容器内部的运行环境有关。 ### 错误原因分析 1. **权限问题** MySQL 容器需要以具有足够...
日志报错：Could not create unix socket lock file /disk/app/mysql/mysql.sock.lock
04-17
用户提到的错误是“could not create unix socket lock file /disk/app/mysql/mysql.sock.lock”，我需要先理解这个错误的原因，然后找出可能的解决方案。 首先，我应该回忆一下MySQL在启动时的流程。当MySQL启动时...
./mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data 2025-09-22T03:48:39.619026Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release. 2025-09-22T03:48:39.619174Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.27) starting as process 4126362 2025-09-22T03:48:39.634126Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-09-22T03:48:39.813730Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-09-22T03:48:40.081531Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main 2025-09-22T03:48:40.081562Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main 2025-09-22T03:48:40.082497Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-09-22T03:48:40.082541Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-09-22T03:48:40.082976Z 0 [ERROR] [MY-010273] [Server] Could not create unix socket lock file /usr/local/mysql/mysql.sock.lock. 2025-09-22T03:48:40.083002Z 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file. 2025-09-22T03:48:40.083258Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-09-22T03:48:41.582631Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.27) MySQL Community Server - GPL.
09-23
1. 'Could not create unix socket lock file /usr/local/mysql/mysql.sock.lock' 2. 'Unable to setup unix socket lock file' 根据错误信息，问题在于无法创建Unix socket锁文件。这通常是由于权限问题导致的。...
mysql执行启动命令，启动成功，但进程立刻被杀死了：Starting MySQL..... SUCCESS! [root@ecs-39256 mysql]# 2025-04-15T08:38:12.902718Z mysqld_safe mysqld process hanging, pid 19321 - killed /disk/app/mysql/bin/mysqld_safe: line 199: 19321 Killed env MYSQLD_PARENT_PID=18923 nohup /disk/app/mysql/bin/mysqld --basedir=/disk/app/mysql --datadir=/disk/app/mysql/data --plugin-dir=/disk/app/mysql/lib/plugin --user=mysql --log-error=/disk/app/mysql/mysql.log --pid-file=/disk/app/mysql/mysqld.pid --socket=/disk/app/mysql/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1
04-16
- `Could not create unix socket lock file`：权限或文件冲突。 - `Out of memory`：内存不足导致进程被系统终止。 2. **检查系统日志** ```bash dmesg | grep -i mysql # 查看内核日志中是否有OOM Killer记录...
mysql 无法创建socket,无法通过socket/var/run/mysqld/mysqld.sock连接到本地MySQL服务器
weixin_39633171的博客
03-17 520
I have run into this error with a MySQL database installed on lucid lynx 10.04 that was working fine. The last activity carried out before this problem manifested was exporting a database back up usi...
Mysql 提示/var/run/mysqld/mysqld.sock的问题
sslcbhyso的博客
09-27 6037
Mysql 提示 Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ 解决方法：在/etc/my.cnf文件中添加以下就可以了，socket = 路径为自己的路径，但必须有相关权限 [client] socket = /home/kiv-mysql/programs/mysql-8.0.20/mysqld.sock ...
MySql安装过程中的错误及解决方法记录
qq_14945475的博客
08-09 2206
1. 错误： [root@localhost data]# /etc/init.d/mysqld start Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid). 错误日志显示Could not create unix socket lock file /var/lib/mysql/mysql .sock.lock.(ll.
Linux安装mysql8.0
qq_22630391的博客
11-28 1716
在CentOS6.5上安装MySQL8.0.18 **1、检查是否已经安装过mysql，执行命令** # rpm -qa | grep mysql 如果能查到，说明已经安装，需要删除 # rpm -e --nodeps mysql-libs-5.1.73-5.el6_6.x86_64 再次执行查询命令，查看是否删除 # rpm -qa | gr...
解决Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)的问题
LaGiggle的博客
02-09 1754
执行mysql -uroot -p 出现Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)错误 在 /var/log/mysql/error.log 中可以看到具体的ERROR 信息：Could not create unix socket lock file /tmp/mys...
源码编译安装mysql启动报错
yangpei1的博客
01-30 620
mysql源码编译5.7 报错
解决Mysql错误：Can't create/write to file 'C:\WINDOWS\TEMP\#sql_1344_0.MYD' (Errcode: 17)
热门推荐
xinpo66的专栏
12-04 6万+
转载一些文章。希望明天能解决。 解决Mysql错误：Can't create/write to file 'C:\WINDOWS\TEMP\#sql_1344_0.MYD' (Errcode: 17)的问题，我所使用的系统是Windows Server 2003 SP2+php 5.2.2+mysql 5.0.22+McAfee杀毒软件，当访问用户主页的时候发现mysql出错误，下面来说一下具体
[ERROR] [MY-010274] [Server] Could not open unix socket lock file /usr/local/mysql/mysql.sock.lock.
m0_62115261的博客
06-05 491
原因：权限不足解决方法:
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值