/usr/libexec/mysqld: Can't change dir to '/xxx' (Errcode: 13) 解决

最新推荐文章于 2023-11-22 19:57:37 发布
最新推荐文章于 2023-11-22 19:57:37 发布
阅读量9.7k 收藏
点赞数
分类专栏： mysql 文章标签： mysql
本文介绍了如何解决MySQL启动过程中出现的警告与错误信息，包括权限设置问题和SELINUX权限限制等问题，并提供了解决方案。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

当看到错误日志里面如下记录：

mysqld started

[Warning] Can't create test file xxx.lower-test
[Warning] Can't create test file xxx.lower-test
/usr/libexec/mysqld: Can't change dir to '/xxx' (Errcode: 13)

[ERROR] Aborting

首先检查数据目录和日志目录的权限和所属用户，如果权限和所属用户都没问题，那应该是SELINUX的权限限制了。

对你的数据目录和日志目录执行如下命令：

chcon -R system_u:object_r:mysqld_db_t:s0 /media/sda3/mysql/

一切问题迎刃而解

实在不行重启电脑!!!

mysql 启动报错 Can t change dir to xxx, No such file or directory 配置错误或挂载导致
global_coding的博客
10-18 5414
mysql 启动报错 Can't change dir to 'xxx', No such file or directory 配置错误或挂载导致
【mysql】报错Can‘t create/write to file ‘/var/tmp/ibQJOprL‘ (Errcode: 28)
u012579892的博客
12-20 2008
centos5.8磁盘扩容。
mysqld: Can‘t change dir to ‘/usr/local/mysql/data/‘ (Errcode: 13 - Permission denied) 报错处理
LSW1737554365的博客
10-27 2860
[root@hecs-399223 bin]# ./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 13 - Permission denied) 2023-10-27T06:21:51.170236Z 0 [Warning] TIMESTAMP w
MySQL 5.7.31安装Can‘t change dir to ‘……‘问题解决
qq_41048413的博客
10-12 1万+
#MySQL 5.7.31安装Can’t change dir to '……'问题解决 首先，MySQL 5.7.31 完整的安装过程如下： MySQL 5.7.31 详细下载安装配置 问题描述： 在进行 mysql - install 显示Service successfully installed 安装成功后，在输入命令：mysqld --initialize后，出现如下错误： 原因分析： 经过查找问题和网上搜索，最终发现是mysql下的配置文件my.ini出错。因为mysql对应地址没有和自己
Linux上安装MySQL初始化报错处理mysqld: Can‘t change dir to 和MySQL server PID file could not be found!
weixin_52687711的博客
11-22 2224
Linux安装MySQL报错处理： mysqld: Can't change dir to '/home/zxa/software/mysql/data/' (Errcode: 13 - Permission denied) MySQL server PID file could not be found!
MySQL5.7执行mysqld命令出现Can‘t change dir to ‘C:\Program Files\MySQL\MySQL Server 5.7\data\‘错误
java后端开发
07-16 2万+
执行mysqld -P3307 出现如下错误： mysqld: Can't change dir to 'C:\Program Files\MySQL\MySQL Server 5.7\data\' (Errcode: 2 - No such file or directory) 2020-07-16T02:50:56.162091Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
[root@localhost bin]# cat /etc/my.cnf [mysqld] bind-address=0.0.0.0 port=3306 user=mysql basedir=/usr/local/mysql datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/data/mysql/mysql.err pid-file=/data/mysql/mysql.pid #character config character_set_server=utf8mb4 symbolic-links=0 explicit_defaults_for_timestamp=true default_authentication_plugin = mysql_native_password symbolic-links=0 plugin_load_add='component_reference_cache.so' [root@localhost bin]# journalctl -xe -u mysqld --no-pager 7月 14 17:24:42 localhost.localdomain systemd[1]: Starting MySQL 8.0 database server... ░░ Subject: mysqld.service 单元已开始启动 ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ mysqld.service 单元已开始启动。 7月 14 17:24:42 localhost.localdomain mysqld[40957]: 2025-07-14T09:24:42.446697Z 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. 7月 14 17:24:42 localhost.localdomain mysqld[40957]: 2025-07-14T09:24:42.446841Z 0 [Warning] [MY-010091] [Server] Can't create test file /data/mysql/mysqld_tmp_file_case_insensitive_test.lower-test 7月 14 17:24:42 localhost.localdomain mysqld[40957]: 2025-07-14T09:24:42.446899Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 7月 14 17:24:42 localhost.localdomain mysqld[40957]: 2025-07-14T09:24:42.446924Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.41) starting as process 40957 7月 14 17:24:42 localhost.localdomain mysqld[40957]: 2025-07-14T09:24:42.449879Z 0 [Warning] [MY-010091] [Server] Can't create test file /data/mysql/mysqld_tmp_file_case_insensitive_test.lower-test 7月 14 17:24:42 localhost.localdomain mysqld[40957]: 2025-07-14T09:24:42.449886Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /data/mysql/ is case insensitive 7月 14 17:24:42 localhost.localdomain mysqld[40957]: 2025-07-14T09:24:42.450361Z 0 [ERROR] [MY-010187] [Server] Could not open file '/data/mysql/mysql.err' for error logging: Permission denied 7月 14 17:24:42 localhost.localdomain mysqld[40957]: 2025-07-14T09:24:42.450447Z 0 [ERROR] [MY-010119] [Server] Aborting 7月 14 17:24:42 localhost.localdomain mysqld[40957]: 2025-07-14T09:24:42.450568Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.41) Source distribution. 7月 14 17:24:42 localhost.localdomain systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE ░░ Subject: Unit process exited ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ An ExecStart= process belonging to unit mysqld.service has exited. ░░ ░░ The process' exit code is 'exited' and its exit status is 1. 7月 14 17:25:43 localhost.localdomain systemd[1]: mysqld.service: Control process exited, code=exited, status=3/NOTIMPLEMENTED ░░ Subject: Unit process exited ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ An ExecStopPost= process belonging to unit mysqld.service has exited. ░░ ░░ The process' exit code is 'exited' and its exit status is 3. 7月 14 17:25:43 localhost.localdomain systemd[1]: mysqld.service: Failed with result 'exit-code'. ░░ Subject: Unit failed ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ The unit mysqld.service has entered the 'failed' state with result 'exit-code'. 7月 14 17:25:43 localhost.localdomain systemd[1]: Failed to start MySQL 8.0 database server. ░░ Subject: mysqld.service 单元已失败 ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ mysqld.service 单元已失败。 ░░ ░░ 结果为“failed”。 7月 14 17:30:58 localhost.localdomain systemd[1]: Starting MySQL 8.0 database server... ░░ Subject: mysqld.service 单元已开始启动 ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ mysqld.service 单元已开始启动。 7月 14 17:30:59 localhost.localdomain mysqld[41251]: 2025-07-14T09:30:59.223243Z 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. 7月 14 17:30:59 localhost.localdomain mysqld[41251]: 2025-07-14T09:30:59.223383Z 0 [Warning] [MY-010091] [Server] Can't create test file /data/mysql/mysqld_tmp_file_case_insensitive_test.lower-test 7月 14 17:30:59 localhost.localdomain mysqld[41251]: 2025-07-14T09:30:59.223443Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 7月 14 17:30:59 localhost.localdomain mysqld[41251]: 2025-07-14T09:30:59.223469Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.41) starting as process 41251 7月 14 17:30:59 localhost.localdomain mysqld[41251]: 2025-07-14T09:30:59.226383Z 0 [Warning] [MY-010091] [Server] Can't create test file /data/mysql/mysqld_tmp_file_case_insensitive_test.lower-test 7月 14 17:30:59 localhost.localdomain mysqld[41251]: 2025-07-14T09:30:59.226390Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /data/mysql/ is case insensitive 7月 14 17:30:59 localhost.localdomain mysqld[41251]: 2025-07-14T09:30:59.226871Z 0 [ERROR] [MY-010187] [Server] Could not open file '/data/mysql/mysql.err' for error logging: Permission denied 7月 14 17:30:59 localhost.localdomain mysqld[41251]: 2025-07-14T09:30:59.226952Z 0 [ERROR] [MY-010119] [Server] Aborting 7月 14 17:30:59 localhost.localdomain mysqld[41251]: 2025-07-14T09:30:59.227071Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.41) Source distribution. 7月 14 17:30:59 localhost.localdomain systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE ░░ Subject: Unit process exited ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ An ExecStart= process belonging to unit mysqld.service has exited. ░░ ░░ The process' exit code is 'exited' and its exit status is 1. 7月 14 17:32:00 localhost.localdomain systemd[1]: mysqld.service: Control process exited, code=exited, status=3/NOTIMPLEMENTED ░░ Subject: Unit process exited ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ An ExecStopPost= process belonging to unit mysqld.service has exited. ░░ ░░ The process' exit code is 'exited' and its exit status is 3. 7月 14 17:32:00 localhost.localdomain systemd[1]: mysqld.service: Failed with result 'exit-code'. ░░ Subject: Unit failed ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ The unit mysqld.service has entered the 'failed' state with result 'exit-code'. 7月 14 17:32:00 localhost.localdomain systemd[1]: Failed to start MySQL 8.0 database server. ░░ Subject: mysqld.service 单元已失败 ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ mysqld.service 单元已失败。 ░░ ░░ 结果为“failed”。 7月 14 17:42:23 localhost.localdomain systemd[1]: Starting MySQL 8.0 database server... ░░ Subject: mysqld.service 单元已开始启动 ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ mysqld.service 单元已开始启动。 7月 14 17:42:23 localhost.localdomain mysql-prepare-db-dir[41483]: Initializing MySQL database 7月 14 17:42:29 localhost.localdomain mysqld[41560]: 2025-07-14T09:42:29.622474Z 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. 7月 14 17:42:29 localhost.localdomain mysqld[41560]: 2025-07-14T09:42:29.622487Z 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. 7月 14 17:42:29 localhost.localdomain mysqld[41560]: 2025-07-14T09:42:29.624267Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 7月 14 17:42:29 localhost.localdomain mysqld[41560]: 2025-07-14T09:42:29.624296Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.41) starting as process 41560 7月 14 17:42:29 localhost.localdomain mysqld[41560]: 2025-07-14T09:42:29.626446Z 0 [ERROR] [MY-010187] [Server] Could not open file '/data/mysql/mysql.err' for error logging: Permission denied 7月 14 17:42:29 localhost.localdomain mysqld[41560]: 2025-07-14T09:42:29.626524Z 0 [ERROR] [MY-010119] [Server] Aborting 7月 14 17:42:29 localhost.localdomain mysqld[41560]: 2025-07-14T09:42:29.626659Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.41) Source distribution. 7月 14 17:42:29 localhost.localdomain systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE ░░ Subject: Unit process exited ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ An ExecStart= process belonging to unit mysqld.service has exited. ░░ ░░ The process' exit code is 'exited' and its exit status is 1. 7月 14 17:43:30 localhost.localdomain systemd[1]: mysqld.service: Control process exited, code=exited, status=3/NOTIMPLEMENTED ░░ Subject: Unit process exited ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ An ExecStopPost= process belonging to unit mysqld.service has exited. ░░ ░░ The process' exit code is 'exited' and its exit status is 3. 7月 14 17:43:30 localhost.localdomain systemd[1]: mysqld.service: Failed with result 'exit-code'. ░░ Subject: Unit failed ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ The unit mysqld.service has entered the 'failed' state with result 'exit-code'. 7月 14 17:43:30 localhost.localdomain systemd[1]: Failed to start MySQL 8.0 database server. ░░ Subject: mysqld.service 单元已失败 ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ mysqld.service 单元已失败。 ░░ ░░ 结果为“failed”。 7月 14 17:43:30 localhost.localdomain systemd[1]: mysqld.service: Consumed 2.187s CPU time. ░░ Subject: Resources consumed by unit runtime ░░ Defined-By: systemd ░░ Support: https://wiki.rockylinux.org/rocky/support ░░ ░░ The unit mysqld.service completed and consumed the indicated resources. [root@localhost bin]# ls /var/lib/mysql/*.err ls: 无法访问 '/var/lib/mysql/*.err': 没有那个文件或目录 [root@localhost bin]# tail -n 50 /var/lib/mysql/localhost.err tail: 无法打开'/var/lib/mysql/localhost.err' 读取数据: 没有那个文件或目录 [root@localhost bin]#
最新发布
07-15
sudo semanage fcontext -a -t mysqld_log_t "/data/mysql(/.*)?" sudo restorecon -Rv /data/mysql ``` #### 步骤 4：检查配置文件 在 `/etc/my.cnf` 中确认日志路径： ```ini [mysqld] log_error = /data/mysql/...
Linux Mysql8.0安装
落寞秋雨的博客
07-08 9614
1.检测系统是否自带Mysql # rpm -qa|grep mysql 2.如果有进行强行卸载 # rpm -e --nodeps mysql-libs-5.1.52-1.el6_0.1.x86_64 3.检测系统是否自带mariadb # rpm -qa|grep mariadb 4.如果存在则强行卸载 # rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64 5.创建目录 在根目录下创建文件夹software和数据库数据文件
mariadb(mysql)报错:Job for mariadb.service failed because the control process exited with error code解决
河北强商网络科技有限公司官方博客
02-26 8383
mariadb(mysql)启动报错报错：Job for mariadb.service failed because the control process exited with error code解决方案 [root@localhost ~]# systemctl start mariadb #1===============执行，返回值给出2个命令查询报错详细记录 Job for mar...
mysql登陆启动报错 ERROR 2002 (HY000) 解决方法
weixin_33739627的博客
04-15 5474
报错信息 登陆数据库报错：` ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")` 重启服务报错：Job for mariadb.service failed because the co...
centos7 selinux开启下启动mysql失败：Can‘t change dir to
hl234的专栏
02-26 3663
selinux开启下启动mysql失败：Can't change dir to
Linux下查看MySQL的安装路径
zishuijing2的专栏
09-01 575
Linux下查看MySQL的安装路径   Linux下查看mysql、apache是否安装,并卸载。   指令 ps -ef|grep mysql 得出结果 1.root     17659     1  0  2011 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --
/usr/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
风花雪月
02-14 3154
150214 00:19:30 mysqld_safe Starting mysqld daemon with databases from /data/mysql 150214  0:19:30 [Warning] Can't create test file /data/mysql/localhost.lower-test 150214  0:19:30 [Warning] Can't c
mysql: ExecStart=/usr/libexec/mysqld --basedir=/usr (code=exited, status=1/FAILURE)
PureFuries的博客
03-10 4880
安装mysql后无法打开守护进程，报错如下： mysqld.service - MySQL 8.0 database server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled) Active: failed (Result: exit-code) since Wed 2021-03-10 02:25:22 CST; 13s ago Process: 37172 ExecSt
MySQL启动报错(Can‘t change dir to ‘/usr/local/mysql/data/‘ (Errcode: 2 - No such file or director)
一杯Mojito可以吗
10-25 849
启动报错，配置文件被忽略。因为权限过大
mysql错误/usr/libexec/mysqld: Out of memory (Needed xxx bytes)
fh09102103的专栏
01-19 1405
核心提示：检查mysqld配置my.conf，着重看key_buffer_size, max_heap_table_size, tmp_table_size几个参数，推荐设置key_buffer_size值为max_heap_table_size的1/4. 因为服务器内存而大富余比较多，前些天把my.conf里的好几个参数调得相当大，1G甚至2G，但并不稳定，mysqld报出过几次Out of
MySQL5.7报错Can‘t change dir to ‘C:\Program Files\MySQL\MySQL Server 5.7\data\‘
gy458402998的博客
04-30 1962
MySQL5.7
Centos8上安装mysql8遇到SELinux is preventing /usr/libexec/mysqld from write access on the directory mysql
weixin_42181890的博客
03-02 4633
问题描述 mysql8安装后数据默认存储路径/var/lib/mysql，修改默认存储路径后遇到如下报错： SELinux is preventing /usr/libexec/mysqld from write access on the directory mysql. For complete SELinux messages run: sealert -l 233b1c8f-ef7> 网上做法 关闭selinux。并不是很明智的做法，会引发潜在的安全问题 完全复制默认安装路径下的文件及权限，
linux系统下，MySQL导入导出数据 ErrCode(13)(permission denied)解决方案
热门推荐
Nireusm的博客
10-23 2万+
在 mysql 服务器上，可以通过 load data infile ‘file_name’ into table table_name; 命令将一个文本文件中的所有数据存到指定表中。最粗略形式的例子： load data infile ‘test.txt’ into table test_table; 默认情况下，load data infile 对于文本中行为是： 一行对应数据库表中的一
sudo service mysql start /etc/init.d/mysql: line 45: /usr/sbin/mysqld: No such file or directory * Starting MySQL database server mysqld /etc/init.d/mysql: line 45: /usr/sbin/mysqld: No such file or directory su: warning: cannot change directory to /nonexistent: No such file or directory /etc/init.d/mysql: line 45: /usr/sbin/mysqld: No such file or directory /etc/init.d/mysql: line 45: /usr/sbin/mysqld: No such file or directory /etc/init.d/mysql: line 45: /usr/sbin/mysqld: No such file or directory /etc/init.d/mysql: line 45: /usr/sbin/mysqld: No such file or directory /etc/init.d/mysql: line 45: /usr/sbin/mysqld: No such file or directory
06-09
我们正在解决MySQL启动时报错：'/usr/sbin/mysqld:Nosuchfileordirectory'这个错误表明系统找不到mysqld可执行文件。可能的原因包括：1.MySQL未正确安装2.MySQL安装目录不在PATH中3.符号链接丢失或损坏4.安装过程...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值