Where can I find MySQL logs in phpMyAdmin?
MysqlLoggingPhpmyadminMysql Problem Overview
Where can I find the MySQL's logs (errors, queries, etc.) in the phpMyAdmin interface?
Mysql Solutions
Solution 1 - Mysql
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.
Solution 2 - Mysql
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.
Solution 3 - Mysql
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):
Solution 4 - Mysql
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.
Solution 5 - Mysql
If you are using XAMPP as your server, you'll find a logs directory as a child of the XAMPP directory. If you have not tried XAMPP, which runs on any system (Windows, Mac OS & Linux) find more here: http://www.apachefriends.org/en/xampp.html
Solution 6 - Mysql
Use performance_schema database and the tables:
- events_statements_current
- events_statemenets_history
- events_statemenets_history_long
Check the manual here