/phpmyadmin/doc/html/faq.html
HTML | 1780 lines | 1760 code | 20 blank | 0 comment | 0 complexity | 00dffb796f721de378c2c09ebf646692 MD5 | raw file
Possible License(s): AGPL-1.0, LGPL-3.0, BSD-3-Clause, GPL-2.0, MPL-2.0, GPL-3.0, LGPL-2.1
Large files files are truncated, but you can click here to view the full file
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
- "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
-
- <title>FAQ - Frequently Asked Questions — phpMyAdmin 4.0.4 documentation</title>
-
- <link rel="stylesheet" href="_static/default.css" type="text/css" />
- <link rel="stylesheet" href="_static/pygments.css" type="text/css" />
-
- <script type="text/javascript">
- var DOCUMENTATION_OPTIONS = {
- URL_ROOT: '',
- VERSION: '4.0.4',
- COLLAPSE_INDEX: false,
- FILE_SUFFIX: '.html',
- HAS_SOURCE: true
- };
- </script>
- <script type="text/javascript" src="_static/jquery.js"></script>
- <script type="text/javascript" src="_static/underscore.js"></script>
- <script type="text/javascript" src="_static/doctools.js"></script>
- <link rel="copyright" title="Copyright" href="copyright.html" />
- <link rel="top" title="phpMyAdmin 4.0.4 documentation" href="index.html" />
- <link rel="next" title="Developers Information" href="developers.html" />
- <link rel="prev" title="Other sources of information" href="other.html" />
- </head>
- <body>
- <div class="related">
- <h3>Navigation</h3>
- <ul>
- <li class="right" style="margin-right: 10px">
- <a href="genindex.html" title="General Index"
- accesskey="I">index</a></li>
- <li class="right" >
- <a href="developers.html" title="Developers Information"
- accesskey="N">next</a> |</li>
- <li class="right" >
- <a href="other.html" title="Other sources of information"
- accesskey="P">previous</a> |</li>
- <li><a href="index.html">phpMyAdmin 4.0.4 documentation</a> »</li>
- </ul>
- </div>
- <div class="document">
- <div class="documentwrapper">
- <div class="bodywrapper">
- <div class="body">
-
- <div class="section" id="faq-frequently-asked-questions">
- <span id="faq"></span><h1>FAQ - Frequently Asked Questions<a class="headerlink" href="#faq-frequently-asked-questions" title="Permalink to this headline">¶</a></h1>
- <p>Please have a look at our <a class="reference external" href="http://www.phpmyadmin.net/home_page/docs.php">Link section</a> on the official
- phpMyAdmin homepage for in-depth coverage of phpMyAdmin’s features and
- or interface.</p>
- <div class="section" id="server">
- <span id="faqserver"></span><h2>Server<a class="headerlink" href="#server" title="Permalink to this headline">¶</a></h2>
- <div class="section" id="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">
- <span id="faq1-1"></span><h3>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?<a class="headerlink" href="#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" title="Permalink to this headline">¶</a></h3>
- <p>Try to set the <span class="target" id="index-0"></span><a class="reference internal" href="config.html#cfg_OBGzip"><tt class="xref config config-option docutils literal"><span class="pre">$cfg['OBGzip']</span></tt></a> directive to <tt class="docutils literal"><span class="pre">false</span></tt> in your
- <tt class="file docutils literal"><span class="pre">config.inc.php</span></tt> file and the <tt class="docutils literal"><span class="pre">zlib.output_compression</span></tt> directive to
- <tt class="docutils literal"><span class="pre">Off</span></tt> in your php configuration file.</p>
- </div>
- <div class="section" id="my-apache-server-crashes-when-using-phpmyadmin">
- <span id="faq1-2"></span><h3>1.2 My Apache server crashes when using phpMyAdmin.<a class="headerlink" href="#my-apache-server-crashes-when-using-phpmyadmin" title="Permalink to this headline">¶</a></h3>
- <p>You should first try the latest versions of Apache (and possibly MySQL). If
- your server keeps crashing, please ask for help in the various Apache support
- groups.</p>
- <div class="admonition-see-also admonition seealso">
- <p class="first admonition-title">See also</p>
- <p class="last"><a class="reference internal" href="#faq1-1"><em>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?</em></a></p>
- </div>
- </div>
- <div class="section" id="withdrawn">
- <span id="faq1-3"></span><h3>1.3 (withdrawn).<a class="headerlink" href="#withdrawn" title="Permalink to this headline">¶</a></h3>
- </div>
- <div class="section" id="using-phpmyadmin-on-iis-i-m-displayed-the-error-message-the-specified-cgi-application-misbehaved-by-not-returning-a-complete-set-of-http-headers">
- <span id="faq1-4"></span><h3>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 ...”.<a class="headerlink" href="#using-phpmyadmin-on-iis-i-m-displayed-the-error-message-the-specified-cgi-application-misbehaved-by-not-returning-a-complete-set-of-http-headers" title="Permalink to this headline">¶</a></h3>
- <p>You just forgot to read the <em>install.txt</em> file from the PHP
- distribution. Have a look at the last message in this <a class="reference external" href="http://bugs.php.net/bug.php?id=12061">PHP bug report #12061</a> from the official PHP bug
- database.</p>
- </div>
- <div class="section" id="using-phpmyadmin-on-iis-i-m-facing-crashes-and-or-many-error-messages-with-the-http">
- <span id="faq1-5"></span><h3>1.5 Using phpMyAdmin on IIS, I’m facing crashes and/or many error messages with the HTTP.<a class="headerlink" href="#using-phpmyadmin-on-iis-i-m-facing-crashes-and-or-many-error-messages-with-the-http" title="Permalink to this headline">¶</a></h3>
- <p>This is a known problem with the PHP <a class="reference internal" href="glossary.html#term-isapi"><em class="xref std std-term">ISAPI</em></a> filter: it’s not so stable.
- Please use instead the cookie authentication mode.</p>
- </div>
- <div class="section" id="i-can-t-use-phpmyadmin-on-pws-nothing-is-displayed">
- <span id="faq1-6"></span><h3>1.6 I can’t use phpMyAdmin on PWS: nothing is displayed!<a class="headerlink" href="#i-can-t-use-phpmyadmin-on-pws-nothing-is-displayed" title="Permalink to this headline">¶</a></h3>
- <p>This seems to be a PWS bug. Filippo Simoncini found a workaround (at
- this time there is no better fix): remove or comment the <tt class="docutils literal"><span class="pre">DOCTYPE</span></tt>
- declarations (2 lines) from the scripts <tt class="file docutils literal"><span class="pre">libraries/Header.class.php</span></tt>
- and <tt class="file docutils literal"><span class="pre">index.php</span></tt>.</p>
- </div>
- <div class="section" id="how-can-i-gzip-or-bzip-a-dump-or-a-csv-export-it-does-not-seem-to-work">
- <span id="faq1-7"></span><h3>1.7 How can I GZip or Bzip a dump or a CSV export? It does not seem to work.<a class="headerlink" href="#how-can-i-gzip-or-bzip-a-dump-or-a-csv-export-it-does-not-seem-to-work" title="Permalink to this headline">¶</a></h3>
- <p>These features are based on the <tt class="docutils literal"><span class="pre">gzencode()</span></tt> and <tt class="docutils literal"><span class="pre">bzcompress()</span></tt>
- PHP functions to be more independent of the platform (Unix/Windows,
- Safe Mode or not, and so on). So, you must have Zlib/Bzip2 support
- (<tt class="docutils literal"><span class="pre">--with-zlib</span></tt> and <tt class="docutils literal"><span class="pre">--with-bz2</span></tt>).</p>
- </div>
- <div class="section" id="i-cannot-insert-a-text-file-in-a-table-and-i-get-an-error-about-safe-mode-being-in-effect">
- <span id="faq1-8"></span><h3>1.8 I cannot insert a text file in a table, and I get an error about safe mode being in effect.<a class="headerlink" href="#i-cannot-insert-a-text-file-in-a-table-and-i-get-an-error-about-safe-mode-being-in-effect" title="Permalink to this headline">¶</a></h3>
- <p>Your uploaded file is saved by PHP in the “upload dir”, as defined in
- <tt class="file docutils literal"><span class="pre">php.ini</span></tt> by the variable <tt class="docutils literal"><span class="pre">upload_tmp_dir</span></tt> (usually the system
- default is <em>/tmp</em>). We recommend the following setup for Apache
- servers running in safe mode, to enable uploads of files while being
- reasonably secure:</p>
- <ul class="simple">
- <li>create a separate directory for uploads: <strong class="command">mkdir /tmp/php</strong></li>
- <li>give ownership to the Apache server’s user.group: <strong class="command">chown
- apache.apache /tmp/php</strong></li>
- <li>give proper permission: <strong class="command">chmod 600 /tmp/php</strong></li>
- <li>put <tt class="docutils literal"><span class="pre">upload_tmp_dir</span> <span class="pre">=</span> <span class="pre">/tmp/php</span></tt> in <tt class="file docutils literal"><span class="pre">php.ini</span></tt></li>
- <li>restart Apache</li>
- </ul>
- </div>
- <div class="section" id="faq1-9">
- <span id="id1"></span><h3>1.9 (withdrawn).<a class="headerlink" href="#faq1-9" title="Permalink to this headline">¶</a></h3>
- </div>
- <div class="section" id="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">
- <span id="faq1-10"></span><h3>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.<a class="headerlink" href="#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" title="Permalink to this headline">¶</a></h3>
- <p>As suggested by “Rob M” in the phpWizard forum, add this line to your
- <em>httpd.conf</em>:</p>
- <div class="highlight-apache"><div class="highlight"><pre><span class="nb">SetEnvIf</span> <span class="k">User</span>-Agent <span class="s2">".*MSIE.*"</span> nokeepalive ssl-unclean-shutdown
- </pre></div>
- </div>
- <p>It seems to clear up many problems between Internet Explorer and SSL.</p>
- </div>
- <div class="section" id="i-get-an-open-basedir-restriction-while-uploading-a-file-from-the-query-box">
- <span id="faq1-11"></span><h3>1.11 I get an ‘open_basedir restriction’ while uploading a file from the query box.<a class="headerlink" href="#i-get-an-open-basedir-restriction-while-uploading-a-file-from-the-query-box" title="Permalink to this headline">¶</a></h3>
- <p>Since version 2.2.4, phpMyAdmin supports servers with open_basedir
- restrictions. However you need to create temporary directory and configure it
- as <span class="target" id="index-1"></span><a class="reference internal" href="config.html#cfg_TempDir"><tt class="xref config config-option docutils literal"><span class="pre">$cfg['TempDir']</span></tt></a>. The uploaded files will be moved there,
- and after execution of your <a class="reference internal" href="glossary.html#term-sql"><em class="xref std std-term">SQL</em></a> commands, removed.</p>
- </div>
- <div class="section" id="i-have-lost-my-mysql-root-password-what-can-i-do">
- <span id="faq1-12"></span><h3>1.12 I have lost my MySQL root password, what can I do?<a class="headerlink" href="#i-have-lost-my-mysql-root-password-what-can-i-do" title="Permalink to this headline">¶</a></h3>
- <p>The MySQL manual explains how to <a class="reference external" href="http://dev.mysql.com/doc/mysql/en/resetting-permissions.html">reset the permissions</a>.</p>
- </div>
- <div class="section" id="faq1-13">
- <span id="id2"></span><h3>1.13 (withdrawn).<a class="headerlink" href="#faq1-13" title="Permalink to this headline">¶</a></h3>
- </div>
- <div class="section" id="faq1-14">
- <span id="id3"></span><h3>1.14 (withdrawn).<a class="headerlink" href="#faq1-14" title="Permalink to this headline">¶</a></h3>
- </div>
- <div class="section" id="i-have-problems-with-mysql-user-column-names">
- <span id="faq1-15"></span><h3>1.15 I have problems with <em>mysql.user</em> column names.<a class="headerlink" href="#i-have-problems-with-mysql-user-column-names" title="Permalink to this headline">¶</a></h3>
- <p>In previous MySQL versions, the <tt class="docutils literal"><span class="pre">User</span></tt> and <tt class="docutils literal"><span class="pre">Password``columns</span> <span class="pre">were</span>
- <span class="pre">named</span> <span class="pre">``user</span></tt> and <tt class="docutils literal"><span class="pre">password</span></tt>. Please modify your column names to
- align with current standards.</p>
- </div>
- <div class="section" id="i-cannot-upload-big-dump-files-memory-http-or-timeout-problems">
- <span id="faq1-16"></span><h3>1.16 I cannot upload big dump files (memory, HTTP or timeout problems).<a class="headerlink" href="#i-cannot-upload-big-dump-files-memory-http-or-timeout-problems" title="Permalink to this headline">¶</a></h3>
- <p>Starting with version 2.7.0, the import engine has been re–written and
- these problems should not occur. If possible, upgrade your phpMyAdmin
- to the latest version to take advantage of the new import features.</p>
- <p>The first things to check (or ask your host provider to check) are the
- values of <tt class="docutils literal"><span class="pre">upload_max_filesize</span></tt>, <tt class="docutils literal"><span class="pre">memory_limit</span></tt> and
- <tt class="docutils literal"><span class="pre">post_max_size</span></tt> in the <tt class="file docutils literal"><span class="pre">php.ini</span></tt> configuration file. All of these
- three settings limit the maximum size of data that can be submitted
- and handled by PHP. One user also said that <tt class="docutils literal"><span class="pre">post_max_size</span></tt> and
- <tt class="docutils literal"><span class="pre">memory_limit</span></tt> need to be larger than <tt class="docutils literal"><span class="pre">upload_max_filesize</span></tt>.
- There exist several workarounds if your upload is too big or your
- hosting provider is unwilling to change the settings:</p>
- <ul>
- <li><p class="first">Look at the <span class="target" id="index-2"></span><a class="reference internal" href="config.html#cfg_UploadDir"><tt class="xref config config-option docutils literal"><span class="pre">$cfg['UploadDir']</span></tt></a> feature. This allows one to upload a file to the server
- via scp, ftp, or your favorite file transfer method. PhpMyAdmin is
- then able to import the files from the temporary directory. More
- information is available in the <a class="reference internal" href="config.html#config"><em>Configuration</em></a> of this document.</p>
- </li>
- <li><p class="first">Using a utility (such as <a class="reference external" href="http://www.ozerov.de/bigdump.php">BigDump</a>) to split the files before
- uploading. We cannot support this or any third party applications, but
- are aware of users having success with it.</p>
- </li>
- <li><p class="first">If you have shell (command line) access, use MySQL to import the files
- directly. You can do this by issuing the “source” command from within
- MySQL:</p>
- <div class="highlight-mysql"><div class="highlight"><pre><span class="n">source</span> <span class="n">filename</span><span class="p">.</span><span class="k">sql</span><span class="p">;</span>
- </pre></div>
- </div>
- </li>
- </ul>
- </div>
- <div class="section" id="which-mysql-versions-does-phpmyadmin-support">
- <span id="faq1-17"></span><h3>1.17 Which MySQL versions does phpMyAdmin support?<a class="headerlink" href="#which-mysql-versions-does-phpmyadmin-support" title="Permalink to this headline">¶</a></h3>
- <p>Since phpMyAdmin 3.0.x, only MySQL 5.0.1 and newer are supported. For
- older MySQL versions, you need to use the latest 2.x branch.
- phpMyAdmin can connect to your MySQL server using PHP’s classic <a class="reference external" href="http://php.net/mysql">MySQL
- extension</a> as well as the <a class="reference external" href="http://php.net/mysqli">improved MySQL
- extension (MySQLi)</a> that is available in PHP
- 5.0. The latter one should be used unless you have a good reason not
- to do so. When compiling PHP, we strongly recommend that you manually
- link the MySQL extension of your choice to a MySQL client library of
- at least the same minor version since the one that is bundled with
- some PHP distributions is rather old and might cause problems see
- <a class="reference internal" href="#faq1-17a"><em>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”</em></a>. <a class="reference external" href="http://mariadb.org/">MariaDB</a> is also supported
- (versions 5.1 and 5.2 were tested).</p>
- <p class="versionchanged">
- <span class="versionmodified">Changed in version 3.5: </span>Since phpMyAdmin 3.5 <a class="reference external" href="http://www.drizzle.org/">Drizzle</a> is supported.</p>
- </div>
- <div class="section" id="a-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">
- <span id="faq1-17a"></span><h3>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”<a class="headerlink" href="#a-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" title="Permalink to this headline">¶</a></h3>
- <p>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 general, it should have at least the same minor version as
- your server - as mentioned in <a class="reference internal" href="#faq1-17"><em>1.17 Which MySQL versions does phpMyAdmin support?</em></a>. This problem is
- generally caused by using MySQL version 4.1 or newer. MySQL changed
- the authentication hash and your PHP is trying to use the old method.
- The proper solution is to use the <a class="reference external" href="http://www.php.net/mysqli">mysqli extension</a> with the proper client library to match
- your MySQL installation. Your chosen extension is specified in
- <span class="target" id="index-3"></span><a class="reference internal" href="config.html#cfg_Servers_extension"><tt class="xref config config-option docutils literal"><span class="pre">$cfg['Servers'][$i]['extension']</span></tt></a>. More
- information (and several workarounds) are located in the <a class="reference external" href="http://dev.mysql.com/doc/mysql/en/old-client.html">MySQL
- Documentation</a>.</p>
- </div>
- <div class="section" id="faq1-18">
- <span id="id4"></span><h3>1.18 (withdrawn).<a class="headerlink" href="#faq1-18" title="Permalink to this headline">¶</a></h3>
- </div>
- <div class="section" id="i-can-t-run-the-display-relations-feature-because-the-script-seems-not-to-know-the-font-face-i-m-using">
- <span id="faq1-19"></span><h3>1.19 I can’t run the “display relations” feature because the script seems not to know the font face I’m using!<a class="headerlink" href="#i-can-t-run-the-display-relations-feature-because-the-script-seems-not-to-know-the-font-face-i-m-using" title="Permalink to this headline">¶</a></h3>
- <p>The <a class="reference internal" href="glossary.html#term-tcpdf"><em class="xref std std-term">TCPDF</em></a> library we’re using for this feature requires some special
- files to use font faces. Please refers to the <a class="reference external" href="http://www.tcpdf.org/">TCPDF manual</a> to build these files.</p>
- </div>
- <div class="section" id="i-receive-the-error-cannot-load-mysql-extension-please-check-php-configuration">
- <span id="faqmysql"></span><h3>1.20 I receive the error “cannot load MySQL extension, please check PHP Configuration”.<a class="headerlink" href="#i-receive-the-error-cannot-load-mysql-extension-please-check-php-configuration" title="Permalink to this headline">¶</a></h3>
- <p>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 (compiled-in), otherwise it needs to be loaded
- dynamically. Its name is probably <em>mysql.so</em> or <em>php_mysql.dll</em>.
- phpMyAdmin tried to load the extension but failed. Usually, the
- problem is solved by installing a software package called “PHP-MySQL”
- or something similar.</p>
- </div>
- <div class="section" id="i-am-running-the-cgi-version-of-php-under-unix-and-i-cannot-log-in-using-cookie-auth">
- <span id="faq1-21"></span><h3>1.21 I am running the CGI version of PHP under Unix, and I cannot log in using cookie auth.<a class="headerlink" href="#i-am-running-the-cgi-version-of-php-under-unix-and-i-cannot-log-in-using-cookie-auth" title="Permalink to this headline">¶</a></h3>
- <p>In <tt class="file docutils literal"><span class="pre">php.ini</span></tt>, set <tt class="docutils literal"><span class="pre">mysql.max_links</span></tt> higher than 1.</p>
- </div>
- <div class="section" id="i-don-t-see-the-location-of-text-file-field-so-i-cannot-upload">
- <span id="faq1-22"></span><h3>1.22 I don’t see the “Location of text file” field, so I cannot upload.<a class="headerlink" href="#i-don-t-see-the-location-of-text-file-field-so-i-cannot-upload" title="Permalink to this headline">¶</a></h3>
- <p>This is most likely because in <tt class="file docutils literal"><span class="pre">php.ini</span></tt>, your <tt class="docutils literal"><span class="pre">file_uploads</span></tt>
- parameter is not set to “on”.</p>
- </div>
- <div class="section" id="i-m-running-mysql-on-a-win32-machine-each-time-i-create-a-new-table-the-table-and-column-names-are-changed-to-lowercase">
- <span id="faq1-23"></span><h3>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!<a class="headerlink" href="#i-m-running-mysql-on-a-win32-machine-each-time-i-create-a-new-table-the-table-and-column-names-are-changed-to-lowercase" title="Permalink to this headline">¶</a></h3>
- <p>This happens because the MySQL directive <tt class="docutils literal"><span class="pre">lower_case_table_names</span></tt>
- defaults to 1 (<tt class="docutils literal"><span class="pre">ON</span></tt>) in the Win32 version of MySQL. You can change
- this behavior by simply changing the directive to 0 (<tt class="docutils literal"><span class="pre">OFF</span></tt>): Just
- edit your <tt class="docutils literal"><span class="pre">my.ini</span></tt> file that should be located in your Windows
- directory and add the following line to the group [mysqld]:</p>
- <div class="highlight-ini"><div class="highlight"><pre><span class="na">set-variable</span> <span class="o">=</span> <span class="s">lower_case_table_names=0</span>
- </pre></div>
- </div>
- <p>Next, save the file and restart the MySQL service. You can always
- check the value of this directive using the query</p>
- <div class="highlight-mysql"><div class="highlight"><pre><span class="k">SHOW</span> <span class="n">VARIABLES</span> <span class="k">LIKE</span> <span class="s1">'lower_case_table_names'</span><span class="p">;</span>
- </pre></div>
- </div>
- </div>
- <div class="section" id="faq1-24">
- <span id="id5"></span><h3>1.24 (withdrawn).<a class="headerlink" href="#faq1-24" title="Permalink to this headline">¶</a></h3>
- </div>
- <div class="section" id="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">
- <span id="faq1-25"></span><h3>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.<a class="headerlink" href="#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" title="Permalink to this headline">¶</a></h3>
- <p>A tip from Jose Fandos: put a comment on the following two lines in
- httpd.conf, like this:</p>
- <div class="highlight-apache"><div class="highlight"><pre><span class="c"># mod_gzip_item_include file \.php$</span>
- <span class="c"># mod_gzip_item_include mime "application/x-httpd-php.*"</span>
- </pre></div>
- </div>
- <p>as this version of mod_gzip on Apache (Windows) has problems handling
- PHP scripts. Of course you have to restart Apache.</p>
- </div>
- <div class="section" id="i-just-installed-phpmyadmin-in-my-document-root-of-iis-but-i-get-the-error-no-input-file-specified-when-trying-to-run-phpmyadmin">
- <span id="faq1-26"></span><h3>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.<a class="headerlink" href="#i-just-installed-phpmyadmin-in-my-document-root-of-iis-but-i-get-the-error-no-input-file-specified-when-trying-to-run-phpmyadmin" title="Permalink to this headline">¶</a></h3>
- <p>This is a permission problem. Right-click on the phpmyadmin folder and
- choose properties. Under the tab Security, click on “Add” and select
- the user “IUSR_machine” from the list. Now set his permissions and it
- should work.</p>
- </div>
- <div class="section" id="i-get-empty-page-when-i-want-to-view-huge-page-eg-db-structure-php-with-plenty-of-tables">
- <span id="faq1-27"></span><h3>1.27 I get empty page when I want to view huge page (eg. db_structure.php with plenty of tables).<a class="headerlink" href="#i-get-empty-page-when-i-want-to-view-huge-page-eg-db-structure-php-with-plenty-of-tables" title="Permalink to this headline">¶</a></h3>
- <p>This was caused by a <a class="reference external" href="http://bugs.php.net/21079">PHP bug</a> that occur when
- GZIP output buffering is enabled. If you turn off it (by
- <span class="target" id="index-4"></span><a class="reference internal" href="config.html#cfg_OBGzip"><tt class="xref config config-option docutils literal"><span class="pre">$cfg['OBGzip']</span></tt></a> in <tt class="file docutils literal"><span class="pre">config.inc.php</span></tt>), it should work.
- This bug will has been fixed in PHP 5.0.0.</p>
- </div>
- <div class="section" id="my-mysql-server-sometimes-refuses-queries-and-returns-the-message-errorcode-13-what-does-this-mean">
- <span id="faq1-28"></span><h3>1.28 My MySQL server sometimes refuses queries and returns the message ‘Errorcode: 13’. What does this mean?<a class="headerlink" href="#my-mysql-server-sometimes-refuses-queries-and-returns-the-message-errorcode-13-what-does-this-mean" title="Permalink to this headline">¶</a></h3>
- <p>This can happen due to a MySQL bug when having database / table names
- with upper case characters although <tt class="docutils literal"><span class="pre">lower_case_table_names</span></tt> is
- set to 1. To fix this, turn off this directive, convert all database
- and table names to lower case and turn it on again. Alternatively,
- there’s a bug-fix available starting with MySQL 3.23.56 /
- 4.0.11-gamma.</p>
- </div>
- <div class="section" id="when-i-create-a-table-or-modify-a-column-i-get-an-error-and-the-columns-are-duplicated">
- <span id="faq1-29"></span><h3>1.29 When I create a table or modify a column, I get an error and the columns are duplicated.<a class="headerlink" href="#when-i-create-a-table-or-modify-a-column-i-get-an-error-and-the-columns-are-duplicated" title="Permalink to this headline">¶</a></h3>
- <p>It is possible to configure Apache in such a way that PHP has problems
- interpreting .php files.</p>
- <p>The problems occur when two different (and conflicting) set of
- directives are used:</p>
- <div class="highlight-apache"><div class="highlight"><pre><span class="nb">SetOutputFilter</span> PHP
- <span class="nb">SetInputFilter</span> PHP
- </pre></div>
- </div>
- <p>and</p>
- <div class="highlight-apache"><div class="highlight"><pre><span class="nb">AddType</span> application/x-httpd-php .php
- </pre></div>
- </div>
- <p>In the case we saw, one set of directives was in
- <tt class="docutils literal"><span class="pre">/etc/httpd/conf/httpd.conf</span></tt>, while the other set was in
- <tt class="docutils literal"><span class="pre">/etc/httpd/conf/addon-modules/php.conf</span></tt>. The recommended way is
- with <tt class="docutils literal"><span class="pre">AddType</span></tt>, so just comment out the first set of lines and
- restart Apache:</p>
- <div class="highlight-apache"><div class="highlight"><pre><span class="c">#SetOutputFilter PHP</span>
- <span class="c">#SetInputFilter PHP</span>
- </pre></div>
- </div>
- </div>
- <div class="section" id="i-get-the-error-navigation-php-missing-hash">
- <span id="faq1-30"></span><h3>1.30 I get the error “navigation.php: Missing hash”.<a class="headerlink" href="#i-get-the-error-navigation-php-missing-hash" title="Permalink to this headline">¶</a></h3>
- <p>This problem is known to happen when the server is running Turck
- MMCache but upgrading MMCache to version 2.3.21 solves the problem.</p>
- </div>
- <div class="section" id="does-phpmyadmin-support-php-5">
- <span id="faq1-31"></span><h3>1.31 Does phpMyAdmin support PHP 5?<a class="headerlink" href="#does-phpmyadmin-support-php-5" title="Permalink to this headline">¶</a></h3>
- <p>Yes.</p>
- <p>Since release 3.0 only PHP 5.2 and newer. For older PHP versions, use
- phpMyAdmin 2.11.x.</p>
- </div>
- <div class="section" id="can-i-use-http-authentication-with-iis">
- <span id="faq1-32"></span><h3>1.32 Can I use HTTP authentication with IIS?<a class="headerlink" href="#can-i-use-http-authentication-with-iis" title="Permalink to this headline">¶</a></h3>
- <p>Yes. This procedure was tested with phpMyAdmin 2.6.1, PHP 4.3.9 in
- <a class="reference internal" href="glossary.html#term-isapi"><em class="xref std std-term">ISAPI</em></a> mode under <a class="reference internal" href="glossary.html#term-iis"><em class="xref std std-term">IIS</em></a> 5.1.</p>
- <ol class="arabic simple">
- <li>In your <tt class="file docutils literal"><span class="pre">php.ini</span></tt> file, set <tt class="docutils literal"><span class="pre">cgi.rfc2616_headers</span> <span class="pre">=</span> <span class="pre">0</span></tt></li>
- <li>In <tt class="docutils literal"><span class="pre">Web</span> <span class="pre">Site</span> <span class="pre">Properties</span> <span class="pre">-></span> <span class="pre">File/Directory</span> <span class="pre">Security</span> <span class="pre">-></span> <span class="pre">Anonymous</span>
- <span class="pre">Access</span></tt> dialog box, check the <tt class="docutils literal"><span class="pre">Anonymous</span> <span class="pre">access</span></tt> checkbox and
- uncheck any other checkboxes (i.e. uncheck <tt class="docutils literal"><span class="pre">Basic</span> <span class="pre">authentication</span></tt>,
- <tt class="docutils literal"><span class="pre">Integrated</span> <span class="pre">Windows</span> <span class="pre">authentication</span></tt>, and <tt class="docutils literal"><span class="pre">Digest</span></tt> if it’s
- enabled.) Click <tt class="docutils literal"><span class="pre">OK</span></tt>.</li>
- <li>In <tt class="docutils literal"><span class="pre">Custom</span> <span class="pre">Errors</span></tt>, select the range of <tt class="docutils literal"><span class="pre">401;1</span></tt> through <tt class="docutils literal"><span class="pre">401;5</span></tt>
- and click the <tt class="docutils literal"><span class="pre">Set</span> <span class="pre">to</span> <span class="pre">Default</span></tt> button.</li>
- </ol>
- <div class="admonition-see-also admonition seealso">
- <p class="first admonition-title">See also</p>
- <p class="last"><span class="target" id="index-5"></span><a class="rfc reference external" href="http://tools.ietf.org/html/rfc2616.html"><strong>RFC 2616</strong></a></p>
- </div>
- </div>
- <div class="section" id="faq1-33">
- <span id="id6"></span><h3>1.33 (withdrawn).<a class="headerlink" href="#faq1-33" title="Permalink to this headline">¶</a></h3>
- </div>
- <div class="section" id="can-i-access-directly-to-database-or-table-pages">
- <span id="faq1-34"></span><h3>1.34 Can I access directly to database or table pages?<a class="headerlink" href="#can-i-access-directly-to-database-or-table-pages" title="Permalink to this headline">¶</a></h3>
- <p>Yes. Out of the box, you can use <a class="reference internal" href="glossary.html#term-url"><em class="xref std std-term">URL</em></a> like <a class="reference external" href="http://server/phpMyAdmin/index.php?server=X&db=databas">http://server/phpMyAdmin/index.php?server=X&db=databas</a>
- e&table=table&target=script. For <tt class="docutils literal"><span class="pre">server</span></tt> you use the server number
- which refers to the order of the server paragraph in
- <tt class="file docutils literal"><span class="pre">config.inc.php</span></tt>. Table and script parts are optional. If you want
- <a class="reference external" href="http://server/phpMyAdmin/database[/table][/script">http://server/phpMyAdmin/database[/table][/script</a>] <a class="reference internal" href="glossary.html#term-url"><em class="xref std std-term">URL</em></a>, you need to do some configuration. Following
- lines apply only for <a class="reference external" href="http://httpd.apache.org">Apache</a> web server.
- First make sure, that you have enabled some features within global
- configuration. You need <tt class="docutils literal"><span class="pre">Options</span> <span class="pre">FollowSymLinks</span></tt> and <tt class="docutils literal"><span class="pre">AllowOverride</span>
- <span class="pre">FileInfo</span></tt> enabled for directory where phpMyAdmin is installed and you
- need mod_rewrite to be enabled. Then you just need to create
- following <a class="reference internal" href="glossary.html#term-htaccess"><em class="xref std std-term">.htaccess</em></a> file in root folder of phpMyAdmin installation (don’t
- forget to change directory name inside of it):</p>
- <div class="highlight-apache"><div class="highlight"><pre><span class="nb">RewriteEngine</span> <span class="k">On</span>
- <span class="nb">RewriteBase</span> <span class="sx">/path_to_phpMyAdmin</span>
- <span class="nb">RewriteRule</span> ^([a-zA-Z0-9_]+)/([a-zA-Z0-9_]+)/([a-z_]+\.php)$ index.php?db=$1&table=$2&target=$3 [R]
- <span class="nb">RewriteRule</span> ^([a-zA-Z0-9_]+)/([a-z_]+\.php)$ index.php?db=$1&target=$2 [R]
- <span class="nb">RewriteRule</span> ^([a-zA-Z0-9_]+)/([a-zA-Z0-9_]+)$ index.php?db=$1&table=$2 [R]
- <span class="nb">RewriteRule</span> ^([a-zA-Z0-9_]+)$ index.php?db=$1 [R]
- </pre></div>
- </div>
- </div>
- <div class="section" id="can-i-use-http-authentication-with-apache-cgi">
- <span id="faq1-35"></span><h3>1.35 Can I use HTTP authentication with Apache CGI?<a class="headerlink" href="#can-i-use-http-authentication-with-apache-cgi" title="Permalink to this headline">¶</a></h3>
- <p>Yes. However you need to pass authentication variable to <a class="reference internal" href="glossary.html#term-cgi"><em class="xref std std-term">CGI</em></a> using
- following rewrite rule:</p>
- <div class="highlight-apache"><div class="highlight"><pre><span class="nb">RewriteEngine</span> <span class="k">On</span>
- <span class="nb">RewriteRule</span> .* - [E=REMOTE_USER:%{HTTP:Authorization},L]
- </pre></div>
- </div>
- </div>
- <div class="section" id="i-get-an-error-500-internal-server-error">
- <span id="faq1-36"></span><h3>1.36 I get an error “500 Internal Server Error”.<a class="headerlink" href="#i-get-an-error-500-internal-server-error" title="Permalink to this headline">¶</a></h3>
- <p>There can be many explanations to this and a look at your server’s
- error log file might give a clue.</p>
- </div>
- <div class="section" id="i-run-phpmyadmin-on-cluster-of-different-machines-and-password-encryption-in-cookie-auth-doesn-t-work">
- <span id="faq1-37"></span><h3>1.37 I run phpMyAdmin on cluster of different machines and password encryption in cookie auth doesn’t work.<a class="headerlink" href="#i-run-phpmyadmin-on-cluster-of-different-machines-and-password-encryption-in-cookie-auth-doesn-t-work" title="Permalink to this headline">¶</a></h3>
- <p>If your cluster consist of different architectures, PHP code used for
- encryption/decryption won’t work correct. This is caused by use of
- pack/unpack functions in code. Only solution is to use mcrypt
- extension which works fine in this case.</p>
- </div>
- <div class="section" id="can-i-use-phpmyadmin-on-a-server-on-which-suhosin-is-enabled">
- <span id="faq1-38"></span><h3>1.38 Can I use phpMyAdmin on a server on which Suhosin is enabled?<a class="headerlink" href="#can-i-use-phpmyadmin-on-a-server-on-which-suhosin-is-enabled" title="Permalink to this headline">¶</a></h3>
- <p>Yes but the default configuration values of Suhosin are known to cause
- problems with some operations, for example editing a table with many
- columns and no primary key or with textual primary key.</p>
- <p>Suhosin configuration might lead to malfunction in some cases and it
- can not be fully avoided as phpMyAdmin is kind of application which
- needs to transfer big amounts of columns in single HTTP request, what
- is something what Suhosin tries to prevent. Generally all
- <tt class="docutils literal"><span class="pre">suhosin.request.*</span></tt>, <tt class="docutils literal"><span class="pre">suhosin.post.*</span></tt> and <tt class="docutils literal"><span class="pre">suhosin.get.*</span></tt>
- directives can have negative effect on phpMyAdmin usability. You can
- always find in your error logs which limit did cause dropping of
- variable, so you can diagnose the problem and adjust matching
- configuration variable.</p>
- <p>The default values for most Suhosin configuration options will work in
- most scenarios, however you might want to adjust at least following
- parameters:</p>
- <ul class="simple">
- <li><a class="reference external" href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.request.max_vars">suhosin.request.max_vars</a> should
- be increased (eg. 2048)</li>
- <li><a class="reference external" href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.post.max_vars">suhosin.post.max_vars</a> should be
- increased (eg. 2048)</li>
- <li><a class="reference external" href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.request.max_array_index_length">suhosin.request.max_array_index_length</a>
- should be increased (eg. 256)</li>
- <li><a class="reference external" href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.post.max_array_index_length">suhosin.post.max_array_index_length</a>
- should be increased (eg. 256)</li>
- <li><a class="reference external" href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.request.max_totalname_length">suhosin.request.max_totalname_length</a>
- should be increased (eg. 8192)</li>
- <li><a class="reference external" href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.post.max_totalname_length">suhosin.post.max_totalname_length</a> should be
- increased (eg. 8192)</li>
- <li><a class="reference external" href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.get.max_value_length">suhosin.get.max_value_length</a>
- should be increased (eg. 1024)</li>
- <li><a class="reference external" href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.sql.bailout_on_error">suhosin.sql.bailout_on_error</a>
- needs to be disabled (the default)</li>
- <li><a class="reference external" href="http://www.hardened-php.net/suhosin/configuration.html#logging_configuration">suhosin.log.*</a> should not
- include <a class="reference internal" href="glossary.html#term-sql"><em class="xref std std-term">SQL</em></a>, otherwise you get big
- slowdown</li>
- </ul>
- <p>You can also disable the warning using the <span class="target" id="index-6"></span><a class="reference internal" href="config.html#cfg_SuhosinDisableWarning"><tt class="xref config config-option docutils literal"><span class="pre">$cfg['SuhosinDisableWarning']</span></tt></a>.</p>
- </div>
- <div class="section" id="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">
- <span id="faq1-39"></span><h3>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?<a class="headerlink" href="#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" title="Permalink to this headline">¶</a></h3>
- <p>Be sure that you have enabled <tt class="docutils literal"><span class="pre">SSLOptions</span></tt> and <tt class="docutils literal"><span class="pre">StdEnvVars</span></tt> in
- your Apache configuration.</p>
- <div class="admonition-see-also admonition seealso">
- <p class="first admonition-title">See also</p>
- <p class="last"><<a class="reference external" href="http://httpd.apache.org/docs/2.0/mod/mod_ssl.html#ssloptions">http://httpd.apache.org/docs/2.0/mod/mod_ssl.html#ssloptions</a>></p>
- </div>
- </div>
- <div class="section" id="when-accessing-phpmyadmin-via-an-apache-reverse-proxy-cookie-login-does-not-work">
- <span id="faq1-40"></span><h3>1.40 When accessing phpMyAdmin via an Apache reverse proxy, cookie login does not work.<a class="headerlink" href="#when-accessing-phpmyadmin-via-an-apache-reverse-proxy-cookie-login-does-not-work" title="Permalink to this headline">¶</a></h3>
- <p>To be able to use cookie auth Apache must know that it has to rewrite
- the set-cookie headers. Example from the Apache 2.2 documentation:</p>
- <div class="highlight-apache"><div class="highlight"><pre><span class="nb">ProxyPass</span> <span class="sx">/mirror/foo/</span> http://backend.example.com/
- <span class="nb">ProxyPassReverse</span> <span class="sx">/mirror/foo/</span> http://backend.example.com/
- <span class="nb">ProxyPassReverseCookieDomain</span> backend.example.com public.example.com
- <span class="nb">ProxyPassReverseCookiePath</span> / <span class="sx">/mirror/foo/</span>
- </pre></div>
- </div>
- <p>Note: if the backend url looks like <a class="reference external" href="http://host/~user/phpmyadmin">http://host/~user/phpmyadmin</a>, the
- tilde (~) must be url encoded as %7E in the ProxyPassReverse* lines.
- This is not specific to phpmyadmin, it’s just the behavior of Apache.</p>
- <div class="highlight-apache"><div class="highlight"><pre><span class="nb">ProxyPass</span> <span class="sx">/mirror/foo/</span> http://backend.example.com/~user/phpmyadmin
- <span class="nb">ProxyPassReverse</span> <span class="sx">/mirror/foo/</span> http://backend.example.com/%7Euser/phpmyadmin
- <span class="nb">ProxyPassReverseCookiePath</span> /%7Euser/phpmyadmin <span class="sx">/mirror/foo</span>
- </pre></div>
- </div>
- <div class="admonition-see-also admonition seealso">
- <p class="first admonition-title">See also</p>
- <p class="last"><<a class="reference external" href="http://httpd.apache.org/docs/2.2/mod/mod_proxy.html">http://httpd.apache.org/docs/2.2/mod/mod_proxy.html</a>></p>
- </div>
- </div>
- <div class="section" id="when-i-view-a-database-and-ask-to-see-its-privileges-i-get-an-error-about-an-unknown-column">
- <span id="faq1-41"></span><h3>1.41 When I view a database and ask to see its privileges, I get an error about an unknown column.<a class="headerlink" href="#when-i-view-a-database-and-ask-to-see-its-privileges-i-get-an-error-about-an-unknown-column" title="Permalink to this headline">¶</a></h3>
- <p>The MySQL server’s privilege tables are not up to date, you need to
- run the <strong class="command">mysql_upgrade</strong> command on the server.</p>
- </div>
- <div class="section" id="how-can-i-prevent-robots-from-accessing-phpmyadmin">
- <span id="faq1-42"></span><h3>1.42 How can I prevent robots from accessing phpMyAdmin?<a class="headerlink" href="#how-can-i-prevent-robots-from-accessing-phpmyadmin" title="Permalink to this headline">¶</a></h3>
- <p>You can add various rules to <a class="reference internal" href="glossary.html#term-htaccess"><em class="xref std std-term">.htaccess</em></a> to filter access based on user agent
- field. This is quite easy to circumvent, but could prevent at least
- some robots accessing your installation.</p>
- <div class="highlight-apache"><div class="highlight"><pre><span class="nb">RewriteEngine</span> <span class="k">on</span>
- <span class="c"># Allow only GET and POST verbs</span>
- <span class="nb">RewriteCond</span> %{REQUEST_METHOD} !^(GET|POST)$ [NC,OR]
- <span class="c"># Ban Typical Vulnerability Scanners and others</span>
- <span class="c"># Kick out Script Kiddies</span>
- <span class="nb">RewriteCond</span> %{HTTP_USER_AGENT} ^(java|curl|wget).* [NC,OR]
- <span class="nb">RewriteCond</span> %{HTTP_USER_AGENT} ^.*(libwww-perl|curl|wget|python|nikto|wkito|pikto|scan|acunetix).* [NC,OR]
- <span class="nb">RewriteCond</span> %{HTTP_USER_AGENT} ^.*(winhttp|HTTrack|clshttp|archiver|loader|email|harvest|extract|grab|miner).* [NC,OR]
- <span class="c"># Ban Search Engines, Crawlers to your administrative panel</span>
- <span class="c"># No reasons to access from bots</span>
- <span class="c"># Ultimately Better than the useless robots.txt</span>
- <span class="c"># Did google respect robots.txt?</span>
- <span class="c"># Try google: intitle:phpMyAdmin intext:"Welcome to phpMyAdmin *.*.*" intext:"Log in" -wiki -forum -forums -questions intext:"Cookies must be enabled"</span>
- <span class="nb">RewriteCond</span> %{HTTP_USER_AGENT} ^.*(AdsBot-Google|ia_archiver|Scooter|Ask.Jeeves|Baiduspider|Exabot|FAST.Enterprise.Crawler|FAST-WebCrawler|www\.neomo\.de|Gigabot|Mediapartners-Google|Google.Desktop|Feedfetcher-Google|Googlebot|heise-IT-Markt-Crawler|heritrix|ibm.com\cs/crawler|ICCrawler|ichiro|MJ12bot|MetagerBot|msnbot-NewsBlogs|msnbot|msnbot-media|NG-Search|lucene.apache.org|NutchCVS|OmniExplorer_Bot|online.link.validator|psbot0|Seekbot|Sensis.Web.Crawler|SEO.search.Crawler|Seoma.\[SEO.Crawler\]|SEOsearch|Snappy|www.urltrends.com|www.tkl.iis.u-tokyo.ac.jp/~crawler|SynooBot|crawleradmin.t-info@telekom.de|TurnitinBot|voyager|W3.SiteSearch.Crawler|W3C-checklink|W3C_Validator|www.WISEnutbot.com|yacybot|Yahoo-MMCrawler|Yahoo\!.DE.Slurp|Yahoo\!.Slurp|YahooSeeker).* [NC]
- <span class="nb">RewriteRule</span> .* - [F]
- </pre></div>
- </div>
- </div>
- <div class="section" id="why-can-t-i-display-the-structure-of-my-table-containing-hundreds-of-columns">
- <span id="faq1-43"></span><h3>1.43 Why can’t I display the structure of my table containing hundreds of columns?<a class="headerlink" href="#why-can-t-i-display-the-structure-of-my-table-containing-hundreds-of-columns" title="Permalink to this headline">¶</a></h3>
- <p>Because your PHP’s <tt class="docutils literal"><span class="pre">memory_limit</span></tt> is too low; adjust it in <tt class="file docutils literal"><span class="pre">php.ini</span></tt>.</p>
- </div>
- </div>
- <div class="section" id="configuration">
- <span id="faqconfig"></span><h2>Configuration<a class="headerlink" href="#configuration" title="Permalink to this headline">¶</a></h2>
- <div class="section" id="the-error-message-warning-cannot-add-header-information-headers-already-sent-by-is-displayed-what-s-the-problem">
- <span id="faq2-1"></span><h3>2.1 The error message “Warning: Cannot add header information - headers already sent by ...” is displayed, what’s the problem?<a class="headerlink" href="#the-error-message-warning-cannot-add-header-information-headers-already-sent-by-is-displayed-what-s-the-problem" title="Permalink to this headline">¶</a></h3>
- <p>Edit your <tt class="file docutils literal"><span class="pre">config.inc.php</span></tt> file and ensure there is nothing (I.E. no
- blank lines, no spaces, no characters...) neither before the <tt class="docutils literal"><span class="pre"><?php</span></tt> tag at
- the beginning, neither after the <tt class="docutils literal"><span class="pre">?></span></tt> tag at the end. We also got a report
- from a user under <a class="reference internal" href="glossary.html#term-iis"><em class="xref std std-term">IIS</em></a>, that used a zipped distribution kit: the file
- <tt class="file docutils literal"><span class="pre">libraries/Config.class.php</span></tt> contained an end-of-line character (hex 0A)
- at the end; removing this character cleared his errors.</p>
- </div>
- <div class="section" id="phpmyadmin-can-t-connect-to-mysql-what-s-wrong">
- <span id="faq2-2"></span><h3>2.2 phpMyAdmin can’t connect to MySQL. What’s wrong?<a class="headerlink" href="#phpmyadmin-can-t-connect-to-mysql-what-s-wrong" title="Permalink to this headline">¶</a></h3>
- <p>Either there is an error with your PHP setup or your username/password
- is wrong. Try to make a small script which uses mysql_connect and see
- if it works. If it doesn’t, it may be you haven’t even compiled MySQL
- support into PHP.</p>
- </div>
- <div class="section" id="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">
- <span id="faq2-3"></span><h3>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?<a class="headerlink" href="#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" title="Permalink to this headline">¶</a></h3>
- <p>For RedHat users, Harald Legner suggests this on the mailing list:</p>
- <p>On my RedHat-Box…
Large files files are truncated, but you can click here to view the full file