pma_history remains empty

Problems with the Windows version of XAMPP, questions, comments, and anything related.

pma_history remains empty

Postby krijger » 07. May 2012 12:36

Hi all,

For development purposes I'm using Xampp 1.7.7. First of all, thank you for a great product!

I do have a slight issue. As I'm debugging I'd like to view an entire SQL history. As far as I know this should be doable with the 'pma' user working and the pma_* setup, and some config settings. See below for my

The problem is all pma_* tables remain empty (apart from one record in pma_userconfig).
I looked in the docs and googled for quite some time but was unable to find a solution. Do I need additional config settings?

Currently I've only changed the pma_password (which was blank first) but didn't appear to make any difference. Reinstalling Xampp I'd rather avoid as it would take quite some backing up and restoring.

Hope someone has any suggestions.

Code: Select all
 * This is needed for cookie based authentication to encrypt password in
 * cookie
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

 * Servers configuration
$i = 0;

 * First server

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'Welcome1';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '<something>'; 

/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

 * End of servers configuration

Posts: 1
Joined: 07. May 2012 12:28
Operating System: Windows 7

Re: pma_history remains empty

Postby Altrea » 07. May 2012 16:14

Hi krijger,

krijger wrote:As I'm debugging I'd like to view an entire SQL history.
I looked in the docs

So you should have already read this sentence of the official documentation: wrote:Since release 2.5.0 you can store your SQL history, which means all queries you entered manually into the phpMyAdmin interface.

are you sure phpMyAdmin history is the functionality you missed?

best wishes,
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
AF Moderator
Posts: 8243
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 48 guests