how can i access on access_log of mysql?

[luigidefra]

Hi guys

I have an app where until now I have been able to connect to mysql.
From today it has decided that it no longer wants to connect.

From ssh I can easily connect.

I would like to ask you where can I find the mysql access_log to understand what happens?

 

[kodeslogic]

Is your app and MySQL server are on the same server?

Have you checked MySQL error log?

/var/lib/mysql/{SERVER_NAME}.err

 

[cPRex]

The error_log that @kodeslogic pointed out would also be the first place I would check. If your system is running MariaDB you may want to be aware of the issues pointed out in this thread:

SOLVED - CPANEL-34745 - MariaDB 10.3.26-1 Breaks PHP < 7.2

Just wanting to post this here, as I've spent the last 2 hours fault finding an issue on my servers this morning. cPanel servers, all the latest updates. MariaDB automatically updated to 10.3.26-1 over night as part of the cPanel yum update. As soon as this happened, any XenForo site running...

forums.cpanel.net