Where can I find MySQL logs in phpMyAdmin?

mysql logging phpmyadmin
rutherford picture rutherford · Jun 14, 2010 · Viewed 193.6k times · Source

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

Answer

linuxatico picture linuxatico · Mar 13, 2013

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.

Related questions

How to see log files in MySQL?

I've read that Mysql server creates a log file where it keeps a record of all activities - like when and what queries execute. Can anybody tell me where it exists in my system? How can I read it? Basically, …

Read More
How to show the last queries executed on MySQL?

Is there any query/way to show the last queries executed on ALL servers?

Read More
How to enable MySQL Query Log?

How do I enable the MySQL function that logs each SQL query statement received from clients and the time that query statement has submitted? Can I do that in phpmyadmin or NaviCat? How do I analyse the log?

Read More