phpMyAdmin setup

Set import and export directories and compression options

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	autoiconvrecode (unavailable)none i
Extra parameters for iconv
ZIP Enable ZIP compression for import and export operations	i
GZip Enable gzip compression for import and export operations
Bzip2 Enable bzip2 compression for import and export operations	i
Compress on the fly Compress gzip/bzip2 exports on the fly without the need for much memory; if you encounter problems with created gzip/bzip2 files disable this feature

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

Blowfish secret Secret passphrase used for encrypting cookies in cookie authentication
Force SSL connection Force secured connection while using phpMyAdmin
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
Recall user name Define whether the previous login should be recalled or not in cookie authentication mode
Login cookie validity Define how long (in seconds) a login cookie is valid
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.

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

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

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 A warning is displayed on the main page if Suhosin is detected
mcrypt warning Disable the default warning that is displayed if mcrypt is missing for cookie authentication

Settings for phpMyAdmin developers

Enable the Developer tab in settings When disabled, users cannot set any of the options below, regardless of the checkbox on the right
Display errors
Gather errors
Debug SQL

Settings that didn't fit enywhere else

Enable Ajax Improves efficiency of screen refresh
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	OpenClosedDisabled
Iconic errors Show icons for warning, error and information messages
Show help button Show help button instead of Documentation text
Maximum databases Maximum number of databases displayed in left frame and database list
Maximum tables Maximum number of tables displayed in table list
Show hint Whether to show hint or not
GZip output buffering use GZip output buffering for increased speed in HTTP transfers	autoyesno
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, eg. 32M (0 for no limit)
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.
Use database search Allow for searching inside the entire database
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 attacks