2

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.

3
  • 2
    Maybe this question is better suited at Stackoverflow.com
    – Mateng
    Nov 8, 2012 at 22:39
  • Are you looking for a kind of MySQL query history?
    – Mateng
    Nov 8, 2012 at 22:57
  • 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.
    – Cormite
    Nov 8, 2012 at 23:56

2 Answers 2

1

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

4
  • 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.
    – Cormite
    Nov 9, 2012 at 6:12
  • The demo works fine in my FF15 (on Win7). I assume it all might be a problem with your browser.
    – Mateng
    Nov 9, 2012 at 9:33
  • 1
    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.
    – Mateng
    Nov 10, 2012 at 13:52
  • 1
    Downgrading helped; however, the weird things is that afterwards I upgraded again and it worked fine. Probably, something went really wrong on the first install. Thank you very much.
    – Cormite
    Nov 12, 2012 at 21:39
0

You probably want to have a look at the MySQL Query Log rather than phpMyAdmin

1
  • 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.
    – Cormite
    Nov 8, 2012 at 23:57

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .