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

?>
krijger
 
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:
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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

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


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 128 guests