phpMyAdmin setup

Features

General

Set some commonly used options.

Documentation Enables check for latest version on main phpMyAdmin page.
Documentation Use natural order for sorting table and database names.
Documentation
Documentation Mark used tables and make it possible to show databases with locked tables.
Documentation Disable the table maintenance mass operations, like optimizing or repairing the selected tables of a database.
Documentation Whether to show hint or not.
Documentation Choose the default action when sending error reports.
Documentation Queries are executed by pressing Enter (instead of Ctrl+Enter). New lines will be inserted with Shift+Enter.
Documentation Disable shortcut keys
Documentation
Databases
Documentation Maximum number of databases displayed in database list.
Documentation Maximum number of tables displayed in table list.
Documentation
Text fields

Customize text input fields.

Documentation 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.
Documentation Defines the minimum size for input fields generated for CHAR and VARCHAR columns.
Documentation Defines the maximum size for input fields generated for CHAR and VARCHAR columns.
Documentation Number of columns for CHAR/VARCHAR textareas.
Documentation Number of rows for CHAR/VARCHAR textareas.
Documentation Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2).
Documentation Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2).
Documentation Double size of textarea for LONGTEXT columns.
Page titles

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

Documentation Title of browser window when nothing is selected.
Documentation Title of browser window when a table is selected.
Documentation Title of browser window when a database is selected.
Documentation Title of browser window when a server is selected.
Warnings

Disable some of the warnings shown by phpMyAdmin.

Documentation 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.
Documentation Disable the default warning that is displayed on the main page if Suhosin is detected.
Documentation 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`.
Documentation Disable the default warning that is displayed on the Structure page if column names in a table are reserved MySQL words.
Console
Documentation
Documentation
Documentation
Documentation
Documentation
Documentation
Documentation
Documentation
Documentation
Documentation
Import / export

Set import and export directories and compression options.

Documentation Directory on server where you can upload files for import. 
Documentation Directory where exports can be saved on server. 
Documentation Select which functions will be used for character set conversion. 
Documentation  
Documentation Enable ZIP compression for import and export operations. 
Documentation Enable gzip compression for import and export operations. 
Documentation Enable bzip2 compression for import operations. 
Documentation Compress gzip exports on the fly without the need for much memory; if you encounter problems with created gzip files disable this feature. 
Security

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

Documentation Secret passphrase used for encrypting cookies in cookie authentication. 
Documentation  
Documentation 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.
 
Documentation  
Documentation If enabled, user can enter any MySQL server in login form for cookie auth. 
Documentation 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. 
Documentation Define whether the previous login should be recalled or not in cookie authentication mode. 
Documentation 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. 
Documentation 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. 
Documentation Enter your public key for your domain reCaptcha service. 
Documentation Enter your private key for your domain reCaptcha service. 
Developer

Settings for phpMyAdmin developers.

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

Settings that didn't fit anywhere else.

Documentation Use GZip output buffering for increased speed in HTTP transfers. 
Documentation Use persistent connections to MySQL databases. 
Documentation Set the number of seconds a script is allowed to run (0 for no limit). 
Documentation The number of bytes a script is allowed to allocate, eg. 32M (-1 for no limit and 0 for no change). 
Documentation Allow for searching inside the entire database. 
Documentation 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". 
Documentation 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. 
Documentation The password for authenticating with the proxy. 
Documentation 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. 
Documentation Enable Zero Configuration mode which lets you setup phpMyAdmin configuration storage tables automatically.