mysql初始化失败

最新推荐文章于 2024-09-21 17:41:03 发布

BoYing16

最新推荐文章于 2024-09-21 17:41:03 发布

阅读量406

点赞数

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/BoYing16/article/details/131939693

版权

在尝试使用./bin/mysqld命令初始化MySQL8.0.33服务器时，遇到了权限问题，具体表现为无法设置datadir到/app/software/mysql-8.0.33/data/，操作系统返回错误号13，表示权限被拒绝。解决方案是通过chmod755software命令授予上级software目录适当的权限。

摘要由CSDN通过智能技术生成

./bin/mysqld --user=mysql  --basedir=/app/software/mysql-8.0.33/ --datadir=/app/software/mysql-8.0.33/data/ --initialize
2023-07-26T06:56:54.463147Z 0 [System] [MY-013169] [Server] /app/software/mysql-8.0.33/bin/mysqld (mysqld 8.0.33) initializing of server in progress as process 30095
2023-07-26T06:56:54.465775Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to '/app/software/mysql-8.0.33/data/' (OS errno: 13 - Permission denied)
2023-07-26T06:56:54.465784Z 0 [ERROR] [MY-013236] [Server] The designated data directory /app/software/mysql-8.0.33/data/ is unusable. You can remove all files that the server added to it.
2023-07-26T06:56:54.465835Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-07-26T06:56:54.466038Z 0 [System] [MY-010910] [Server] /app/software/mysql-8.0.33/bin/mysqld: Shutdown complete (mysqld 8.0.33)  MySQL Community Server - GPL.

报错原因：上级software目录没有权限

解决方式：chmod 755 software