Where can I find MySQL logs in phpMyAdmin?
Open your PHPMyAdmin, don't select any database and look for Binary Log
tab .
You can select different logs from a drop down list and press GO
Button to view them.
In phpMyAdmin 4.0, you go to Status > Monitor. In there you can enable the slow query log and general log, see a live monitor, select a portion of the graph, see the related queries and analyse them.
I am using phpMyAdmin version 4.2.11. At the time of writing, my Status
tab looks like this (a few options expanded; note "Current settings", bottom right):
Note, there are no directly visible "features" that allow for the enabling of things such as slow_query_log
. So, I went digging on the internet because UI-oriented answers will only be relevant to a particular release and, therefore, will quickly become out of date. So, what do you do if you don't see a relevant answer, above?
As this article explains, you can run a global query to enable or disable the slow_query_log
et al. The queries for enabling and disabling these logs are not difficult, so don't be afraid of them, e.g.
SET GLOBAL slow_query_log = 'ON';
From here, phpMyAdmin is pretty helpful and a bit of Googling will get you up to speed in no time. For instance, after I ran the above query, I can go back to the "Instructions/Setup" option under the Status tab's Monitor
window and see this (note the further instructions):
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.