共计 5925 个字符，预计需要花费 15 分钟才能阅读完成。
丸趣 TV 小编给大家分享一下 phpmyadmin 怎么配置，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！
开启记录 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
看完了这篇文章，相信你对“phpmyadmin 怎么配置”有了一定的了解，如果想了解更多相关知识，欢迎关注丸趣 TV 行业资讯频道，感谢各位的阅读！
