diff options
Diffstat (limited to 'srcs/phpmyadmin/doc/html/faq.html')
| -rw-r--r-- | srcs/phpmyadmin/doc/html/faq.html | 2045 |
1 files changed, 0 insertions, 2045 deletions
diff --git a/srcs/phpmyadmin/doc/html/faq.html b/srcs/phpmyadmin/doc/html/faq.html deleted file mode 100644 index 6e4fbd7..0000000 --- a/srcs/phpmyadmin/doc/html/faq.html +++ /dev/null @@ -1,2045 +0,0 @@ -<!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 5.0.1 documentation</title> - - <link rel="stylesheet" href="_static/classic.css" type="text/css" /> - <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> - - <script type="text/javascript"> - var DOCUMENTATION_OPTIONS = { - URL_ROOT: './', - VERSION: '5.0.1', - 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="index" title="Index" href="genindex.html" /> - <link rel="search" title="Search" href="search.html" /> - <link rel="copyright" title="Copyright" href="copyright.html" /> - <link rel="top" title="phpMyAdmin 5.0.1 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 role="document"> - <div class="related" role="navigation" aria-label="related navigation"> - <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 class="nav-item nav-item-0"><a href="index.html">phpMyAdmin 5.0.1 documentation</a> »</li> - </ul> - </div> - - <div class="document"> - <div class="documentwrapper"> - <div class="bodywrapper"> - <div class="body" role="main"> - - <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="https://www.phpmyadmin.net/docs/">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"><code class="xref config config-option docutils literal"><span class="pre">$cfg['OBGzip']</span></code></a> directive to <code class="docutils literal"><span class="pre">false</span></code> in your -<code class="file docutils literal"><span class="pre">config.inc.php</span></code> file and the <code class="docutils literal"><span class="pre">zlib.output_compression</span></code> directive to -<code class="docutils literal"><span class="pre">Off</span></code> 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 seealso"> -<p class="first admonition-title">See also</p> -<p class="last"><a class="reference internal" href="#faq1-1"><span class="std std-ref">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?</span></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="https://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"><span class="xref std std-term">ISAPI</span></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 <code class="docutils literal"><span class="pre">DOCTYPE</span></code> -declarations (2 lines) from the scripts <code class="file docutils literal"><span class="pre">libraries/Header.class.php</span></code> -and <code class="file docutils literal"><span class="pre">index.php</span></code>.</p> -</div> -<div class="section" id="how-can-i-gzip-a-dump-or-a-csv-export-it-does-not-seem-to-work"> -<span id="faq1-7"></span><h3>1.7 How can I gzip a dump or a CSV export? It does not seem to work.<a class="headerlink" href="#how-can-i-gzip-a-dump-or-a-csv-export-it-does-not-seem-to-work" title="Permalink to this headline">¶</a></h3> -<p>This feature is based on the <code class="docutils literal"><span class="pre">gzencode()</span></code> -PHP function to be more independent of the platform (Unix/Windows, -Safe Mode or not, and so on). So, you must have Zlib support -(<code class="docutils literal"><span class="pre">--with-zlib</span></code>).</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 -<code class="file docutils literal"><span class="pre">php.ini</span></code> by the variable <code class="docutils literal"><span class="pre">upload_tmp_dir</span></code> (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 <code class="docutils literal"><span class="pre">upload_tmp_dir</span> <span class="pre">=</span> <span class="pre">/tmp/php</span></code> in <code class="file docutils literal"><span class="pre">php.ini</span></code></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></span><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-import-tab"> -<span id="faq1-11"></span><h3>1.11 I get an ‘open_basedir restriction’ while uploading a file from the import tab.<a class="headerlink" href="#i-get-an-open-basedir-restriction-while-uploading-a-file-from-the-import-tab" 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"><code class="xref config config-option docutils literal"><span class="pre">$cfg['TempDir']</span></code></a>. The uploaded files will be moved there, -and after execution of your <a class="reference internal" href="glossary.html#term-sql"><span class="xref std std-term">SQL</span></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>phpMyAdmin does authenticate against MySQL server you’re using, so to recover -from phpMyAdmin password loss, you need to recover at MySQL level.</p> -<p>The MySQL manual explains how to <a class="reference external" href="https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html">reset the permissions</a>.</p> -<p>If you are using MySQL server installed by your hosting provider, please -contact their support to recover the password for you.</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 <code class="docutils literal"><span class="pre">User</span></code> and <code class="docutils literal"><span class="pre">Password</span></code> columns were -named <code class="docutils literal"><span class="pre">user</span></code> and <code class="docutils literal"><span class="pre">password</span></code>. 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 <code class="docutils literal"><span class="pre">max_execution_time</span></code>, <code class="docutils literal"><span class="pre">upload_max_filesize</span></code>, <code class="docutils literal"><span class="pre">memory_limit</span></code> and -<code class="docutils literal"><span class="pre">post_max_size</span></code> in the <code class="file docutils literal"><span class="pre">php.ini</span></code> configuration file. All of these -settings limit the maximum size of data that can be submitted and handled by -PHP. Please note that <code class="docutils literal"><span class="pre">post_max_size</span></code> needs to be larger than -<code class="docutils literal"><span class="pre">upload_max_filesize</span></code>. 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"><code class="xref config config-option docutils literal"><span class="pre">$cfg['UploadDir']</span></code></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"><span class="std std-ref">Configuration</span></a> of this document.</p> -</li> -<li><p class="first">Using a utility (such as <a class="reference external" href="https://www.ozerov.de/bigdump/">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></span><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-database-versions-does-phpmyadmin-support"> -<span id="faq1-17"></span><h3>1.17 Which Database versions does phpMyAdmin support?<a class="headerlink" href="#which-database-versions-does-phpmyadmin-support" title="Permalink to this headline">¶</a></h3> -<p>For <a class="reference external" href="https://www.mysql.com/">MySQL</a>, versions 5.5 and newer are supported. -For older MySQL versions, our <a class="reference external" href="https://www.phpmyadmin.net/downloads/">Downloads</a> page offers older phpMyAdmin versions -(which may have become unsupported).</p> -<p>For <a class="reference external" href="https://mariadb.org/">MariaDB</a>, versions 5.5 and newer are 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"><span class="std std-ref">1.17 Which Database versions does phpMyAdmin support?</span></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="https://www.php.net/mysqli">mysqli extension</a> with the proper client library to match -your MySQL installation. More -information (and several workarounds) are located in the <a class="reference external" href="https://dev.mysql.com/doc/refman/5.7/en/common-errors.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"><span class="xref std std-term">TCPDF</span></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="https://tcpdf.org/">TCPDF manual</a> to build these files.</p> -</div> -<div class="section" id="i-receive-an-error-about-missing-mysqli-and-mysql-extensions"> -<span id="faqmysql"></span><h3>1.20 I receive an error about missing mysqli and mysql extensions.<a class="headerlink" href="#i-receive-an-error-about-missing-mysqli-and-mysql-extensions" 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>mysqli.so</em> or <em>php_mysqli.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> -<p>There are currently two interfaces PHP provides as MySQL extensions - <code class="docutils literal"><span class="pre">mysql</span></code> -and <code class="docutils literal"><span class="pre">mysqli</span></code>. The <code class="docutils literal"><span class="pre">mysqli</span></code> is tried first, because it’s the best one.</p> -<p>This problem can be also caused by wrong paths in the <code class="file docutils literal"><span class="pre">php.ini</span></code> or using -wrong <code class="file docutils literal"><span class="pre">php.ini</span></code>.</p> -<p>Make sure that the extension files do exist in the folder which the -<code class="docutils literal"><span class="pre">extension_dir</span></code> points to and that the corresponding lines in your -<code class="file docutils literal"><span class="pre">php.ini</span></code> are not commented out (you can use <code class="docutils literal"><span class="pre">phpinfo()</span></code> to check -current setup):</p> -<div class="highlight-ini"><div class="highlight"><pre><span></span><span class="k">[PHP]</span> - -<span class="c1">; Directory in which the loadable extensions (modules) reside.</span> -<span class="na">extension_dir</span> <span class="o">=</span> <span class="s">"C:/Apache2/modules/php/ext"</span> -</pre></div> -</div> -<p>The <code class="file docutils literal"><span class="pre">php.ini</span></code> can be loaded from several locations (especially on -Windows), so please check you’re updating the correct one. If using Apache, you -can tell it to use specific path for this file using <code class="docutils literal"><span class="pre">PHPIniDir</span></code> directive:</p> -<div class="highlight-apache"><div class="highlight"><pre><span></span><span class="nb">LoadFile</span> <span class="s2">"C:/php/php5ts.dll"</span> -<span class="nb">LoadModule</span> php5_module <span class="s2">"C:/php/php5apache2_2.dll"</span> -<span class="nt"><IfModule</span> <span class="s">php5_module</span><span class="nt">></span> - <span class="nb">PHPIniDir</span> <span class="s2">"C:/PHP"</span> - <span class="nt"><Location></span> - <span class="nb">AddType</span> text/html .php - <span class="nb">AddHandler</span> application/x-httpd-php .php - <span class="nt"></Location></span> -<span class="nt"></IfModule></span> -</pre></div> -</div> -<p>In some rare cases this problem can be also caused by other extensions loaded -in PHP which prevent MySQL extensions to be loaded. If anything else fails, you -can try commenting out extensions for other databses from <code class="file docutils literal"><span class="pre">php.ini</span></code>.</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 <code class="file docutils literal"><span class="pre">php.ini</span></code>, set <code class="docutils literal"><span class="pre">mysql.max_links</span></code> 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 <code class="file docutils literal"><span class="pre">php.ini</span></code>, your <code class="docutils literal"><span class="pre">file_uploads</span></code> -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 <code class="docutils literal"><span class="pre">lower_case_table_names</span></code> -defaults to 1 (<code class="docutils literal"><span class="pre">ON</span></code>) in the Win32 version of MySQL. You can change -this behavior by simply changing the directive to 0 (<code class="docutils literal"><span class="pre">OFF</span></code>): Just -edit your <code class="docutils literal"><span class="pre">my.ini</span></code> 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></span><span class="na">set-variable</span> <span class="o">=</span> <span class="s">lower_case_table_names=0</span> -</pre></div> -</div> -<div class="admonition note"> -<p class="first admonition-title">Note</p> -<p class="last">Forcing this variable to 0 with –lower-case-table-names=0 on a -case-insensitive filesystem and access MyISAM tablenames using different -lettercases, index corruption may result.</p> -</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></span><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 class="admonition seealso"> -<p class="first admonition-title">See also</p> -<p class="last"><a class="reference external" href="https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html">Identifier Case Sensitivity in the MySQL Reference Manual</a></p> -</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></span><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="https://bugs.php.net/bug.php?id=21079">PHP bug</a> that occur when -GZIP output buffering is enabled. If you turn off it (by -<span class="target" id="index-3"></span><a class="reference internal" href="config.html#cfg_OBGzip"><code class="xref config config-option docutils literal"><span class="pre">$cfg['OBGzip']</span></code></a> in <code class="file docutils literal"><span class="pre">config.inc.php</span></code>), 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 <code class="docutils literal"><span class="pre">lower_case_table_names</span></code> 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></span><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></span><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 -<code class="docutils literal"><span class="pre">/etc/httpd/conf/httpd.conf</span></code>, while the other set was in -<code class="docutils literal"><span class="pre">/etc/httpd/conf/addon-modules/php.conf</span></code>. The recommended way is -with <code class="docutils literal"><span class="pre">AddType</span></code>, so just comment out the first set of lines and -restart Apache:</p> -<div class="highlight-apache"><div class="highlight"><pre><span></span><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="which-php-versions-does-phpmyadmin-support"> -<span id="faq1-31"></span><h3>1.31 Which PHP versions does phpMyAdmin support?<a class="headerlink" href="#which-php-versions-does-phpmyadmin-support" title="Permalink to this headline">¶</a></h3> -<p>Since release 4.5, phpMyAdmin supports only PHP 5.5 and newer. Since release -4.1 phpMyAdmin supports only PHP 5.3 and newer. For PHP 5.2 you can use 4.0.x -releases.</p> -<p>PHP 7 is supported since phpMyAdmin 4.6, PHP 7.1 is supported since 4.6.5, -PHP 7.2 is supported since 4.7.4.</p> -<p>HHVM is supported up to phpMyAdmin 4.8.</p> -<p>Since release 5.0, phpMyAdmin supports only PHP 7.1 and newer.</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"><span class="xref std std-term">ISAPI</span></a> mode under <a class="reference internal" href="glossary.html#term-iis"><span class="xref std std-term">IIS</span></a> 5.1.</p> -<ol class="arabic simple"> -<li>In your <code class="file docutils literal"><span class="pre">php.ini</span></code> file, set <code class="docutils literal"><span class="pre">cgi.rfc2616_headers</span> <span class="pre">=</span> <span class="pre">0</span></code></li> -<li>In <code 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></code> dialog box, check the <code class="docutils literal"><span class="pre">Anonymous</span> <span class="pre">access</span></code> checkbox and -uncheck any other checkboxes (i.e. uncheck <code class="docutils literal"><span class="pre">Basic</span> <span class="pre">authentication</span></code>, -<code class="docutils literal"><span class="pre">Integrated</span> <span class="pre">Windows</span> <span class="pre">authentication</span></code>, and <code class="docutils literal"><span class="pre">Digest</span></code> if it’s -enabled.) Click <code class="docutils literal"><span class="pre">OK</span></code>.</li> -<li>In <code class="docutils literal"><span class="pre">Custom</span> <span class="pre">Errors</span></code>, select the range of <code class="docutils literal"><span class="pre">401;1</span></code> through <code class="docutils literal"><span class="pre">401;5</span></code> -and click the <code class="docutils literal"><span class="pre">Set</span> <span class="pre">to</span> <span class="pre">Default</span></code> button.</li> -</ol> -<div class="admonition seealso"> -<p class="first admonition-title">See also</p> -<p class="last"><span class="target" id="index-4"></span><a class="rfc reference external" href="https://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-directly-access-a-database-or-table-pages"> -<span id="faq1-34"></span><h3>1.34 Can I directly access a database or table pages?<a class="headerlink" href="#can-i-directly-access-a-database-or-table-pages" title="Permalink to this headline">¶</a></h3> -<p>Yes. Out of the box, you can use a <a class="reference internal" href="glossary.html#term-url"><span class="xref std std-term">URL</span></a> like -<code class="docutils literal"><span class="pre">http://server/phpMyAdmin/index.php?server=X&db=database&table=table&target=script</span></code>. -For <code class="docutils literal"><span class="pre">server</span></code> you can use the server number -which refers to the numeric host index (from <code class="docutils literal"><span class="pre">$i</span></code>) in -<code class="file docutils literal"><span class="pre">config.inc.php</span></code>. The table and script parts are optional.</p> -<p>If you want a URL like -<code class="docutils literal"><span class="pre">http://server/phpMyAdmin/database[/table][/script]</span></code>, you need to do some additional configuration. The following -lines apply only for the <a class="reference external" href="https://httpd.apache.org">Apache</a> web server. -First, make sure that you have enabled some features within the Apache global -configuration. You need <code class="docutils literal"><span class="pre">Options</span> <span class="pre">SymLinksIfOwnerMatch</span></code> and <code class="docutils literal"><span class="pre">AllowOverride</span> -<span class="pre">FileInfo</span></code> enabled for directory where phpMyAdmin is installed and you -need mod_rewrite to be enabled. Then you just need to create the -following <a class="reference internal" href="glossary.html#term-htaccess"><span class="xref std std-term">.htaccess</span></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></span><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 class="admonition seealso"> -<p class="first admonition-title">See also</p> -<p class="last"><a class="reference internal" href="#faq4-8"><span class="std std-ref">4.8 Which parameters can I use in the URL that starts phpMyAdmin?</span></a></p> -</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"><span class="xref std std-term">CGI</span></a> using -following rewrite rule:</p> -<div class="highlight-apache"><div class="highlight"><pre><span></span><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 <a class="reference internal" href="glossary.html#term-primary-key"><span class="xref std std-term">primary key</span></a> or with textual <a class="reference internal" href="glossary.html#term-primary-key"><span class="xref std std-term">primary key</span></a>.</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 |