1.1 My server is crashing each time a specific action is required or phpMyAdmin sends a blank page or a page full of cryptic characters to my browser, what can I do?

1.4 Using phpMyAdmin on IIS, I’m displayed the error message: “The specified CGI application misbehaved by not returning a complete set of HTTP headers …”.

1.4 Using phpMyAdmin on IIS, I'm displayed the error message: "The specified CGI application misbehaved by not returning a complete set of HTTP headers ...".

1.5 Using phpMyAdmin on IIS, I’m facing crashes and/or many error messages with the HTTP.

1.5 Using phpMyAdmin on IIS, I'm facing crashes and/or many error messages with the HTTP.

1.7 How can I gzip a dump or a CSV export? It does not seem to work.

1.8 I cannot insert a text file in a table, and I get an error about safe mode being in effect.

1.10 I’m having troubles when uploading files with phpMyAdmin running on a secure server. My browser is Internet Explorer and I’m using the Apache server.

1.10 I'm having troubles when uploading files with phpMyAdmin running on a secure server. My browser is Internet Explorer and I'm using the Apache server.

1.11 I get an 'open\_basedir restriction' while uploading a file from the import tab.

1.16 I cannot upload big dump files (memory, HTTP or timeout problems).

1.17a I cannot connect to the MySQL server. It always returns the error message, “Client does not support authentication protocol requested by server; consider upgrading MySQL client”

1.17a I cannot connect to the MySQL server. It always returns the error message, "Client does not support authentication protocol requested by server; consider upgrading MySQL client"

1.19 I can’t run the “display relations” feature because the script seems not to know the font face I’m using!

1.19 I can't run the "display relations" feature because the script seems not to know the font face I'm using!

1.20 I receive an error about missing mysqli and mysql extensions.

1.21 I am running the CGI version of PHP under Unix, and I cannot log in using cookie auth.

1.22 I don’t see the “Location of text file” field, so I cannot upload.

1.22 I don't see the "Location of text file" field, so I cannot upload.

1.23 I’m running MySQL on a Win32 machine. Each time I create a new table the table and column names are changed to lowercase!

1.23 I'm running MySQL on a Win32 machine. Each time I create a new table the table and column names are changed to lowercase!

1.25 I am running Apache with mod\_gzip-1.3.26.1a on Windows XP, and I get problems, such as undefined variables when I run a SQL query.

1.26 I just installed phpMyAdmin in my document root of IIS but I get the error “No input file specified” when trying to run phpMyAdmin.

1.26 I just installed phpMyAdmin in my document root of IIS but I get the error "No input file specified" when trying to run phpMyAdmin.

1.27 I get empty page when I want to view huge page (eg. db\_structure.php with plenty of tables).

1.28 My MySQL server sometimes refuses queries and returns the message ‘Errorcode: 13’. What does this mean?

1.28 My MySQL server sometimes refuses queries and returns the message 'Errorcode: 13'. What does this mean?

1.29 When I create a table or modify a column, I get an error and the columns are duplicated.

1.37 I run phpMyAdmin on cluster of different machines and password encryption in cookie auth doesn’t work.

1.37 I run phpMyAdmin on cluster of different machines and password encryption in cookie auth doesn't work.

1.38 Can I use phpMyAdmin on a server on which Suhosin is enabled?

1.39 When I try to connect via https, I can log in, but then my connection is redirected back to http. What can cause this behavior?

1.40 When accessing phpMyAdmin via an Apache reverse proxy, cookie login does not work.

1.41 When I view a database and ask to see its privileges, I get an error about an unknown column.

1.43 Why can’t I display the structure of my table containing hundreds of columns?

1.43 Why can't I display the structure of my table containing hundreds of columns?

1.45 I get an error message about unknown authentication method caching_sha2_password when trying to log in

2.1 The error message “Warning: Cannot add header information - headers already sent by …” is displayed, what’s the problem?

2.1 The error message "Warning: Cannot add header information - headers already sent by ..." is displayed, what's the problem?

2.3 The error message “Warning: MySQL Connection Failed: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (111) …” is displayed. What can I do?

2.3 The error message "Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) ..." is displayed. What can I do?

2.4 Nothing is displayed by my browser when I try to run phpMyAdmin, what can I do?

