MySQL启动报错(Can‘t change dir to ‘/usr/local/mysql/data/‘ (Errcode: 2 - No such file or director)

原创已于 2023-10-25 10:26:41 修改 · 847 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #android #数据库

于 2023-10-25 10:26:02 首次发布

文章讲述了在尝试重启MySQL服务时遇到的错误，主要原因是配置文件my.cnf权限设置为777导致的，解决方案是将权限改为644。报错还涉及到数据目录的设定不正确。

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

报错场景

在启动服务时，

systemctl restart mysql_4405
Job for mysql_4405.service failed because the control process exited with error code. See "systemctl status mysql_4405.service" and "journalctl -xe" for details.

详细日志
journalctl -xe
-- 
-- Unit mysql_4405.service has begun starting up.
Oct 25 01:59:00 sudada mysqld[18277]: mysqld: [Warning] World-writable config file '/data/mysql/4405/my.cnf.4405' is ignored.
Oct 25 01:59:00 sudada mysqld[18277]: mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2 - No such file or director
Oct 25 01:59:00 sudada mysqld[18277]: 2023-10-25T01:59:00.812489Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated
Oct 25 01:59:00 sudada mysqld[18277]: 2023-10-25T01:59:00.812641Z 0 [Note] --secure-file-priv is set to NULL. Operations related 
Oct 25 01:59:00 sudada mysqld[18277]: 2023-10-25T01:59:00.812672Z 0 [Note] /data/mysql/4405/base/bin/mysqld (mysqld 5.7.43) start
Oct 25 01:59:00 sudada mysqld[18277]: 2023-10-25T01:59:00.812701Z 0 [ERROR] Can't find error-message file '/usr/local/mysql/share
Oct 25 01:59:00 sudada mysqld[18277]: 2023-10-25T01:59:00.813206Z 0 [Warning] Can't create test file /usr/local/mysql/data/sudada
Oct 25 01:59:00 sudada mysqld[18277]: 2023-10-25T01:59:00.813211Z 0 [Warning] Can't create test file /usr/local/mysql/data/sudada
Oct 25 01:59:00 sudada mysqld[18277]: 2023-10-25T01:59:00.813266Z 0 [ERROR] failed to set datadir to /usr/local/mysql/data/
Oct 25 01:59:00 sudada mysqld[18277]: 2023-10-25T01:59:00.813272Z 0 [ERROR] Aborting
Oct 25 01:59:00 sudada mysqld[18277]: 2023-10-25T01:59:00.813300Z 0 [Note] Binlog end
Oct 25 01:59:00 sudada systemd[1]: mysql_4405.service: control process exited, code=exited status=1
Oct 25 01:59:00 sudada mysqld[18277]: Initialization of mysqld failed: 0
Oct 25 01:59:00 sudada mysqld[18277]: 2023-10-25T01:59:00.814179Z 0 [Note]
Oct 25 01:59:00 sudada systemd[1]: Failed to start MySQL Server.
-- Subject: Unit mysql_4405.service has failed

因为错误日志没有输出(下面只是关闭时候的日志，没有启动日志)

2023-10-25T01:58:59.009620-00:00 0 [Note] Shutting down plugin 'MyISAM'
2023-10-25T01:58:59.009648-00:00 0 [Note] Shutting down plugin 'MRG_MYISAM'
2023-10-25T01:58:59.009664-00:00 0 [Note] Shutting down plugin 'MEMORY'
2023-10-25T01:58:59.009671-00:00 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-10-25T01:58:59.009702-00:00 0 [Note] Shutting down plugin 'sha256_password'
2023-10-25T01:58:59.009709-00:00 0 [Note] Shutting down plugin 'mysql_native_password'
2023-10-25T01:58:59.009997-00:00 0 [Note] Shutting down plugin 'binlog'
2023-10-25T01:58:59.010825-00:00 0 [Note] /data/mysql/4405/base/bin/mysqld: Shutdown complete

问题要点

/usr/local/mysql/data/目录不是服务的实际目录（实际目录是/data/mysql/4405/data）
且没有/usr/local/mysql/data/目录的存在

解决办法

mysqld: [Warning] World-writable config file ‘/data/mysql/4405/my.cnf.4405’ is ignored.
上面的启动日志 “World-writable“ 配置文件的权限太大了。

解决办法,把777改成了644就可以启动了
chmod 644 /data/mysql/4405/my.cnf.4405

好奇怪的报错，结论是配置文件权限不能是777。
完结撒花🌹