mysql: however file don't exists. Create writable for user 'mysql'.

最新推荐文章于 2023-11-16 15:56:24 发布

30baby

最新推荐文章于 2023-11-16 15:56:24 发布

阅读量1.3w

点赞数 3

分类专栏： MYSQL

本文链接：https://blog.csdn.net/ibsfn/article/details/82085418

版权

MYSQL 专栏收录该内容

10 篇文章 2 订阅

订阅专栏

第一次启动mysql5.7时,报错.

[root@test2 my57_3307]# /usr/local/mysql57/bin/mysqld_safe  --defaults-file=/dbdata/mysql/my57_3307/my57_3307.cnf  --ledir=/usr/local/mysql57/bin
2018-08-26T14:12:45.459798Z mysqld_safe error: log-error set to '/var/log/mysqld/my57_3307.log', however file don't exists. Create writable for user 'mysql'.

问题出在alert日志上.参数指定的日志文件不存在,那是必然的,因为是第一次启动,奇怪在mysql不会创建alert log...暂时没找到问题所在.

直接创建个空的日志文件,并启动,问题解决.

[root@test2 my57_3307]# touch /var/log/mysqld/my57_3307.log
[root@test2 my57_3307]# chown mysql /var/log/mysqld/my57_3307.log
[root@test2 my57_3307]# /usr/local/mysql57/bin/mysqld_safe  --defaults-file=/dbdata/mysql/my57_3307/my57_3307.cnf  --ledir=/usr/local/mysql57/bin
2018-08-26T14:13:54.454508Z mysqld_safe Logging to '/var/log/mysqld/my57_3307.log'.
2018-08-26T14:13:54.482116Z mysqld_safe Starting mysqld daemon with databases from /dbdata/mysql/my57_3307/data