How can I see the exact queries phpmyadmin is running?

Question

How can I see what SQL queries phpmyadmin runs to execute commands? I want to create a not easy database, first using phpmyadmin, then using php code. But when I create the table with phpmyadmin, it doesn't show the commands it uses to create or select a table.

Is there any way? :)

Thanks!

ps.: mysql version: 5.6.12

PHPMyAdmin shows SQL queries it has run just after they completed in green / red boxed depending on their results. Execute some queries and see for yourself. — Tomasz Kowalczyk, Apr 22 '14 at 11:07

score 1 · Answer 1 · answered Apr 21 '14 at 18:09

1

You can edit your my.cnf file and add this line:

log=/var/log/mysql.log

Next you can monitor that file using tail with this command:

tail -f var/log/mysql/mysql.log

And you will see all queries on real time :)

answered Apr 21 '14 at 18:09

Arnold Roa

7,335
5
50
69

1

I've got a wild guess that the OP is using windows... – HamZa Apr 21 '14 at 18:10
Erm, a question. Where is the "my.cnf" file? That is the mysql consol? Or what? – user3290356 Apr 21 '14 at 18:15
So you are runing windows? should be in the same folder where your mysql server executable file is. Are you using wamp? – Arnold Roa Apr 21 '14 at 19:59

score 0 · Answer 2 · edited May 23 '17 at 12:11

0

This question is perhaps already answered in older Stack Overflow questions Log all queries in mysql or How to enable MySQL Query Log?

(I used Google "mysql query logger" to find them)

edited May 23 '17 at 12:11

Community

1
1

answered Apr 21 '14 at 18:25

xmojmr

8,073
5
31
54

How can I see the exact queries phpmyadmin is running?

2 Answers2