FAQ 1. Server

From PmaWiki

Jump to: navigation, search
mediawiki
  • FAQ 1.1 I'm running PHP 4 and 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?
  • FAQ 1.2 My Apache server crashes when using phpMyAdmin.
  • FAQ 1.3 I'm running phpMyAdmin with "cookie" authentication mode under PHP 4.2.0 or 4.2.1 loaded as an Apache 2 module but can't enter the script: I'm always displayed the login screen.
  • FAQ 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 ...".
  • FAQ 1.5 Using phpMyAdmin on IIS, I'm facing crashes and/or many error messages with the HTTP or advanced authentication mode.
  • FAQ 1.6 I can't use phpMyAdmin on PWS: nothing is displayed!
  • FAQ 1.7 How can I zip, gzip or bzip2 a dump or a CSV export? It does not seem to work.
  • FAQ 1.8 I cannot insert a text file in a table, and I get an error about safe mode being in effect.
  • FAQ 1.9 I'm having troubles when uploading files. In general file uploads don't work on my system and uploaded files have a Content-Type: header in the first line.
  • FAQ 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.
  • FAQ 1.11 I get an 'open_basedir restriction' while uploading a file from the query box.
  • FAQ 1.12 I have lost my MySQL root password, what can I do?
  • FAQ 1.13 I get an error 'No SQL query' when trying to execute a bookmark.
  • FAQ 1.14 I get an error 'No SQL query' when trying to submit a query from the convenient text area.
  • FAQ 1.15 I have problems with mysql.user field names.
  • FAQ 1.16 I cannot upload big dump files (memory, HTTP or timeout problems).
  • FAQ 1.17 Which MySQL versions does phpMyAdmin support?
  • FAQ 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"
  • FAQ 1.18 I'm running MySQL <= 4.0.1 having lower_case_table_names set to 1. If I create a new table with a capital letter in its name it is changed to lowercase as it should. But if I try to DROP this table MySQL is unable to find the corresponding file.
  • FAQ 1.19 I can't run the "display relations" feature because the script seems not to know the font face I'm using!
  • FAQ 1.20 I receive the error "cannot load MySQL extension, please check PHP Configuration".
  • FAQ 1.21 I am running the CGI version of PHP under Unix, and I cannot login using cookie auth.
  • FAQ 1.22 I don't see the "Location of text file" field, so I cannot upload.
  • FAQ 1.23 I'm running MySQL on a Win32 machine. Each time I create a new table the table and field names are changed to lowercase!
  • FAQ 1.24 Some characters are being truncated in my queries, or I get characters randomly added. I am running PHP 4.2.3.
  • FAQ 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.
  • FAQ 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.
  • FAQ 1.27 I get empty page when I want to view huge page (eg. db_details_structure.php with plenty of tables).
  • FAQ 1.28 My MySQL server sometimes refuses queries and returns the message 'Errorcode: 13'. What does this mean?
  • FAQ 1.29 When I create a table or modify a field, I get an error and the fields are duplicated.
  • FAQ 1.30 I get the error "left.php: Missing hash".
  • FAQ 1.31 Does phpMyAdmin support PHP 5?
  • FAQ 1.32 Can I use HTTP authentication with IIS?
  • FAQ 1.33 Is there a problem with the mysqli extension when running PHP 5.0.4 on 64-bit systems?
  • FAQ 1.34 Can I access directly to database or table pages?
  • FAQ 1.35 Can I use HTTP authentication with Apache CGI?
  • FAQ 1.36 I get an error "500 Internal Server Error".
  • FAQ 1.37 I run phpMyAdmin on cluster of different machines and password encryption in cookie auth doesn't work.
  • FAQ 1.38 Can I use phpMyAdmin on a server on which Suhosin is enabled?
  • FAQ 1.39 Using IIS the styles are not displayed correctly or I get an error like Warning: require_once(.libraries/common.lib.php) [function.require-once]: failed to open stream: No such file or directory in C:\Php\phpMyAdmin\css\phpmyadmin.css.php on line 7 or about Disallowed Parent Path.
Advertisement