Generic settings

$cfg['DisableShortcutKeys']
Type: boolean
Default value: false

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

$cfg['ServerDefault']
Type: integer
Default value: 1

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']
Type: boolean
Default value: true

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

Note

This setting can be adjusted by your vendor.

$cfg['ProxyUrl']
Type: string
Default value: ""

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']
Type: string
Default value: ""

The username for authenticating with the proxy. By default, no authentication is performed. If a username is supplied, Basic Authentication will be performed. No other types of authentication are currently supported.

$cfg['ProxyPass']
Type: string
Default value: ""

The password for authenticating with the proxy.

$cfg['MaxDbList']
Type: integer
Default value: 100

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

$cfg['MaxTableList']
Type: integer
Default value: 250

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

$cfg['ShowHint']
Type: boolean
Default value: true

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

$cfg['MaxCharactersInDisplayedSQL']
Type: integer
Default value: 1000

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']
Type: boolean
Default value: false

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

$cfg['ForceSSL']
Type: boolean
Default value: false

Deprecated since version 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.

Note

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

$cfg['ExecTimeLimit']
Type: integer [number of seconds]
Default value: 300

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']
Type: string
Default value: ''

Path for storing session data (session_save_path PHP parameter).

Warning

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

$cfg['MemoryLimit']
Type: string [number of bytes]
Default value: '-1'

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']
Type: boolean
Default value: false

Mark used tables and make it possible to show databases with locked tables (since MySQL 3.23.30).

$cfg['ShowSQL']
Type: boolean
Default value: true

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

$cfg['RetainQueryBox']
Type: boolean
Default value: false

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

$cfg['CodemirrorEnable']
Type: boolean
Default value: true

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']
Type: string
Default value: 'default'

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']
Type: boolean
Default value: false

Warning

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']
Type: boolean
Default value: true

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

$cfg['UseDbSearch']
Type: boolean
Default value: true

Define whether the "search string inside database" is enabled or not.

$cfg['IgnoreMultiSubmitErrors']
Type: boolean
Default value: false

Define whether phpMyAdmin will continue executing a multi-query statement if one of the queries fails. Default is to abort execution.

$cfg['enable_drag_drop_import']
Type: boolean
Default value: true

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.