phpMyAdmin setup

Features


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 conversioni 
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 Force secured connection while using phpMyAdmin 
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 Define whether the previous login should be recalled or not in cookie authentication mode 
Documentation Define how long (in seconds) a login cookie is valid
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 
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 if a difference between the MySQL library and server is detected
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 A warning is displayed on the main page if Suhosin is detected
Documentation Disable the default warning that is displayed if mcrypt is missing for cookie authentication
Developer

Settings for phpMyAdmin developers

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

Settings that didn't fit anywhere else

Documentation Use natural order for sorting table and database names
Documentation
Documentation Maximum number of databases displayed in database list
Documentation Maximum number of tables displayed in table list
Documentation Maximum number of recently used tables; set 0 to disable
Documentation Whether to show hint or not
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 (0 for no limit) 
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 Allow for searching inside the entire database 
Documentation Enables check for latest version on main phpMyAdmin page
Documentation Choose the default action when sending error reports
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 attacks