mysql无法开启：The /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql'

最新推荐文章于 2024-01-19 17:03:49 发布

转载最新推荐文章于 2024-01-19 17:03:49 发布 · 7.3k 阅读

文章标签：

#mac #mysql #jsp

问题与解决同时被 2 个专栏收录

40 篇文章

订阅专栏

jsp学习

2 篇文章

订阅专栏

本文解决了在Snow Leopard系统中启动MySQL服务时遇到的警告问题，即数据目录未被MySQL用户拥有。通过使用三条简单的命令行操作，可以成功地更改目录的所有权并启动MySQL服务。

If you can't start mysql service in snow leopard, and in the panel prefs appears 'warning the user/local/mysql/data directory is not owned by the mysql user', you have to:

sudo chown -RL root:mysql /usr/local/mysql
sudo chown -RL mysql:mysql /usr/local/mysql/data
sudo /usr/local/mysql/support-files/mysql.server start

出现如标题问题，可以执行以上三句命令行。

即可成开启mysql

感谢：http://stackoverflow.com/questions/5527676/warning-the-user-local-mysql-data-directory-is-not-owned-by-the-mysql-user

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

kevinlinkai

关注关注

4
点赞
踩
5

收藏

觉得还不错? 一键收藏
3
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

mysqld 启动报错 Can‘t create directory ‘/usr/local/mysql/data/’(Errcode:2 -No such file or directory)

寂夜了无痕的博客

06-23

3878

mysqld 启动报错 Can‘t c 彻底解决办法第一种可以启动但是其他配置其他参数没生效 ./mysqld --user=root --basedir=/usr/local/develop/mysql-5.7.31 --datadir=/usr/local/develop/mysql-5.7.31/data 第二种指定配置文件其他配置其他参数生效 ./mysqld --defaults-file=/usr/local/develop/mysql-5.7.31/my.cnf --...

MySql技术内幕：InnoDB存储引擎读书笔记

qq_33275348的博客

12-06

786

书名《MySql技术内幕：InnoDB存储引擎》作者姜承尧书摘第一章：MySQL体系结构和存储引擎定义数据库和实例：定义数据库和实例数据库：文件的集合，frm、MYD、MYI、ibd等实例：是有后台线程以及一个共享内存区组成。操作数据库文件。单进程...

3 条评论您还未登录，请先登录后发表或查看评论

mac 在偏好设置启动mysql 失败，“Warning:The /usr/local/mysql/data directory is not owned by the 'mysql' or '_my

我的博客

03-07

3888

一、Mac OS X的升级或其他原因可能会导致ＭySQL启动或开机自动运行时在ＭySQL操作面板上会提示“Warning:The /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql' ”，这应该是某种情况下导致/usr/local/mysql/data的宿主发生了改变，

Mac下启动MySQL出现错误“the /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql' user”解决...

angou6476的博客

01-16

581

错误如下： Warring the /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql' user 这应该是某种情况下导致/usr/local/mysql/data的宿主发生了改变。解决方法：终端输入： sudo chown -R mysql /usr/local/mysql/...

The /usr/local/mysql/data directory is not owned by the ‘mysql‘ or ‘_mysql‘

12-20

4万+

The /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql'

Mac解决mysql stop报错问题：The /usr/local/mysql/data directory is not owned by the ‘mysql‘ or ‘_mysql‘

我有满天星辰的博客

11-19

474

报错信息：The /usr/local/mysql/data directory is not owned by the ‘mysql’ or ‘_mysql’ user.

[root@localhost support-files]# sudo ./mysql.server start ./mysql.server: line 239: my_print_defaults: command not found ./mysql.server: line 259: cd: /usr/local/mysql: No such file or directory Starting MySQL ERROR! Couldn't find MySQL server (/usr/local/mysql/bin/mysqld_safe) [root@localhost support-files]# ls magic mysqld_multi.server mysql-log-rotate mysql.server

最新发布

08-26

- **更改数据目录的所有权**：如果遇到类似 `Warring the /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql' user` 的警告，可以通过更改该目录及其内容的所有者来解决。执行 `sudo chown -...

Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql-8.0/data//localhost.localdomain.pid).

07-29

2. Verify file permissions: Ensure that the MySQL data directory and its files are owned by the MySQL user and group. You can use the following command to check and fix the permissions: ``` chown -R...

生产环境centos7 安装mysql 5.7.35

山巅

03-04

1503

生产环境centos7 安装mysql 5.7.35初始化mysql 初始化mysql [root@mysql bin]# ./mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/mom/data/mysql 2022-03-03T01:36:00.586711Z 0 [Warning] TIMESTAMP with implicit DEFAULT value

MySQL基础：客户端管理工具mysqladmin

知行合一止于至善

03-18

7982

mysqladmin是mysql的客户端管理工具，虽然有相当一部分功能使用mysql客户端就可以实现，这篇文章整理一下mysqladmin的常见用法。确认版本可以使用如下方式进行mysqladmin的版本确认确认mysqladmin的版本信息 # mysqladmin --version mysqladmin Ver 8.42 Distrib 5.7.16, for Linux on...

一.MySQL的数据目录

m0_71163619的博客

01-19

2431

数据目录

mysqld初始化Can‘t create directory ‘/usr/local/mysql/data/’(Errcode:2 -No such file or directory)

寂夜了无痕的博客

06-16

9005

mysqld初始化Can‘t create directory ‘/usr/local/mysql/data/’(Errcode:2 -No such file or directory)

mysql 目录启动_MySQL启动时必需到usr/local/mysql目录的问题解决方法

weixin_32824369的博客

01-19

1790

之前我安装MySql数据库的时候，由于我的MySQL不是安装在标准的/usr/local/mysql目录，而是安装在/usr/local/development/mysql-5.5.25目录，导致在启动MySQL服务时报告找不到/usr/local/mysql目录的错误。最后我就创建了符号链/usr/local/mysql链接到/usr/local/development/mysql-5.5.25...

Warning:The /usr/local/mysql/data directory is not owned by the ‘mysql‘ or ‘_mysql‘

qiaojiu的博客

08-06

145

Warning:The /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql'。

/usr/local/mysql/data/bogon.err: 没有那个文件或目录

weixin_44895829的博客

03-06

1226

linux的mysql执行开启命令时会报这样的错 ./usr/local/mysql/data/bogon.err: 没有那个文件或目录解决办法：依次建目录或文件 [roo@bogon bin]$ mkdir /usr/local/mysql mkdir: 无法创建目录"/usr/local/mysql": 权限不够 [roo@bogon bin]$ sudo mkdir /usr/local/mysql [roo@bogon bin]$ sudo mkdir /usr/local/mysql/d

mysqld: Can‘t change dir to ‘/usr/local/mysql/data/‘ (Errcode: 13 - Permission denied) 报错处理

LSW1737554365的博客

10-27

3004

[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安装错误：mysqld: Can't create directory