2.5 Each time I want to insert or change a row or drop a database or a table, an error 404 (page not found) is displayed or, with HTTP or cookie authentication, I’m asked to log in again. What’s wrong?

2.5 Each time I want to insert or change a row or drop a database or a table, an error 404 (page not found) is displayed or, with HTTP or cookie authentication, I'm asked to log in again. What's wrong?

’ (Using password: YES)”-error when trying to access a MySQL-Server on a host which is port-forwarded for my localhost.

' (Using password: YES)"-error when trying to access a MySQL-Server on a host which is port-forwarded for my localhost.

3.1 When using HTTP authentication, a user who logged out can not log in again in with the same nick.

3.2 When dumping a large table in compressed mode, I get a memory limit error or a time limit error.

3.3 With InnoDB tables, I lose foreign key relationships when I rename a table or a column.

3.4 I am unable to import dumps I created with the mysqldump tool bundled with the MySQL server distribution.

3.5 When using nested folders, multiple hierarchies are displayed in a wrong manner.

3.7 I have table with many (100+) columns and when I try to browse table I get series of errors like “Warning: unable to parse url”. How can this be fixed?

3.7 I have table with many (100+) columns and when I try to browse table I get series of errors like "Warning: unable to parse url". How can this be fixed?

3.8 I cannot use (clickable) HTML-forms in columns where I put a MIME-Transformation onto!

3.9 I get error messages when using "--sql\_mode=ANSI" for the MySQL server.

3.10 Homonyms and no primary key: When the results of a SELECT display more that one column with the same value (for example 

 and two “Smith” values are displayed), if I click Edit I cannot be sure that I am editing the intended row.

 and two "Smith" values are displayed), if I click Edit I cannot be sure that I am editing the intended row.

3.14 I am not able to browse a table when I don’t have the right to SELECT one of the columns.

3.14 I am not able to browse a table when I don't have the right to SELECT one of the columns.

3.18 When I import a CSV file that contains multiple tables, they are lumped together into a single table.

3.19 When I import a file and have phpMyAdmin determine the appropriate data structure it only uses int, decimal, and varchar types.

3.20 After upgrading, some bookmarks are gone or their content cannot be shown.

3.21 I am unable to log in with a username containing unicode characters such as á.

4.1 I’m an ISP. Can I setup one central copy of phpMyAdmin or do I need to install it for each customer?

4.1 I'm an ISP. Can I setup one central copy of phpMyAdmin or do I need to install it for each customer?

4.2 What’s the preferred way of making phpMyAdmin secure against evil access?

4.2 What's the preferred way of making phpMyAdmin secure against evil access?

4.4 phpMyAdmin always gives “Access denied” when using HTTP authentication.

4.4 phpMyAdmin always gives "Access denied" when using HTTP authentication.

4.8 Which parameters can I use in the URL that starts phpMyAdmin?

5.1 I get an out of memory error, and my controls are non-functional, when trying to create a table with more than 14 columns.

5.3 I have problems dumping tables with Konqueror (phpMyAdmin 2.2.2).

5.4 I can’t use the cookie authentication mode because Internet Explorer never stores the cookies.

5.4 I can't use the cookie authentication mode because Internet Explorer never stores the cookies.

5.7 I refresh (reload) my browser, and come back to the welcome page.

5.8 With Mozilla 0.9.7 I have problems sending a query modified in the query box.

5.9 With Mozilla 0.9.? to 1.0 and Netscape 7.0-PR1 I can’t type a whitespace in the SQL-Query edit area: the page scrolls down.

5.9 With Mozilla 0.9.? to 1.0 and Netscape 7.0-PR1 I can't type a whitespace in the SQL-Query edit area: the page scrolls down.

5.11 Extended-ASCII characters like German umlauts are displayed wrong.

5.16 With Internet Explorer, I get “Access is denied” Javascript errors. Or I cannot make phpMyAdmin work under Windows.

5.16 With Internet Explorer, I get "Access is denied" Javascript errors. Or I cannot make phpMyAdmin work under Windows.

5.17 With Firefox, I cannot delete rows of data or drop a database.

5.21 I get errors about potentially unsafe operation when browsing table or executing SQL query.

6.1 I can’t insert new rows into a table / I can’t create a table - MySQL brings up a SQL error.

