phpMyAdmin - Display all queries

Question

I have installed a fresh desktop with ubuntu quantal and the following packages versions:

MySQL: 5.5.28-0ubuntu0.12.10.1
Apache: 2.2.22 (Ubuntu)
phpMyAdmin: 3.4.11.1deb1

I would like phpmyadmin to display all the queries I run. How can I do it?

Thank you very much.

UPDATE
To be more specific, there are some queries showing into the query box, but I would like phpMyAdmin to show ALL of them including when I export a Database (if possible). Thank you.

Solution

Usually, you see all the queries that you put into the textarea in the "SQL" tab. Check out if it works for you on the PHPMyAdmin demo site, currently running v3.5.3 (Login: root/no password). If it doesn't help, try describing precisely what you do. Maybe the extended AJAX functions in newer releases prevent the display of certain queries.

Also, there's a history function (Source):

phpmyadmin does offer a brief history. If you click on the 'sql' icon just underneath the 'phpmyadmin' logo, it'll open a new window. In the new window, just click on the 'history' tab.

EDIT: Downgrading phpmyadmin to version 3.2.x should help. Back then, less or none AJAX functions were applied to the query text input.

BTW: I prefer Adminer to PHPMyAdmin for a few month now. Added solution

Comments

[Mateng]

Maybe this question is better suited at Stackoverflow.com

[Mateng]

Are you looking for a kind of MySQL query history?

[abaid778]

In previous versions of phpMyAdmin, everytime you launched an event (i.e. create a user) you could see the query launched displayed. I do not see it displayed anymore and that is what I would like to get. Thank you.

[abaid778]

It is not exactly what I am looking for. In previous versions of phpMyAdmin, everytime you launched an event (i.e. create a user) you could see the query launched displayed. I do not see it displayed anymore and that is what I would like to get. Thank you.

[abaid778]

Have you tried the demo page? It brings a lot of warnings and does not login. Adminer might be a great tool, but it is not straight forward to a non programmer. In my case, all I did was to install a lamp server by "sudo tasksel install lamp-server" and tried to use phpMyAdmin right after. It was then to my surprise that the SQL queries were not showing. By the way, the SQL history tab undeneath the phpmyadmin logo does not show the history either. As I mentioned before, it has not happened to me in previous installations.

[Mateng]

The demo works fine in my FF15 (on Win7). I assume it all might be a problem with your browser.

[Mateng]

I guess downgrading phpmyadmin to version 3.2.x could help. Back then, all the elaborate AJAX stuff wasn't applied to the query text input.