Apache Friends Support Forum

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 config.inc.php.

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

<?php
/*
 * 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
 */
$i++;

/* 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
 */

?>

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:

http://www.phpmyadmin.net/documentation/#cfg_Servers_history 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,
Altrea