A
A
Al2019-11-29 14:17:40
PHP
Al, 2019-11-29 14:17:40

How to force phpmyadmin to log mysql errors?

I'm trying to get phpmyadmin to write errors to the apache log.
When attempting unsuccessful authorization, mysql writes something like this to the log (/var/log/mysql/error.log) :

2019-11-29T10:58:22.437468Z 45 [Note] Access denied for user 'test'@'localhost' (using password: YES)

but in the phpmyadmin log (/var/log/apache2/phpmyadmin/access.log) there is nothing about Access Denied errors.
At the same time, in the Apache config for phpmyadmin, the following log format is:
LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %{userID}n %{userStatus} n" pma_combined
CustomLog /var/log/apache2/phpmyadmin/access.log pma_combined


What is the problem? What am I doing wrong?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
X
xmoonlight, 2019-11-29
@xmoonlight

You are waiting for errors from the script, but access is denied - mysql.
And Apache has nothing to do with it at all!)
Open the dock according to the mysql-server configuration and read: how to set up logging.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question