6.1 I can't insert new rows into a table / I can't create a table - MySQL brings up a SQL error.

6.2 When I create a table, I set an index for two columns and phpMyAdmin generates only one index with those two columns.

6.5 How can I restore (upload) my database or table using a dump? How can I run a “.sql” file?

6.5 How can I restore (upload) my database or table using a dump? How can I run a ".sql" file?

6.10 When creating a privilege, what happens with underscores in the database name?

6.15 I want to add a BLOB column and put an index on it, but MySQL says “BLOB column ‘…’ used in key specification without a key length”.

6.15 I want to add a BLOB column and put an index on it, but MySQL says "BLOB column '...' used in key specification without a key length".

6.17 Transformations: I can’t enter my own mimetype! What is this feature then useful for?

6.17 Transformations: I can't enter my own mimetype! What is this feature then useful for?

6.18 Bookmarks: Where can I store bookmarks? Why can’t I see any bookmarks below the query box? What are these variables for?

6.18 Bookmarks: Where can I store bookmarks? Why can't I see any bookmarks below the query box? What are these variables for?

6.19 How can I create simple LATEX document to include exported table?

6.20 I see a lot of databases which are not mine, and cannot access them.

6.21 In edit/insert mode, how can I see a list of possible values for a column, based on some foreign table?

6.22 Bookmarks: Can I execute a default bookmark automatically when entering Browse mode for a table?

6.23 Export: I heard phpMyAdmin can export Microsoft Excel files?

6.24 Now that phpMyAdmin supports native MySQL 4.1.x column comments, what happens to my column comments stored in pmadb?

6.39 What is the “Adjust privileges” option when renaming, copying, or moving a database, table, column, or procedure?

6.39 What is the "Adjust privileges" option when renaming, copying, or moving a database, table, column, or procedure?

6.40 I see “Bind parameters” checkbox in the “SQL” page. How do I write parameterized SQL queries?

6.40 I see "Bind parameters" checkbox in the "SQL" page. How do I write parameterized SQL queries?

6.41 I get import errors while importing the dumps exported from older MySQL versions (pre-5.7.6) into newer MySQL versions (5.7.7+), but they work fine when imported back on same older versions ?

7.2 I want to translate the messages to a new language or upgrade an existing language, where do I start?

7.3 I would like to help out with the development of phpMyAdmin. How should I proceed?

8.1 Where can I get information about the security alerts issued for phpMyAdmin?

8.3 Why are there path disclosures when directly loading certain files?

8.4 CSV files exported from phpMyAdmin could allow a formula injection attack.

Trouble logging back in after logging out using ‘http’ authentication

Trouble logging back in after logging out using 'http' authentication

Changed in version 3.4.0: Since phpMyAdmin 3.4.0 the default value is 'SMART'.

Changed in version 3.4.0: Prior to phpMyAdmin 3.4.0 this was called Linked Tables Infrastructure, but
the name was changed due to the extended scope of the storage.

Changed in version 4.6.5: This setting was not available in phpMyAdmin 4.6.0 - 4.6.4.

Changed in version 4.8.0: The default value was lowered to 50000 for performance reasons.

Changed in version 4.8.0: Before 4.8.0 the theme metadata was passed in the info.inc.php file.
It has been replaced by theme.json to allow easier parsing (without
need to handle PHP code) and to support additional features.

Deprecated since version 4.7.0: This setting was removed as the warning has been removed as well.

Deprecated since version 4.7.0: This setting is no longer used as of 4.7.0, since MySQL decides the
connection type based on host, so it could lead to unexpected results.
Please set $cfg['Servers'][$i]['host'] accordingly
instead.

Deprecated since version 4.7.0: This setting was removed as it can produce unexpected results.

Changed in version 4.7.0: The generated JSON structure has been changed in phpMyAdmin 4.7.0 to
produce valid JSON data.

Deprecated since version 4.6.0: This setting is no longer available since phpMyAdmin 4.6.0. Please
adjust your webserver instead.

New in version 3.0.0.0: This setting was named $cfg['Servers'][$i]['auth_feebee_config'] and was renamed before the 3.0.0.0 release.

Deprecated since version 4.6.4: This setting was removed because their servers are no longer working and it was not working correctly.

