Generic settings

$cfg['DisableShortcutKeys']

You can disable phpMyAdmin shortcut keys by setting $cfg['DisableShortcutKeys'] to false.

$cfg['ServerDefault']

If you have more than one server configured, you can set $cfg['ServerDefault'] to any one of them to autoconnect to that server when phpMyAdmin is started, or set it to 0 to be given a list of servers without logging in.

If you have only one server configured, $cfg['ServerDefault'] MUST be set to that server.

$cfg['VersionCheck']

Enables check for latest versions using JavaScript on the main phpMyAdmin page or by directly accessing version_check.php.

注解

This setting can be adjusted by your vendor.

$cfg['ProxyUrl']

The url of the proxy to be used when phpmyadmin needs to access the outside internet such as when retrieving the latest version info or submitting error reports. You need this if the server where phpMyAdmin is installed does not have direct access to the internet. The format is: “hostname:portnumber”

$cfg['ProxyUser']

连接代理服务器时使用的用户名。如果提供用户名，将使用基本认证方式连接。目前还不支持其他认证方式。

$cfg['ProxyPass']

代理服务的密码.

$cfg['MaxDbList']

The maximum number of database names to be displayed in the main panel’s database list.

$cfg['MaxTableList']

The maximum number of table names to be displayed in the main panel’s list (except on the Export page).

$cfg['ShowHint']

Whether or not to show hints (for example, hints when hovering over table headers).

$cfg['MaxCharactersInDisplayedSQL']

The maximum number of characters when a SQL query is displayed. The default limit of 1000 should be correct to avoid the display of tons of hexadecimal codes that represent BLOBs, but some users have real SQL queries that are longer than 1000 characters. Also, if a query’s length exceeds this limit, this query is not saved in the history.

$cfg['PersistentConnections']

Whether persistent connections should be used or not. Works with following extensions:

• mysql (mysql_pconnect),
• mysqli (requires PHP 5.3.0 or newer, more information).

$cfg['ForceSSL']

4.6.0 版后已移除: This setting is no longer available since phpMyAdmin 4.6.0. Please adjust your webserver instead.

Whether to force using https while accessing phpMyAdmin. In a reverse proxy setup, setting this to true is not supported.

注解

In some setups (like separate SSL proxy or load balancer) you might have to set $cfg['PmaAbsoluteUri'] for correct redirection.

$cfg['ExecTimeLimit']

Set the number of seconds a script is allowed to run. If seconds is set to zero, no time limit is imposed. This setting is used while importing/exporting dump files but has no effect when PHP is running in safe mode.

$cfg['SessionSavePath']

Path for storing session data (session_save_path PHP parameter).

警告

This folder should not be publicly accessible through the webserver, otherwise you risk leaking private data from your session.

$cfg['MemoryLimit']

Set the number of bytes a script is allowed to allocate. If set to '-1', no limit is imposed. If set to '0', no change of the memory limit is attempted and the php.ini memory_limit is used.

This setting is used while importing/exporting dump files so you definitely don’t want to put here a too low value. It has no effect when PHP is running in safe mode.

You can also use any string as in php.ini, eg. ‘16M’. Ensure you don’t omit the suffix (16 means 16 bytes!)

$cfg['SkipLockedTables']

标记正在使用的表以使得可以显示含有已锁定表的数据库 (自 MySQL 3.23.30 起) 。

$cfg['ShowSQL']

Defines whether SQL queries generated by phpMyAdmin should be displayed or not.

$cfg['RetainQueryBox']

Defines whether the SQL query box should be kept displayed after its submission.

$cfg['CodemirrorEnable']

Defines whether to use a Javascript code editor for SQL query boxes. CodeMirror provides syntax highlighting and line numbers. However, middle-clicking for pasting the clipboard contents in some Linux distributions (such as Ubuntu) is not supported by all browsers.

$cfg['DefaultForeignKeyChecks']

Default value of the checkbox for foreign key checks, to disable/enable foreign key checks for certain queries. The possible values are 'default', 'enable' or 'disable'. If set to 'default', the value of the MySQL variable FOREIGN_KEY_CHECKS is used.

$cfg['AllowUserDropDatabase']

警告

This is not a security measure as there will be always ways to circumvent this. If you want to prohibit users from dropping databases, revoke their corresponding DROP privilege.

Defines whether normal users (non-administrator) are allowed to delete their own database or not. If set as false, the link Drop Database will not be shown, and even a DROP DATABASE mydatabase will be rejected. Quite practical for ISP ‘s with many customers.

This limitation of SQL queries is not as strict as when using MySQL privileges. This is due to nature of SQL queries which might be quite complicated. So this choice should be viewed as help to avoid accidental dropping rather than strict privilege limitation.

$cfg['Confirm']

Whether a warning (“Are your really sure…”) should be displayed when you’re about to lose data.

$cfg['UseDbSearch']

设置是否允许使用 “数据库搜索” 。

$cfg['IgnoreMultiSubmitErrors']

设置 phpMyAdmin 是否在执行多语句查询出错的时候继续执行。默认为中断执行。

$cfg['enable_drag_drop_import']

Whether or not the drag and drop import feature is enabled. When enabled, a user can drag a file in to their browser and phpMyAdmin will attempt to import the file.