Knowledgebase

Support Center > Knowledgebase > phpMyAdmin > Server

• Can I directly access a database and/or table ?

  Yes. Out of the box, you can use URLs like http://server/pathTo/phpmyadmin/index.php?db=yourdb&table=yourtbl&target=script. Table and script parts...

• Can I use HTTP authentication with Apache CGI ?

  Yes. However you need to pass authentication variable to CGI using following rewrite rule: RewriteEngine On RewriteRule .* -...

• Can I use HTTP authentication with IIS ?

  Yes. This procedure was tested with phpMyAdmin 2.6.1, PHP 4.3.9 in ISAPI mode under IIS 5.1. In your php.ini file, set cgi.rfc2616_headers = 0...

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

  Yes but the default configuration values of Suhosin are known to cause problems with some operations, for example editing a table with many columns...

• Does phpMyAdmin support PHP 5 ?

  Yes. However, phpMyAdmin needs to be backwards compatible to PHP 4. This is why phpMyAdmin disables the E_STRICT error_level in...

• How can I zip, gzip or bzip2 a dump or a CSV export? It does not seem to work.

  These features are based on the gzencode() and bzcompress() PHP functions to be more independent of the platform (Unix/Windows, Safe Mode or not,...

• 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.

  A tip from Jose Fandos: put a comment on the following two lines in httpd.conf, like this: # mod_gzip_item_include file \.php$ #...

• I am running the CGI version of PHP under Unix, and I cannot login using cookie authentication.

  In php.ini, set mysql.max_links higher than 1.

• 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"

  You tried to access MySQL with an old MySQL client library. The version of your MySQL client library can be checked in your phpinfo() output. In...

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

  Your uploaded file is saved by PHP in the "upload dir", as defined in php.ini by the variable upload_tmp_dir (usually the system default is /tmp)....

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

  Starting with version phpMyAdmin 2.7.0, the import engine has been re–written and these problems should not occur. If possible, upgrade your...

• I get an empty page when I want to view a huge page (e.g. db_details_structure.php with plenty of tables).

  This is a PHP bug that occurs when gzip output buffering is enabled. If you turn it off (by $cfg['OBGzip'] = false in config.inc.php), it should...

• I get an error "500 Internal Server Error".

  There can be many explanations to this and a look at your server's error log file might give a clue. Furthermore, Internet Explorer defaults to...

• I get the error "left.php: Missing hash".

  This problem is known to happen when the server is running Turck MMCache but upgrading MMCache to version 2.3.21 solves the problem.

• I have lost my MySQL root password, what can I do ?

  The MySQL manual explains how to reset the permissions.

• I have problems with `mysql`.`user` field names.

  In older MySQL versions, the `User` and `Password` fields were named `user` and `password` (lowercase). Please modify your field names to align...

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

  This is a permission problem. Right-click on the phpmyadmin folder and choose properties. Under the tab Security, click on "Add" and select the...

• I receive the error "cannot load MySQL extension, please check PHP Configuration".

  To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution...

• Is there a problem with the mysqli extension when running PHP 5.0.4 on 64-bit systems ?

  Yes. This problem affects phpMyAdmin ("Call to undefined function pma_reloadnavigation"), so upgrade your PHP to the next version.

• My Apache server crashes when using phpMyAdmin.

  You should first try the latest versions of Apache (and possibly MySQL). See also the FAQ 1.1 entry about PHP bugs with output buffering. If your...

• Some characters are being truncated in my queries, or I get characters randomly added. I am running PHP 4.2.3.

  This is a PHP 4.2.3 bug.

• Which MySQL versions does phpMyAdmin support ?

  All MySQL versions from 3.23.32 till 5.0 (except for 4.1.0 and 4.1.1) are fully supported. Please note that the older your MySQL version is, the...