yeszao / dnmp

Docker LNMP (Nginx, PHP7/PHP5, MySQL, Redis)
https://www.awaimai.com/2120.html
MIT License
3.96k stars 1.41k forks source link

启动mysql失败 #529

Closed CherishNA closed 1 year ago

CherishNA commented 1 year ago

阿里云服务器到期了 然后服务全停了,续费后重新启动服务 发现mysql 启动不起来了。查看了错误日志:Could not open file '/var/log/mysql/mysql.error.log' for error logging: No such file or directory 已经手动在dnmp/services/mysql/ 下建立文件夹/log/mysql 以及mysql.error.log文件。 docker错误日志如下: `2023-01-29T02:21:45.079991Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.

2023-01-29T02:21:45.080077Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.

2023-01-29T02:21:45.080127Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.13) starting as process 1

2023-01-29T02:21:45.083670Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/mysql.error.log' for error logging: No such file or directory

2023-01-29T02:21:45.083708Z 0 [ERROR] [MY-010119] [Server] Aborting

2023-01-29T02:21:45.084402Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.13) MySQL Community Server - GPL.`

afu727 commented 1 year ago

这是来自QQ邮箱的假期自动回复邮件。   您好,我最近正在休假中,无法亲自回复您的邮件。我将在假期结束后,尽快给您回复。

yeszao commented 1 year ago

删除 data/msyql/* 下面所有的文件,再试试。