Well, I’m trying to locate the log file to check errors in phpmyadmin interface and I saw in posts and forums that phpmyadmin have a binary log tab to check it, but I don’t have enabled that tab and the solutions I found don’t have any real solution to me…
Thanks yall!
Question posted in PhpMyAdmin
The official documentation can be found here.
2
Answers
What problem are you seeing with phpMyAdmin that you hope to fix by viewing the log? You haven’t really described what problem you’re trying to solve, which makes answering your question a bit difficult.
There are a number of logs available, but the most direct answer about the log file to check regarding errors with phpMyAdmin is in your webserver’s error log. Read on for more details, though.
If it’s a problem within phpMyAdmin directly (or something that phpMyAdmin does with MySQL), it’s usually shown directly on the screen as a friendly message. If it’s something that breaks phpMyAdmin directly, it’s logged through whatever means you have configured for PHP errors to be logged (usually directly to the webserver error log).
If you’re having a problem with a query through MySQL, those are logged by MySQL through the MySQL error log, which is usually to a file in most systems I’m familiar with.
The binary log is not related to error logging, but is instead an ongoing transaction log where MySQL records ongoing queries (docs, more docs). Based on your description, this is not what you’re looking for.
The Phpmyadmin application does not have a log file, however you can perform this trick:
Phpmyadmin has a php script that when executed will return a result with the errors you find.
On Ubuntu Server the file is in:
then you must enter that folder and run
this will return the errors that Phpmyadmin has, most of the time they are errors in the configuration file config.inc.php