荒-于嬉 2019-07-25 11:58 采纳率: 75%
浏览 274
已结题

Ubuntu mysql的binlog只能放在/var/log/mysql下

mysql5.7 ubuntu16.4
binlog只能放在mysql配置文件默认的/var/log/mysql下,将路径修改为其他位置则提示权限不足
属主属组权限都给了myql,目录改为了777,依旧不行

/var/log/mysql目录权限

root@ubuntu:/var/log/mysql# ll /var/log/mysql/
total 208
drwxr-x--- 2 mysql adm      4096 Jul 25 11:51 ./
drwxrwxr-x 7 root  syslog   4096 Jul 25 10:08 ../
-rw-r----- 1 mysql adm    177095 Jul 25 11:51 error.log
-rw-r----- 1 mysql mysql     177 Jul 25 11:39 mysql-bin.000001
-rw-r----- 1 mysql mysql     177 Jul 25 11:44 mysql-bin.000002
-rw-r----- 1 mysql mysql     177 Jul 25 11:49 mysql-bin.000003
-rw-r----- 1 mysql mysql     154 Jul 25 11:51 mysql-bin.000004
-rw-r----- 1 mysql mysql     128 Jul 25 11:51 mysql-bin.index

属主属组完全相同但是还是报错

2019-07-25T03:50:31.499690Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2019-07-25T03:50:31.499875Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2019-07-25T03:50:31.678797Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-07-25T03:50:31.681269Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.16.04.1-log) starting as process 22722 ...
mysqld: File '/log/mysql-bin.index' not found (Errcode: 13 - Permission denied)
2019-07-25T03:50:31.685861Z 0 [ERROR] Aborting

2019-07-25T03:50:31.685940Z 0 [Note] Binlog end
2019-07-25T03:50:31.686079Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-07-25T03:50:46.822469Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2019-07-25T03:50:46.822565Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2019-07-25T03:50:47.029772Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-07-25T03:50:47.032072Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.16.04.1-log) starting as process 22773 ...
mysqld: File '/log/mysql-bin.index' not found (Errcode: 13 - Permission denied)
2019-07-25T03:50:47.037520Z 0 [ERROR] Aborting

2019-07-25T03:50:47.037610Z 0 [Note] Binlog end
2019-07-25T03:50:47.037763Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-07-25T03:51:17.533526Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2019-07-25T03:51:17.533655Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2019-07-25T03:51:17.791165Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-07-25T03:51:17.793337Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.16.04.1-log) starting as process 22853 ...
mysqld: File '/log/mysql-bin.index' not found (Errcode: 13 - Permission denied)
2019-07-25T03:51:17.798406Z 0 [ERROR] Aborting

2019-07-25T03:51:17.798466Z 0 [Note] Binlog end
2019-07-25T03:51:17.799262Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

  • 写回答

1条回答 默认 最新

  • 憧憬blog 2023-03-15 05:40
    关注

    根据您提供的错误日志和描述,看起来是文件权限问题。尝试使用chmod命令更改新目录的文件权限。可以执行以下命令:

    sudo chmod -R 777 /path/to/new/directory
    

    务必将“/path/to/new/directory”替换为您想要放置binlog的目录的实际路径。如果仍然无法正常工作,请检查mysql用户的UID和GID是否匹配您的系统,是否有任何SELinux限制,以及尝试重启MySQL服务。

    评论

报告相同问题?

问题事件

  • 已结题 (查看结题原因) 7月26日

悬赏问题

  • ¥15 数学的三元一次方程求解
  • ¥20 iqoo11 如何下载安装工程模式
  • ¥15 本题的答案是不是有问题
  • ¥15 关于#r语言#的问题:(svydesign)为什么在一个大的数据集中抽取了一个小数据集
  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 蓝桥杯单片机第十三届第一场,整点继电器吸合,5s后断开出现了问题