Website fails to connect to database

Keywords: WordPress Multisite - Bitnami Cloud Hosting - Technical issue - Other

bndiagnostic ID: 9c4b533a-956b-7eeb-7e83-4b3ecb5d1a4f

bndiagnostic output:

? Mysql: Found possible issues
? Apache: Found possible issues
? Resources: Found possible issues
https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-mysql/
https://docs.bitnami.com/general/apps/wordpress/troubleshooting/disable-binary-logging-mysql/
https://docs.bitnami.com/general/apps/wordpress/troubleshooting/debug-errors-apache/
https://docs.bitnami.com/bch/apps/moodle/troubleshooting/deny-connections-bots-apache/

bndiagnostic failure reason: I do not know how to perform the changes explained in the documentation

Description:
Cannot access my websites. Fails to connect to database. www.bitcoin-education.com

Hi @wayne.gregori,

Did you take a look at the guides the tool suggested? The first guide shows you how to check the MySQL’s log file and you can find this error there

mysqld.bin: File './binlog.007880' not found (OS errno 2 - No such file or directory)
2022-01-12T15:16:58.631235Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2022-01-12T15:16:58.641258Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2022-01-12T15:16:58.641285Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-01-12T15:16:59.881787Z 0 [System] [MY-010910] [Server] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete (mysqld 8.0.13)  MySQL Community Server - GPL.

It seems that file was removed and that’s why the database can’t be started. You can disable the binary logging to not to receive that error

https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/disable-binary-logging-mysql/