开启记录history的参数是以下这个，当设置为true后就能将用户操作的sql记录在配合pmyadmin的pma_history中
$cfg['QueryHistoryDB']='true';//enable phpmyadmin record user sql

点击(此处)折叠或打开

<?php

/**

* Debian local configuration file

*

* This file overrides the settings made by phpMyAdmin interactive setup

* utility.

*

* For example configuration see

*/usr/share/doc/phpmyadmin/examples/config.sample.inc.php

* or

*/usr/share/doc/phpmyadmin/examples/config.manyhosts.inc.php

*

* NOTE: do not add security sensitive data to this file (like passwords)

* unless you really know what you're doing. If you do, any user that can

* run PHP or CGI on your webserver will be able to read them. If you still

* want to do this, make sure to properly secure the access to this file

* (also on the filesystem level).

*/

if (!function_exists('check_file_access')) {

function check_file_access($path)

{

if (is_readable($path)) {

return true;

} else {

error_log(

'phpmyadmin: Failed to load ' . $path

. ' Check group www-data has read access and open_basedir restrictions.'

);

return false;

}

}

}

// Load secret generated on postinst

if (check_file_access('/var/lib/phpmyadmin/blowfish_secret.inc.php')) {

require('/var/lib/phpmyadmin/blowfish_secret.inc.php');

}

// Load autoconf local config

if (check_file_access('/var/lib/phpmyadmin/config.inc.php')) {

require('/var/lib/phpmyadmin/config.inc.php');

}

/**

* Server(s) configuration

*/

$i = 0;

// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].

// You can disable a server config entry by setting host to ''.

$i++;

/**

* Read configuration from dbconfig-common

* You can regenerate it using: dpkg-reconfigure -plow phpmyadmin

*/

if (check_file_access('/etc/phpmyadmin/config-db.php')) {

require('/etc/phpmyadmin/config-db.php');

}

/* Configure according to dbconfig-common if enabled */

if (!empty($dbname)) {

/* Authentication type */

$cfg['Servers'][$i]['auth_type'] = 'cookie';

/* Server parameters */

if (empty($dbserver)) $dbserver = 'localhost';

$cfg['Servers'][$i]['host'] = $dbserver;

if (!empty($dbport) || $dbserver != 'localhost') {

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['port'] = $dbport;

}

//$cfg['Servers'][$i]['compress'] = false;

/* Select mysqli if your server has it */

$cfg['Servers'][$i]['extension'] = 'mysqli';

/* Optional: User for advanced features */

$cfg['Servers'][$i]['controluser'] = $dbuser;

$cfg['Servers'][$i]['controlpass'] = $dbpass;

$cfg['QueryHistoryDB'] = 'true'; //enable phpmyadmin record user sql

//$cfg['QueryHistoryMax'] = '100'; //specify the amount of saved history sql

// Allow connection to server name ending with -mysql:

$cfg['ArbitraryServerRegexp'] = '@^[^:]\-mysql$@';

/* Optional: Advanced phpMyAdmin features */

$cfg['Servers'][$i]['pmadb'] = $dbname;

$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]['table_uiprefs'] = 'pma__table_uiprefs';

$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';

$cfg['Servers'][$i]['tracking'] = 'pma__tracking';

$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';

$cfg['Servers'][$i]['recent'] = 'pma__recent';

/* Uncomment the following to enable logging in to passwordless accounts,

* after taking note of the associated security risks. */

// $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

/* Advance to next server for rest of config */

$i++;

}

/* Server: XXXXXX.com,1234 [1] */

$i++;

$cfg['Servers'][$i]['verbose'] = 'XXXXXX.com,1234';

$cfg['Servers'][$i]['host'] = 'XXXXXX.com';

$cfg['Servers'][$i]['port'] = 1234;

$cfg['Servers'][$i]['socket'] = '';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['extension'] = 'mysql';

$cfg['Servers'][$i]['auth_type'] = 'cookie';

$cfg['Servers'][$i]['user'] = '';

$cfg['Servers'][$i]['password'] = '';

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

$cfg['Servers'][$i]['controluser'] = 'pma';

$cfg['Servers'][$i]['controlpass'] = 'pmapassword';

$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';

$cfg['Servers'][$i]['relation'] = 'pma__relation';

$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';

$cfg['Servers'][$i]['table_info'] = 'pma__table_info';

$cfg['Servers'][$i]['column_info'] = 'pma__column_info';

$cfg['Servers'][$i]['history'] = 'pma__history';

$cfg['Servers'][$i]['recent'] = 'pma__recent';

$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';

$cfg['Servers'][$i]['tracking'] = 'pma__tracking';

$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';

$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';

$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';

$cfg['Servers'][$i]['tracking_version_auto_create'] = true;

$cfg['QueryHistoryDB'] = 'true'; //enable phpmyadmin record user sql

//$cfg['QueryHistoryMax'] = '100'; //specify the amount of saved history sql

/* End of servers configuration */

/* Authentication type */

//$cfg['Servers'][$i]['auth_type'] = 'cookie';

/* Server parameters */

//$cfg['Servers'][$i]['host'] = 'localhost';

//$cfg['Servers'][$i]['connect_type'] = 'tcp';

//$cfg['Servers'][$i]['compress'] = false;

/* Select mysqli if your server has it */

//$cfg['Servers'][$i]['extension'] = 'mysql';

/* Optional: User for advanced features */

// $cfg['Servers'][$i]['controluser'] = 'pma';

// $cfg['Servers'][$i]['controlpass'] = 'pmapass';

/* Storage database and tables */

// $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]['table_uiprefs'] = 'pma_table_uiprefs';

// $cfg['Servers'][$i]['tracking'] = 'pma_tracking';

// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

// $cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

// $cfg['Servers'][$i]['recent'] = 'pma_recent';

/* Uncomment the following to enable logging in to passwordless accounts,

* after taking note of the associated security risks. */

// $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

/*

* End of servers configuration

*/

/*

* Directories for saving/loading files from server

*/

$cfg['UploadDir'] = '';

$cfg['SaveDir'] = '';

/* Support additional configurations */

foreach (glob('/etc/phpmyadmin/conf.d/*.php') as $filename)

{

include($filename);

}

/* Display warning on main page if the MySQL library and server version is diff */

$cfg['ServerLibraryDifference_DisableWarning'] = 'true';