cdocutils.nodes document q)q}q(U nametypesq}q(Xsignon authentication modeqNX setup_scriptqX quick installqNXusing setup scriptq NXhttp://phpmyadmin.net/auth_keyq X quick_installq X upgradingq Xauthentication_modesq X linked-tablesqX setup scriptqXhttp authentication modeqNXconfig authentication modeqNXcookieqXupgrading from an older versionqNXusing authentication modesqNX%securing your phpmyadmin installationqNXmanually creating the fileqNX installationqNXsetupqXswekey authentication modeqNX phpmyadmin configuration storageqNXmain phpmyadmin directoryqXcookie authentication modeqNXswekeyquUsubstitution_defsq}qUparse_messagesq ]q!Ucurrent_sourceq"NU decorationq#NUautofootnote_startq$KUnameidsq%}q&(hUsignon-authentication-modeq'hU setup-scriptq(hUid1q)h Uusing-setup-scriptq*h Uhttp-phpmyadmin-net-auth-keyq+h U quick-installq,h U upgradingq-h Uauthentication-modesq.hU linked-tablesq/hUid2q0hUhttp-authentication-modeq1hUconfig-authentication-modeq2hUcookieq3hUupgrading-from-an-older-versionq4hUusing-authentication-modesq5hU%securing-your-phpmyadmin-installationq6hUmanually-creating-the-fileq7hU installationq8hUsetupq9hUswekey-authentication-modeq:hU phpmyadmin-configuration-storageq;hUmain-phpmyadmin-directoryquUchildrenq?]q@(cdocutils.nodes target qA)qB}qC(U rawsourceqDX .. _setup:qEUparentqFhUsourceqGcdocutils.nodes reprunicode qHXO/usr/local/apache2/htdocs/phpmyadmin/release/phpMyAdmin-4.0.10.10/doc/setup.rstqIqJ}qKbUtagnameqLUtargetqMU attributesqN}qO(UidsqP]qQUbackrefsqR]qSUdupnamesqT]qUUclassesqV]qWUnamesqX]qYUrefidqZh9uUlineq[KUdocumentq\hh?]q]ubcdocutils.nodes section q^)q_}q`(hDUhFhhGhJUexpect_referenced_by_nameqa}qbhhBshLUsectionqchN}qd(hT]qehV]qfhR]qghP]qh(h8h9ehX]qi(hheuh[Kh\hUexpect_referenced_by_idqj}qkh9hBsh?]ql(cdocutils.nodes title qm)qn}qo(hDX InstallationqphFh_hGhJhLUtitleqqhN}qr(hT]qshV]qthR]quhP]qvhX]qwuh[Kh\hh?]qxcdocutils.nodes Text qyX Installationqzq{}q|(hDhphFhnubaubcdocutils.nodes paragraph q})q~}q(hDXphpMyAdmin does not apply any special security methods to the MySQL database server. It is still the system administrator's job to grant permissions on the MySQL databases properly. phpMyAdmin's :guilabel:`Users` page can be used for this.qhFh_hGhJhLU paragraphqhN}q(hT]qhV]qhR]qhP]qhX]quh[Kh\hh?]q(hyXphpMyAdmin does not apply any special security methods to the MySQL database server. It is still the system administrator's job to grant permissions on the MySQL databases properly. phpMyAdmin's qq}q(hDXphpMyAdmin does not apply any special security methods to the MySQL database server. It is still the system administrator's job to grant permissions on the MySQL databases properly. phpMyAdmin's qhFh~ubcdocutils.nodes emphasis q)q}q(hDUhN}q(UrawtextqX:guilabel:`Users`qhP]qhR]qhT]qhV]qXguilabelqahX]quhFh~h?]qhyXUsersqq}q(hDUhFhubahLUemphasisqubhyX page can be used for this.qq}q(hDX page can be used for this.qhFh~ubeubcdocutils.nodes warning q)q}q(hDX=:term:`Mac` users should note that if you are on a version before :term:`Mac OS X`, StuffIt unstuffs with :term:`Mac` formats. So you'll have to resave as in BBEdit to Unix style ALL phpMyAdmin scripts before uploading them to your server, as PHP seems not to like :term:`Mac`-style end of lines character ("``\r``").qhFh_hGhJhLUwarningqhN}q(hT]qhV]qhR]qhP]qhX]quh[Nh\hh?]qh})q}q(hDX=:term:`Mac` users should note that if you are on a version before :term:`Mac OS X`, StuffIt unstuffs with :term:`Mac` formats. So you'll have to resave as in BBEdit to Unix style ALL phpMyAdmin scripts before uploading them to your server, as PHP seems not to like :term:`Mac`-style end of lines character ("``\r``").qhFhhGhJhLhhN}q(hT]qhV]qhR]qhP]qhX]quh[K h?]q(csphinx.addnodes pending_xref q)q}q(hDX :term:`Mac`qhFhhGhJhLU pending_xrefqhN}q(UreftypeqXtermqUrefwarnqU reftargetqXmacqU refdomainqXstdqhP]qhR]qU refexplicitqljhT]qhV]qhX]qUrefdocqUsetupquh[K h?]qh)q}q(hDhhN}q(hT]qhV]q(UxrefqhXstd-termqehR]qhP]qhX]quhFhh?]qhyXMacqمq}q(hDUhFhubahLhubaubhyX7 users should note that if you are on a version before q܅q}q(hDX7 users should note that if you are on a version before qhFhubh)q}q(hDX:term:`Mac OS X`qhFhhGhJhLhhN}q(UreftypeqXtermqhhXmac os xqU refdomainqXstdqhP]qhR]qU refexplicitqhT]qhV]qhX]qhhuh[K h?]qh)q}q(hDhhN}q(hT]qhV]q(hhXstd-termqehR]qhP]qhX]quhFhh?]qhyXMac OS Xqq}q(hDUhFhubahLhubaubhyX, StuffIt unstuffs with qq}q(hDX, StuffIt unstuffs with rhFhubh)r}r(hDX :term:`Mac`rhFhhGhJhLhhN}r(UreftyperXtermrhhXmacrU refdomainrXstdr hP]r hR]r U refexplicitr hT]r hV]rhX]rhhuh[K h?]rh)r}r(hDjhN}r(hT]rhV]r(hj Xstd-termrehR]rhP]rhX]ruhFjh?]rhyXMacrr}r(hDUhFjubahLhubaubhyX formats. So you'll have to resave as in BBEdit to Unix style ALL phpMyAdmin scripts before uploading them to your server, as PHP seems not to like rr}r (hDX formats. So you'll have to resave as in BBEdit to Unix style ALL phpMyAdmin scripts before uploading them to your server, as PHP seems not to like r!hFhubh)r"}r#(hDX :term:`Mac`r$hFhhGhJhLhhN}r%(Ureftyper&Xtermr'hhXmacr(U refdomainr)Xstdr*hP]r+hR]r,U refexplicitr-hT]r.hV]r/hX]r0hhuh[K h?]r1h)r2}r3(hDj$hN}r4(hT]r5hV]r6(hj*Xstd-termr7ehR]r8hP]r9hX]r:uhFj"h?]r;hyXMacr<r=}r>(hDUhFj2ubahLhubaubhyX -style end of lines character ("r?r@}rA(hDX -style end of lines character ("rBhFhubcdocutils.nodes literal rC)rD}rE(hDX``\r``rFhN}rG(hT]rHhV]rIhR]rJhP]rKhX]rLuhFhh?]rMhyX\rrNrO}rP(hDUhFjDubahLUliteralrQubhyX").rRrS}rT(hDX").rUhFhubeubaubhA)rV}rW(hDX.. _quick_install:rXhFh_hGhJhLhMhN}rY(hP]rZhR]r[hT]r\hV]r]hX]r^hZh,uh[Kh\hh?]r_ubh^)r`}ra(hDUhFh_hGhJha}rbh jVshLhchN}rc(hT]rdhV]rehR]rfhP]rg(h,h)ehX]rh(hh euh[Kh\hhj}rih,jVsh?]rj(hm)rk}rl(hDX Quick InstallrmhFj`hGhJhLhqhN}rn(hT]rohV]rphR]rqhP]rrhX]rsuh[Kh\hh?]rthyX Quick Installrurv}rw(hDjmhFjkubaubcdocutils.nodes enumerated_list rx)ry}rz(hDUhFj`hGhJhLUenumerated_listr{hN}r|(Usuffixr}U.hP]r~hR]rhT]rUprefixrUhV]rhX]rUenumtyperUarabicruh[Kh\hh?]r(cdocutils.nodes list_item r)r}r(hDXChoose an appropriate distribution kit from the phpmyadmin.net Downloads page. Some kits contain only the English messages, others contain all languages. We'll assume you chose a kit whose name looks like ``phpMyAdmin-x.x.x -all-languages.tar.gz``.rhFjyhGhJhLU list_itemrhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXChoose an appropriate distribution kit from the phpmyadmin.net Downloads page. Some kits contain only the English messages, others contain all languages. We'll assume you chose a kit whose name looks like ``phpMyAdmin-x.x.x -all-languages.tar.gz``.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh?]r(hyXChoose an appropriate distribution kit from the phpmyadmin.net Downloads page. Some kits contain only the English messages, others contain all languages. We'll assume you chose a kit whose name looks like rr}r(hDXChoose an appropriate distribution kit from the phpmyadmin.net Downloads page. Some kits contain only the English messages, others contain all languages. We'll assume you chose a kit whose name looks like rhFjubjC)r}r(hDX*``phpMyAdmin-x.x.x -all-languages.tar.gz``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX&phpMyAdmin-x.x.x -all-languages.tar.gzrr}r(hDUhFjubahLjQubhyX.r}r(hDX.hFjubeubaubj)r}r(hDX^Untar or unzip the distribution (be sure to unzip the subdirectories): ``tar -xzvf phpMyAdmin_x.x.x-all-languages.tar.gz`` in your webserver's document root. If you don't have direct access to your document root, put the files in a directory on your local machine, and, after step 4, transfer the directory on your web server using, for example, ftp.rhFjyhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDX^Untar or unzip the distribution (be sure to unzip the subdirectories): ``tar -xzvf phpMyAdmin_x.x.x-all-languages.tar.gz`` in your webserver's document root. If you don't have direct access to your document root, put the files in a directory on your local machine, and, after step 4, transfer the directory on your web server using, for example, ftp.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh?]r(hyXGUntar or unzip the distribution (be sure to unzip the subdirectories): rr}r(hDXGUntar or unzip the distribution (be sure to unzip the subdirectories): rhFjubjC)r}r(hDX3``tar -xzvf phpMyAdmin_x.x.x-all-languages.tar.gz``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX/tar -xzvf phpMyAdmin_x.x.x-all-languages.tar.gzrr}r(hDUhFjubahLjQubhyX in your webserver's document root. If you don't have direct access to your document root, put the files in a directory on your local machine, and, after step 4, transfer the directory on your web server using, for example, ftp.rr}r(hDX in your webserver's document root. If you don't have direct access to your document root, put the files in a directory on your local machine, and, after step 4, transfer the directory on your web server using, for example, ftp.rhFjubeubaubj)r}r(hDXEnsure that all the scripts have the appropriate owner (if PHP is running in safe mode, having some scripts with an owner different from the owner of other scripts will be a problem). See :ref:`faq4_2` and :ref:`faq1_26` for suggestions.rhFjyhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXEnsure that all the scripts have the appropriate owner (if PHP is running in safe mode, having some scripts with an owner different from the owner of other scripts will be a problem). See :ref:`faq4_2` and :ref:`faq1_26` for suggestions.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[K"h?]r(hyXEnsure that all the scripts have the appropriate owner (if PHP is running in safe mode, having some scripts with an owner different from the owner of other scripts will be a problem). See rr}r(hDXEnsure that all the scripts have the appropriate owner (if PHP is running in safe mode, having some scripts with an owner different from the owner of other scripts will be a problem). See rhFjubh)r}r(hDX :ref:`faq4_2`rhFjhGhJhLhhN}r(UreftyperXrefrhhXfaq4_2rU refdomainrXstdrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[K"h?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]r uhFjh?]r hyXfaq4_2r r }r (hDUhFjubahLhubaubhyX and rr}r(hDX and rhFjubh)r}r(hDX:ref:`faq1_26`rhFjhGhJhLhhN}r(UreftyperXrefrhhXfaq1_26rU refdomainrXstdrhP]rhR]rU refexplicitrhT]rhV]rhX]r hhuh[K"h?]r!h)r"}r#(hDjhN}r$(hT]r%hV]r&(hjXstd-refr'ehR]r(hP]r)hX]r*uhFjh?]r+hyXfaq1_26r,r-}r.(hDUhFj"ubahLhubaubhyX for suggestions.r/r0}r1(hDX for suggestions.r2hFjubeubaubj)r3}r4(hDXgNow you must configure your installation. There are two methods that can be used. Traditionally, users have hand-edited a copy of :file:`config.inc.php`, but now a wizard-style setup script is provided for those who prefer a graphical installation. Creating a :file:`config.inc.php` is still a quick way to get started and needed for some advanced features. r5hFjyhGhJhLjhN}r6(hT]r7hV]r8hR]r9hP]r:hX]r;uh[Nh\hh?]r<h})r=}r>(hDXeNow you must configure your installation. There are two methods that can be used. Traditionally, users have hand-edited a copy of :file:`config.inc.php`, but now a wizard-style setup script is provided for those who prefer a graphical installation. Creating a :file:`config.inc.php` is still a quick way to get started and needed for some advanced features.r?hFj3hGhJhLhhN}r@(hT]rAhV]rBhR]rChP]rDhX]rEuh[K&h?]rF(hyXNow you must configure your installation. There are two methods that can be used. Traditionally, users have hand-edited a copy of rGrH}rI(hDXNow you must configure your installation. There are two methods that can be used. Traditionally, users have hand-edited a copy of rJhFj=ubjC)rK}rL(hDUhN}rM(hP]rNhR]rOhT]rPhV]rQXfilerRaUrolerSjRhX]rTuhFj=h?]rUhyXconfig.inc.phprVrW}rX(hDXconfig.inc.phprYhFjKubahLjQubhyXl, but now a wizard-style setup script is provided for those who prefer a graphical installation. Creating a rZr[}r\(hDXl, but now a wizard-style setup script is provided for those who prefer a graphical installation. Creating a r]hFj=ubjC)r^}r_(hDUhN}r`(hP]rahR]rbhT]rchV]rdXfilereaUrolerfjehX]rguhFj=h?]rhhyXconfig.inc.phprirj}rk(hDXconfig.inc.phprlhFj^ubahLjQubhyXK is still a quick way to get started and needed for some advanced features.rmrn}ro(hDXK is still a quick way to get started and needed for some advanced features.rphFj=ubeubaubeubh^)rq}rr(hDUhFj`hGhJhLhchN}rs(hT]rthV]ruhR]rvhP]rwh7ahX]rxhauh[K/h\hh?]ry(hm)rz}r{(hDXManually creating the filer|hFjqhGhJhLhqhN}r}(hT]r~hV]rhR]rhP]rhX]ruh[K/h\hh?]rhyXManually creating the filerr}r(hDj|hFjzubaubh})r}r(hDX[To manually create the file, simply use your text editor to create the file :file:`config.inc.php` (you can copy :file:`config.sample.inc.php` to get minimal configuration file) in the main (top-level) phpMyAdmin directory (the one that contains :file:`index.php`). phpMyAdmin first loads :file:`libraries/config.default.php` and then overrides those values with anything found in :file:`config.inc.php`. If the default value is okay for a particular setting, there is no need to include it in :file:`config.inc.php`. You'll need a few directives to get going, a simple configuration may look like this:rhFjqhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[K1h\hh?]r(hyXLTo manually create the file, simply use your text editor to create the file rr}r(hDXLTo manually create the file, simply use your text editor to create the file rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX (you can copy rr}r(hDX (you can copy rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.sample.inc.phprr}r(hDXconfig.sample.inc.phprhFjubahLjQubhyXh to get minimal configuration file) in the main (top-level) phpMyAdmin directory (the one that contains rr}r(hDXh to get minimal configuration file) in the main (top-level) phpMyAdmin directory (the one that contains rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyX index.phprr}r(hDX index.phprhFjubahLjQubhyX). phpMyAdmin first loads rr}r(hDX). phpMyAdmin first loads rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXlibraries/config.default.phprr}r(hDXlibraries/config.default.phprhFjubahLjQubhyX8 and then overrides those values with anything found in rr}r(hDX8 and then overrides those values with anything found in rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX[. If the default value is okay for a particular setting, there is no need to include it in rr}r(hDX[. If the default value is okay for a particular setting, there is no need to include it in rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyXW. You'll need a few directives to get going, a simple configuration may look like this:rr}r(hDXW. You'll need a few directives to get going, a simple configuration may look like this:rhFjubeubcdocutils.nodes literal_block r)r}r (hDXr hFjqhGhJhLU literal_blockr hN}r (Ulinenosr UlanguagerXphprU xml:spacerUpreserverhP]rhR]rhT]rhV]rhX]ruh[K;h\hh?]rhyXrr}r(hDUhFjubaubh})r}r(hDX;Or, if you prefer to not be prompted every time you log in:rhFjqhGhJhLhhN}r(hT]rhV]r hR]r!hP]r"hX]r#uh[KFh\hh?]r$hyX;Or, if you prefer to not be prompted every time you log in:r%r&}r'(hDjhFjubaubj)r(}r)(hDXr*hFjqhGhJhLj hN}r+(j jXphpr,jjhP]r-hR]r.hT]r/hV]r0hX]r1uh[KHh\hh?]r2hyXr3r4}r5(hDUhFj(ubaubh})r6}r7(hDX`For a full explanation of possible configuration values, see the :ref:`config` of this document.r8hFjqhGhJhLhhN}r9(hT]r:hV]r;hR]r<hP]r=hX]r>uh[KTh\hh?]r?(hyXAFor a full explanation of possible configuration values, see the r@rA}rB(hDXAFor a full explanation of possible configuration values, see the rChFj6ubh)rD}rE(hDX :ref:`config`rFhFj6hGhJhLhhN}rG(UreftyperHXrefrIhhXconfigrJU refdomainrKXstdrLhP]rMhR]rNU refexplicitrOhT]rPhV]rQhX]rRhhuh[KTh?]rSh)rT}rU(hDjFhN}rV(hT]rWhV]rX(hjLXstd-refrYehR]rZhP]r[hX]r\uhFjDh?]r]hyXconfigr^r_}r`(hDUhFjTubahLhubaubhyX of this document.rarb}rc(hDX of this document.rdhFj6ubeubcsphinx.addnodes index re)rf}rg(hDUhFjqhGhJhLUindexrhhN}ri(hP]rjhR]rkhT]rlhV]rmhX]rnUentriesro]rp(UsinglerqX Setup scriptUindex-0rrUtrsaUinlinertuh[KXh\hh?]ruubhA)rv}rw(hDUhFjqhGhJhLhMhN}rx(hP]ryhR]rzhT]r{hV]r|hX]r}hZjruh[KXh\hh?]r~ubhA)r}r(hDX.. _setup_script:rhFjqhGhJha}rhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZh(uh[KYh\hhj}rjrjvsh?]rubeubh^)r}r(hDUhFj`hGhJha}rhjshLhchN}r(hT]rhV]rhR]rhP]r(h*h(jrehX]r(h heuh[K\h\hhj}r(jrjvh(juh?]r(hm)r}r(hDXUsing Setup scriptrhFjhGhJhLhqhN}r(hT]rhV]rhR]rhP]rhX]ruh[K\h\hh?]rhyXUsing Setup scriptrr}r(hDjhFjubaubh})r}r(hDXInstead of manually editing :file:`config.inc.php`, you can use the `Setup Script `_. First you must manually create a folder ``config`` in the phpMyAdmin directory. This is a security measure. On a Linux/Unix system you can use the following commands:rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[K^h\hh?]r(hyXInstead of manually editing rr}r(hDXInstead of manually editing rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX, you can use the rr}r(hDX, you can use the rhFjubcdocutils.nodes reference r)r}r(hDX`Setup Script `_rhN}r(UnamerX Setup ScriptrUrefurirXsetup/rhP]rhR]rhT]rhV]rhX]ruhFjh?]rhyX Setup Scriptrr}r(hDUhFjubahLU referencerubhA)r}r(hDX rU referencedrKhFjhLhMhN}r(UrefurirjhP]rh0ahR]rhT]rhV]rhX]rhauh?]rubhyX*. First you must manually create a folder rr}r(hDX*. First you must manually create a folder rhFjubjC)r}r(hDX ``config``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXconfigrr}r(hDUhFjubahLjQubhyXt in the phpMyAdmin directory. This is a security measure. On a Linux/Unix system you can use the following commands:rr}r(hDXt in the phpMyAdmin directory. This is a security measure. On a Linux/Unix system you can use the following commands:rhFjubeubj)r}r(hDXcd phpMyAdmin mkdir config # create directory for saving chmod o+rw config # give it world writable permissionsrhFjhGhJhLj hN}r(j jXshrjjhP]rhR]rhT]rhV]rhX]ruh[Kch\hh?]rhyXcd phpMyAdmin mkdir config # create directory for saving chmod o+rw config # give it world writable permissionsrr}r(hDUhFjubaubh})r}r(hDX:And to edit an existing configuration, copy it over first:rhFjhGhJhLhhN}r (hT]r hV]r hR]r hP]r hX]ruh[Kjh\hh?]rhyX:And to edit an existing configuration, copy it over first:rr}r(hDjhFjubaubj)r}r(hDXcp config.inc.php config/ # copy current configuration for editing chmod o+w config/config.inc.php # give it world writable permissionsrhFjhGhJhLj hN}r(j jXshrjjhP]rhR]rhT]rhV]rhX]ruh[Klh\hh?]rhyXcp config.inc.php config/ # copy current configuration for editing chmod o+w config/config.inc.php # give it world writable permissionsrr}r (hDUhFjubaubh})r!}r"(hDXOn other platforms, simply create the folder and ensure that your web server has read and write access to it. :ref:`faq1_26` can help with this.r#hFjhGhJhLhhN}r$(hT]r%hV]r&hR]r'hP]r(hX]r)uh[Krh\hh?]r*(hyXnOn other platforms, simply create the folder and ensure that your web server has read and write access to it. r+r,}r-(hDXnOn other platforms, simply create the folder and ensure that your web server has read and write access to it. r.hFj!ubh)r/}r0(hDX:ref:`faq1_26`r1hFj!hGhJhLhhN}r2(Ureftyper3Xrefr4hhXfaq1_26r5U refdomainr6Xstdr7hP]r8hR]r9U refexplicitr:hT]r;hV]r<hX]r=hhuh[Krh?]r>h)r?}r@(hDj1hN}rA(hT]rBhV]rC(hj7Xstd-refrDehR]rEhP]rFhX]rGuhFj/h?]rHhyXfaq1_26rIrJ}rK(hDUhFj?ubahLhubaubhyX can help with this.rLrM}rN(hDX can help with this.rOhFj!ubeubh})rP}rQ(hDXNext, open ``setup/`` in your browser. If you have an existing configuration, use the ``Load`` button to bring its content inside the setup panel. Note that **changes are not saved to disk until explicitly choose ``Save``** from the *Configuration* area of the screen. Normally the script saves the new :file:`config.inc.php` to the ``config/`` directory, but if the webserver does not have the proper permissions you may see the error "Cannot load or save configuration." Ensure that the ``config/`` directory exists and has the proper permissions - or use the ``Download`` link to save the config file locally and upload it (via FTP or some similar means) to the proper location.rRhFjhGhJhLhhN}rS(hT]rThV]rUhR]rVhP]rWhX]rXuh[Kvh\hh?]rY(hyX Next, open rZr[}r\(hDX Next, open r]hFjPubjC)r^}r_(hDX ``setup/``r`hN}ra(hT]rbhV]rchR]rdhP]rehX]rfuhFjPh?]rghyXsetup/rhri}rj(hDUhFj^ubahLjQubhyXA in your browser. If you have an existing configuration, use the rkrl}rm(hDXA in your browser. If you have an existing configuration, use the rnhFjPubjC)ro}rp(hDX``Load``rqhN}rr(hT]rshV]rthR]ruhP]rvhX]rwuhFjPh?]rxhyXLoadryrz}r{(hDUhFjoubahLjQubhyX? button to bring its content inside the setup panel. Note that r|r}}r~(hDX? button to bring its content inside the setup panel. Note that rhFjPubcdocutils.nodes strong r)r}r(hDXB**changes are not saved to disk until explicitly choose ``Save``**rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjPh?]rhyX>changes are not saved to disk until explicitly choose ``Save``rr}r(hDUhFjubahLUstrongrubhyX from the rr}r(hDX from the rhFjPubh)r}r(hDX*Configuration*rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjPh?]rhyX Configurationrr}r(hDUhFjubahLhubhyX7 area of the screen. Normally the script saves the new rr}r(hDX7 area of the screen. Normally the script saves the new rhFjPubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjPh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX to the rr}r(hDX to the rhFjPubjC)r}r(hDX ``config/``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjPh?]rhyXconfig/rr}r(hDUhFjubahLjQubhyX directory, but if the webserver does not have the proper permissions you may see the error "Cannot load or save configuration." Ensure that the rr}r(hDX directory, but if the webserver does not have the proper permissions you may see the error "Cannot load or save configuration." Ensure that the rhFjPubjC)r}r(hDX ``config/``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjPh?]rhyXconfig/rr}r(hDUhFjubahLjQubhyX> directory exists and has the proper permissions - or use the rr}r(hDX> directory exists and has the proper permissions - or use the rhFjPubjC)r}r(hDX ``Download``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjPh?]rhyXDownloadrr}r(hDUhFjubahLjQubhyXk link to save the config file locally and upload it (via FTP or some similar means) to the proper location.rr}r(hDXk link to save the config file locally and upload it (via FTP or some similar means) to the proper location.rhFjPubeubh})r}r(hDXOnce the file has been saved, it must be moved out of the ``config/`` directory and the permissions must be reset, again as a security measure:rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r(hyX:Once the file has been saved, it must be moved out of the rr}r(hDX:Once the file has been saved, it must be moved out of the rhFjubjC)r}r(hDX ``config/``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXconfig/rr}r(hDUhFjubahLjQubhyXJ directory and the permissions must be reset, again as a security measure:rr}r(hDXJ directory and the permissions must be reset, again as a security measure:rhFjubeubj)r }r (hDXmv config/config.inc.php . # move file to current directory chmod o-rw config.inc.php # remove world read and write permissions rm -rf config # remove not needed directoryr hFjhGhJhLj hN}r (j jXshr jjhP]rhR]rhT]rhV]rhX]ruh[Kh\hh?]rhyXmv config/config.inc.php . # move file to current directory chmod o-rw config.inc.php # remove world read and write permissions rm -rf config # remove not needed directoryrr}r(hDUhFj ubaubh})r}r(hDXNow the file is ready to be used. You can choose to review or edit the file with your favorite editor, if you prefer to set some advanced options which the setup script does not provide.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r hyXNow the file is ready to be used. You can choose to review or edit the file with your favorite editor, if you prefer to set some advanced options which the setup script does not provide.r!r"}r#(hDjhFjubaubjx)r$}r%(hDUhFjhGhJhLj{hN}r&(j}U.hP]r'hR]r(hT]r)jUhV]r*hX]r+jjuh[Kh\hh?]r,(j)r-}r.(hDXIf you are using the ``auth_type`` "config", it is suggested that you protect the phpMyAdmin installation directory because using config does not require a user to enter a password to access the phpMyAdmin installation. Use of an alternate authentication method is recommended, for example with HTTP–AUTH in a :term:`.htaccess` file or switch to using ``auth_type`` cookie or http. See the :ref:`faqmultiuser` for additional information, especially :ref:`faq4_4`.r/hFj$hGhJhLjhN}r0(hT]r1hV]r2hR]r3hP]r4hX]r5uh[Nh\hh?]r6h})r7}r8(hDXIf you are using the ``auth_type`` "config", it is suggested that you protect the phpMyAdmin installation directory because using config does not require a user to enter a password to access the phpMyAdmin installation. Use of an alternate authentication method is recommended, for example with HTTP–AUTH in a :term:`.htaccess` file or switch to using ``auth_type`` cookie or http. See the :ref:`faqmultiuser` for additional information, especially :ref:`faq4_4`.r9hFj-hGhJhLhhN}r:(hT]r;hV]r<hR]r=hP]r>hX]r?uh[Kh?]r@(hyXIf you are using the rArB}rC(hDXIf you are using the rDhFj7ubjC)rE}rF(hDX ``auth_type``rGhN}rH(hT]rIhV]rJhR]rKhP]rLhX]rMuhFj7h?]rNhyX auth_typerOrP}rQ(hDUhFjEubahLjQubhyX "config", it is suggested that you protect the phpMyAdmin installation directory because using config does not require a user to enter a password to access the phpMyAdmin installation. Use of an alternate authentication method is recommended, for example with HTTP–AUTH in a rRrS}rT(hDX "config", it is suggested that you protect the phpMyAdmin installation directory because using config does not require a user to enter a password to access the phpMyAdmin installation. Use of an alternate authentication method is recommended, for example with HTTP–AUTH in a rUhFj7ubh)rV}rW(hDX:term:`.htaccess`rXhFj7hGhJhLhhN}rY(UreftyperZXtermr[hhX .htaccessr\U refdomainr]Xstdr^hP]r_hR]r`U refexplicitrahT]rbhV]rchX]rdhhuh[Kh?]reh)rf}rg(hDjXhN}rh(hT]rihV]rj(hj^Xstd-termrkehR]rlhP]rmhX]rnuhFjVh?]rohyX .htaccessrprq}rr(hDUhFjfubahLhubaubhyX file or switch to using rsrt}ru(hDX file or switch to using rvhFj7ubjC)rw}rx(hDX ``auth_type``ryhN}rz(hT]r{hV]r|hR]r}hP]r~hX]ruhFj7h?]rhyX auth_typerr}r(hDUhFjwubahLjQubhyX cookie or http. See the rr}r(hDX cookie or http. See the rhFj7ubh)r}r(hDX:ref:`faqmultiuser`rhFj7hGhJhLhhN}r(UreftyperXrefrhhX faqmultiuserrU refdomainrXstdrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[Kh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFjh?]rhyX faqmultiuserrr}r(hDUhFjubahLhubaubhyX( for additional information, especially rr}r(hDX( for additional information, especially rhFj7ubh)r}r(hDX :ref:`faq4_4`rhFj7hGhJhLhhN}r(UreftyperXrefrhhXfaq4_4rU refdomainrXstdrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[Kh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFjh?]rhyXfaq4_4rr}r(hDUhFjubahLhubaubhyX.r}r(hDX.hFj7ubeubaubj)r}r(hDXOpen the `main phpMyAdmin directory `_ in your browser. phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using :term:`HTTP` or cookie authentication mode.rhFj$hGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXOpen the `main phpMyAdmin directory `_ in your browser. phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using :term:`HTTP` or cookie authentication mode.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh?]r(hyX Open the rr}r(hDX Open the rhFjubj)r}r(hDX(`main phpMyAdmin directory `_rhN}r(UnamerXmain phpMyAdmin directoryrjX index.phprhP]rhR]rhT]rhV]rhX]ruhFjh?]rhyXmain phpMyAdmin directoryrr}r(hDUhFjubahLjubhA)r}r(hDX rjKhFjhLhMhN}r(UrefurirjhP]rhhP]r?hX]r@uhFj*h?]rAhyX ./librariesrBrC}rD(hDUhFj8ubahLjQubhyX and rErF}rG(hDX and rHhFj*ubjC)rI}rJ(hDX``./setup/lib``rKhN}rL(hT]rMhV]rNhR]rOhP]rPhX]rQuhFj*h?]rRhyX ./setup/librSrT}rU(hDUhFjIubahLjQubhyXM subfolders in your webserver configuration. For Apache you can use supplied rVrW}rX(hDXM subfolders in your webserver configuration. For Apache you can use supplied rYhFj*ubh)rZ}r[(hDX:term:`.htaccess`r\hFj*hGhJhLhhN}r](Ureftyper^Xtermr_hhX .htaccessr`U refdomainraXstdrbhP]rchR]rdU refexplicitrehT]rfhV]rghX]rhhhuh[Kh?]rih)rj}rk(hDj\hN}rl(hT]rmhV]rn(hjbXstd-termroehR]rphP]rqhX]rruhFjZh?]rshyX .htaccessrtru}rv(hDUhFjjubahLhubaubhyX file in that folder, for other webservers, you should configure this yourself. Such configuration prevents from possible path exposure and cross side scripting vulnerabilities that might happen to be found in that code.rwrx}ry(hDX file in that folder, for other webservers, you should configure this yourself. Such configuration prevents from possible path exposure and cross side scripting vulnerabilities that might happen to be found in that code.rzhFj*ubeubaubj)r{}r|(hDXIt is generally good idea to protect public phpMyAdmin installation against access by robots as they usually can not do anything good there. You can do this using ``robots.txt`` file in root of your webserver or limit access by web server configuration, see :ref:`faq1_42`. r}hFj$hGhJhLjhN}r~(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXIt is generally good idea to protect public phpMyAdmin installation against access by robots as they usually can not do anything good there. You can do this using ``robots.txt`` file in root of your webserver or limit access by web server configuration, see :ref:`faq1_42`.rhFj{hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh?]r(hyXIt is generally good idea to protect public phpMyAdmin installation against access by robots as they usually can not do anything good there. You can do this using rr}r(hDXIt is generally good idea to protect public phpMyAdmin installation against access by robots as they usually can not do anything good there. You can do this using rhFjubjC)r}r(hDX``robots.txt``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX robots.txtrr}r(hDUhFjubahLjQubhyXQ file in root of your webserver or limit access by web server configuration, see rr}r(hDXQ file in root of your webserver or limit access by web server configuration, see rhFjubh)r}r(hDX:ref:`faq1_42`rhFjhGhJhLhhN}r(UreftyperXrefrhhXfaq1_42rU refdomainrXstdrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[Kh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFjh?]rhyXfaq1_42rr}r(hDUhFjubahLhubaubhyX.r}r(hDX.hFjubeubaubeubje)r}r(hDUhFjhGhJhLjhhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqXConfiguration storageUindex-1rUtr(jqX phpMyAdmin configuration storagejUtr(jqXpmadbjUtrejtuh[Kh\hh?]rubhA)r}r(hDUhFjhGhJhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZjuh[Kh\hh?]rubhA)r}r(hDX.. _linked-tables:rhFjhGhJha}rhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZh/uh[Kh\hhj}rjjsh?]rubeubeubh^)r}r(hDUhFh_hGhJha}rhjshLhchN}r(hT]rhV]rhR]rhP]r(h;h/jehX]r(hheuh[Kh\hhj}r(jjh/juh?]r(hm)r}r(hDX phpMyAdmin configuration storagerhFjhGhJhLhqhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]rhyX phpMyAdmin configuration storagerr}r(hDjhFjubaubh})r}r(hDXFor a whole set of new features (bookmarks, comments, :term:`SQL`-history, tracking mechanism, :term:`PDF`-generation, column contents transformation, etc.) you need to create a set of special tables. Those tables can be located in your own database, or in a central database for a multi-user installation (this database would then be accessed by the controluser, so no other user should have rights to it).rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r(hyX6For a whole set of new features (bookmarks, comments, rr }r (hDX6For a whole set of new features (bookmarks, comments, r hFjubh)r }r (hDX :term:`SQL`rhFjhGhJhLhhN}r(UreftyperXtermrhhXsqlrU refdomainrXstdrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[Kh?]rh)r}r(hDjhN}r(hT]rhV]r (hjXstd-termr!ehR]r"hP]r#hX]r$uhFj h?]r%hyXSQLr&r'}r((hDUhFjubahLhubaubhyX-history, tracking mechanism, r)r*}r+(hDX-history, tracking mechanism, r,hFjubh)r-}r.(hDX :term:`PDF`r/hFjhGhJhLhhN}r0(Ureftyper1Xtermr2hhXpdfr3U refdomainr4Xstdr5hP]r6hR]r7U refexplicitr8hT]r9hV]r:hX]r;hhuh[Kh?]r<h)r=}r>(hDj/hN}r?(hT]r@hV]rA(hj5Xstd-termrBehR]rChP]rDhX]rEuhFj-h?]rFhyXPDFrGrH}rI(hDUhFj=ubahLhubaubhyX.-generation, column contents transformation, etc.) you need to create a set of special tables. Those tables can be located in your own database, or in a central database for a multi-user installation (this database would then be accessed by the controluser, so no other user should have rights to it).rJrK}rL(hDX.-generation, column contents transformation, etc.) you need to create a set of special tables. Those tables can be located in your own database, or in a central database for a multi-user installation (this database would then be accessed by the controluser, so no other user should have rights to it).rMhFjubeubh})rN}rO(hDXPlease look at your ``./examples/`` directory, where you should find a file called *create\_tables.sql*. (If you are using a Windows server, pay special attention to :ref:`faq1_23`).rPhFjhGhJhLhhN}rQ(hT]rRhV]rShR]rThP]rUhX]rVuh[Kh\hh?]rW(hyXPlease look at your rXrY}rZ(hDXPlease look at your r[hFjNubjC)r\}r](hDX``./examples/``r^hN}r_(hT]r`hV]rahR]rbhP]rchX]rduhFjNh?]rehyX ./examples/rfrg}rh(hDUhFj\ubahLjQubhyX0 directory, where you should find a file called rirj}rk(hDX0 directory, where you should find a file called rlhFjNubh)rm}rn(hDX*create\_tables.sql*rohN}rp(hT]rqhV]rrhR]rshP]rthX]ruuhFjNh?]rvhyXcreate_tables.sqlrwrx}ry(hDUhFjmubahLhubhyX?. (If you are using a Windows server, pay special attention to rzr{}r|(hDX?. (If you are using a Windows server, pay special attention to r}hFjNubh)r~}r(hDX:ref:`faq1_23`rhFjNhGhJhLhhN}r(UreftyperXrefrhhXfaq1_23rU refdomainrXstdrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[Kh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFj~h?]rhyXfaq1_23rr}r(hDUhFjubahLhubaubhyX).rr}r(hDX).rhFjNubeubh})r}r(hDXIf you already had this infrastructure and upgraded to MySQL 4.1.2 or newer, please use :file:`examples/upgrade_tables_mysql_4_1_2+.sql` and then create new tables by importing :file:`examples/create_tables.sql`.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r(hyXXIf you already had this infrastructure and upgraded to MySQL 4.1.2 or newer, please use rr}r(hDXXIf you already had this infrastructure and upgraded to MySQL 4.1.2 or newer, please use rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyX(examples/upgrade_tables_mysql_4_1_2+.sqlrr}r(hDX(examples/upgrade_tables_mysql_4_1_2+.sqlrhFjubahLjQubhyX) and then create new tables by importing rr}r(hDX) and then create new tables by importing rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXexamples/create_tables.sqlrr}r(hDXexamples/create_tables.sqlrhFjubahLjQubhyX.r}r(hDX.hFjubeubh})r}r(hDXYou can use your phpMyAdmin to create the tables for you. Please be aware that you may need special (administrator) privileges to create the database and tables, and that the script may need some tuning, depending on the database name.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]rhyXYou can use your phpMyAdmin to create the tables for you. Please be aware that you may need special (administrator) privileges to create the database and tables, and that the script may need some tuning, depending on the database name.rr}r(hDjhFjubaubh})r}r(hDXKAfter having imported the :file:`examples/create_tables.sql` file, you should specify the table names in your :file:`config.inc.php` file. The directives used for that can be found in the :ref:`config`. You will also need to have a controluser with the proper rights to those tables (see section :ref:`authentication_modes` below).rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r(hyXAfter having imported the rr}r(hDXAfter having imported the rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXexamples/create_tables.sqlrr}r(hDXexamples/create_tables.sqlrhFjubahLjQubhyX2 file, you should specify the table names in your rr}r(hDX2 file, you should specify the table names in your rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]r hyXconfig.inc.phpr r }r (hDXconfig.inc.phpr hFjubahLjQubhyX8 file. The directives used for that can be found in the rr}r(hDX8 file. The directives used for that can be found in the rhFjubh)r}r(hDX :ref:`config`rhFjhGhJhLhhN}r(UreftyperXrefrhhXconfigrU refdomainrXstdrhP]rhR]rU refexplicitrhT]rhV]rhX]r hhuh[Kh?]r!h)r"}r#(hDjhN}r$(hT]r%hV]r&(hjXstd-refr'ehR]r(hP]r)hX]r*uhFjh?]r+hyXconfigr,r-}r.(hDUhFj"ubahLhubaubhyX_. You will also need to have a controluser with the proper rights to those tables (see section r/r0}r1(hDX_. You will also need to have a controluser with the proper rights to those tables (see section r2hFjubh)r3}r4(hDX:ref:`authentication_modes`r5hFjhGhJhLhhN}r6(Ureftyper7Xrefr8hhXauthentication_modesr9U refdomainr:Xstdr;hP]r<hR]r=U refexplicitr>hT]r?hV]r@hX]rAhhuh[Kh?]rBh)rC}rD(hDj5hN}rE(hT]rFhV]rG(hj;Xstd-refrHehR]rIhP]rJhX]rKuhFj3h?]rLhyXauthentication_modesrMrN}rO(hDUhFjCubahLhubaubhyX below).rPrQ}rR(hDX below).rShFjubeubhA)rT}rU(hDX.. _upgrading:rVhFjhGhJhLhMhN}rW(hP]rXhR]rYhT]rZhV]r[hX]r\hZh-uh[Kh\hh?]r]ubeubh^)r^}r_(hDUhFh_hGhJha}r`h jTshLhchN}ra(hT]rbhV]rchR]rdhP]re(h4h-ehX]rf(hh euh[Kh\hhj}rgh-jTsh?]rh(hm)ri}rj(hDXUpgrading from an older versionrkhFj^hGhJhLhqhN}rl(hT]rmhV]rnhR]rohP]rphX]rquh[Kh\hh?]rrhyXUpgrading from an older versionrsrt}ru(hDjkhFjiubaubh})rv}rw(hDX\Simply copy :file:`config.inc.php` from your previous installation into the newly unpacked one. Configuration files from old versions may require some tweaking as some options have been changed or removed. For compatibility with PHP 6, remove a ``set_magic_quotes_runtime(0);`` statement that you might find near the end of your configuration file.rxhFj^hGhJhLhhN}ry(hT]rzhV]r{hR]r|hP]r}hX]r~uh[Kh\hh?]r(hyX Simply copy rr}r(hDX Simply copy rhFjvubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjvh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX from your previous installation into the newly unpacked one. Configuration files from old versions may require some tweaking as some options have been changed or removed. For compatibility with PHP 6, remove a rr}r(hDX from your previous installation into the newly unpacked one. Configuration files from old versions may require some tweaking as some options have been changed or removed. For compatibility with PHP 6, remove a rhFjvubjC)r}r(hDX ``set_magic_quotes_runtime(0);``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjvh?]rhyXset_magic_quotes_runtime(0);rr}r(hDUhFjubahLjQubhyXG statement that you might find near the end of your configuration file.rr}r(hDXG statement that you might find near the end of your configuration file.rhFjvubeubh})r}r(hDXYou should **not** copy :file:`libraries/config.default.php` over :file:`config.inc.php` because the default configuration file is version- specific.rhFj^hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r(hyX You should rr}r(hDX You should rhFjubj)r}r(hDX**not**rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXnotrr}r(hDUhFjubahLjubhyX copy rr}r(hDX copy rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXlibraries/config.default.phprr}r(hDXlibraries/config.default.phprhFjubahLjQubhyX over rr}r(hDX over rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX= because the default configuration file is version- specific.rr}r(hDX= because the default configuration file is version- specific.rhFjubeubh})r}r(hDXIf you have upgraded your MySQL server from a version previous to 4.1.2 to version 5.x or newer and if you use the phpMyAdmin configuration storage, you should run the :term:`SQL` script found in :file:`examples/upgrade_tables_mysql_4_1_2+.sql`.rhFj^hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r(hyXIf you have upgraded your MySQL server from a version previous to 4.1.2 to version 5.x or newer and if you use the phpMyAdmin configuration storage, you should run the rr}r(hDXIf you have upgraded your MySQL server from a version previous to 4.1.2 to version 5.x or newer and if you use the phpMyAdmin configuration storage, you should run the rhFjubh)r}r(hDX :term:`SQL`rhFjhGhJhLhhN}r(UreftyperXtermr hhXsqlr U refdomainr Xstdr hP]r hR]r U refexplicitr hT]r hV]r hX]r hhuh[Kh?]r h)r }r (hDjhN}r (hT]r hV]r (hj Xstd-termr ehR]r hP]r hX]r uhFjh?]r hyXSQLr r }r (hDUhFj ubahLhubaubhyX script found in r r }r (hDX script found in r hFjubjC)r }r (hDUhN}r (hP]r hR]r hT]r! hV]r" Xfiler# aUroler$ j# hX]r% uhFjh?]r& hyX(examples/upgrade_tables_mysql_4_1_2+.sqlr' r( }r) (hDX(examples/upgrade_tables_mysql_4_1_2+.sqlr* hFj ubahLjQubhyX.r+ }r, (hDX.hFjubeubje)r- }r. (hDUhFj^hGhJhLjhhN}r/ (hP]r0 hR]r1 hT]r2 hV]r3 hX]r4 jo]r5 (jqXAuthentication modeUindex-2r6 Utr7 ajtuh[Kh\hh?]r8 ubhA)r9 }r: (hDUhFj^hGhJhLhMhN}r; (hP]r< hR]r= hT]r> hV]r? hX]r@ hZj6 uh[Kh\hh?]rA ubhA)rB }rC (hDX.. _authentication_modes:rD hFj^hGhJha}rE hLhMhN}rF (hP]rG hR]rH hT]rI hV]rJ hX]rK hZh.uh[Kh\hhj}rL j6 j9 sh?]rM ubeubh^)rN }rO (hDUhFh_hGhJha}rP h jB shLhchN}rQ (hT]rR hV]rS hR]rT hP]rU (h5h.j6 ehX]rV (hh euh[Kh\hhj}rW (h.jB j6 j9 uh?]rX (hm)rY }rZ (hDXUsing authentication modesr[ hFjN hGhJhLhqhN}r\ (hT]r] hV]r^ hR]r_ hP]r` hX]ra uh[Kh\hh?]rb hyXUsing authentication modesrc rd }re (hDj[ hFjY ubaubh})rf }rg (hDX:term:`HTTP` and cookie authentication modes are recommended in a **multi-user environment** where you want to give users access to their own database and don't want them to play around with others. Nevertheless be aware that MS Internet Explorer seems to be really buggy about cookies, at least till version 6. Even in a **single-user environment**, you might prefer to use :term:`HTTP` or cookie mode so that your user/password pair are not in clear in the configuration file.rh hFjN hGhJhLhhN}ri (hT]rj hV]rk hR]rl hP]rm hX]rn uh[Kh\hh?]ro (h)rp }rq (hDX :term:`HTTP`rr hFjf hGhJhLhhN}rs (Ureftypert Xtermru hhXhttprv U refdomainrw Xstdrx hP]ry hR]rz U refexplicitr{ hT]r| hV]r} hX]r~ hhuh[Kh?]r h)r }r (hDjr hN}r (hT]r hV]r (hjx Xstd-termr ehR]r hP]r hX]r uhFjp h?]r hyXHTTPr r }r (hDUhFj ubahLhubaubhyX6 and cookie authentication modes are recommended in a r r }r (hDX6 and cookie authentication modes are recommended in a r hFjf ubj)r }r (hDX**multi-user environment**r hN}r (hT]r hV]r hR]r hP]r hX]r uhFjf h?]r hyXmulti-user environmentr r }r (hDUhFj ubahLjubhyX where you want to give users access to their own database and don't want them to play around with others. Nevertheless be aware that MS Internet Explorer seems to be really buggy about cookies, at least till version 6. Even in a r r }r (hDX where you want to give users access to their own database and don't want them to play around with others. Nevertheless be aware that MS Internet Explorer seems to be really buggy about cookies, at least till version 6. Even in a r hFjf ubj)r }r (hDX**single-user environment**r hN}r (hT]r hV]r hR]r hP]r hX]r uhFjf h?]r hyXsingle-user environmentr r }r (hDUhFj ubahLjubhyX, you might prefer to use r r }r (hDX, you might prefer to use r hFjf ubh)r }r (hDX :term:`HTTP`r hFjf hGhJhLhhN}r (Ureftyper Xtermr hhXhttpr U refdomainr Xstdr hP]r hR]r U refexplicitr hT]r hV]r hX]r hhuh[Kh?]r h)r }r (hDj hN}r (hT]r hV]r (hj Xstd-termr ehR]r hP]r hX]r uhFj h?]r hyXHTTPr r }r (hDUhFj ubahLhubaubhyX[ or cookie mode so that your user/password pair are not in clear in the configuration file.r r }r (hDX[ or cookie mode so that your user/password pair are not in clear in the configuration file.r hFjf ubeubh})r }r (hDX:term:`HTTP` and cookie authentication modes are more secure: the MySQL login information does not need to be set in the phpMyAdmin configuration file (except possibly for the :config:option:`$cfg['Servers'][$i]['controluser']`). However, keep in mind that the password travels in plain text, unless you are using the HTTPS protocol. In cookie mode, the password is stored, encrypted with the blowfish algorithm, in a temporary cookie.r hFjN hGhJhLhhN}r (hT]r hV]r hR]r hP]r hX]r uh[Kh\hh?]r (h)r }r (hDX :term:`HTTP`r hFj hGhJhLhhN}r (Ureftyper Xtermr hhXhttpr U refdomainr Xstdr hP]r hR]r U refexplicitr hT]r hV]r hX]r hhuh[Kh?]r h)r }r (hDj hN}r (hT]r hV]r (hj Xstd-termr ehR]r hP]r hX]r uhFj h?]r hyXHTTPr r }r (hDUhFj ubahLhubaubhyX and cookie authentication modes are more secure: the MySQL login information does not need to be set in the phpMyAdmin configuration file (except possibly for the r r }r (hDX and cookie authentication modes are more secure: the MySQL login information does not need to be set in the phpMyAdmin configuration file (except possibly for the r hFj ubje)r }r (hDUhN}r (hP]r hR]r hT]r hV]r hX]r jo]r ((jqX"$cfg['Servers'][$i]['controluser']r Uindex-3r j tr (jqX8configuration option; $cfg['Servers'][$i]['controluser']j j tr euhFj h?]r hLjhubhA)r }r (hDUhN}r (hT]r hV]r hR]r hP]r j ahX]r uhFj h?]r hLhMubh)r }r (hDX3:config:option:`$cfg['Servers'][$i]['controluser']`r hFj hGhJhLhhN}r (Ureftyper Xoptionr hhj U refdomainr Xconfigr hP]r hR]r U refexplicitr hT]r! hV]r" hX]r# hhuh[Kh?]r$ jC)r% }r& (hDj hN}r' (hT]r( hV]r) (hj X config-optionr* ehR]r+ hP]r, hX]r- uhFj h?]r. hyX"$cfg['Servers'][$i]['controluser']r/ r0 }r1 (hDUhFj% ubahLjQubaubhyX). However, keep in mind that the password travels in plain text, unless you are using the HTTPS protocol. In cookie mode, the password is stored, encrypted with the blowfish algorithm, in a temporary cookie.r2 r3 }r4 (hDX). However, keep in mind that the password travels in plain text, unless you are using the HTTPS protocol. In cookie mode, the password is stored, encrypted with the blowfish algorithm, in a temporary cookie.r5 hFj ubeubcdocutils.nodes comment r6 )r7 }r8 (hDXenote: This section is only applicable if your MySQL server is running with ``--skip-show-database``.r9 hFjN hGhJhLUcommentr: hN}r; (jjhP]r< hR]r= hT]r> hV]r? hX]r@ uh[Kh\hh?]rA hyXenote: This section is only applicable if your MySQL server is running with ``--skip-show-database``.rB rC }rD (hDUhFj7 ubaubh})rE }rF (hDXFor ':term:`HTTP`' and 'cookie' modes, phpMyAdmin needs a controluser that has **only** the ``SELECT`` privilege on the *`mysql`.`user` (all columns except `Password`)*, *`mysql`.`db` (all columns)*, *`mysql`.`host` (all columns)* and *`mysql`.`tables\_priv` (all columns except `Grantor` and `Timestamp`)* tables. You must specify the details for the controluser in the :file:`config.inc.php` file under the :config:option:`$cfg['Servers'][$i]['controluser']` and :config:option:`$cfg['Servers'][$i]['controlpass']` settings. The following example assumes you want to use ``pma`` as the controluser and ``pmapass`` as the controlpass, but **this is only an example: use something else in your file!** Input these statements from the phpMyAdmin :term:`SQL` Query window or mysql command–line client. Of course you have to replace ``localhost`` with the webserver's host if it's not the same as the MySQL server's one.rG hFjN hGhJhLhhN}rH (hT]rI hV]rJ hR]rK hP]rL hX]rM uh[Kh\hh?]rN (hyXFor 'rO rP }rQ (hDXFor 'rR hFjE ubh)rS }rT (hDX :term:`HTTP`rU hFjE hGhJhLhhN}rV (UreftyperW XtermrX hhXhttprY U refdomainrZ Xstdr[ hP]r\ hR]r] U refexplicitr^ hT]r_ hV]r` hX]ra hhuh[Kh?]rb h)rc }rd (hDjU hN}re (hT]rf hV]rg (hj[ Xstd-termrh ehR]ri hP]rj hX]rk uhFjS h?]rl hyXHTTPrm rn }ro (hDUhFjc ubahLhubaubhyX>' and 'cookie' modes, phpMyAdmin needs a controluser that has rp rq }rr (hDX>' and 'cookie' modes, phpMyAdmin needs a controluser that has rs hFjE ubj)rt }ru (hDX**only**rv hN}rw (hT]rx hV]ry hR]rz hP]r{ hX]r| uhFjE h?]r} hyXonlyr~ r }r (hDUhFjt ubahLjubhyX the r r }r (hDX the r hFjE ubjC)r }r (hDX ``SELECT``r hN}r (hT]r hV]r hR]r hP]r hX]r uhFjE h?]r hyXSELECTr r }r (hDUhFj ubahLjQubhyX privilege on the r r }r (hDX privilege on the r hFjE ubh)r }r (hDX0*`mysql`.`user` (all columns except `Password`)*r hN}r (hT]r hV]r hR]r hP]r hX]r uhFjE h?]r hyX.`mysql`.`user` (all columns except `Password`)r r }r (hDUhFj ubahLhubhyX, r r }r (hDX, r hFjE ubh)r }r (hDX*`mysql`.`db` (all columns)*r hN}r (hT]r hV]r hR]r hP]r hX]r uhFjE h?]r hyX`mysql`.`db` (all columns)r r }r (hDUhFj ubahLhubhyX, r r }r (hDX, r hFjE ubh)r }r (hDX*`mysql`.`host` (all columns)*r hN}r (hT]r hV]r hR]r hP]r hX]r uhFjE h?]r hyX`mysql`.`host` (all columns)r r }r (hDUhFj ubahLhubhyX and r r }r (hDX and r hFjE ubh)r }r (hDXG*`mysql`.`tables\_priv` (all columns except `Grantor` and `Timestamp`)*r hN}r (hT]r hV]r hR]r hP]r hX]r uhFjE h?]r hyXD`mysql`.`tables_priv` (all columns except `Grantor` and `Timestamp`)r r }r (hDUhFj ubahLhubhyXA tables. You must specify the details for the controluser in the r r }r (hDXA tables. You must specify the details for the controluser in the r hFjE ubjC)r }r (hDUhN}r (hP]r hR]r hT]r hV]r Xfiler aUroler j hX]r uhFjE h?]r hyXconfig.inc.phpr r }r (hDXconfig.inc.phpr hFj ubahLjQubhyX file under the r r }r (hDX file under the r hFjE ubje)r }r (hDUhN}r (hP]r hR]r hT]r hV]r hX]r jo]r ((jqX"$cfg['Servers'][$i]['controluser']r Uindex-4r j tr (jqX8configuration option; $cfg['Servers'][$i]['controluser']j j tr euhFjE h?]r hLjhubhA)r }r (hDUhN}r (hT]r hV]r hR]r hP]r j ahX]r uhFjE h?]r hLhMubh)r }r (hDX3:config:option:`$cfg['Servers'][$i]['controluser']`r hFjE hGhJhLhhN}r (Ureftyper Xoptionr hhj U refdomainr Xconfigr hP]r hR]r U refexplicitr hT]r hV]r hX]r hhuh[Kh?]r jC)r }r (hDj hN}r (hT]r hV]r (hj X config-optionr ehR]r hP]r hX]r uhFj h?]r hyX"$cfg['Servers'][$i]['controluser']r r }r (hDUhFj ubahLjQubaubhyX and r r! }r" (hDX and r# hFjE ubje)r$ }r% (hDUhN}r& (hP]r' hR]r( hT]r) hV]r* hX]r+ jo]r, ((jqX"$cfg['Servers'][$i]['controlpass']r- Uindex-5r. j- tr/ (jqX8configuration option; $cfg['Servers'][$i]['controlpass']j. j- tr0 euhFjE h?]r1 hLjhubhA)r2 }r3 (hDUhN}r4 (hT]r5 hV]r6 hR]r7 hP]r8 j. ahX]r9 uhFjE h?]r: hLhMubh)r; }r< (hDX3:config:option:`$cfg['Servers'][$i]['controlpass']`r= hFjE hGhJhLhhN}r> (Ureftyper? Xoptionr@ hhj- U refdomainrA XconfigrB hP]rC hR]rD U refexplicitrE hT]rF hV]rG hX]rH hhuh[Kh?]rI jC)rJ }rK (hDj= hN}rL (hT]rM hV]rN (hjB X config-optionrO ehR]rP hP]rQ hX]rR uhFj; h?]rS hyX"$cfg['Servers'][$i]['controlpass']rT rU }rV (hDUhFjJ ubahLjQubaubhyX9 settings. The following example assumes you want to use rW rX }rY (hDX9 settings. The following example assumes you want to use rZ hFjE ubjC)r[ }r\ (hDX``pma``r] hN}r^ (hT]r_ hV]r` hR]ra hP]rb hX]rc uhFjE h?]rd hyXpmare rf }rg (hDUhFj[ ubahLjQubhyX as the controluser and rh ri }rj (hDX as the controluser and rk hFjE ubjC)rl }rm (hDX ``pmapass``rn hN}ro (hT]rp hV]rq hR]rr hP]rs hX]rt uhFjE h?]ru hyXpmapassrv rw }rx (hDUhFjl ubahLjQubhyX as the controlpass, but ry rz }r{ (hDX as the controlpass, but r| hFjE ubj)r} }r~ (hDX=**this is only an example: use something else in your file!**r hN}r (hT]r hV]r hR]r hP]r hX]r uhFjE h?]r hyX9this is only an example: use something else in your file!r r }r (hDUhFj} ubahLjubhyX, Input these statements from the phpMyAdmin r r }r (hDX, Input these statements from the phpMyAdmin r hFjE ubh)r }r (hDX :term:`SQL`r hFjE hGhJhLhhN}r (Ureftyper Xtermr hhXsqlr U refdomainr Xstdr hP]r hR]r U refexplicitr hT]r hV]r hX]r hhuh[Kh?]r h)r }r (hDj hN}r (hT]r hV]r (hj Xstd-termr ehR]r hP]r hX]r uhFj h?]r hyXSQLr r }r (hDUhFj ubahLhubaubhyXL Query window or mysql command–line client. Of course you have to replace r r }r (hDXL Query window or mysql command–line client. Of course you have to replace r hFjE ubjC)r }r (hDX ``localhost``r hN}r (hT]r hV]r hR]r hP]r hX]r uhFjE h?]r hyX localhostr r }r (hDUhFj ubahLjQubhyXJ with the webserver's host if it's not the same as the MySQL server's one.r r }r (hDXJ with the webserver's host if it's not the same as the MySQL server's one.r hFjE ubeubh})r }r (hDXIf you want to use the many new relation and bookmark features: (this of course requires that your :ref:`linked-tables` be set up).r hFjN hGhJhLhhN}r (hT]r hV]r hR]r hP]r hX]r uh[M h\hh?]r (hyXdIf you want to use the many new relation and bookmark features: (this of course requires that your r r }r (hDXdIf you want to use the many new relation and bookmark features: (this of course requires that your r hFj ubh)r }r (hDX:ref:`linked-tables`r hFj hGhJhLhhN}r (Ureftyper Xrefr hhX linked-tablesr U refdomainr Xstdr hP]r hR]r U refexplicitr hT]r hV]r hX]r hhuh[M h?]r h)r }r (hDj hN}r (hT]r hV]r (hj Xstd-refr ehR]r hP]r hX]r uhFj h?]r hyX linked-tablesr r }r (hDUhFj ubahLhubaubhyX be set up).r r }r (hDX be set up).r hFj ubeubj)r }r (hDX|GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass'; GRANT SELECT ( Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv ) ON mysql.user TO 'pma'@'localhost'; GRANT SELECT ON mysql.db TO 'pma'@'localhost'; GRANT SELECT ON mysql.host TO 'pma'@'localhost'; GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'pma'@'localhost';r hFjN hGhJhLj hN}r (j jXmysqlr jjhP]r hR]r hT]r hV]r hX]r uh[M h\hh?]r hyX|GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass'; GRANT SELECT ( Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv ) ON mysql.user TO 'pma'@'localhost'; GRANT SELECT ON mysql.db TO 'pma'@'localhost'; GRANT SELECT ON mysql.host TO 'pma'@'localhost'; GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'pma'@'localhost';r r }r (hDUhFj ubaubh})r }r (hDX?If you want to use the many new relation and bookmark features:r hFjN hGhJhLhhN}r (hT]r hV]r hR]r hP]r hX]r uh[Mh\hh?]r hyX?If you want to use the many new relation and bookmark features:r r }r (hDj hFj ubaubj)r }r (hDXHGRANT SELECT, INSERT, UPDATE, DELETE ON .* TO 'pma'@'localhost';r hFjN hGhJhLj hN}r (j jXmysqlr jjhP]r hR]r hT]r hV]r hX]r uh[Mh\hh?]r hyXHGRANT SELECT, INSERT, UPDATE, DELETE ON .* TO 'pma'@'localhost';r r }r (hDUhFj ubaubh})r }r (hDXO(this of course requires that your phpMyAdmin configuration storage be set up).r hFjN hGhJhLhhN}r (hT]r hV]r hR]r hP]r hX]r uh[M"h\hh?]r! hyXO(this of course requires that your phpMyAdmin configuration storage be set up).r" r# }r$ (hDj hFj ubaubh})r% }r& (hDXfThen each of the *true* users should be granted a set of privileges on a set of particular databases. Normally you shouldn't give global privileges to an ordinary user, unless you understand the impact of those privileges (for example, you are creating a superuser). For example, to grant the user *real_user* with all privileges on the database *user_base*:r' hFjN hGhJhLhhN}r( (hT]r) hV]r* hR]r+ hP]r, hX]r- uh[M%h\hh?]r. (hyXThen each of the r/ r0 }r1 (hDXThen each of the r2 hFj% ubh)r3 }r4 (hDX*true*r5 hN}r6 (hT]r7 hV]r8 hR]r9 hP]r: hX]r; uhFj% h?]r< hyXtruer= r> }r? (hDUhFj3 ubahLhubhyX users should be granted a set of privileges on a set of particular databases. Normally you shouldn't give global privileges to an ordinary user, unless you understand the impact of those privileges (for example, you are creating a superuser). For example, to grant the user r@ rA }rB (hDX users should be granted a set of privileges on a set of particular databases. Normally you shouldn't give global privileges to an ordinary user, unless you understand the impact of those privileges (for example, you are creating a superuser). For example, to grant the user rC hFj% ubh)rD }rE (hDX *real_user*rF hN}rG (hT]rH hV]rI hR]rJ hP]rK hX]rL uhFj% h?]rM hyX real_userrN rO }rP (hDUhFjD ubahLhubhyX% with all privileges on the database rQ rR }rS (hDX% with all privileges on the database rT hFj% ubh)rU }rV (hDX *user_base*rW hN}rX (hT]rY hV]rZ hR]r[ hP]r\ hX]r] uhFj% h?]r^ hyX user_baser_ r` }ra (hDUhFjU ubahLhubhyX:rb }rc (hDX:hFj% ubeubj)rd }re (hDX[GRANT ALL PRIVILEGES ON user_base.* TO 'real_user'@localhost IDENTIFIED BY 'real_password';rf hFjN hGhJhLj hN}rg (j jXmysqlrh jjhP]ri hR]rj hT]rk hV]rl hX]rm uh[M,h\hh?]rn hyX[GRANT ALL PRIVILEGES ON user_base.* TO 'real_user'@localhost IDENTIFIED BY 'real_password';ro rp }rq (hDUhFjd ubaubh})rr }rs (hDXWhat the user may now do is controlled entirely by the MySQL user management system. With HTTP or cookie authentication mode, you don't need to fill the user/password fields inside the :config:option:`$cfg['Servers']`.rt hFjN hGhJhLhhN}ru (hT]rv hV]rw hR]rx hP]ry hX]rz uh[M1h\hh?]r{ (hyXWhat the user may now do is controlled entirely by the MySQL user management system. With HTTP or cookie authentication mode, you don't need to fill the user/password fields inside the r| r} }r~ (hDXWhat the user may now do is controlled entirely by the MySQL user management system. With HTTP or cookie authentication mode, you don't need to fill the user/password fields inside the r hFjr ubje)r }r (hDUhN}r (hP]r hR]r hT]r hV]r hX]r jo]r ((jqX$cfg['Servers']r Uindex-6r j tr (jqX%configuration option; $cfg['Servers']j j tr euhFjr h?]r hLjhubhA)r }r (hDUhN}r (hT]r hV]r hR]r hP]r j ahX]r uhFjr h?]r hLhMubh)r }r (hDX :config:option:`$cfg['Servers']`r hFjr hGhJhLhhN}r (Ureftyper Xoptionr hhj U refdomainr Xconfigr hP]r hR]r U refexplicitr hT]r hV]r hX]r hhuh[M1h?]r jC)r }r (hDj hN}r (hT]r hV]r (hj X config-optionr ehR]r hP]r hX]r uhFj h?]r hyX$cfg['Servers']r r }r (hDUhFj ubahLjQubaubhyX.r }r (hDX.hFjr ubeubje)r }r (hDUhFjN hGhJhLjhhN}r (hP]r hR]r hT]r hV]r hX]r jo]r (Upairr XHTTP; Authentication modeUindex-7r Utr ajtuh[M6h\hh?]r ubhA)r }r (hDUhFjN hGhJhLhMhN}r (hP]r hR]r hT]r hV]r hX]r hZj uh[M6h\hh?]r ubh^)r }r (hDUhFjN hGhJha}r hLhchN}r (hT]r hV]r hR]r hP]r (h1j ehX]r hauh[M8h\hhj}r j j sh?]r (hm)r }r (hDXHTTP authentication moder hFj hGhJhLhqhN}r (hT]r hV]r hR]r hP]r hX]r uh[M8h\hh?]r hyXHTTP authentication moder r }r (hDj hFj ubaubcdocutils.nodes bullet_list r )r }r (hDUhFj hGhJhLU bullet_listr hN}r (Ubulletr X*hP]r hR]r hT]r hV]r hX]r uh[M:h\hh?]r (j)r }r (hDX_Uses :term:`HTTP` Basic authentication method and allows you to log in as any valid MySQL user.r hFj hGhJhLjhN}r (hT]r hV]r hR]r hP]r hX]r uh[Nh\hh?]r h})r }r (hDX_Uses :term:`HTTP` Basic authentication method and allows you to log in as any valid MySQL user.r hFj hGhJhLhhN}r (hT]r hV]r hR]r hP]r hX]r uh[M:h?]r (hyXUses r r }r (hDXUses r hFj ubh)r }r (hDX :term:`HTTP`r hFj hGhJhLhhN}r (Ureftyper Xtermr hhXhttpr U refdomainr Xstdr hP]r hR]r U refexplicitr hT]r hV]r hX]r hhuh[M:h?]r h)r }r (hDj hN}r (hT]r hV]r (hj Xstd-termr ehR]r hP]r hX]r uhFj h?]r hyXHTTPr! r" }r# (hDUhFj ubahLhubaubhyXN Basic authentication method and allows you to log in as any valid MySQL user.r$ r% }r& (hDXN Basic authentication method and allows you to log in as any valid MySQL user.r' hFj ubeubaubj)r( }r) (hDXIs supported with most PHP configurations. For :term:`IIS` (:term:`ISAPI`) support using :term:`CGI` PHP see :ref:`faq1_32`, for using with Apache :term:`CGI` see :ref:`faq1_35`.r* hFj hGhJhLjhN}r+ (hT]r, hV]r- hR]r. hP]r/ hX]r0 uh[Nh\hh?]r1 h})r2 }r3 (hDXIs supported with most PHP configurations. For :term:`IIS` (:term:`ISAPI`) support using :term:`CGI` PHP see :ref:`faq1_32`, for using with Apache :term:`CGI` see :ref:`faq1_35`.r4 hFj( hGhJhLhhN}r5 (hT]r6 hV]r7 hR]r8 hP]r9 hX]r: uh[M<h?]r; (hyX/Is supported with most PHP configurations. For r< r= }r> (hDX/Is supported with most PHP configurations. For r? hFj2 ubh)r@ }rA (hDX :term:`IIS`rB hFj2 hGhJhLhhN}rC (UreftyperD XtermrE hhXiisrF U refdomainrG XstdrH hP]rI hR]rJ U refexplicitrK hT]rL hV]rM hX]rN hhuh[M<h?]rO h)rP }rQ (hDjB hN}rR (hT]rS hV]rT (hjH Xstd-termrU ehR]rV hP]rW hX]rX uhFj@ h?]rY hyXIISrZ r[ }r\ (hDUhFjP ubahLhubaubhyX (r] r^ }r_ (hDX (r` hFj2 ubh)ra }rb (hDX :term:`ISAPI`rc hFj2 hGhJhLhhN}rd (Ureftypere Xtermrf hhXisapirg U refdomainrh Xstdri hP]rj hR]rk U refexplicitrl hT]rm hV]rn hX]ro hhuh[M<h?]rp h)rq }rr (hDjc hN}rs (hT]rt hV]ru (hji Xstd-termrv ehR]rw hP]rx hX]ry uhFja h?]rz hyXISAPIr{ r| }r} (hDUhFjq ubahLhubaubhyX) support using r~ r }r (hDX) support using r hFj2 ubh)r }r (hDX :term:`CGI`r hFj2 hGhJhLhhN}r (Ureftyper Xtermr hhXcgir U refdomainr Xstdr hP]r hR]r U refexplicitr hT]r hV]r hX]r hhuh[M<h?]r h)r }r (hDj hN}r (hT]r hV]r (hj Xstd-termr ehR]r hP]r hX]r uhFj h?]r hyXCGIr r }r (hDUhFj ubahLhubaubhyX PHP see r r }r (hDX PHP see r hFj2 ubh)r }r (hDX:ref:`faq1_32`r hFj2 hGhJhLhhN}r (Ureftyper Xrefr hhXfaq1_32r U refdomainr Xstdr hP]r hR]r U refexplicitr hT]r hV]r hX]r hhuh[M<h?]r h)r }r (hDj hN}r (hT]r hV]r (hj Xstd-refr ehR]r hP]r hX]r uhFj h?]r hyXfaq1_32r r }r (hDUhFj ubahLhubaubhyX, for using with Apache r r }r (hDX, for using with Apache r hFj2 ubh)r }r (hDX :term:`CGI`r hFj2 hGhJhLhhN}r (Ureftyper Xtermr hhXcgir U refdomainr Xstdr hP]r hR]r U refexplicitr hT]r hV]r hX]r hhuh[M<h?]r h)r }r (hDj hN}r (hT]r hV]r (hj Xstd-termr ehR]r hP]r hX]r uhFj h?]r hyXCGIr r }r (hDUhFj ubahLhubaubhyX see r r }r (hDX see r hFj2 ubh)r }r (hDX:ref:`faq1_35`r hFj2 hGhJhLhhN}r (Ureftyper Xrefr hhXfaq1_35r U refdomainr Xstdr hP]r hR]r U refexplicitr hT]r hV]r hX]r hhuh[M<h?]r h)r }r (hDj hN}r (hT]r hV]r (hj Xstd-refr ehR]r hP]r hX]r uhFj h?]r hyXfaq1_35r r}r(hDUhFj ubahLhubaubhyX.r}r(hDX.hFj2 ubeubaubj)r}r(hDXvSee also :ref:`faq4_4` about not using the :term:`.htaccess` mechanism along with ':term:`HTTP`' authentication mode. rhFj hGhJhLjhN}r(hT]rhV]r hR]r hP]r hX]r uh[Nh\hh?]r h})r}r(hDXuSee also :ref:`faq4_4` about not using the :term:`.htaccess` mechanism along with ':term:`HTTP`' authentication mode.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[M?h?]r(hyX See also rr}r(hDX See also rhFjubh)r}r(hDX :ref:`faq4_4`rhFjhGhJhLhhN}r(Ureftyper Xrefr!hhXfaq4_4r"U refdomainr#Xstdr$hP]r%hR]r&U refexplicitr'hT]r(hV]r)hX]r*hhuh[M?h?]r+h)r,}r-(hDjhN}r.(hT]r/hV]r0(hj$Xstd-refr1ehR]r2hP]r3hX]r4uhFjh?]r5hyXfaq4_4r6r7}r8(hDUhFj,ubahLhubaubhyX about not using the r9r:}r;(hDX about not using the r<hFjubh)r=}r>(hDX:term:`.htaccess`r?hFjhGhJhLhhN}r@(UreftyperAXtermrBhhX .htaccessrCU refdomainrDXstdrEhP]rFhR]rGU refexplicitrHhT]rIhV]rJhX]rKhhuh[M?h?]rLh)rM}rN(hDj?hN}rO(hT]rPhV]rQ(hjEXstd-termrRehR]rShP]rThX]rUuhFj=h?]rVhyX .htaccessrWrX}rY(hDUhFjMubahLhubaubhyX mechanism along with 'rZr[}r\(hDX mechanism along with 'r]hFjubh)r^}r_(hDX :term:`HTTP`r`hFjhGhJhLhhN}ra(UreftyperbXtermrchhXhttprdU refdomainreXstdrfhP]rghR]rhU refexplicitrihT]rjhV]rkhX]rlhhuh[M?h?]rmh)rn}ro(hDj`hN}rp(hT]rqhV]rr(hjfXstd-termrsehR]rthP]ruhX]rvuhFj^h?]rwhyXHTTPrxry}rz(hDUhFjnubahLhubaubhyX' authentication mode.r{r|}r}(hDX' authentication mode.r~hFjubeubaubeubje)r}r(hDUhFj hGhJhLjhhN}r(hP]rhR]rhT]rhV]rhX]rjo]r(j XCookie; Authentication modeUindex-8rUtrajtuh[MCh\hh?]rubhA)r}r(hDUhFj hGhJhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZjuh[MCh\hh?]rubhA)r}r(hDX .. _cookie:rhFj hGhJha}rhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZh3uh[MDh\hhj}rjjsh?]rubeubh^)r}r(hDUhFjN hGhJha}rhjshLhchN}r(hT]rhV]rhR]rhP]r(h=h3jehX]r(hheuh[MGh\hhj}r(jjh3juh?]r(hm)r}r(hDXCookie authentication moderhFjhGhJhLhqhN}r(hT]rhV]rhR]rhP]rhX]ruh[MGh\hh?]rhyXCookie authentication moderr}r(hDjhFjubaubj )r}r(hDUhFjhGhJhLj hN}r(j X*hP]rhR]rhT]rhV]rhX]ruh[MIh\hh?]r(j)r}r(hDXzYou can use this method as a replacement for the :term:`HTTP` authentication (for example, if you're running :term:`IIS`).rhFjhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXzYou can use this method as a replacement for the :term:`HTTP` authentication (for example, if you're running :term:`IIS`).rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[MIh?]r(hyX1You can use this method as a replacement for the rr}r(hDX1You can use this method as a replacement for the rhFjubh)r}r(hDX :term:`HTTP`rhFjhGhJhLhhN}r(UreftyperXtermrhhXhttprU refdomainrXstdrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[MIh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-termrehR]rhP]rhX]ruhFjh?]rhyXHTTPrr}r(hDUhFjubahLhubaubhyX0 authentication (for example, if you're running rr}r(hDX0 authentication (for example, if you're running rhFjubh)r}r(hDX :term:`IIS`rhFjhGhJhLhhN}r(UreftyperXtermrhhXiisrU refdomainrXstdrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[MIh?]r h)r }r (hDjhN}r (hT]r hV]r(hjXstd-termrehR]rhP]rhX]ruhFjh?]rhyXIISrr}r(hDUhFj ubahLhubaubhyX).rr}r(hDX).rhFjubeubaubj)r}r(hDXsObviously, the user must enable cookies in the browser, but this is now a requirement for all authentication modes.rhFjhGhJhLjhN}r(hT]rhV]r hR]r!hP]r"hX]r#uh[Nh\hh?]r$h})r%}r&(hDXsObviously, the user must enable cookies in the browser, but this is now a requirement for all authentication modes.r'hFjhGhJhLhhN}r((hT]r)hV]r*hR]r+hP]r,hX]r-uh[MKh?]r.hyXsObviously, the user must enable cookies in the browser, but this is now a requirement for all authentication modes.r/r0}r1(hDj'hFj%ubaubaubj)r2}r3(hDX`With this mode, the user can truly log out of phpMyAdmin and log in back with the same username.r4hFjhGhJhLjhN}r5(hT]r6hV]r7hR]r8hP]r9hX]r:uh[Nh\hh?]r;h})r<}r=(hDX`With this mode, the user can truly log out of phpMyAdmin and log in back with the same username.r>hFj2hGhJhLhhN}r?(hT]r@hV]rAhR]rBhP]rChX]rDuh[MMh?]rEhyX`With this mode, the user can truly log out of phpMyAdmin and log in back with the same username.rFrG}rH(hDj>hFj<ubaubaubj)rI}rJ(hDXfIf you want to log in to arbitrary server see :config:option:`$cfg['AllowArbitraryServer']` directive.rKhFjhGhJhLjhN}rL(hT]rMhV]rNhR]rOhP]rPhX]rQuh[Nh\hh?]rRh})rS}rT(hDjKhFjIhGhJhLhhN}rU(hT]rVhV]rWhR]rXhP]rYhX]rZuh[MOh?]r[(hyX.If you want to log in to arbitrary server see r\r]}r^(hDX.If you want to log in to arbitrary server see r_hFjSubje)r`}ra(hDUhN}rb(hP]rchR]rdhT]rehV]rfhX]rgjo]rh((jqX$cfg['AllowArbitraryServer']riUindex-9rjjitrk(jqX2configuration option; $cfg['AllowArbitraryServer']jjjitrleuhFjSh?]rmhLjhubhA)rn}ro(hDUhN}rp(hT]rqhV]rrhR]rshP]rtjjahX]ruuhFjSh?]rvhLhMubh)rw}rx(hDX-:config:option:`$cfg['AllowArbitraryServer']`ryhFjShGhJhLhhN}rz(Ureftyper{Xoptionr|hhjiU refdomainr}Xconfigr~hP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[MOh?]rjC)r}r(hDjyhN}r(hT]rhV]r(hj~X config-optionrehR]rhP]rhX]ruhFjwh?]rhyX$cfg['AllowArbitraryServer']rr}r(hDUhFjubahLjQubaubhyX directive.rr}r(hDX directive.rhFjSubeubaubj)r}r(hDXAs mentioned in the :ref:`require` section, having the ``mcrypt`` extension will speed up access considerably, but is not required. rhFjhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXAs mentioned in the :ref:`require` section, having the ``mcrypt`` extension will speed up access considerably, but is not required.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[MPh?]r(hyXAs mentioned in the rr}r(hDXAs mentioned in the rhFjubh)r}r(hDX:ref:`require`rhFjhGhJhLhhN}r(UreftyperXrefrhhXrequirerU refdomainrXstdrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[MPh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFjh?]rhyXrequirerr}r(hDUhFjubahLhubaubhyX section, having the rr}r(hDX section, having the rhFjubjC)r}r(hDX ``mcrypt``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXmcryptrr}r(hDUhFjubahLjQubhyXB extension will speed up access considerably, but is not required.rr}r(hDXB extension will speed up access considerably, but is not required.rhFjubeubaubeubje)r}r(hDUhFjhGhJhLjhhN}r(hP]rhR]rhT]rhV]rhX]rjo]r(j XSignon; Authentication modeUindex-10rUtrajtuh[MTh\hh?]rubhA)r}r(hDUhFjhGhJhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZjuh[MTh\hh?]rubeubh^)r}r(hDUhFjN hGhJha}rhLhchN}r(hT]rhV]rhR]rhP]r(h'jehX]rhauh[MVh\hhj}rjjsh?]r(hm)r}r(hDXSignon authentication moderhFjhGhJhLhqhN}r(hT]rhV]rhR]rhP]rhX]r uh[MVh\hh?]r hyXSignon authentication moder r }r (hDjhFjubaubj )r}r(hDUhFjhGhJhLj hN}r(j X*hP]rhR]rhT]rhV]rhX]ruh[MXh\hh?]r(j)r}r(hDXjThis mode is a convenient way of using credentials from another application to authenticate to phpMyAdmin.rhFjhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]r h})r!}r"(hDXjThis mode is a convenient way of using credentials from another application to authenticate to phpMyAdmin.r#hFjhGhJhLhhN}r$(hT]r%hV]r&hR]r'hP]r(hX]r)uh[MXh?]r*hyXjThis mode is a convenient way of using credentials from another application to authenticate to phpMyAdmin.r+r,}r-(hDj#hFj!ubaubaubj)r.}r/(hDXHThe other application has to store login information into session data. r0hFjhGhJhLjhN}r1(hT]r2hV]r3hR]r4hP]r5hX]r6uh[Nh\hh?]r7h})r8}r9(hDXGThe other application has to store login information into session data.r:hFj.hGhJhLhhN}r;(hT]r<hV]r=hR]r>hP]r?hX]r@uh[MZh?]rAhyXGThe other application has to store login information into session data.rBrC}rD(hDj:hFj8ubaubaubeubcsphinx.addnodes seealso rE)rF}rG(hDUhFjhGNhLUseealsorHhN}rI(hT]rJhV]rKUadmonition-see-alsorLahR]rMhP]rNhX]rOuh[Nh\hh?]rP(hm)rQ}rR(hDXSee alsorShN}rT(hT]rUhV]rVhR]rWhP]rXhX]rYuhFjFh?]rZhyXSee alsor[r\}r](hDjShFjQubahLhqubh})r^}r_(hDUhN}r`(hT]rahV]rbhR]rchP]rdhX]reuhFjFh?]rf(je)rg}rh(hDUhN}ri(hP]rjhR]rkhT]rlhV]rmhX]rnjo]ro((jqX $cfg['Servers'][$i]['auth_type']rpUindex-11rqjptrr(jqX6configuration option; $cfg['Servers'][$i]['auth_type']jqjptrseuhFj^h?]rthLjhubhA)ru}rv(hDUhN}rw(hT]rxhV]ryhR]rzhP]r{jqahX]r|uhFj^h?]r}hLhMubh)r~}r(hDX1:config:option:`$cfg['Servers'][$i]['auth_type']`rhFj^hGhJhLhhN}r(UreftyperXoptionrhhjpU refdomainrXconfigrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[M]h?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX config-optionrehR]rhP]rhX]ruhFj~h?]rhyX $cfg['Servers'][$i]['auth_type']rr}r(hDUhFjubahLjQubaubhyX, rr}r(hDX, rhFj^ubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX$$cfg['Servers'][$i]['SignonSession']rUindex-12rjtr(jqX:configuration option; $cfg['Servers'][$i]['SignonSession']jjtreuhFj^h?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFj^h?]rhLhMubh)r}r(hDX5:config:option:`$cfg['Servers'][$i]['SignonSession']`rhFj^hGhJhLhhN}r(UreftyperXoptionrhhjU refdomainrXconfigrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[M]h?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX config-optionrehR]rhP]rhX]ruhFjh?]rhyX$$cfg['Servers'][$i]['SignonSession']rr}r(hDUhFjubahLjQubaubhyX, rr}r(hDX, rhFj^ubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX#$cfg['Servers'][$i]['SignonScript']rUindex-13rjtr(jqX9configuration option; $cfg['Servers'][$i]['SignonScript']jjtreuhFj^h?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFj^h?]rhLhMubh)r}r(hDX4:config:option:`$cfg['Servers'][$i]['SignonScript']`rhFj^hGhJhLhhN}r(UreftyperXoptionrhhjU refdomainrXconfigrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[M]h?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX config-optionrehR]rhP]rhX]ruhFjh?]rhyX#$cfg['Servers'][$i]['SignonScript']rr}r(hDUhFjubahLjQubaubhyX, rr }r (hDX, r hFj^ubje)r }r (hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX $cfg['Servers'][$i]['SignonURL']rUindex-14rjtr(jqX6configuration option; $cfg['Servers'][$i]['SignonURL']jjtreuhFj^h?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]r jahX]r!uhFj^h?]r"hLhMubh)r#}r$(hDX1:config:option:`$cfg['Servers'][$i]['SignonURL']`r%hFj^hGhJhLhhN}r&(Ureftyper'Xoptionr(hhjU refdomainr)Xconfigr*hP]r+hR]r,U refexplicitr-hT]r.hV]r/hX]r0hhuh[M]h?]r1jC)r2}r3(hDj%hN}r4(hT]r5hV]r6(hj*X config-optionr7ehR]r8hP]r9hX]r:uhFj#h?]r;hyX $cfg['Servers'][$i]['SignonURL']r<r=}r>(hDUhFj2ubahLjQubaubehLhubeubje)r?}r@(hDUhFjhGhJhLjhhN}rA(hP]rBhR]rChT]rDhV]rEhX]rFjo]rG(j XConfig; Authentication modeUindex-15rHUtrIajtuh[Meh\hh?]rJubhA)rK}rL(hDUhFjhGhJhLhMhN}rM(hP]rNhR]rOhT]rPhV]rQhX]rRhZjHuh[Meh\hh?]rSubeubh^)rT}rU(hDUhFjN hGhJha}rVhLhchN}rW(hT]rXhV]rYhR]rZhP]r[(h2jHehX]r\hauh[Mgh\hhj}r]jHjKsh?]r^(hm)r_}r`(hDXConfig authentication moderahFjThGhJhLhqhN}rb(hT]rchV]rdhR]rehP]rfhX]rguh[Mgh\hh?]rhhyXConfig authentication moderirj}rk(hDjahFj_ubaubj )rl}rm(hDUhFjThGhJhLj hN}rn(j X*hP]rohR]rphT]rqhV]rrhX]rsuh[Mih\hh?]rt(j)ru}rv(hDXThis mode is the less secure one because it requires you to fill the :config:option:`$cfg['Servers'][$i]['user']` and :config:option:`$cfg['Servers'][$i]['password']` fields (and as a result, anyone who can read your :file:`config.inc.php` can discover your username and password). But you don't need to setup a "controluser" here: using the :config:option:`$cfg['Servers'][$i]['only_db']` might be enough.rwhFjlhGhJhLjhN}rx(hT]ryhV]rzhR]r{hP]r|hX]r}uh[Nh\hh?]r~h})r}r(hDXThis mode is the less secure one because it requires you to fill the :config:option:`$cfg['Servers'][$i]['user']` and :config:option:`$cfg['Servers'][$i]['password']` fields (and as a result, anyone who can read your :file:`config.inc.php` can discover your username and password). But you don't need to setup a "controluser" here: using the :config:option:`$cfg['Servers'][$i]['only_db']` might be enough.rhFjuhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mih?]r(hyXEThis mode is the less secure one because it requires you to fill the rr}r(hDXEThis mode is the less secure one because it requires you to fill the rhFjubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX$cfg['Servers'][$i]['user']rUindex-16rjtr(jqX1configuration option; $cfg['Servers'][$i]['user']jjtreuhFjh?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFjh?]rhLhMubh)r}r(hDX,:config:option:`$cfg['Servers'][$i]['user']`rhFjhGhJhLhhN}r(UreftyperXoptionrhhjU refdomainrXconfigrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[Mih?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX config-optionrehR]rhP]rhX]ruhFjh?]rhyX$cfg['Servers'][$i]['user']rr}r(hDUhFjubahLjQubaubhyX and rr}r(hDX and rhFjubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX$cfg['Servers'][$i]['password']rUindex-17rjtr(jqX5configuration option; $cfg['Servers'][$i]['password']jjtreuhFjh?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFjh?]rhLhMubh)r}r(hDX0:config:option:`$cfg['Servers'][$i]['password']`rhFjhGhJhLhhN}r(UreftyperXoptionrhhjU refdomainrXconfigrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[Mih?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX config-optionrehR]rhP]rhX]ruhFjh?]rhyX$cfg['Servers'][$i]['password']rr}r(hDUhFjubahLjQubaubhyX3 fields (and as a result, anyone who can read your rr}r(hDX3 fields (and as a result, anyone who can read your rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phpr hFjubahLjQubhyXh can discover your username and password). But you don't need to setup a "controluser" here: using the r r }r (hDXh can discover your username and password). But you don't need to setup a "controluser" here: using the r hFjubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX$cfg['Servers'][$i]['only_db']rUindex-18rjtr(jqX4configuration option; $cfg['Servers'][$i]['only_db']jjtreuhFjh?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]r hR]r!hP]r"jahX]r#uhFjh?]r$hLhMubh)r%}r&(hDX/:config:option:`$cfg['Servers'][$i]['only_db']`r'hFjhGhJhLhhN}r((Ureftyper)Xoptionr*hhjU refdomainr+Xconfigr,hP]r-hR]r.U refexplicitr/hT]r0hV]r1hX]r2hhuh[Mih?]r3jC)r4}r5(hDj'hN}r6(hT]r7hV]r8(hj,X config-optionr9ehR]r:hP]r;hX]r<uhFj%h?]r=hyX$cfg['Servers'][$i]['only_db']r>r?}r@(hDUhFj4ubahLjQubaubhyX might be enough.rArB}rC(hDX might be enough.rDhFjubeubaubj)rE}rF(hDXhIn the :ref:`faqmultiuser` section, there is an entry explaining how to protect your configuration file.rGhFjlhGhJhLjhN}rH(hT]rIhV]rJhR]rKhP]rLhX]rMuh[Nh\hh?]rNh})rO}rP(hDXhIn the :ref:`faqmultiuser` section, there is an entry explaining how to protect your configuration file.rQhFjEhGhJhLhhN}rR(hT]rShV]rThR]rUhP]rVhX]rWuh[Moh?]rX(hyXIn the rYrZ}r[(hDXIn the r\hFjOubh)r]}r^(hDX:ref:`faqmultiuser`r_hFjOhGhJhLhhN}r`(UreftyperaXrefrbhhX faqmultiuserrcU refdomainrdXstdrehP]rfhR]rgU refexplicitrhhT]rihV]rjhX]rkhhuh[Moh?]rlh)rm}rn(hDj_hN}ro(hT]rphV]rq(hjeXstd-refrrehR]rshP]rthX]ruuhFj]h?]rvhyX faqmultiuserrwrx}ry(hDUhFjmubahLhubaubhyXN section, there is an entry explaining how to protect your configuration file.rzr{}r|(hDXN section, there is an entry explaining how to protect your configuration file.r}hFjOubeubaubj)r~}r(hDXFor additional security in this mode, you may wish to consider the Host authentication :config:option:`$cfg['Servers'][$i]['AllowDeny']['order']` and :config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']` configuration directives.rhFjlhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXFor additional security in this mode, you may wish to consider the Host authentication :config:option:`$cfg['Servers'][$i]['AllowDeny']['order']` and :config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']` configuration directives.rhFj~hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mqh?]r(hyXWFor additional security in this mode, you may wish to consider the Host authentication rr}r(hDXWFor additional security in this mode, you may wish to consider the Host authentication rhFjubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX)$cfg['Servers'][$i]['AllowDeny']['order']rUindex-19rjtr(jqX?configuration option; $cfg['Servers'][$i]['AllowDeny']['order']jjtreuhFjh?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFjh?]rhLhMubh)r}r(hDX::config:option:`$cfg['Servers'][$i]['AllowDeny']['order']`rhFjhGhJhLhhN}r(UreftyperXoptionrhhjU refdomainrXconfigrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[Mqh?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX config-optionrehR]rhP]rhX]ruhFjh?]rhyX)$cfg['Servers'][$i]['AllowDeny']['order']rr}r(hDUhFjubahLjQubaubhyX and rr}r(hDX and rhFjubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX)$cfg['Servers'][$i]['AllowDeny']['rules']rUindex-20rjtr(jqX?configuration option; $cfg['Servers'][$i]['AllowDeny']['rules']jjtreuhFjh?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFjh?]rhLhMubh)r}r(hDX::config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']`rhFjhGhJhLhhN}r(UreftyperXoptionrhhjU refdomainrXconfigrhP]rhR]rU refexplicitrhT]rhV]rhX]rhhuh[Mqh?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX config-optionrehR]rhP]rhX]ruhFjh?]rhyX)$cfg['Servers'][$i]['AllowDeny']['rules']rr}r(hDUhFjubahLjQubaubhyX configuration directives.rr}r(hDX configuration directives.rhFjubeubaubj)r}r(hDXUnlike cookie and http, does not require a user to log in when first loading the phpMyAdmin site. This is by design but could allow any user to access your installation. Use of some restriction method is suggested, perhaps a :term:`.htaccess` file with the HTTP-AUTH directive or disallowing incoming HTTP requests at one’s router or firewall will suffice (both of which are beyond the scope of this manual but easily searchable with Google). rhFjlhGhJhLjhN}r(hT]rhV]r hR]r hP]r hX]r uh[Nh\hh?]r h})r}r(hDXUnlike cookie and http, does not require a user to log in when first loading the phpMyAdmin site. This is by design but could allow any user to access your installation. Use of some restriction method is suggested, perhaps a :term:`.htaccess` file with the HTTP-AUTH directive or disallowing incoming HTTP requests at one’s router or firewall will suffice (both of which are beyond the scope of this manual but easily searchable with Google).rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mth?]r(hyXUnlike cookie and http, does not require a user to log in when first loading the phpMyAdmin site. This is by design but could allow any user to access your installation. Use of some restriction method is suggested, perhaps a rr}r(hDXUnlike cookie and http, does not require a user to log in when first loading the phpMyAdmin site. This is by design but could allow any user to access your installation. Use of some restriction method is suggested, perhaps a rhFjubh)r}r(hDX:term:`.htaccess`rhFjhGhJhLhhN}r(Ureftyper Xtermr!hhX .htaccessr"U refdomainr#Xstdr$hP]r%hR]r&U refexplicitr'hT]r(hV]r)hX]r*hhuh[Mth?]r+h)r,}r-(hDjhN}r.(hT]r/hV]r0(hj$Xstd-termr1ehR]r2hP]r3hX]r4uhFjh?]r5hyX .htaccessr6r7}r8(hDUhFj,ubahLhubaubhyX file with the HTTP-AUTH directive or disallowing incoming HTTP requests at one’s router or firewall will suffice (both of which are beyond the scope of this manual but easily searchable with Google).r9r:}r;(hDX file with the HTTP-AUTH directive or disallowing incoming HTTP requests at one’s router or firewall will suffice (both of which are beyond the scope of this manual but easily searchable with Google).r<hFjubeubaubeubje)r=}r>(hDUhFjThGhJhLjhhN}r?(hP]r@hR]rAhT]rBhV]rChX]rDjo]rE(j XSwekey; Authentication modeUindex-21rFUtrGajtuh[M}h\hh?]rHubhA)rI}rJ(hDUhFjThGhJhLhMhN}rK(hP]rLhR]rMhT]rNhV]rOhX]rPhZjFuh[M}h\hh?]rQubhA)rR}rS(hDX .. _swekey:rThFjThGhJha}rUhLhMhN}rV(hP]rWhR]rXhT]rYhV]rZhX]r[hZh>uh[M~h\hhj}r\jFjIsh?]r]ubeubh^)r^}r_(hDUhFjN hGhJha}r`hjRshLhchN}ra(hT]rbhV]rchR]rdhP]re(h:h>jFehX]rf(hheuh[Mh\hhj}rg(h>jRjFjIuh?]rh(hm)ri}rj(hDXSwekey authentication moderkhFj^hGhJhLhqhN}rl(hT]rmhV]rnhR]rohP]rphX]rquh[Mh\hh?]rrhyXSwekey authentication modersrt}ru(hDjkhFjiubaubh})rv}rw(hDX{The Swekey is a low cost authentication USB key that can be used in web applications. When Swekey authentication is activated, phpMyAdmin requires the users's Swekey to be plugged before entering the login page (currently supported for cookie authentication mode only). Swekey Authentication is disabled by default. To enable it, add the following line to :file:`config.inc.php`:rxhFj^hGhJhLhhN}ry(hT]rzhV]r{hR]r|hP]r}hX]r~uh[Mh\hh?]r(hyXdThe Swekey is a low cost authentication USB key that can be used in web applications. When Swekey authentication is activated, phpMyAdmin requires the users's Swekey to be plugged before entering the login page (currently supported for cookie authentication mode only). Swekey Authentication is disabled by default. To enable it, add the following line to rr}r(hDXdThe Swekey is a low cost authentication USB key that can be used in web applications. When Swekey authentication is activated, phpMyAdmin requires the users's Swekey to be plugged before entering the login page (currently supported for cookie authentication mode only). Swekey Authentication is disabled by default. To enable it, add the following line to rhFjvubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjvh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX:r}r(hDX:hFjvubeubj)r}r(hDX?$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey.conf';rhFj^hGhJhLj hN}r(j jXphprjjhP]rhR]rhT]rhV]rhX]ruh[Mh\hh?]rhyX?$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey.conf';rr}r(hDUhFjubaubh})r}r(hDXYou then have to create the ``swekey.conf`` file that will associate each user with their Swekey Id. It is important to place this file outside of your web server's document root (in the example, it is located in ``/etc``). A self documented sample file is provided in the ``examples`` directory. Feel free to use it with your own users' information. If you want to purchase a Swekey please visit `http://phpmyadmin.net/auth\_key `_ since this link provides funding for phpMyAdmin.rhFj^hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mh\hh?]r(hyXYou then have to create the rr}r(hDXYou then have to create the rhFjubjC)r}r(hDX``swekey.conf``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX swekey.confrr}r(hDUhFjubahLjQubhyX file that will associate each user with their Swekey Id. It is important to place this file outside of your web server's document root (in the example, it is located in rr}r(hDX file that will associate each user with their Swekey Id. It is important to place this file outside of your web server's document root (in the example, it is located in rhFjubjC)r}r(hDX``/etc``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX/etcrr}r(hDUhFjubahLjQubhyX4). A self documented sample file is provided in the rr}r(hDX4). A self documented sample file is provided in the rhFjubjC)r}r(hDX ``examples``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXexamplesrr}r(hDUhFjubahLjQubhyXp directory. Feel free to use it with your own users' information. If you want to purchase a Swekey please visit rr}r(hDXp directory. Feel free to use it with your own users' information. If you want to purchase a Swekey please visit rhFjubj)r}r(hDXC`http://phpmyadmin.net/auth\_key `_rhN}r(UnamerXhttp://phpmyadmin.net/auth_keyrjXhttp://phpmyadmin.net/auth_keyrhP]rhR]rhT]rhV]rhX]ruhFjh?]rhyXhttp://phpmyadmin.net/auth_keyrr}r(hDUhFjubahLjubhA)r}r(hDX! rjKhFjhLhMhN}r(UrefurirjhP]rh+ahR]rhT]rhV]rhX]rh auh?]rubhyX1 since this link provides funding for phpMyAdmin.rr}r(hDX1 since this link provides funding for phpMyAdmin.rhFjubeubjE)r}r(hDUhFj^hGNhLjHhN}r(hT]rhV]rUadmonition-see-alsorahR]r hP]r hX]r uh[Nh\hh?]r (hm)r }r(hDXSee alsorhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXSee alsorr}r(hDjhFj ubahLhqubh})r}r(hDUhN}r(hT]rhV]rhR]rhP]r hX]r!uhFjh?]r"(je)r#}r$(hDUhN}r%(hP]r&hR]r'hT]r(hV]r)hX]r*jo]r+((jqX)$cfg['Servers'][$i]['auth_swekey_config']r,Uindex-22r-j,tr.(jqX?configuration option; $cfg['Servers'][$i]['auth_swekey_config']j-j,tr/euhFjh?]r0hLjhubhA)r1}r2(hDUhN}r3(hT]r4hV]r5hR]r6hP]r7j-ahX]r8uhFjh?]r9hLhMubh)r:}r;(hDX::config:option:`$cfg['Servers'][$i]['auth_swekey_config']`r<hFjhGhJhLhhN}r=(Ureftyper>Xoptionr?hhj,U refdomainr@XconfigrAhP]rBhR]rCU refexplicitrDhT]rEhV]rFhX]rGhhuh[Mh?]rHjC)rI}rJ(hDj<hN}rK(hT]rLhV]rM(hjAX config-optionrNehR]rOhP]rPhX]rQuhFj:h?]rRhyX)$cfg['Servers'][$i]['auth_swekey_config']rSrT}rU(hDUhFjIubahLjQubaubehLhubeubeubeubh^)rV}rW(hDUhFh_hGhJhLhchN}rX(hT]rYhV]rZhR]r[hP]r\h6ahX]r]hauh[Mh\hh?]r^(hm)r_}r`(hDX%Securing your phpMyAdmin installationrahFjVhGhJhLhqhN}rb(hT]rchV]rdhR]rehP]rfhX]rguh[Mh\hh?]rhhyX%Securing your phpMyAdmin installationrirj}rk(hDjahFj_ubaubh})rl}rm(hDXThe phpMyAdmin team tries hardly to make the application secure, however there are always ways to make your installation more secure:rnhFjVhGhJhLhhN}ro(hT]rphV]rqhR]rrhP]rshX]rtuh[Mh\hh?]ruhyXThe phpMyAdmin team tries hardly to make the application secure, however there are always ways to make your installation more secure:rvrw}rx(hDjnhFjlubaubj )ry}rz(hDUhFjVhGhJhLj hN}r{(j X*hP]r|hR]r}hT]r~hV]rhX]ruh[Mh\hh?]r(j)r}r(hDX\remove ``setup`` directory from phpMyAdmin, you will probably not use it after initial setuprhFjyhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDX\remove ``setup`` directory from phpMyAdmin, you will probably not use it after initial setuprhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mh?]r(hyXremove rr}r(hDXremove rhFjubjC)r}r(hDX ``setup``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXsetuprr}r(hDUhFjubahLjQubhyXL directory from phpMyAdmin, you will probably not use it after initial setuprr}r(hDXL directory from phpMyAdmin, you will probably not use it after initial setuprhFjubeubaubj)r}r(hDXrprevent access to ``libraries`` directory from browser, as it is not needed, supplied ``.htaccess`` file does thisrhFjyhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXrprevent access to ``libraries`` directory from browser, as it is not needed, supplied ``.htaccess`` file does thisrhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mh?]r(hyXprevent access to rr}r(hDXprevent access to rhFjubjC)r}r(hDX ``libraries``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX librariesrr}r(hDUhFjubahLjQubhyX7 directory from browser, as it is not needed, supplied rr}r(hDX7 directory from browser, as it is not needed, supplied rhFjubjC)r}r(hDX ``.htaccess``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX .htaccessrr}r(hDUhFjubahLjQubhyX file does thisrr}r(hDX file does thisrhFjubeubaubj)r}r(hDXdproperly choose authentication method - :ref:`cookie` is probably the best choice for shared hostingrhFjyhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXdproperly choose authentication method - :ref:`cookie` is probably the best choice for shared hostingrhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mh?]r(hyX(properly choose authentication method - rr}r(hDX(properly choose authentication method - rhFjubh)r}r(hDX :ref:`cookie`rhFjhGhJhLhhN}r(UreftyperXrefrhhXcookierU refdomainrXstdrhP]rhR]rU refexplicitrhT]r hV]r hX]r hhuh[Mh?]r h)r }r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFjh?]rhyXcookierr}r(hDUhFj ubahLhubaubhyX/ is probably the best choice for shared hostingrr}r(hDX/ is probably the best choice for shared hostingrhFjubeubaubj)r}r(hDXin case you don't want all MySQL users to be able to access phpMyAdmin, you can use :config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']` to limit themr hFjyhGhJhLjhN}r!(hT]r"hV]r#hR]r$hP]r%hX]r&uh[Nh\hh?]r'h})r(}r)(hDXin case you don't want all MySQL users to be able to access phpMyAdmin, you can use :config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']` to limit themr*hFjhGhJhLhhN}r+(hT]r,hV]r-hR]r.hP]r/hX]r0uh[Mh?]r1(hyXTin case you don't want all MySQL users to be able to access phpMyAdmin, you can use r2r3}r4(hDXTin case you don't want all MySQL users to be able to access phpMyAdmin, you can use r5hFj(ubje)r6}r7(hDUhN}r8(hP]r9hR]r:hT]r;hV]r<hX]r=jo]r>((jqX)$cfg['Servers'][$i]['AllowDeny']['rules']r?Uindex-23r@j?trA(jqX?configuration option; $cfg['Servers'][$i]['AllowDeny']['rules']j@j?trBeuhFj(h?]rChLjhubhA)rD}rE(hDUhN}rF(hT]rGhV]rHhR]rIhP]rJj@ahX]rKuhFj(h?]rLhLhMubh)rM}rN(hDX::config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']`rOhFj(hGhJhLhhN}rP(UreftyperQXoptionrRhhj?U refdomainrSXconfigrThP]rUhR]rVU refexplicitrWhT]rXhV]rYhX]rZhhuh[Mh?]r[jC)r\}r](hDjOhN}r^(hT]r_hV]r`(hjTX config-optionraehR]rbhP]rchX]rduhFjMh?]rehyX)$cfg['Servers'][$i]['AllowDeny']['rules']rfrg}rh(hDUhFj\ubahLjQubaubhyX to limit themrirj}rk(hDX to limit themrlhFj(ubeubaubj)rm}rn(hDXqconsider hiding phpMyAdmin behind authentication proxy, so that MySQL credentials are not all users need to loginrohFjyhGhJhLjhN}rp(hT]rqhV]rrhR]rshP]rthX]ruuh[Nh\hh?]rvh})rw}rx(hDXqconsider hiding phpMyAdmin behind authentication proxy, so that MySQL credentials are not all users need to loginryhFjmhGhJhLhhN}rz(hT]r{hV]r|hR]r}hP]r~hX]ruh[Mh?]rhyXqconsider hiding phpMyAdmin behind authentication proxy, so that MySQL credentials are not all users need to loginrr}r(hDjyhFjwubaubaubeubeubeubehDUU transformerrNU footnote_refsr}rUrefnamesr}rUsymbol_footnotesr]rUautofootnote_refsr]rUsymbol_footnote_refsr]rU citationsr]rh\hU current_linerNUtransform_messagesr]r(cdocutils.nodes system_message r)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKUtyperUINFOruh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX+Hyperlink target "setup" is not referenced.rr}r(hDUhFjubahLhubahLUsystem_messagerubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX3Hyperlink target "quick-install" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKXUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX-Hyperlink target "index-0" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKYUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX2Hyperlink target "setup-script" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKUtyperjuh?]rh})r}r (hDUhN}r (hT]r hV]r hR]r hP]rhX]ruhFjh?]rhyX-Hyperlink target "index-1" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKUtyperjuh?]r h})r!}r"(hDUhN}r#(hT]r$hV]r%hR]r&hP]r'hX]r(uhFjh?]r)hyX3Hyperlink target "linked-tables" is not referenced.r*r+}r,(hDUhFj!ubahLhubahLjubj)r-}r.(hDUhN}r/(hT]r0Ulevelr1KhP]r2hR]r3Usourcer4hJhV]r5hX]r6Uliner7KUtyper8juh?]r9h})r:}r;(hDUhN}r<(hT]r=hV]r>hR]r?hP]r@hX]rAuhFj-h?]rBhyX/Hyperlink target "upgrading" is not referenced.rCrD}rE(hDUhFj:ubahLhubahLjubj)rF}rG(hDUhN}rH(hT]rIUlevelrJKhP]rKhR]rLUsourcerMhJhV]rNhX]rOUlinerPKUtyperQjuh?]rRh})rS}rT(hDUhN}rU(hT]rVhV]rWhR]rXhP]rYhX]rZuhFjFh?]r[hyX-Hyperlink target "index-2" is not referenced.r\r]}r^(hDUhFjSubahLhubahLjubj)r_}r`(hDUhN}ra(hT]rbUlevelrcKhP]rdhR]reUsourcerfhJhV]rghX]rhUlineriKUtyperjjuh?]rkh})rl}rm(hDUhN}rn(hT]rohV]rphR]rqhP]rrhX]rsuhFj_h?]rthyX:Hyperlink target "authentication-modes" is not referenced.rurv}rw(hDUhFjlubahLhubahLjubj)rx}ry(hDUhN}rz(hT]r{Ulevelr|KhP]r}hR]r~UsourcerhJhV]rhX]rUlinerKUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjxh?]rhyX-Hyperlink target "index-3" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX-Hyperlink target "index-4" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX-Hyperlink target "index-5" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerM1Utyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX-Hyperlink target "index-6" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerM6Utyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX-Hyperlink target "index-7" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMCUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]r uhFjh?]r hyX-Hyperlink target "index-8" is not referenced.r r }r (hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMDUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]r hP]r!hX]r"uhFjh?]r#hyX,Hyperlink target "cookie" is not referenced.r$r%}r&(hDUhFjubahLhubahLjubj)r'}r((hDUhN}r)(hT]r*Ulevelr+KhP]r,hR]r-Usourcer.hJhV]r/hX]r0Uliner1MOUtyper2juh?]r3h})r4}r5(hDUhN}r6(hT]r7hV]r8hR]r9hP]r:hX]r;uhFj'h?]r<hyX-Hyperlink target "index-9" is not referenced.r=r>}r?(hDUhFj4ubahLhubahLjubj)r@}rA(hDUhN}rB(hT]rCUlevelrDKhP]rEhR]rFUsourcerGhJhV]rHhX]rIUlinerJMTUtyperKjuh?]rLh})rM}rN(hDUhN}rO(hT]rPhV]rQhR]rRhP]rShX]rTuhFj@h?]rUhyX.Hyperlink target "index-10" is not referenced.rVrW}rX(hDUhFjMubahLhubahLjubj)rY}rZ(hDUhN}r[(hT]r\Ulevelr]KhP]r^hR]r_Usourcer`hJhV]rahX]rbUlinercMVUtyperdjuh?]reh})rf}rg(hDUhN}rh(hT]rihV]rjhR]rkhP]rlhX]rmuhFjYh?]rnhyX.Hyperlink target "index-11" is not referenced.rorp}rq(hDUhFjfubahLhubahLjubj)rr}rs(hDUhN}rt(hT]ruUlevelrvKhP]rwhR]rxUsourceryhJhV]rzhX]r{Uliner|MVUtyper}juh?]r~h})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjrh?]rhyX.Hyperlink target "index-12" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMVUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-13" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMVUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-14" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMeUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-15" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMiUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-16" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMiUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-17" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r (hDUhN}r (hT]r Ulevelr KhP]r hR]rUsourcerhJhV]rhX]rUlinerMiUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-18" is not referenced.rr}r (hDUhFjubahLhubahLjubj)r!}r"(hDUhN}r#(hT]r$Ulevelr%KhP]r&hR]r'Usourcer(hJhV]r)hX]r*Uliner+MqUtyper,juh?]r-h})r.}r/(hDUhN}r0(hT]r1hV]r2hR]r3hP]r4hX]r5uhFj!h?]r6hyX.Hyperlink target "index-19" is not referenced.r7r8}r9(hDUhFj.ubahLhubahLjubj)r:}r;(hDUhN}r<(hT]r=Ulevelr>KhP]r?hR]r@UsourcerAhJhV]rBhX]rCUlinerDMqUtyperEjuh?]rFh})rG}rH(hDUhN}rI(hT]rJhV]rKhR]rLhP]rMhX]rNuhFj:h?]rOhyX.Hyperlink target "index-20" is not referenced.rPrQ}rR(hDUhFjGubahLhubahLjubj)rS}rT(hDUhN}rU(hT]rVUlevelrWKhP]rXhR]rYUsourcerZhJhV]r[hX]r\Uliner]M}Utyper^juh?]r_h})r`}ra(hDUhN}rb(hT]rchV]rdhR]rehP]rfhX]rguhFjSh?]rhhyX.Hyperlink target "index-21" is not referenced.rirj}rk(hDUhFj`ubahLhubahLjubj)rl}rm(hDUhN}rn(hT]roUlevelrpKhP]rqhR]rrUsourcershJhV]rthX]ruUlinervM~Utyperwjuh?]rxh})ry}rz(hDUhN}r{(hT]r|hV]r}hR]r~hP]rhX]ruhFjlh?]rhyX,Hyperlink target "swekey" is not referenced.rr}r(hDUhFjyubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-22" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-23" is not referenced.rr}r(hDUhFjubahLhubahLjubeUreporterrNUid_startrKU autofootnotesr]rU citation_refsr}rUindirect_targetsr]rUsettingsr(cdocutils.frontend Values ror}r(Ufootnote_backlinksrKUrecord_dependenciesrNU rfc_base_urlrUhttp://tools.ietf.org/html/rU tracebackrUpep_referencesrNUstrip_commentsrNU toc_backlinksrUentryrU language_coderUenrU datestamprNU report_levelrKU _destinationrNU halt_levelrKU strip_classesrNhqNUerror_encoding_error_handlerrUbackslashreplacerUdebugrNUembed_stylesheetrUoutput_encoding_error_handlerrUstrictrU sectnum_xformrKUdump_transformsrNU docinfo_xformrKUwarning_streamrNUpep_file_url_templaterUpep-%04drUexit_status_levelrKUconfigrNUstrict_visitorrNUcloak_email_addressesrUtrim_footnote_reference_spacerUenvrNUdump_pseudo_xmlrNUexpose_internalsrNUsectsubtitle_xformrU source_linkrNUrfc_referencesrNUoutput_encodingrUutf-8rU source_urlrNUinput_encodingrU utf-8-sigrU_disable_configrNU id_prefixrUU tab_widthrKUerror_encodingrUANSI_X3.4-1968rU_sourcerUO/usr/local/apache2/htdocs/phpmyadmin/release/phpMyAdmin-4.0.10.10/doc/setup.rstrUgettext_compactrU generatorrNUdump_internalsrNU smart_quotesrU pep_base_urlrUhttp://www.python.org/dev/peps/rUsyntax_highlightrUlongrUinput_encoding_error_handlerrjUauto_id_prefixrUidrUdoctitle_xformrUstrip_elements_with_classesrNU _config_filesr]rUfile_insertion_enabledrKU raw_enabledrKU dump_settingsrNubUsymbol_footnote_startrKUidsr }r (h=jh;jh0jh*jh+jh5jN jqjuh7jqjFj^jjjjjjjjjjh1j h-j^jjjjh)j`j j j. j2 j j j j jrjjjj6 jN j j jjjjjnjjh:j^h/jh(jh.jN h3jjHjTh,j`h2jTh8h_j@jDj-j1h9h_h4j^jjh6jVh>j^h]rjRah/]rjah9]rhBajH]rjKah-]rjTah(]rjaj]rjaj ]rj ah.]r jB ajr]r!jvaj]r"jaj6 ]r#j9 ah3]r$jah,]r%jVaj]r&jajF]r'jIauub.