phpMyAdmin setup

Features

Set some commonly used options.

General

Version check Enables check for latest version on main phpMyAdmin page.
Natural order Use natural order for sorting table and database names.
Initial state for sliders
Login cookie validity Define how long (in seconds) a login cookie is valid.
Skip locked tables Mark used tables and make it possible to show databases with locked tables.
Disable multi table maintenance Disable the table maintenance mass operations, like optimizing or repairing the selected tables of a database.
Show hint Whether to show hint or not.
Send error reports Choose the default action when sending error reports.
Enter executes queries in console Queries are executed by pressing Enter (instead of Ctrl+Enter). New lines will be inserted with Shift+Enter.
Disable shortcut keys Disable shortcut keys
First day of calendar

Databases

Maximum databases Maximum number of databases displayed in database list.
Maximum tables Maximum number of tables displayed in table list.
Server connection collation

Customize text input fields.

Text fields

CHAR columns editing Defines which type of editing controls should be used for CHAR and VARCHAR columns; `input` - allows limiting of input length, `textarea` - allows newlines in columns.
Minimum size for input field Defines the minimum size for input fields generated for CHAR and VARCHAR columns.
Maximum size for input field Defines the maximum size for input fields generated for CHAR and VARCHAR columns.
CHAR textarea columns Number of columns for CHAR/VARCHAR textareas.
CHAR textarea rows Number of rows for CHAR/VARCHAR textareas.
Textarea columns Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2).
Textarea rows Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2).
Bigger textarea for LONGTEXT Double size of textarea for LONGTEXT columns.

Specify browser's title bar text. Refer to documentation for magic strings that can be used to get special values.

Page titles

Default title Title of browser window when nothing is selected.
Table Title of browser window when a table is selected.
Database Title of browser window when a database is selected.
Server Title of browser window when a server is selected.

Disable some of the warnings shown by phpMyAdmin.

Warnings

Missing phpMyAdmin configuration storage tables Disable the default warning that is displayed on the database details Structure page if any of the required tables for the phpMyAdmin configuration storage could not be found.
Suhosin warning Disable the default warning that is displayed on the main page if Suhosin is detected.
Login cookie validity warning Disable the default warning that is displayed on the main page if the value of the PHP setting session.gc_maxlifetime is less than the value of `LoginCookieValidity`.
MySQL reserved word warning Disable the default warning that is displayed on the Structure page if column names in a table are reserved MySQL words.

Console

Console mode
Show query history at start
Always expand query messages
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter
Switch to dark theme
Console height
Group queries
Order by
Order

Set import and export directories and compression options.

Import / export

Upload directory Directory on server where you can upload files for import.
Save directory Directory where exports can be saved on server.
Recoding engine Select which functions will be used for character set conversion.
Extra parameters for iconv
ZIP Enable ZIP compression for import and export operations.
GZip Enable gzip compression for import and export operations.
Bzip2 Enable bzip2 compression for import operations.
Compress on the fly Compress gzip exports on the fly without the need for much memory; if you encounter problems with created gzip files disable this feature.

Please note that phpMyAdmin is just a user interface and its features do not limit MySQL.

Security

Blowfish secret Secret passphrase used for encrypting cookies in `cookie` authentication.
Check config file permissions
List of trusted proxies for IP allow/deny Input proxies as `IP: trusted HTTP header`. The following example specifies that phpMyAdmin should trust a HTTP_X_FORWARDED_FOR (X-Forwarded-For) header coming from the proxy 1.2.3.4: `1.2.3.4: HTTP_X_FORWARDED_FOR`.
Show "Drop database" link to normal users
Allow login to any MySQL server If enabled, user can enter any MySQL server in login form for cookie auth.
Restrict login to MySQL server Restricts the MySQL servers the user can enter when a login to an arbitrary MySQL server is enabled by matching the IP or hostname of the MySQL server to the given regular expression.
Recall user name Define whether the previous login should be recalled or not in `cookie` authentication mode.
Login cookie store Defines how long (in seconds) a login cookie should be stored in browser. The default of 0 means that it will be kept for the existing session only, and will be deleted as soon as you close the browser window. This is recommended for non-trusted environments.
Delete all cookies on logout If TRUE, logout deletes cookies for all servers; when set to FALSE, logout only occurs for the current server. Setting this to FALSE makes it easy to forget to log out from other servers when connected to multiple servers.
Public key for reCAPTCHA Enter your public key for the reCAPTCHA service on your domain.
Private key for reCAPTCHA Enter your private key for your domain reCAPTCHA service.
URL for reCAPTCHA siteverify Enter your siteverify URL for your reCAPTCHA service.

Settings for phpMyAdmin developers.

Developer

Enable the Developer tab in settings When disabled, users cannot set any of the options below, regardless of the checkbox on the right.
Debug SQL Log SQL queries and their execution time, to be displayed in the console

Settings that didn't fit anywhere else.

Other core settings

GZip output buffering Use GZip output buffering for increased speed in HTTP transfers.
Persistent connections Use persistent connections to MySQL databases.
Maximum execution time Set the number of seconds a script is allowed to run (`0` for no limit).
Memory limit The number of bytes a script is allowed to allocate, e.g. `32M` (`-1` for no limit and `0` for no change).
Use database search Allow for searching inside the entire database.
Proxy URL The URL of the proxy to be used when retrieving the information about the latest version of phpMyAdmin, or when 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".
Proxy username 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.
Proxy password The password for authenticating with the proxy.
Allow third party framing Enabling this allows a page located on a different domain to call phpMyAdmin inside a frame, and is a potential security hole allowing cross-frame scripting (XSS) attacks.
Enable Zero Configuration mode Enable Zero Configuration mode which lets you set up phpMyAdmin configuration storage tables automatically.