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