Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where can I find MySQL logs in phpMyAdmin?

Where can I find the MySQL's logs (errors, queries, etc.) in the phpMyAdmin interface?

like image 655
blippy Avatar asked Jun 14 '10 18:06

blippy


People also ask

Where can I find MySQL logs?

The default location for each of the logs is the MySQL Data directory (C:\ProgramData\MySQL\MySQL Server [version number]\Data\), and the default log names are based on the computer's device name.

How do I get SQL history in phpMyAdmin?

Open PhpMyAdmin and select database. There is a console tab at bottom of the SQL query screen,click to open and click on history. It will shows all the query logs.


1 Answers

I had the same problem of @rutherford, today the new phpMyAdmin's 3.4.11.1 GUI is different, so I figure out it's better if someone improves the answers with updated info.

Full mysql logs can be found in:

"Status"->"Binary Log"

This is the answer, doesn't matter if you're using MAMP, XAMPP, LAMP, etc.

like image 130
linuxatico Avatar answered Oct 05 '22 18:10

linuxatico