php
MyAdmin
setup
Overview
Export
Features
Import
Main panel
Navigation panel
SQL queries
Features
General
Databases
Text fields
Page titles
Warnings
Console
Import / export
Security
Developer
Other core settings
General
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
Open
Closed
Disabled
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.
Ask before sending error reports
Always send error reports
Never send 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
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Databases
Databases
Maximum databases
Maximum number of databases displayed in database list.
Maximum tables
Maximum number of tables displayed in table list.
Server connection collation
Text fields
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.
input
textarea
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.
Page titles
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.
Warnings
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
Console mode
info
show
collapse
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
exec
time
count
Order
asc
desc
Import / export
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.
auto
iconv
mb
none
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.
Security
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.
Developer
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
Other core settings
Settings that didn't fit anywhere else.
Other core settings
GZip output buffering
Use GZip output buffering for increased speed in HTTP transfers.
auto
Yes
No
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.