phpMyAdmin setup

Features


Import / export

Set import and export directories and compression options

Doc Wiki Directory on server where you can upload files for import  
Doc Wiki Directory where exports can be saved on server  
Doc Wiki Select which functions will be used for character set conversion i  
Doc Wiki  
Doc Wiki Enable ZIP compression for import and export operations i  
Doc Wiki Enable gzip compression for import and export operations  
Doc Wiki Enable bzip2 compression for import and export operations i  
Doc Wiki 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  
Security

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

Doc Wiki Secret passphrase used for encrypting cookies in cookie authentication  
Doc Wiki Force secured connection while using phpMyAdmin  
Doc Wiki  
Doc Wiki 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
 
Doc Wiki  
Doc Wiki If enabled user can enter any MySQL server in login form for cookie auth  
Doc Wiki Define whether the previous login should be recalled or not in cookie authentication mode  
Doc Wiki Define how long (in seconds) a login cookie is valid
Doc Wiki 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.  
Doc Wiki 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.  
Page titles

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

Doc Wiki Title of browser window when nothing is selected
Doc Wiki Title of browser window when a table is selected
Doc Wiki Title of browser window when a database is selected
Doc Wiki Title of browser window when a server is selected
Warnings

Disable some of the warnings shown by phpMyAdmin

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

Settings for phpMyAdmin developers

Doc Wiki When disabled, users cannot set any of the options below, regardless of the checkbox on the right  
Doc Wiki
Doc Wiki
Doc Wiki
Other core settings

Settings that didn't fit enywhere else

Doc Wiki Improves efficiency of screen refresh
Doc Wiki Enables check for latest version on main phpMyAdmin page
Doc Wiki Use natural order for sorting table and database names
Doc Wiki
Doc Wiki Show icons for warning, error and information messages
Doc Wiki Show help button instead of Documentation text
Doc Wiki Maximum number of databases displayed in left frame and database list comment
Doc Wiki Maximum number of tables displayed in table list comment
Doc Wiki use GZip output buffering for increased speed in HTTP transfers  
Doc Wiki Use persistent connections to MySQL databases  
Doc Wiki Set the number of seconds a script is allowed to run (0 for no limit)  
Doc Wiki The number of bytes a script is allowed to allocate, eg. 32M (0 for no limit)  
Doc Wiki Mark used tables and make it possible to show databases with locked tables
Doc Wiki Allow for searching inside the entire database  
Doc Wiki 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