Deprecated since version 4.0.10.17: This setting was removed in a maintenance release because their servers are no longer working and it was not working correctly.

Changed in version 4.0.0: Previous versions permitted to specify the display order of
the database names via this directive.

Deprecated since version 4.2.0: This setting was removed. The mysql extension will only be used when
the mysqli extension is not available. As of 5.0.0, only the
mysqli extension can be used.

New in version 2.10.0: Since release 2.10.0 a Designer interface is available; it permits to
visually manage the relations.

Deprecated since version 4.3.0: This setting was removed and the Designer table positioning data is now stored into $cfg['Servers'][$i]['table_coords'].

Changed in version 5.1.0: Support for using the target parameter was removed in phpMyAdmin 5.1.0.
Use the route parameter instead.

Changed in version 3.1.0: Since version 3.1.0 phpMyAdmin can generate this on the fly, but it
makes a bit weaker security as this generated secret is stored in
session and furthermore it makes impossible to recall user name from
cookie.

Changed in version 5.2.0: Since version 5.2.0, phpMyAdmin uses the
sodium_crypto_secretbox and
sodium_crypto_secretbox_open PHP functions to encrypt
and decrypt cookies, respectively.

Changed in version 5.2.0: You need a browser which is supported by Bootstrap 5.0, see
<https://getbootstrap.com/docs/5.0/getting-started/browsers-devices/>.

Changed in version 5.0.0: The default value was changed from 2 to 7.

Deprecated since version 5.0.0: This setting was removed as the browser is more efficient,
thus no need of this option.

Changed in version 4.2.6: The default value was changed to 500000.

Changed in version 4.9.0: Support for using the pma_username and pma_password parameters was removed
in phpMyAdmin 4.9.0 (see PMASA-2019-4).

Changed in version 3.4.5: Since phpMyAdmin 3.4.5 support for direct export to Microsoft Excel version
97 and newer was dropped.

Changed in version 3.3.0: The XML schema used has changed as of version 3.3.0

configuration option; $cfg['ServerLibraryDifference_DisableWarning']

configuration option; $cfg['Servers'][$i]['tracking_version_auto_create']

configuration option; $cfg['Servers'][$i]['tracking_default_statements']

configuration option; $cfg['Servers'][$i]['tracking_add_drop_view']

configuration option; $cfg['Servers'][$i]['tracking_add_drop_table']

configuration option; $cfg['Servers'][$i]['tracking_add_drop_database']

configuration option; $cfg['Servers'][$i]['hide_connection_errors']

configuration option; $cfg['NavigationTreeDisplayItemFilterMinimum']

configuration option; $cfg['NavigationTreeDisplayDbFilterMinimum']

configuration option; $cfg['Export']['remove_definer_from_definitions']

configuration option; $cfg['EnableAutocompleteForTablesAndColumns']

configuration option; $cfg['DefaultTransformations']['Substring']

configuration option; $cfg['DefaultTransformations']['Bool2Text']

configuration option; $cfg['DefaultTransformations']['External']

configuration option; $cfg['DefaultTransformations']['PreApPend']

configuration option; $cfg['DefaultTransformations']['DateFormat']

configuration option; $cfg['DefaultTransformations']['TextImageLink']

configuration option; $cfg['DefaultTransformations']['TextLink']

1.11 I get an ‘open_basedir restriction’ while uploading a file from the import tab.

1.25 I am running Apache with mod_gzip-1.3.26.1a on Windows XP, and I get problems, such as undefined variables when I run a SQL query.

1.27 I get empty page when I want to view huge page (eg. db_structure.php with plenty of tables).

2.6 I get an “Access denied for user: ‘root@localhost’ (Using password: YES)”-error when trying to access a MySQL-Server on a host which is port-forwarded for my localhost.

3.9 I get error messages when using “–sql_mode=ANSI” for the MySQL server.

3.10 Homonyms and no primary key: When the results of a SELECT display more that one column with the same value (for example SELECT lastname from employees where firstname like 'A%' and two “Smith” values are displayed), if I click Edit I cannot be sure that I am editing the intended row.

3.13 I get an error when entering USE followed by a db name containing an hyphen.

4.3 I get errors about not being able to include a file in /lang or in /libraries.