€cdocutils.nodes document q)q}q(U nametypesq}q(XxamppqKXred hat enterprise linuxqNX upgradingqKX setup_scriptq KX quick installq NXsignon authentication modeq NXinstalling on windowsq NXusing setup scriptq NXhttp://phpmyadmin.net/auth_keyqKX linked-tablesqKX quick_installqKXfedoraqNXppa for michal ÄihaÅ™qKX wikipediaqKXauthentication_modesqKXcookie authentication modeqNXgentooqNX setup scriptqKXhttp authentication modeqNXopensuseqNXlinux distributionsqNXcookieqKX*extra packages for enterprise linux (epel)qKXubuntuqNXusing authentication modesqNX%securing your phpmyadmin installationqNXdebianq NXmanually creating the fileq!NX installationq"NXconfig authentication modeq#NXsetupq$KXswekey authentication modeq%NXenabledq&KX phpmyadmin configuration storageq'NXopensuse build serviceq(KXmain phpmyadmin directoryq)KXmandrivaq*NXupgrading from an older versionq+NXswekeyq,KuUsubstitution_defsq-}q.Uparse_messagesq/]q0Ucurrent_sourceq1NU decorationq2NUautofootnote_startq3KUnameidsq4}q5(hUxamppq6hUred-hat-enterprise-linuxq7hU upgradingq8h U setup-scriptq9h Uid1q:h Usignon-authentication-modeq;h Uinstalling-on-windowsqhU linked-tablesq?hU quick-installq@hUfedoraqAhUppa-for-michal-ciharqBhU wikipediaqChUauthentication-modesqDhUcookie-authentication-modeqEhUgentooqFhUid2qGhUhttp-authentication-modeqHhUopensuseqIhUlinux-distributionsqJhUcookieqKhU(extra-packages-for-enterprise-linux-epelqLhUubuntuqMhUusing-authentication-modesqNhU%securing-your-phpmyadmin-installationqOh UdebianqPh!Umanually-creating-the-fileqQh"U installationqRh#Uconfig-authentication-modeqSh$UsetupqTh%Uswekey-authentication-modeqUh&UenabledqVh'U phpmyadmin-configuration-storageqWh(Uopensuse-build-serviceqXh)Umain-phpmyadmin-directoryqYh*UmandrivaqZh+Uupgrading-from-an-older-versionq[h,Uswekeyq\uUchildrenq]]q^(cdocutils.nodes target q_)q`}qa(U rawsourceqbX .. _setup:UparentqchUsourceqdcdocutils.nodes reprunicode qeX=/var/www/phpmyadmin/release/phpMyAdmin-4.1.14.3/doc/setup.rstqf…qg}qhbUtagnameqiUtargetqjU attributesqk}ql(Uidsqm]Ubackrefsqn]Udupnamesqo]Uclassesqp]Unamesqq]UrefidqrhTuUlineqsKUdocumentqthh]]ubcdocutils.nodes section qu)qv}qw(hbUhchhdhgUexpect_referenced_by_nameqx}qyh$h`shiUsectionqzhk}q{(ho]hp]hn]hm]q|(hRhTehq]q}(h"h$euhsKhthUexpect_referenced_by_idq~}qhTh`sh]]q€(cdocutils.nodes title q)q‚}qƒ(hbX Installationq„hchvhdhghiUtitleq…hk}q†(ho]hp]hn]hm]hq]uhsKhthh]]q‡cdocutils.nodes Text qˆX Installationq‰…qŠ}q‹(hbh„hch‚ubaubcdocutils.nodes paragraph qŒ)q}qŽ(hbXïphpMyAdmin 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.hchvhdhghiU paragraphqhk}q(ho]hp]hn]hm]hq]uhsKhthh]]q‘(hˆXÃphpMyAdmin 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 q’…q“}q”(hbXÃphpMyAdmin 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 hchubcdocutils.nodes emphasis q•)q–}q—(hbUhk}q˜(UrawtextX:guilabel:`Users`hm]hn]ho]hp]q™Xguilabelqšahq]uhchh]]q›hˆXUsersqœ…q}qž(hbUhch–ubahiUemphasisqŸubhˆX page can be used for this.q …q¡}q¢(hbX page can be used for this.hchubeubcdocutils.nodes warning q£)q¤}q¥(hbX=: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``").hchvhdhghiUwarningq¦hk}q§(ho]hp]hn]hm]hq]uhsNhthh]]q¨hŒ)q©}qª(hbX=: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``").hch¤hdhghihhk}q«(ho]hp]hn]hm]hq]uhsK h]]q¬(csphinx.addnodes pending_xref q­)q®}q¯(hbX :term:`Mac`q°hch©hdhghiU pending_xrefq±hk}q²(UreftypeXtermUrefwarnq³ˆU reftargetq´XmacU refdomainXstdqµhm]hn]U refexplicit‰ho]hp]hq]Urefdocq¶Usetupq·uhsK h]]q¸h•)q¹}qº(hbh°hk}q»(ho]hp]q¼(Uxrefq½hµXstd-termq¾ehn]hm]hq]uhch®h]]q¿hˆXMacqÀ…qÁ}qÂ(hbUhch¹ubahihŸubaubhˆX7 users should note that if you are on a version before qÃ…qÄ}qÅ(hbX7 users should note that if you are on a version before hch©ubh­)qÆ}qÇ(hbX:term:`Mac OS X`qÈhch©hdhghih±hk}qÉ(UreftypeXtermh³ˆh´Xmac os xU refdomainXstdqÊhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsK h]]qËh•)qÌ}qÍ(hbhÈhk}qÎ(ho]hp]qÏ(h½hÊXstd-termqÐehn]hm]hq]uhchÆh]]qÑhˆXMac OS XqÒ…qÓ}qÔ(hbUhchÌubahihŸubaubhˆX, StuffIt unstuffs with qÕ…qÖ}q×(hbX, StuffIt unstuffs with hch©ubh­)qØ}qÙ(hbX :term:`Mac`qÚhch©hdhghih±hk}qÛ(UreftypeXtermh³ˆh´XmacU refdomainXstdqÜhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsK h]]qÝh•)qÞ}qß(hbhÚhk}qà(ho]hp]qá(h½hÜXstd-termqâehn]hm]hq]uhchØh]]qãhˆXMacqä…qå}qæ(hbUhchÞubahihŸubaubhˆX” 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 qç…qè}qé(hbX” 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 hch©ubh­)qê}që(hbX :term:`Mac`qìhch©hdhghih±hk}qí(UreftypeXtermh³ˆh´XmacU refdomainXstdqîhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsK h]]qïh•)qð}qñ(hbhìhk}qò(ho]hp]qó(h½hîXstd-termqôehn]hm]hq]uhchêh]]qõhˆXMacqö…q÷}qø(hbUhchðubahihŸubaubhˆX -style end of lines character ("qù…qú}qû(hbX -style end of lines character ("hch©ubcdocutils.nodes literal qü)qý}qþ(hbX``\r``hk}qÿ(ho]hp]hn]hm]hq]uhch©h]]rhˆX\rr…r}r(hbUhchýubahiUliteralrubhˆX").r…r}r(hbX").hch©ubeubaubhu)r}r (hbUhchvhdhghihzhk}r (ho]hp]hn]hm]r hJahq]r hauhsKhthh]]r (h)r}r(hbXLinux distributionsrhcjhdhghih…hk}r(ho]hp]hn]hm]hq]uhsKhthh]]rhˆXLinux distributionsr…r}r(hbjhcjubaubhŒ)r}r(hbXðphpMyAdmin is included in most Linux distributions. It is recommended to use distribution packages when possible - they usually provide integration to your distribution and you will automatically get security updates from your distribution.rhcjhdhghihhk}r(ho]hp]hn]hm]hq]uhsKhthh]]rhˆXðphpMyAdmin is included in most Linux distributions. It is recommended to use distribution packages when possible - they usually provide integration to your distribution and you will automatically get security updates from your distribution.r…r}r(hbjhcjubaubhu)r}r(hbUhcjhdhghihzhk}r (ho]hp]hn]hm]r!hPahq]r"h auhsKhthh]]r#(h)r$}r%(hbXDebianr&hcjhdhghih…hk}r'(ho]hp]hn]hm]hq]uhsKhthh]]r(hˆXDebianr)…r*}r+(hbj&hcj$ubaubhŒ)r,}r-(hbXÑDebian's package repositories include a phpMyAdmin package, but be aware that the configuration file is maintained in ``/etc/phpmyadmin`` and may differ in some ways from the official phpMyAdmin documentation.hcjhdhghihhk}r.(ho]hp]hn]hm]hq]uhsKhthh]]r/(hˆXvDebian's package repositories include a phpMyAdmin package, but be aware that the configuration file is maintained in r0…r1}r2(hbXvDebian's package repositories include a phpMyAdmin package, but be aware that the configuration file is maintained in hcj,ubhü)r3}r4(hbX``/etc/phpmyadmin``hk}r5(ho]hp]hn]hm]hq]uhcj,h]]r6hˆX/etc/phpmyadminr7…r8}r9(hbUhcj3ubahijubhˆXH and may differ in some ways from the official phpMyAdmin documentation.r:…r;}r<(hbXH and may differ in some ways from the official phpMyAdmin documentation.hcj,ubeubeubhu)r=}r>(hbUhcjhdhghihzhk}r?(ho]hp]hn]hm]r@hIahq]rAhauhsK#hthh]]rB(h)rC}rD(hbXOpenSUSErEhcj=hdhghih…hk}rF(ho]hp]hn]hm]hq]uhsK#hthh]]rGhˆXOpenSUSErH…rI}rJ(hbjEhcjCubaubhŒ)rK}rL(hbX›OpenSUSE already comes with phpMyAdmin package, just install packages from the `openSUSE Build Service `_.hcj=hdhghihhk}rM(ho]hp]hn]hm]hq]uhsK%hthh]]rN(hˆXOOpenSUSE already comes with phpMyAdmin package, just install packages from the rO…rP}rQ(hbXOOpenSUSE already comes with phpMyAdmin package, just install packages from the hcjKubcdocutils.nodes reference rR)rS}rT(hbXK`openSUSE Build Service `_hk}rU(UnameXopenSUSE Build ServiceUrefurirVX/http://software.opensuse.org/package/phpMyAdminrWhm]hn]ho]hp]hq]uhcjKh]]rXhˆXopenSUSE Build ServicerY…rZ}r[(hbUhcjSubahiU referencer\ubh_)r]}r^(hbX2 hk}r_(UrefurijWhm]r`hXahn]ho]hp]hq]rah(auhcjKh]]hihjubhˆX.…rb}rc(hbX.hcjKubeubeubhu)rd}re(hbUhcjhdhghihzhk}rf(ho]hp]hn]hm]rghMahq]rhhauhsK)hthh]]ri(h)rj}rk(hbXUbunturlhcjdhdhghih…hk}rm(ho]hp]hn]hm]hq]uhsK)hthh]]rnhˆXUbunturo…rp}rq(hbjlhcjjubaubhŒ)rr}rs(hbX³Ubuntu ships phpMyAdmin package, however if you want to use recent version, you can use packages from `PPA for Michal ÄŒihaÅ™ `_.hcjdhdhghihhk}rt(ho]hp]hn]hm]hq]uhsK+hthh]]ru(hˆXfUbuntu ships phpMyAdmin package, however if you want to use recent version, you can use packages from rv…rw}rx(hbXfUbuntu ships phpMyAdmin package, however if you want to use recent version, you can use packages from hcjrubjR)ry}rz(hbXL`PPA for Michal ÄŒihaÅ™ `_hk}r{(UnameXPPA for Michal ÄŒihaÅ™jVX0https://launchpad.net/~nijel/+archive/phpmyadminr|hm]hn]ho]hp]hq]uhcjrh]]r}hˆXPPA for Michal ÄŒihaÅ™r~…r}r€(hbUhcjyubahij\ubh_)r}r‚(hbX3 hk}rƒ(Urefurij|hm]r„hBahn]ho]hp]hq]r…hauhcjrh]]hihjubhˆX.…r†}r‡(hbX.hcjrubeubeubhu)rˆ}r‰(hbUhcjhdhghihzhk}rŠ(ho]hp]hn]hm]r‹hFahq]rŒhauhsK0hthh]]r(h)rŽ}r(hbXGentoorhcjˆhdhghih…hk}r‘(ho]hp]hn]hm]hq]uhsK0hthh]]r’hˆXGentoor“…r”}r•(hbjhcjŽubaubhŒ)r–}r—(hbX¥Gentoo ships the phpMyAdmin package, both in a near stock configuration as well as in a ``webapp-config`` configuration. Use ``emerge dev-db/phpmyadmin`` to install.hcjˆhdhghihhk}r˜(ho]hp]hn]hm]hq]uhsK2hthh]]r™(hˆXXGentoo ships the phpMyAdmin package, both in a near stock configuration as well as in a rš…r›}rœ(hbXXGentoo ships the phpMyAdmin package, both in a near stock configuration as well as in a hcj–ubhü)r}rž(hbX``webapp-config``hk}rŸ(ho]hp]hn]hm]hq]uhcj–h]]r hˆX webapp-configr¡…r¢}r£(hbUhcjubahijubhˆX configuration. Use r¤…r¥}r¦(hbX configuration. Use hcj–ubhü)r§}r¨(hbX``emerge dev-db/phpmyadmin``hk}r©(ho]hp]hn]hm]hq]uhcj–h]]rªhˆXemerge dev-db/phpmyadminr«…r¬}r­(hbUhcj§ubahijubhˆX to install.r®…r¯}r°(hbX to install.hcj–ubeubeubhu)r±}r²(hbUhcjhdhghihzhk}r³(ho]hp]hn]hm]r´hZahq]rµh*auhsK7hthh]]r¶(h)r·}r¸(hbXMandrivar¹hcj±hdhghih…hk}rº(ho]hp]hn]hm]hq]uhsK7hthh]]r»hˆXMandrivar¼…r½}r¾(hbj¹hcj·ubaubhŒ)r¿}rÀ(hbXtMandriva ships the phpMyAdmin package in their ``contrib`` branch and can be installed via the usual Control Center.hcj±hdhghihhk}rÁ(ho]hp]hn]hm]hq]uhsK9hthh]]rÂ(hˆX/Mandriva ships the phpMyAdmin package in their rÃ…rÄ}rÅ(hbX/Mandriva ships the phpMyAdmin package in their hcj¿ubhü)rÆ}rÇ(hbX ``contrib``hk}rÈ(ho]hp]hn]hm]hq]uhcj¿h]]rÉhˆXcontribrÊ…rË}rÌ(hbUhcjÆubahijubhˆX: branch and can be installed via the usual Control Center.rÍ…rÎ}rÏ(hbX: branch and can be installed via the usual Control Center.hcj¿ubeubeubhu)rÐ}rÑ(hbUhcjhdhghihzhk}rÒ(ho]hp]hn]hm]rÓhAahq]rÔhauhsK=hthh]]rÕ(h)rÖ}r×(hbXFedorarØhcjÐhdhghih…hk}rÙ(ho]hp]hn]hm]hq]uhsK=hthh]]rÚhˆXFedorarÛ…rÜ}rÝ(hbjØhcjÖubaubhŒ)rÞ}rß(hbX»Fedora ships the phpMyAdmin package, but be aware that the configuration file is maintained in ``/etc/phpMyAdmin/`` and may differ in some ways from the official phpMyAdmin documentation.hcjÐhdhghihhk}rà(ho]hp]hn]hm]hq]uhsK?hthh]]rá(hˆX_Fedora ships the phpMyAdmin package, but be aware that the configuration file is maintained in râ…rã}rä(hbX_Fedora ships the phpMyAdmin package, but be aware that the configuration file is maintained in hcjÞubhü)rå}ræ(hbX``/etc/phpMyAdmin/``hk}rç(ho]hp]hn]hm]hq]uhcjÞh]]rèhˆX/etc/phpMyAdmin/ré…rê}rë(hbUhcjåubahijubhˆXH and may differ in some ways from the official phpMyAdmin documentation.rì…rí}rî(hbXH and may differ in some ways from the official phpMyAdmin documentation.hcjÞubeubeubhu)rï}rð(hbUhcjhdhghihzhk}rñ(ho]hp]hn]hm]ròh7ahq]róhauhsKDhthh]]rô(h)rõ}rö(hbXRed Hat Enterprise Linuxr÷hcjïhdhghih…hk}rø(ho]hp]hn]hm]hq]uhsKDhthh]]rùhˆXRed Hat Enterprise Linuxrú…rû}rü(hbj÷hcjõubaubhŒ)rý}rþ(hbXµRed Hat Enterprise Linux itself and thus derivatives like CentOS don't ship phpMyAdmin, but the Fedora-driven repository `Extra Packages for Enterprise Linux (EPEL) `_ is doing so, if it's `enabled `_. But be aware that the configuration file is maintained in ``/etc/phpMyAdmin/`` and may differ in some ways from the official phpMyAdmin documentation.hcjïhdhghihhk}rÿ(ho]hp]hn]hm]hq]uhsKFhthh]]r(hˆXyRed Hat Enterprise Linux itself and thus derivatives like CentOS don't ship phpMyAdmin, but the Fedora-driven repository r…r}r(hbXyRed Hat Enterprise Linux itself and thus derivatives like CentOS don't ship phpMyAdmin, but the Fedora-driven repository hcjýubjR)r}r(hbXR`Extra Packages for Enterprise Linux (EPEL) `_hk}r(UnameX*Extra Packages for Enterprise Linux (EPEL)jVX"http://fedoraproject.org/wiki/EPELrhm]hn]ho]hp]hq]uhcjýh]]rhˆX*Extra Packages for Enterprise Linux (EPEL)r …r }r (hbUhcjubahij\ubh_)r }r (hbX% hk}r(Urefurijhm]rhLahn]ho]hp]hq]rhauhcjýh]]hihjubhˆX is doing so, if it's r…r}r(hbX is doing so, if it's hcjýubjR)r}r(hbX<`enabled `_hk}r(Unameh&jVX/http://fedoraproject.org/wiki/EPEL/FAQ#howtouserhm]hn]ho]hp]hq]uhcjýh]]rhˆXenabledr…r}r(hbUhcjubahij\ubh_)r}r(hbX2 hk}r(Urefurijhm]rhVahn]ho]hp]hq]r h&auhcjýh]]hihjubhˆX<. But be aware that the configuration file is maintained in r!…r"}r#(hbX<. But be aware that the configuration file is maintained in hcjýubhü)r$}r%(hbX``/etc/phpMyAdmin/``hk}r&(ho]hp]hn]hm]hq]uhcjýh]]r'hˆX/etc/phpMyAdmin/r(…r)}r*(hbUhcj$ubahijubhˆXH and may differ in some ways from the official phpMyAdmin documentation.r+…r,}r-(hbXH and may differ in some ways from the official phpMyAdmin documentation.hcjýubeubeubeubhu)r.}r/(hbUhchvhdhghihzhk}r0(ho]hp]hn]hm]r1h`_.hcj.hdhghihhk}r>(ho]hp]hn]hm]hq]uhsKShthh]]r?(hˆX”The easiest way to get phpMyAdmin on Windows is using third party products which include phpMyAdmin together with a database and web server such as r@…rA}rB(hbX”The easiest way to get phpMyAdmin on Windows is using third party products which include phpMyAdmin together with a database and web server such as hcj<ubjR)rC}rD(hbX5`XAMPP `_hk}rE(UnameXXAMPPjVX*http://www.apachefriends.org/en/xampp.htmlrFhm]hn]ho]hp]hq]uhcj<h]]rGhˆXXAMPPrH…rI}rJ(hbUhcjCubahij\ubh_)rK}rL(hbX- hk}rM(UrefurijFhm]rNh6ahn]ho]hp]hq]rOhauhcj<h]]hihjubhˆX.…rP}rQ(hbX.hcj<ubeubhŒ)rR}rS(hbXgYou can find more of such options at `Wikipedia `_.rThcj.hdhghihhk}rU(ho]hp]hn]hm]hq]uhsKWhthh]]rV(hˆX%You can find more of such options at rW…rX}rY(hbX%You can find more of such options at hcjRubjR)rZ}r[(hbXA`Wikipedia `_hk}r\(UnameX WikipediajVX2https://en.wikipedia.org/wiki/List_of_AMP_packagesr]hm]hn]ho]hp]hq]uhcjRh]]r^hˆX Wikipediar_…r`}ra(hbUhcjZubahij\ubh_)rb}rc(hbX5 hk}rd(Urefurij]hm]rehCahn]ho]hp]hq]rfhauhcjRh]]hihjubhˆX.…rg}rh(hbX.hcjRubeubh_)ri}rj(hbX.. _quick_install:hcj.hdhghihjhk}rk(hm]hn]ho]hp]hq]hrh@uhsKZhthh]]ubeubhu)rl}rm(hbUhchvhdhghx}rnhjishihzhk}ro(ho]hp]hn]hm]rp(h@h:ehq]rq(h heuhsK]hthh~}rrh@jish]]rs(h)rt}ru(hbX Quick Installrvhcjlhdhghih…hk}rw(ho]hp]hn]hm]hq]uhsK]hthh]]rxhˆX Quick Installry…rz}r{(hbjvhcjtubaubcdocutils.nodes enumerated_list r|)r}}r~(hbUhcjlhdhghiUenumerated_listrhk}r€(UsuffixrU.hm]hn]ho]Uprefixr‚Uhp]hq]UenumtyperƒUarabicr„uhsK_hthh]]r…(cdocutils.nodes list_item r†)r‡}rˆ(hbXøChoose 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``.hcj}hdhghiU list_itemr‰hk}rŠ(ho]hp]hn]hm]hq]uhsNhthh]]r‹hŒ)rŒ}r(hbXøChoose 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``.hcj‡hdhghihhk}rŽ(ho]hp]hn]hm]hq]uhsK_h]]r(hˆXÍChoose 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 r…r‘}r’(hbXÍChoose 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 hcjŒubhü)r“}r”(hbX*``phpMyAdmin-x.x.x -all-languages.tar.gz``hk}r•(ho]hp]hn]hm]hq]uhcjŒh]]r–hˆX&phpMyAdmin-x.x.x -all-languages.tar.gzr—…r˜}r™(hbUhcj“ubahijubhˆX.…rš}r›(hbX.hcjŒubeubaubj†)rœ}r(hbX^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.hcj}hdhghij‰hk}rž(ho]hp]hn]hm]hq]uhsNhthh]]rŸhŒ)r }r¡(hbX^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.hcjœhdhghihhk}r¢(ho]hp]hn]hm]hq]uhsKch]]r£(hˆXGUntar or unzip the distribution (be sure to unzip the subdirectories): r¤…r¥}r¦(hbXGUntar or unzip the distribution (be sure to unzip the subdirectories): hcj ubhü)r§}r¨(hbX3``tar -xzvf phpMyAdmin_x.x.x-all-languages.tar.gz``hk}r©(ho]hp]hn]hm]hq]uhcj h]]rªhˆX/tar -xzvf phpMyAdmin_x.x.x-all-languages.tar.gzr«…r¬}r­(hbUhcj§ubahijubhˆXä 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.r®…r¯}r°(hbXä 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.hcj ubeubaubj†)r±}r²(hbXíEnsure 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.hcj}hdhghij‰hk}r³(ho]hp]hn]hm]hq]uhsNhthh]]r´hŒ)rµ}r¶(hbXíEnsure 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.hcj±hdhghihhk}r·(ho]hp]hn]hm]hq]uhsKih]]r¸(hˆX¼Ensure 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 r¹…rº}r»(hbX¼Ensure 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 hcjµubh­)r¼}r½(hbX :ref:`faq4_2`r¾hcjµhdhghih±hk}r¿(UreftypeXrefh³ˆh´Xfaq4_2U refdomainXstdrÀhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsKih]]rÁh•)rÂ}rÃ(hbj¾hk}rÄ(ho]hp]rÅ(h½jÀXstd-refrÆehn]hm]hq]uhcj¼h]]rÇhˆXfaq4_2rÈ…rÉ}rÊ(hbUhcjÂubahihŸubaubhˆX and rË…rÌ}rÍ(hbX and hcjµubh­)rÎ}rÏ(hbX:ref:`faq1_26`rÐhcjµhdhghih±hk}rÑ(UreftypeXrefh³ˆh´Xfaq1_26U refdomainXstdrÒhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsKih]]rÓh•)rÔ}rÕ(hbjÐhk}rÖ(ho]hp]r×(h½jÒXstd-refrØehn]hm]hq]uhcjÎh]]rÙhˆXfaq1_26rÚ…rÛ}rÜ(hbUhcjÔubahihŸubaubhˆX for suggestions.rÝ…rÞ}rß(hbX for suggestions.hcjµubeubaubj†)rà}rá(hbXgNow 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. hcj}hdhghij‰hk}râ(ho]hp]hn]hm]hq]uhsNhthh]]rãhŒ)rä}rå(hbXeNow 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.hcjàhdhghihhk}ræ(ho]hp]hn]hm]hq]uhsKmh]]rç(hˆX‚Now you must configure your installation. There are two methods that can be used. Traditionally, users have hand-edited a copy of rè…ré}rê(hbX‚Now you must configure your installation. There are two methods that can be used. Traditionally, users have hand-edited a copy of hcjäubhü)rë}rì(hbUhk}rí(hm]hn]ho]hp]rîXfilerïaUrolejïhq]uhcjäh]]rðhˆXconfig.inc.phprñ…rò}ró(hbXconfig.inc.phphcjëubahijubhˆXl, but now a wizard-style setup script is provided for those who prefer a graphical installation. Creating a rô…rõ}rö(hbXl, but now a wizard-style setup script is provided for those who prefer a graphical installation. Creating a hcjäubhü)r÷}rø(hbUhk}rù(hm]hn]ho]hp]rúXfilerûaUrolejûhq]uhcjäh]]rühˆXconfig.inc.phprý…rþ}rÿ(hbXconfig.inc.phphcj÷ubahijubhˆXK is still a quick way to get started and needed for some advanced features.r…r}r(hbXK is still a quick way to get started and needed for some advanced features.hcjäubeubaubeubhu)r}r(hbUhcjlhdhghihzhk}r(ho]hp]hn]hm]rhQahq]rh!auhsKvhthh]]r(h)r }r (hbXManually creating the filer hcjhdhghih…hk}r (ho]hp]hn]hm]hq]uhsKvhthh]]r hˆXManually creating the filer…r}r(hbj hcj ubaubhŒ)r}r(hbX[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:hcjhdhghihhk}r(ho]hp]hn]hm]hq]uhsKxhthh]]r(hˆXLTo manually create the file, simply use your text editor to create the file r…r}r(hbXLTo manually create the file, simply use your text editor to create the file hcjubhü)r}r(hbUhk}r(hm]hn]ho]hp]rXfileraUrolejhq]uhcjh]]rhˆXconfig.inc.phpr…r}r (hbXconfig.inc.phphcjubahijubhˆX (you can copy r!…r"}r#(hbX (you can copy hcjubhü)r$}r%(hbUhk}r&(hm]hn]ho]hp]r'Xfiler(aUrolej(hq]uhcjh]]r)hˆXconfig.sample.inc.phpr*…r+}r,(hbXconfig.sample.inc.phphcj$ubahijubhˆXh to get minimal configuration file) in the main (top-level) phpMyAdmin directory (the one that contains r-…r.}r/(hbXh to get minimal configuration file) in the main (top-level) phpMyAdmin directory (the one that contains hcjubhü)r0}r1(hbUhk}r2(hm]hn]ho]hp]r3Xfiler4aUrolej4hq]uhcjh]]r5hˆX index.phpr6…r7}r8(hbX index.phphcj0ubahijubhˆX). phpMyAdmin first loads r9…r:}r;(hbX). phpMyAdmin first loads hcjubhü)r<}r=(hbUhk}r>(hm]hn]ho]hp]r?Xfiler@aUrolej@hq]uhcjh]]rAhˆXlibraries/config.default.phprB…rC}rD(hbXlibraries/config.default.phphcj<ubahijubhˆX8 and then overrides those values with anything found in rE…rF}rG(hbX8 and then overrides those values with anything found in hcjubhü)rH}rI(hbUhk}rJ(hm]hn]ho]hp]rKXfilerLaUrolejLhq]uhcjh]]rMhˆXconfig.inc.phprN…rO}rP(hbXconfig.inc.phphcjHubahijubhˆX[. If the default value is okay for a particular setting, there is no need to include it in rQ…rR}rS(hbX[. If the default value is okay for a particular setting, there is no need to include it in hcjubhü)rT}rU(hbUhk}rV(hm]hn]ho]hp]rWXfilerXaUrolejXhq]uhcjh]]rYhˆXconfig.inc.phprZ…r[}r\(hbXconfig.inc.phphcjTubahijubhˆXW. You'll need a few directives to get going, a simple configuration may look like this:r]…r^}r_(hbXW. You'll need a few directives to get going, a simple configuration may look like this:hcjubeubcdocutils.nodes literal_block r`)ra}rb(hbX˜hcjhdhghiU literal_blockrchk}rd(Ulinenosre‰UlanguagerfXxml+phpU xml:spacergUpreserverhhm]hn]ho]hp]hq]uhsK‚hthh]]rihˆX˜rj…rk}rl(hbUhcjaubaubhŒ)rm}rn(hbX;Or, if you prefer to not be prompted every time you log in:rohcjhdhghihhk}rp(ho]hp]hn]hm]hq]uhsKhthh]]rqhˆX;Or, if you prefer to not be prompted every time you log in:rr…rs}rt(hbjohcjmubaubj`)ru}rv(hbXÁhcjhdhghijchk}rw(je‰jfXxml+phpjgjhhm]hn]ho]hp]hq]uhsKhthh]]rxhˆXÁry…rz}r{(hbUhcjuubaubhŒ)r|}r}(hbX`For a full explanation of possible configuration values, see the :ref:`config` of this document.hcjhdhghihhk}r~(ho]hp]hn]hm]hq]uhsK›hthh]]r(hˆXAFor a full explanation of possible configuration values, see the r€…r}r‚(hbXAFor a full explanation of possible configuration values, see the hcj|ubh­)rƒ}r„(hbX :ref:`config`r…hcj|hdhghih±hk}r†(UreftypeXrefh³ˆh´XconfigU refdomainXstdr‡hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsK›h]]rˆh•)r‰}rŠ(hbj…hk}r‹(ho]hp]rŒ(h½j‡Xstd-refrehn]hm]hq]uhcjƒh]]rŽhˆXconfigr…r}r‘(hbUhcj‰ubahihŸubaubhˆX of this document.r’…r“}r”(hbX of this document.hcj|ubeubcsphinx.addnodes index r•)r–}r—(hbUhcjhdhghiUindexr˜hk}r™(hm]hn]ho]hp]hq]Uentriesrš]r›(UsinglerœX Setup scriptUindex-0rUtržaUinlinerŸ‰uhsKŸhthh]]ubh_)r }r¡(hbUhcjhdhghihjhk}r¢(hm]hn]ho]hp]hq]hrjuhsKŸhthh]]ubh_)r£}r¤(hbX.. _setup_script:hcjhdhghx}hihjhk}r¥(hm]hn]ho]hp]hq]hrh9uhsK hthh~}r¦jj sh]]ubeubhu)r§}r¨(hbUhcjlhdhghx}r©h j£shihzhk}rª(ho]hp]hn]hm]r«(h=h9jehq]r¬(h h euhsK£hthh~}r­(jj h9j£uh]]r®(h)r¯}r°(hbXUsing Setup scriptr±hcj§hdhghih…hk}r²(ho]hp]hn]hm]hq]uhsK£hthh]]r³hˆXUsing Setup scriptr´…rµ}r¶(hbj±hcj¯ubaubhŒ)r·}r¸(hbXInstead 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:hcj§hdhghihhk}r¹(ho]hp]hn]hm]hq]uhsK¥hthh]]rº(hˆXInstead of manually editing r»…r¼}r½(hbXInstead of manually editing hcj·ubhü)r¾}r¿(hbUhk}rÀ(hm]hn]ho]hp]rÁXfilerÂaUrolejÂhq]uhcj·h]]rÃhˆXconfig.inc.phprÄ…rÅ}rÆ(hbXconfig.inc.phphcj¾ubahijubhˆX, you can use the rÇ…rÈ}rÉ(hbX, you can use the hcj·ubjR)rÊ}rË(hbX`Setup Script `_hk}rÌ(UnameX Setup ScriptjVXsetup/rÍhm]hn]ho]hp]hq]uhcj·h]]rÎhˆX Setup ScriptrÏ…rÐ}rÑ(hbUhcjÊubahij\ubh_)rÒ}rÓ(hbX hk}rÔ(UrefurijÍhm]rÕhGahn]ho]hp]hq]rÖhauhcj·h]]hihjubhˆX*. First you must manually create a folder r×…rØ}rÙ(hbX*. First you must manually create a folder hcj·ubhü)rÚ}rÛ(hbX ``config``hk}rÜ(ho]hp]hn]hm]hq]uhcj·h]]rÝhˆXconfigrÞ…rß}rà(hbUhcjÚubahijubhˆXt in the phpMyAdmin directory. This is a security measure. On a Linux/Unix system you can use the following commands:rá…râ}rã(hbXt in the phpMyAdmin directory. This is a security measure. On a Linux/Unix system you can use the following commands:hcj·ubeubj`)rä}rå(hbX˜cd phpMyAdmin mkdir config # create directory for saving chmod o+rw config # give it world writable permissionshcj§hdhghijchk}ræ(je‰jfXshjgjhhm]hn]ho]hp]hq]uhsKªhthh]]rçhˆX˜cd phpMyAdmin mkdir config # create directory for saving chmod o+rw config # give it world writable permissionsrè…ré}rê(hbUhcjäubaubhŒ)rë}rì(hbX:And to edit an existing configuration, copy it over first:ríhcj§hdhghihhk}rî(ho]hp]hn]hm]hq]uhsK±hthh]]rïhˆX:And to edit an existing configuration, copy it over first:rð…rñ}rò(hbjíhcjëubaubj`)ró}rô(hbX•cp config.inc.php config/ # copy current configuration for editing chmod o+w config/config.inc.php # give it world writable permissionshcj§hdhghijchk}rõ(je‰jfXshjgjhhm]hn]ho]hp]hq]uhsK³hthh]]röhˆX•cp config.inc.php config/ # copy current configuration for editing chmod o+w config/config.inc.php # give it world writable permissionsr÷…rø}rù(hbUhcjóubaubhŒ)rú}rû(hbXOn 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.hcj§hdhghihhk}rü(ho]hp]hn]hm]hq]uhsK¹hthh]]rý(hˆXnOn other platforms, simply create the folder and ensure that your web server has read and write access to it. rþ…rÿ}r(hbXnOn other platforms, simply create the folder and ensure that your web server has read and write access to it. hcjúubh­)r}r(hbX:ref:`faq1_26`rhcjúhdhghih±hk}r(UreftypeXrefh³ˆh´Xfaq1_26U refdomainXstdrhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsK¹h]]rh•)r}r(hbjhk}r (ho]hp]r (h½jXstd-refr ehn]hm]hq]uhcjh]]r hˆXfaq1_26r …r}r(hbUhcjubahihŸubaubhˆX can help with this.r…r}r(hbX can help with this.hcjúubeubhŒ)r}r(hbX©Next, 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.hcj§hdhghihhk}r(ho]hp]hn]hm]hq]uhsK½hthh]]r(hˆX Next, open r…r}r(hbX Next, open hcjubhü)r}r(hbX ``setup/``hk}r(ho]hp]hn]hm]hq]uhcjh]]rhˆXsetup/r…r}r (hbUhcjubahijubhˆXA in your browser. If you have an existing configuration, use the r!…r"}r#(hbXA in your browser. If you have an existing configuration, use the hcjubhü)r$}r%(hbX``Load``hk}r&(ho]hp]hn]hm]hq]uhcjh]]r'hˆXLoadr(…r)}r*(hbUhcj$ubahijubhˆX? button to bring its content inside the setup panel. Note that r+…r,}r-(hbX? button to bring its content inside the setup panel. Note that hcjubcdocutils.nodes strong r.)r/}r0(hbXB**changes are not saved to disk until explicitly choose ``Save``**hk}r1(ho]hp]hn]hm]hq]uhcjh]]r2hˆX>changes are not saved to disk until explicitly choose ``Save``r3…r4}r5(hbUhcj/ubahiUstrongr6ubhˆX from the r7…r8}r9(hbX from the hcjubh•)r:}r;(hbX*Configuration*hk}r<(ho]hp]hn]hm]hq]uhcjh]]r=hˆX Configurationr>…r?}r@(hbUhcj:ubahihŸubhˆX7 area of the screen. Normally the script saves the new rA…rB}rC(hbX7 area of the screen. Normally the script saves the new hcjubhü)rD}rE(hbUhk}rF(hm]hn]ho]hp]rGXfilerHaUrolejHhq]uhcjh]]rIhˆXconfig.inc.phprJ…rK}rL(hbXconfig.inc.phphcjDubahijubhˆX to the rM…rN}rO(hbX to the hcjubhü)rP}rQ(hbX ``config/``hk}rR(ho]hp]hn]hm]hq]uhcjh]]rShˆXconfig/rT…rU}rV(hbUhcjPubahijubhˆX‘ directory, but if the webserver does not have the proper permissions you may see the error "Cannot load or save configuration." Ensure that the rW…rX}rY(hbX‘ directory, but if the webserver does not have the proper permissions you may see the error "Cannot load or save configuration." Ensure that the hcjubhü)rZ}r[(hbX ``config/``hk}r\(ho]hp]hn]hm]hq]uhcjh]]r]hˆXconfig/r^…r_}r`(hbUhcjZubahijubhˆX> directory exists and has the proper permissions - or use the ra…rb}rc(hbX> directory exists and has the proper permissions - or use the hcjubhü)rd}re(hbX ``Download``hk}rf(ho]hp]hn]hm]hq]uhcjh]]rghˆXDownloadrh…ri}rj(hbUhcjdubahijubhˆXk link to save the config file locally and upload it (via FTP or some similar means) to the proper location.rk…rl}rm(hbXk link to save the config file locally and upload it (via FTP or some similar means) to the proper location.hcjubeubhŒ)rn}ro(hbXOnce 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:hcj§hdhghihhk}rp(ho]hp]hn]hm]hq]uhsKÈhthh]]rq(hˆX:Once the file has been saved, it must be moved out of the rr…rs}rt(hbX:Once the file has been saved, it must be moved out of the hcjnubhü)ru}rv(hbX ``config/``hk}rw(ho]hp]hn]hm]hq]uhcjnh]]rxhˆXconfig/ry…rz}r{(hbUhcjuubahijubhˆXJ directory and the permissions must be reset, again as a security measure:r|…r}}r~(hbXJ directory and the permissions must be reset, again as a security measure:hcjnubeubj`)r}r€(hbXÑmv 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 directoryhcj§hdhghijchk}r(je‰jfXshjgjhhm]hn]ho]hp]hq]uhsKÌhthh]]r‚hˆXÑmv 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ƒ…r„}r…(hbUhcjubaubhŒ)r†}r‡(hbXºNow 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ˆhcj§hdhghihhk}r‰(ho]hp]hn]hm]hq]uhsKÓhthh]]rŠhˆXºNow 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(hbjˆhcj†ubaubj|)rŽ}r(hbUhcj§hdhghijhk}r(jU.hm]hn]ho]j‚Uhp]hq]jƒj„uhsK×hthh]]r‘(j†)r’}r“(hbXÑIf 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`.hcjŽhdhghij‰hk}r”(ho]hp]hn]hm]hq]uhsNhthh]]r•hŒ)r–}r—(hbXÑIf 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`.hcj’hdhghihhk}r˜(ho]hp]hn]hm]hq]uhsK×h]]r™(hˆXIf you are using the rš…r›}rœ(hbXIf you are using the hcj–ubhü)r}rž(hbX ``auth_type``hk}rŸ(ho]hp]hn]hm]hq]uhcj–h]]r hˆX auth_typer¡…r¢}r£(hbUhcjubahijubhˆX "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 r¤…r¥}r¦(hbX "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 hcj–ubh­)r§}r¨(hbX:term:`.htaccess`r©hcj–hdhghih±hk}rª(UreftypeXtermh³ˆh´X .htaccessU refdomainXstdr«hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsK×h]]r¬h•)r­}r®(hbj©hk}r¯(ho]hp]r°(h½j«Xstd-termr±ehn]hm]hq]uhcj§h]]r²hˆX .htaccessr³…r´}rµ(hbUhcj­ubahihŸubaubhˆX file or switch to using r¶…r·}r¸(hbX file or switch to using hcj–ubhü)r¹}rº(hbX ``auth_type``hk}r»(ho]hp]hn]hm]hq]uhcj–h]]r¼hˆX auth_typer½…r¾}r¿(hbUhcj¹ubahijubhˆX cookie or http. See the rÀ…rÁ}rÂ(hbX cookie or http. See the hcj–ubh­)rÃ}rÄ(hbX:ref:`faqmultiuser`rÅhcj–hdhghih±hk}rÆ(UreftypeXrefh³ˆh´X faqmultiuserU refdomainXstdrÇhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsK×h]]rÈh•)rÉ}rÊ(hbjÅhk}rË(ho]hp]rÌ(h½jÇXstd-refrÍehn]hm]hq]uhcjÃh]]rÎhˆX faqmultiuserrÏ…rÐ}rÑ(hbUhcjÉubahihŸubaubhˆX( for additional information, especially rÒ…rÓ}rÔ(hbX( for additional information, especially hcj–ubh­)rÕ}rÖ(hbX :ref:`faq4_4`r×hcj–hdhghih±hk}rØ(UreftypeXrefh³ˆh´Xfaq4_4U refdomainXstdrÙhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsK×h]]rÚh•)rÛ}rÜ(hbj×hk}rÝ(ho]hp]rÞ(h½jÙXstd-refrßehn]hm]hq]uhcjÕh]]ràhˆXfaq4_4rá…râ}rã(hbUhcjÛubahihŸubaubhˆX.…rä}rå(hbX.hcj–ubeubaubj†)ræ}rç(hbXÌOpen 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.hcjŽhdhghij‰hk}rè(ho]hp]hn]hm]hq]uhsNhthh]]réhŒ)rê}rë(hbXÌOpen 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.hcjæhdhghihhk}rì(ho]hp]hn]hm]hq]uhsKÞh]]rí(hˆX Open the rî…rï}rð(hbX Open the hcjêubjR)rñ}rò(hbX(`main phpMyAdmin directory `_hk}ró(UnameXmain phpMyAdmin directoryjVX index.phprôhm]hn]ho]hp]hq]uhcjêh]]rõhˆXmain phpMyAdmin directoryrö…r÷}rø(hbUhcjñubahij\ubh_)rù}rú(hbX hk}rû(Urefurijôhm]rühYahn]ho]hp]hq]rýh)auhcjêh]]hihjubhˆXp in your browser. phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using rþ…rÿ}r(hbXp in your browser. phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using hcjêubh­)r}r(hbX :term:`HTTP`rhcjêhdhghih±hk}r(UreftypeXtermh³ˆh´XhttpU refdomainXstdrhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsKÞh]]rh•)r}r(hbjhk}r (ho]hp]r (h½jXstd-termr ehn]hm]hq]uhcjh]]r hˆXHTTPr …r}r(hbUhcjubahihŸubaubhˆX or cookie authentication mode.r…r}r(hbX or cookie authentication mode.hcjêubeubaubj†)r}r(hbX|You should deny access to the ``./libraries`` and ``./setup/lib`` subfolders in your webserver configuration. For Apache you can use supplied :term:`.htaccess` 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.hcjŽhdhghij‰hk}r(ho]hp]hn]hm]hq]uhsNhthh]]rhŒ)r}r(hbX|You should deny access to the ``./libraries`` and ``./setup/lib`` subfolders in your webserver configuration. For Apache you can use supplied :term:`.htaccess` 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.hcjhdhghihhk}r(ho]hp]hn]hm]hq]uhsKâh]]r(hˆXYou should deny access to the r…r}r(hbXYou should deny access to the hcjubhü)r}r(hbX``./libraries``hk}r (ho]hp]hn]hm]hq]uhcjh]]r!hˆX ./librariesr"…r#}r$(hbUhcjubahijubhˆX and r%…r&}r'(hbX and hcjubhü)r(}r)(hbX``./setup/lib``hk}r*(ho]hp]hn]hm]hq]uhcjh]]r+hˆX ./setup/libr,…r-}r.(hbUhcj(ubahijubhˆXM subfolders in your webserver configuration. For Apache you can use supplied r/…r0}r1(hbXM subfolders in your webserver configuration. For Apache you can use supplied hcjubh­)r2}r3(hbX:term:`.htaccess`r4hcjhdhghih±hk}r5(UreftypeXtermh³ˆh´X .htaccessU refdomainXstdr6hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsKâh]]r7h•)r8}r9(hbj4hk}r:(ho]hp]r;(h½j6Xstd-termr<ehn]hm]hq]uhcj2h]]r=hˆX .htaccessr>…r?}r@(hbUhcj8ubahihŸubaubhˆXÝ 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.rA…rB}rC(hbXÝ 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.hcjubeubaubj†)rD}rE(hbXIt 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`. hcjŽhdhghij‰hk}rF(ho]hp]hn]hm]hq]uhsNhthh]]rGhŒ)rH}rI(hbXIt 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`.hcjDhdhghihhk}rJ(ho]hp]hn]hm]hq]uhsKèh]]rK(hˆX£It 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 rL…rM}rN(hbX£It 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 hcjHubhü)rO}rP(hbX``robots.txt``hk}rQ(ho]hp]hn]hm]hq]uhcjHh]]rRhˆX robots.txtrS…rT}rU(hbUhcjOubahijubhˆXQ file in root of your webserver or limit access by web server configuration, see rV…rW}rX(hbXQ file in root of your webserver or limit access by web server configuration, see hcjHubh­)rY}rZ(hbX:ref:`faq1_42`r[hcjHhdhghih±hk}r\(UreftypeXrefh³ˆh´Xfaq1_42U refdomainXstdr]hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsKèh]]r^h•)r_}r`(hbj[hk}ra(ho]hp]rb(h½j]Xstd-refrcehn]hm]hq]uhcjYh]]rdhˆXfaq1_42re…rf}rg(hbUhcj_ubahihŸubaubhˆX.…rh}ri(hbX.hcjHubeubaubeubj•)rj}rk(hbUhcj§hdhghij˜hk}rl(hm]hn]ho]hp]hq]jš]rm((jœXConfiguration storageUindex-1rnUtro(jœX phpMyAdmin configuration storagejnUtrp(jœXpmadbjnUtrqejŸ‰uhsKòhthh]]ubh_)rr}rs(hbUhcj§hdhghihjhk}rt(hm]hn]ho]hp]hq]hrjnuhsKòhthh]]ubh_)ru}rv(hbX.. _linked-tables:hcj§hdhghx}hihjhk}rw(hm]hn]ho]hp]hq]hrh?uhsKóhthh~}rxjnjrsh]]ubeubeubhu)ry}rz(hbUhchvhdhghx}r{hjushihzhk}r|(ho]hp]hn]hm]r}(hWh?jnehq]r~(h'heuhsKöhthh~}r(jnjrh?juuh]]r€(h)r}r‚(hbX phpMyAdmin configuration storagerƒhcjyhdhghih…hk}r„(ho]hp]hn]hm]hq]uhsKöhthh]]r…hˆX phpMyAdmin configuration storager†…r‡}rˆ(hbjƒhcjubaubhŒ)r‰}rŠ(hbX˜For 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).hcjyhdhghihhk}r‹(ho]hp]hn]hm]hq]uhsKøhthh]]rŒ(hˆX6For a whole set of new features (bookmarks, comments, r…rŽ}r(hbX6For a whole set of new features (bookmarks, comments, hcj‰ubh­)r}r‘(hbX :term:`SQL`r’hcj‰hdhghih±hk}r“(UreftypeXtermh³ˆh´XsqlU refdomainXstdr”hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsKøh]]r•h•)r–}r—(hbj’hk}r˜(ho]hp]r™(h½j”Xstd-termršehn]hm]hq]uhcjh]]r›hˆXSQLrœ…r}rž(hbUhcj–ubahihŸubaubhˆX-history, tracking mechanism, rŸ…r }r¡(hbX-history, tracking mechanism, hcj‰ubh­)r¢}r£(hbX :term:`PDF`r¤hcj‰hdhghih±hk}r¥(UreftypeXtermh³ˆh´XpdfU refdomainXstdr¦hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsKøh]]r§h•)r¨}r©(hbj¤hk}rª(ho]hp]r«(h½j¦Xstd-termr¬ehn]hm]hq]uhcj¢h]]r­hˆXPDFr®…r¯}r°(hbUhcj¨ubahihŸubaubhˆX.-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).r±…r²}r³(hbX.-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).hcj‰ubeubhŒ)r´}rµ(hbX¶Please 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`).hcjyhdhghihhk}r¶(ho]hp]hn]hm]hq]uhsKÿhthh]]r·(hˆXPlease look at your r¸…r¹}rº(hbXPlease look at your hcj´ubhü)r»}r¼(hbX``./examples/``hk}r½(ho]hp]hn]hm]hq]uhcj´h]]r¾hˆX ./examples/r¿…rÀ}rÁ(hbUhcj»ubahijubhˆX0 directory, where you should find a file called rÂ…rÃ}rÄ(hbX0 directory, where you should find a file called hcj´ubh•)rÅ}rÆ(hbX*create\_tables.sql*hk}rÇ(ho]hp]hn]hm]hq]uhcj´h]]rÈhˆXcreate_tables.sqlrÉ…rÊ}rË(hbUhcjÅubahihŸubhˆX?. (If you are using a Windows server, pay special attention to rÌ…rÍ}rÎ(hbX?. (If you are using a Windows server, pay special attention to hcj´ubh­)rÏ}rÐ(hbX:ref:`faq1_23`rÑhcj´hdhghih±hk}rÒ(UreftypeXrefh³ˆh´Xfaq1_23U refdomainXstdrÓhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsKÿh]]rÔh•)rÕ}rÖ(hbjÑhk}r×(ho]hp]rØ(h½jÓXstd-refrÙehn]hm]hq]uhcjÏh]]rÚhˆXfaq1_23rÛ…rÜ}rÝ(hbUhcjÕubahihŸubaubhˆX).rÞ…rß}rà(hbX).hcj´ubeubhŒ)rá}râ(hbXÔIf 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`.hcjyhdhghihhk}rã(ho]hp]hn]hm]hq]uhsMhthh]]rä(hˆXXIf you already had this infrastructure and upgraded to MySQL 4.1.2 or newer, please use rå…ræ}rç(hbXXIf you already had this infrastructure and upgraded to MySQL 4.1.2 or newer, please use hcjáubhü)rè}ré(hbUhk}rê(hm]hn]ho]hp]rëXfilerìaUrolejìhq]uhcjáh]]ríhˆX(examples/upgrade_tables_mysql_4_1_2+.sqlrî…rï}rð(hbX(examples/upgrade_tables_mysql_4_1_2+.sqlhcjèubahijubhˆX) and then create new tables by importing rñ…rò}ró(hbX) and then create new tables by importing hcjáubhü)rô}rõ(hbUhk}rö(hm]hn]ho]hp]r÷XfilerøaUrolejøhq]uhcjáh]]rùhˆXexamples/create_tables.sqlrú…rû}rü(hbXexamples/create_tables.sqlhcjôubahijubhˆX.…rý}rþ(hbX.hcjáubeubhŒ)rÿ}r(hbXëYou 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.rhcjyhdhghihhk}r(ho]hp]hn]hm]hq]uhsMhthh]]rhˆXëYou 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.r…r}r(hbjhcjÿubaubhŒ)r}r(hbXKAfter 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).hcjyhdhghihhk}r (ho]hp]hn]hm]hq]uhsM hthh]]r (hˆXAfter having imported the r …r }r (hbXAfter having imported the hcjubhü)r}r(hbUhk}r(hm]hn]ho]hp]rXfileraUrolejhq]uhcjh]]rhˆXexamples/create_tables.sqlr…r}r(hbXexamples/create_tables.sqlhcjubahijubhˆX2 file, you should specify the table names in your r…r}r(hbX2 file, you should specify the table names in your hcjubhü)r}r(hbUhk}r(hm]hn]ho]hp]rXfileraUrolejhq]uhcjh]]rhˆXconfig.inc.phpr …r!}r"(hbXconfig.inc.phphcjubahijubhˆX8 file. The directives used for that can be found in the r#…r$}r%(hbX8 file. The directives used for that can be found in the hcjubh­)r&}r'(hbX :ref:`config`r(hcjhdhghih±hk}r)(UreftypeXrefh³ˆh´XconfigU refdomainXstdr*hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM h]]r+h•)r,}r-(hbj(hk}r.(ho]hp]r/(h½j*Xstd-refr0ehn]hm]hq]uhcj&h]]r1hˆXconfigr2…r3}r4(hbUhcj,ubahihŸubaubhˆX_. You will also need to have a controluser with the proper rights to those tables (see section r5…r6}r7(hbX_. You will also need to have a controluser with the proper rights to those tables (see section hcjubh­)r8}r9(hbX:ref:`authentication_modes`r:hcjhdhghih±hk}r;(UreftypeXrefh³ˆh´Xauthentication_modesU refdomainXstdr<hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM h]]r=h•)r>}r?(hbj:hk}r@(ho]hp]rA(h½j<Xstd-refrBehn]hm]hq]uhcj8h]]rChˆXauthentication_modesrD…rE}rF(hbUhcj>ubahihŸubaubhˆX below).rG…rH}rI(hbX below).hcjubeubh_)rJ}rK(hbX.. _upgrading:hcjyhdhghihjhk}rL(hm]hn]ho]hp]hq]hrh8uhsMhthh]]ubeubhu)rM}rN(hbUhchvhdhghx}rOhjJshihzhk}rP(ho]hp]hn]hm]rQ(h[h8ehq]rR(h+heuhsMhthh~}rSh8jJsh]]rT(h)rU}rV(hbXUpgrading from an older versionrWhcjMhdhghih…hk}rX(ho]hp]hn]hm]hq]uhsMhthh]]rYhˆXUpgrading from an older versionrZ…r[}r\(hbjWhcjUubaubhŒ)r]}r^(hbX\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.hcjMhdhghihhk}r_(ho]hp]hn]hm]hq]uhsMhthh]]r`(hˆX Simply copy ra…rb}rc(hbX Simply copy hcj]ubhü)rd}re(hbUhk}rf(hm]hn]ho]hp]rgXfilerhaUrolejhhq]uhcj]h]]rihˆXconfig.inc.phprj…rk}rl(hbXconfig.inc.phphcjdubahijubhˆXÓ 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 rm…rn}ro(hbXÓ 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 hcj]ubhü)rp}rq(hbX ``set_magic_quotes_runtime(0);``hk}rr(ho]hp]hn]hm]hq]uhcj]h]]rshˆXset_magic_quotes_runtime(0);rt…ru}rv(hbUhcjpubahijubhˆXG statement that you might find near the end of your configuration file.rw…rx}ry(hbXG statement that you might find near the end of your configuration file.hcj]ubeubhŒ)rz}r{(hbX•You should **not** copy :file:`libraries/config.default.php` over :file:`config.inc.php` because the default configuration file is version- specific.hcjMhdhghihhk}r|(ho]hp]hn]hm]hq]uhsMhthh]]r}(hˆX You should r~…r}r€(hbX You should hcjzubj.)r}r‚(hbX**not**hk}rƒ(ho]hp]hn]hm]hq]uhcjzh]]r„hˆXnotr……r†}r‡(hbUhcjubahij6ubhˆX copy rˆ…r‰}rŠ(hbX copy hcjzubhü)r‹}rŒ(hbUhk}r(hm]hn]ho]hp]rŽXfileraUrolejhq]uhcjzh]]rhˆXlibraries/config.default.phpr‘…r’}r“(hbXlibraries/config.default.phphcj‹ubahijubhˆX over r”…r•}r–(hbX over hcjzubhü)r—}r˜(hbUhk}r™(hm]hn]ho]hp]ršXfiler›aUrolej›hq]uhcjzh]]rœhˆXconfig.inc.phpr…rž}rŸ(hbXconfig.inc.phphcj—ubahijubhˆX= because the default configuration file is version- specific.r …r¡}r¢(hbX= because the default configuration file is version- specific.hcjzubeubhŒ)r£}r¤(hbXõIf 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`.hcjMhdhghihhk}r¥(ho]hp]hn]hm]hq]uhsM#hthh]]r¦(hˆX¨If 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 r§…r¨}r©(hbX¨If 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 hcj£ubh­)rª}r«(hbX :term:`SQL`r¬hcj£hdhghih±hk}r­(UreftypeXtermh³ˆh´XsqlU refdomainXstdr®hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM#h]]r¯h•)r°}r±(hbj¬hk}r²(ho]hp]r³(h½j®Xstd-termr´ehn]hm]hq]uhcjªh]]rµhˆXSQLr¶…r·}r¸(hbUhcj°ubahihŸubaubhˆX script found in r¹…rº}r»(hbX script found in hcj£ubhü)r¼}r½(hbUhk}r¾(hm]hn]ho]hp]r¿XfilerÀaUrolejÀhq]uhcj£h]]rÁhˆX(examples/upgrade_tables_mysql_4_1_2+.sqlrÂ…rÃ}rÄ(hbX(examples/upgrade_tables_mysql_4_1_2+.sqlhcj¼ubahijubhˆX.…rÅ}rÆ(hbX.hcj£ubeubj•)rÇ}rÈ(hbUhcjMhdhghij˜hk}rÉ(hm]hn]ho]hp]hq]jš]rÊ(jœXAuthentication modeUindex-2rËUtrÌajŸ‰uhsM)hthh]]ubh_)rÍ}rÎ(hbUhcjMhdhghihjhk}rÏ(hm]hn]ho]hp]hq]hrjËuhsM)hthh]]ubh_)rÐ}rÑ(hbX.. _authentication_modes:hcjMhdhghx}hihjhk}rÒ(hm]hn]ho]hp]hq]hrhDuhsM*hthh~}rÓjËjÍsh]]ubeubhu)rÔ}rÕ(hbUhchvhdhghx}rÖhjÐshihzhk}r×(ho]hp]hn]hm]rØ(hNhDjËehq]rÙ(hheuhsM-hthh~}rÚ(hDjÐjËjÍuh]]rÛ(h)rÜ}rÝ(hbXUsing authentication modesrÞhcjÔhdhghih…hk}rß(ho]hp]hn]hm]hq]uhsM-hthh]]ràhˆXUsing authentication modesrá…râ}rã(hbjÞhcjÜubaubhŒ)rä}rå(hbXÞ: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.hcjÔhdhghihhk}ræ(ho]hp]hn]hm]hq]uhsM/hthh]]rç(h­)rè}ré(hbX :term:`HTTP`rêhcjähdhghih±hk}rë(UreftypeXtermh³ˆh´XhttpU refdomainXstdrìhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM/h]]ríh•)rî}rï(hbjêhk}rð(ho]hp]rñ(h½jìXstd-termròehn]hm]hq]uhcjèh]]róhˆXHTTPrô…rõ}rö(hbUhcjîubahihŸubaubhˆX6 and cookie authentication modes are recommended in a r÷…rø}rù(hbX6 and cookie authentication modes are recommended in a hcjäubj.)rú}rû(hbX**multi-user environment**hk}rü(ho]hp]hn]hm]hq]uhcjäh]]rýhˆXmulti-user environmentrþ…rÿ}r(hbUhcjúubahij6ubhˆXæ 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(hbXæ 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 hcjäubj.)r}r(hbX**single-user environment**hk}r(ho]hp]hn]hm]hq]uhcjäh]]rhˆXsingle-user environmentr…r }r (hbUhcjubahij6ubhˆX, you might prefer to use r …r }r (hbX, you might prefer to use hcjäubh­)r}r(hbX :term:`HTTP`rhcjähdhghih±hk}r(UreftypeXtermh³ˆh´XhttpU refdomainXstdrhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM/h]]rh•)r}r(hbjhk}r(ho]hp]r(h½jXstd-termrehn]hm]hq]uhcjh]]rhˆXHTTPr…r}r(hbUhcjubahihŸubaubhˆX[ or cookie mode so that your user/password pair are not in clear in the configuration file.r…r}r(hbX[ or cookie mode so that your user/password pair are not in clear in the configuration file.hcjäubeubhŒ)r }r!(hbX³: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.hcjÔhdhghihhk}r"(ho]hp]hn]hm]hq]uhsM7hthh]]r#(h­)r$}r%(hbX :term:`HTTP`r&hcj hdhghih±hk}r'(UreftypeXtermh³ˆh´XhttpU refdomainXstdr(hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM7h]]r)h•)r*}r+(hbj&hk}r,(ho]hp]r-(h½j(Xstd-termr.ehn]hm]hq]uhcj$h]]r/hˆXHTTPr0…r1}r2(hbUhcj*ubahihŸubaubhˆX¤ 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 r3…r4}r5(hbX¤ 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 hcj ubj•)r6}r7(hbUhk}r8(hm]hn]ho]hp]hq]jš]r9((jœX"$cfg['Servers'][$i]['controluser']r:Uindex-3r;j:tr<(jœX8configuration option; $cfg['Servers'][$i]['controluser']j;j:tr=euhcj h]]hij˜ubh_)r>}r?(hbUhk}r@(ho]hp]hn]hm]rAj;ahq]uhcj h]]hihjubh­)rB}rC(hbX3:config:option:`$cfg['Servers'][$i]['controluser']`rDhcj hdhghih±hk}rE(UreftypeXoptionh³‰h´j:U refdomainXconfigrFhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM7h]]rGhü)rH}rI(hbjDhk}rJ(ho]hp]rK(h½jFX config-optionrLehn]hm]hq]uhcjBh]]rMhˆX"$cfg['Servers'][$i]['controluser']rN…rO}rP(hbUhcjHubahijubaubhˆXÐ). 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.rQ…rR}rS(hbXÐ). 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.hcj ubeubcdocutils.nodes comment rT)rU}rV(hbXenote: This section is only applicable if your MySQL server is running with ``--skip-show-database``.hcjÔhdhghiUcommentrWhk}rX(jgjhhm]hn]ho]hp]hq]uhsMChthh]]rYhˆXenote: This section is only applicable if your MySQL server is running with ``--skip-show-database``.rZ…r[}r\(hbUhcjUubaubhŒ)r]}r^(hbX—For ':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.hcjÔhdhghihhk}r_(ho]hp]hn]hm]hq]uhsMDhthh]]r`(hˆXFor 'ra…rb}rc(hbXFor 'hcj]ubh­)rd}re(hbX :term:`HTTP`rfhcj]hdhghih±hk}rg(UreftypeXtermh³ˆh´XhttpU refdomainXstdrhhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMDh]]rih•)rj}rk(hbjfhk}rl(ho]hp]rm(h½jhXstd-termrnehn]hm]hq]uhcjdh]]rohˆXHTTPrp…rq}rr(hbUhcjjubahihŸubaubhˆX>' and 'cookie' modes, phpMyAdmin needs a controluser that has rs…rt}ru(hbX>' and 'cookie' modes, phpMyAdmin needs a controluser that has hcj]ubj.)rv}rw(hbX**only**hk}rx(ho]hp]hn]hm]hq]uhcj]h]]ryhˆXonlyrz…r{}r|(hbUhcjvubahij6ubhˆX the r}…r~}r(hbX the hcj]ubhü)r€}r(hbX ``SELECT``hk}r‚(ho]hp]hn]hm]hq]uhcj]h]]rƒhˆXSELECTr„…r…}r†(hbUhcj€ubahijubhˆX privilege on the r‡…rˆ}r‰(hbX privilege on the hcj]ubh•)rŠ}r‹(hbX0*`mysql`.`user` (all columns except `Password`)*hk}rŒ(ho]hp]hn]hm]hq]uhcj]h]]rhˆX.`mysql`.`user` (all columns except `Password`)rŽ…r}r(hbUhcjŠubahihŸubhˆX, r‘…r’}r“(hbX, hcj]ubh•)r”}r•(hbX*`mysql`.`db` (all columns)*hk}r–(ho]hp]hn]hm]hq]uhcj]h]]r—hˆX`mysql`.`db` (all columns)r˜…r™}rš(hbUhcj”ubahihŸubhˆX, r›…rœ}r(hbX, hcj]ubh•)rž}rŸ(hbX*`mysql`.`host` (all columns)*hk}r (ho]hp]hn]hm]hq]uhcj]h]]r¡hˆX`mysql`.`host` (all columns)r¢…r£}r¤(hbUhcjžubahihŸubhˆX and r¥…r¦}r§(hbX and hcj]ubh•)r¨}r©(hbXG*`mysql`.`tables\_priv` (all columns except `Grantor` and `Timestamp`)*hk}rª(ho]hp]hn]hm]hq]uhcj]h]]r«hˆXD`mysql`.`tables_priv` (all columns except `Grantor` and `Timestamp`)r¬…r­}r®(hbUhcj¨ubahihŸubhˆXA tables. You must specify the details for the controluser in the r¯…r°}r±(hbXA tables. You must specify the details for the controluser in the hcj]ubhü)r²}r³(hbUhk}r´(hm]hn]ho]hp]rµXfiler¶aUrolej¶hq]uhcj]h]]r·hˆXconfig.inc.phpr¸…r¹}rº(hbXconfig.inc.phphcj²ubahijubhˆX file under the r»…r¼}r½(hbX file under the hcj]ubj•)r¾}r¿(hbUhk}rÀ(hm]hn]ho]hp]hq]jš]rÁ((jœX"$cfg['Servers'][$i]['controluser']rÂUindex-4rÃjÂtrÄ(jœX8configuration option; $cfg['Servers'][$i]['controluser']jÃjÂtrÅeuhcj]h]]hij˜ubh_)rÆ}rÇ(hbUhk}rÈ(ho]hp]hn]hm]rÉjÃahq]uhcj]h]]hihjubh­)rÊ}rË(hbX3:config:option:`$cfg['Servers'][$i]['controluser']`rÌhcj]hdhghih±hk}rÍ(UreftypeXoptionh³‰h´jÂU refdomainXconfigrÎhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMDh]]rÏhü)rÐ}rÑ(hbjÌhk}rÒ(ho]hp]rÓ(h½jÎX config-optionrÔehn]hm]hq]uhcjÊh]]rÕhˆX"$cfg['Servers'][$i]['controluser']rÖ…r×}rØ(hbUhcjÐubahijubaubhˆX and rÙ…rÚ}rÛ(hbX and hcj]ubj•)rÜ}rÝ(hbUhk}rÞ(hm]hn]ho]hp]hq]jš]rß((jœX"$cfg['Servers'][$i]['controlpass']ràUindex-5rájàtrâ(jœX8configuration option; $cfg['Servers'][$i]['controlpass']jájàtrãeuhcj]h]]hij˜ubh_)rä}rå(hbUhk}ræ(ho]hp]hn]hm]rçjáahq]uhcj]h]]hihjubh­)rè}ré(hbX3:config:option:`$cfg['Servers'][$i]['controlpass']`rêhcj]hdhghih±hk}rë(UreftypeXoptionh³‰h´jàU refdomainXconfigrìhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMDh]]ríhü)rî}rï(hbjêhk}rð(ho]hp]rñ(h½jìX config-optionròehn]hm]hq]uhcjèh]]róhˆX"$cfg['Servers'][$i]['controlpass']rô…rõ}rö(hbUhcjîubahijubaubhˆX9 settings. The following example assumes you want to use r÷…rø}rù(hbX9 settings. The following example assumes you want to use hcj]ubhü)rú}rû(hbX``pma``hk}rü(ho]hp]hn]hm]hq]uhcj]h]]rýhˆXpmarþ…rÿ}r(hbUhcjúubahijubhˆX as the controluser and r…r}r(hbX as the controluser and hcj]ubhü)r}r(hbX ``pmapass``hk}r(ho]hp]hn]hm]hq]uhcj]h]]rhˆXpmapassr…r }r (hbUhcjubahijubhˆX as the controlpass, but r …r }r (hbX as the controlpass, but hcj]ubj.)r}r(hbX=**this is only an example: use something else in your file!**hk}r(ho]hp]hn]hm]hq]uhcj]h]]rhˆX9this is only an example: use something else in your file!r…r}r(hbUhcjubahij6ubhˆX, Input these statements from the phpMyAdmin r…r}r(hbX, Input these statements from the phpMyAdmin hcj]ubh­)r}r(hbX :term:`SQL`rhcj]hdhghih±hk}r(UreftypeXtermh³ˆh´XsqlU refdomainXstdrhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMDh]]rh•)r}r(hbjhk}r (ho]hp]r!(h½jXstd-termr"ehn]hm]hq]uhcjh]]r#hˆXSQLr$…r%}r&(hbUhcjubahihŸubaubhˆXL Query window or mysql command–line client. Of course you have to replace r'…r(}r)(hbXL Query window or mysql command–line client. Of course you have to replace hcj]ubhü)r*}r+(hbX ``localhost``hk}r,(ho]hp]hn]hm]hq]uhcj]h]]r-hˆX localhostr.…r/}r0(hbUhcj*ubahijubhˆXJ with the webserver's host if it's not the same as the MySQL server's one.r1…r2}r3(hbXJ with the webserver's host if it's not the same as the MySQL server's one.hcj]ubeubj`)r4}r5(hbX|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';hcjÔhdhghijchk}r6(je‰jfXmysqljgjhhm]hn]ho]hp]hq]uhsMQhthh]]r7hˆX|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';r8…r9}r:(hbUhcj4ubaubhŒ)r;}r<(hbX?If you want to use the many new relation and bookmark features:r=hcjÔhdhghihhk}r>(ho]hp]hn]hm]hq]uhsM`hthh]]r?hˆX?If you want to use the many new relation and bookmark features:r@…rA}rB(hbj=hcj;ubaubj`)rC}rD(hbXHGRANT SELECT, INSERT, UPDATE, DELETE ON .* TO 'pma'@'localhost';hcjÔhdhghijchk}rE(je‰jfXmysqljgjhhm]hn]ho]hp]hq]uhsMbhthh]]rFhˆXHGRANT SELECT, INSERT, UPDATE, DELETE ON .* TO 'pma'@'localhost';rG…rH}rI(hbUhcjCubaubhŒ)rJ}rK(hbXC(this of course requires that your :ref:`linked-tables` be set up).rLhcjÔhdhghihhk}rM(ho]hp]hn]hm]hq]uhsMfhthh]]rN(hˆX#(this of course requires that your rO…rP}rQ(hbX#(this of course requires that your hcjJubh­)rR}rS(hbX:ref:`linked-tables`rThcjJhdhghih±hk}rU(UreftypeXrefh³ˆh´X linked-tablesU refdomainXstdrVhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMfh]]rWh•)rX}rY(hbjThk}rZ(ho]hp]r[(h½jVXstd-refr\ehn]hm]hq]uhcjRh]]r]hˆX linked-tablesr^…r_}r`(hbUhcjXubahihŸubaubhˆX be set up).ra…rb}rc(hbX be set up).hcjJubeubhŒ)rd}re(hbXfThen 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*:hcjÔhdhghihhk}rf(ho]hp]hn]hm]hq]uhsMhhthh]]rg(hˆXThen each of the rh…ri}rj(hbXThen each of the hcjdubh•)rk}rl(hbX*true*hk}rm(ho]hp]hn]hm]hq]uhcjdh]]rnhˆXtruero…rp}rq(hbUhcjkubahihŸubhˆX 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 rr…rs}rt(hbX 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 hcjdubh•)ru}rv(hbX *real_user*hk}rw(ho]hp]hn]hm]hq]uhcjdh]]rxhˆX real_userry…rz}r{(hbUhcjuubahihŸubhˆX% with all privileges on the database r|…r}}r~(hbX% with all privileges on the database hcjdubh•)r}r€(hbX *user_base*hk}r(ho]hp]hn]hm]hq]uhcjdh]]r‚hˆX user_baserƒ…r„}r…(hbUhcjubahihŸubhˆX:…r†}r‡(hbX:hcjdubeubj`)rˆ}r‰(hbX[GRANT ALL PRIVILEGES ON user_base.* TO 'real_user'@localhost IDENTIFIED BY 'real_password';hcjÔhdhghijchk}rŠ(je‰jfXmysqljgjhhm]hn]ho]hp]hq]uhsMohthh]]r‹hˆX[GRANT ALL PRIVILEGES ON user_base.* TO 'real_user'@localhost IDENTIFIED BY 'real_password';rŒ…r}rŽ(hbUhcjˆubaubhŒ)r}r(hbXÚWhat 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']`.hcjÔhdhghihhk}r‘(ho]hp]hn]hm]hq]uhsMththh]]r’(hˆX¹What 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•(hbX¹What 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 hcjubj•)r–}r—(hbUhk}r˜(hm]hn]ho]hp]hq]jš]r™((jœX$cfg['Servers']ršUindex-6r›jštrœ(jœX%configuration option; $cfg['Servers']j›jštreuhcjh]]hij˜ubh_)rž}rŸ(hbUhk}r (ho]hp]hn]hm]r¡j›ahq]uhcjh]]hihjubh­)r¢}r£(hbX :config:option:`$cfg['Servers']`r¤hcjhdhghih±hk}r¥(UreftypeXoptionh³‰h´jšU refdomainXconfigr¦hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMth]]r§hü)r¨}r©(hbj¤hk}rª(ho]hp]r«(h½j¦X config-optionr¬ehn]hm]hq]uhcj¢h]]r­hˆX$cfg['Servers']r®…r¯}r°(hbUhcj¨ubahijubaubhˆX.…r±}r²(hbX.hcjubeubj•)r³}r´(hbUhcjÔhdhghij˜hk}rµ(hm]hn]ho]hp]hq]jš]r¶(Upairr·XHTTP; Authentication modeUindex-7r¸Utr¹ajŸ‰uhsMyhthh]]ubh_)rº}r»(hbUhcjÔhdhghihjhk}r¼(hm]hn]ho]hp]hq]hrj¸uhsMyhthh]]ubhu)r½}r¾(hbUhcjÔhdhghx}hihzhk}r¿(ho]hp]hn]hm]rÀ(hHj¸ehq]rÁhauhsM{hthh~}rÂj¸jºsh]]rÃ(h)rÄ}rÅ(hbXHTTP authentication moderÆhcj½hdhghih…hk}rÇ(ho]hp]hn]hm]hq]uhsM{hthh]]rÈhˆXHTTP authentication moderÉ…rÊ}rË(hbjÆhcjÄubaubcdocutils.nodes bullet_list rÌ)rÍ}rÎ(hbUhcj½hdhghiU bullet_listrÏhk}rÐ(UbulletrÑX*hm]hn]ho]hp]hq]uhsM}hthh]]rÒ(j†)rÓ}rÔ(hbX_Uses :term:`HTTP` Basic authentication method and allows you to log in as any valid MySQL user.hcjÍhdhghij‰hk}rÕ(ho]hp]hn]hm]hq]uhsNhthh]]rÖhŒ)r×}rØ(hbX_Uses :term:`HTTP` Basic authentication method and allows you to log in as any valid MySQL user.hcjÓhdhghihhk}rÙ(ho]hp]hn]hm]hq]uhsM}h]]rÚ(hˆXUses rÛ…rÜ}rÝ(hbXUses hcj×ubh­)rÞ}rß(hbX :term:`HTTP`ràhcj×hdhghih±hk}rá(UreftypeXtermh³ˆh´XhttpU refdomainXstdrâhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM}h]]rãh•)rä}rå(hbjàhk}ræ(ho]hp]rç(h½jâXstd-termrèehn]hm]hq]uhcjÞh]]réhˆXHTTPrê…rë}rì(hbUhcjäubahihŸubaubhˆXN Basic authentication method and allows you to log in as any valid MySQL user.rí…rî}rï(hbXN Basic authentication method and allows you to log in as any valid MySQL user.hcj×ubeubaubj†)rð}rñ(hbX²Is 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`.hcjÍhdhghij‰hk}rò(ho]hp]hn]hm]hq]uhsNhthh]]róhŒ)rô}rõ(hbX²Is 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`.hcjðhdhghihhk}rö(ho]hp]hn]hm]hq]uhsMh]]r÷(hˆX/Is supported with most PHP configurations. For rø…rù}rú(hbX/Is supported with most PHP configurations. For hcjôubh­)rû}rü(hbX :term:`IIS`rýhcjôhdhghih±hk}rþ(UreftypeXtermh³ˆh´XiisU refdomainXstdrÿhm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMh]]r h•)r }r (hbjýhk}r (ho]hp]r (h½jÿXstd-termr ehn]hm]hq]uhcjûh]]r hˆXIISr …r }r (hbUhcj ubahihŸubaubhˆX (r …r }r (hbX (hcjôubh­)r }r (hbX :term:`ISAPI`r hcjôhdhghih±hk}r (UreftypeXtermh³ˆh´XisapiU refdomainXstdr hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMh]]r h•)r }r (hbj hk}r (ho]hp]r (h½j Xstd-termr ehn]hm]hq]uhcj h]]r hˆXISAPIr …r }r (hbUhcj ubahihŸubaubhˆX) support using r …r }r (hbX) support using hcjôubh­)r }r (hbX :term:`CGI`r! hcjôhdhghih±hk}r" (UreftypeXtermh³ˆh´XcgiU refdomainXstdr# hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMh]]r$ h•)r% }r& (hbj! hk}r' (ho]hp]r( (h½j# Xstd-termr) ehn]hm]hq]uhcj h]]r* hˆXCGIr+ …r, }r- (hbUhcj% ubahihŸubaubhˆX PHP see r. …r/ }r0 (hbX PHP see hcjôubh­)r1 }r2 (hbX:ref:`faq1_32`r3 hcjôhdhghih±hk}r4 (UreftypeXrefh³ˆh´Xfaq1_32U refdomainXstdr5 hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMh]]r6 h•)r7 }r8 (hbj3 hk}r9 (ho]hp]r: (h½j5 Xstd-refr; ehn]hm]hq]uhcj1 h]]r< hˆXfaq1_32r= …r> }r? (hbUhcj7 ubahihŸubaubhˆX, for using with Apache r@ …rA }rB (hbX, for using with Apache hcjôubh­)rC }rD (hbX :term:`CGI`rE hcjôhdhghih±hk}rF (UreftypeXtermh³ˆh´XcgiU refdomainXstdrG hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMh]]rH h•)rI }rJ (hbjE hk}rK (ho]hp]rL (h½jG Xstd-termrM ehn]hm]hq]uhcjC h]]rN hˆXCGIrO …rP }rQ (hbUhcjI ubahihŸubaubhˆX see rR …rS }rT (hbX see hcjôubh­)rU }rV (hbX:ref:`faq1_35`rW hcjôhdhghih±hk}rX (UreftypeXrefh³ˆh´Xfaq1_35U refdomainXstdrY hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMh]]rZ h•)r[ }r\ (hbjW hk}r] (ho]hp]r^ (h½jY Xstd-refr_ ehn]hm]hq]uhcjU h]]r` hˆXfaq1_35ra …rb }rc (hbUhcj[ ubahihŸubaubhˆX.…rd }re (hbX.hcjôubeubaubj†)rf }rg (hbXvSee also :ref:`faq4_4` about not using the :term:`.htaccess` mechanism along with ':term:`HTTP`' authentication mode. hcjÍhdhghij‰hk}rh (ho]hp]hn]hm]hq]uhsNhthh]]ri hŒ)rj }rk (hbXuSee also :ref:`faq4_4` about not using the :term:`.htaccess` mechanism along with ':term:`HTTP`' authentication mode.hcjf hdhghihhk}rl (ho]hp]hn]hm]hq]uhsM‚h]]rm (hˆX See also rn …ro }rp (hbX See also hcjj ubh­)rq }rr (hbX :ref:`faq4_4`rs hcjj hdhghih±hk}rt (UreftypeXrefh³ˆh´Xfaq4_4U refdomainXstdru hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM‚h]]rv h•)rw }rx (hbjs hk}ry (ho]hp]rz (h½ju Xstd-refr{ ehn]hm]hq]uhcjq h]]r| hˆXfaq4_4r} …r~ }r (hbUhcjw ubahihŸubaubhˆX about not using the r€ …r }r‚ (hbX about not using the hcjj ubh­)rƒ }r„ (hbX:term:`.htaccess`r… hcjj hdhghih±hk}r† (UreftypeXtermh³ˆh´X .htaccessU refdomainXstdr‡ hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM‚h]]rˆ h•)r‰ }rŠ (hbj… hk}r‹ (ho]hp]rŒ (h½j‡ Xstd-termr ehn]hm]hq]uhcjƒ h]]rŽ hˆX .htaccessr …r }r‘ (hbUhcj‰ ubahihŸubaubhˆX mechanism along with 'r’ …r“ }r” (hbX mechanism along with 'hcjj ubh­)r• }r– (hbX :term:`HTTP`r— hcjj hdhghih±hk}r˜ (UreftypeXtermh³ˆh´XhttpU refdomainXstdr™ hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM‚h]]rš h•)r› }rœ (hbj— hk}r (ho]hp]rž (h½j™ Xstd-termrŸ ehn]hm]hq]uhcj• h]]r  hˆXHTTPr¡ …r¢ }r£ (hbUhcj› ubahihŸubaubhˆX' authentication mode.r¤ …r¥ }r¦ (hbX' authentication mode.hcjj ubeubaubeubj•)r§ }r¨ (hbUhcj½hdhghij˜hk}r© (hm]hn]ho]hp]hq]jš]rª (j·XCookie; Authentication modeUindex-8r« Utr¬ ajŸ‰uhsM†hthh]]ubh_)r­ }r® (hbUhcj½hdhghihjhk}r¯ (hm]hn]ho]hp]hq]hrj« uhsM†hthh]]ubh_)r° }r± (hbX .. _cookie:hcj½hdhghx}hihjhk}r² (hm]hn]ho]hp]hq]hrhKuhsM‡hthh~}r³ j« j­ sh]]ubeubhu)r´ }rµ (hbUhcjÔhdhghx}r¶ hj° shihzhk}r· (ho]hp]hn]hm]r¸ (hEhKj« ehq]r¹ (hheuhsMŠhthh~}rº (j« j­ hKj° uh]]r» (h)r¼ }r½ (hbXCookie authentication moder¾ hcj´ hdhghih…hk}r¿ (ho]hp]hn]hm]hq]uhsMŠhthh]]rÀ hˆXCookie authentication moderÁ …r }rà (hbj¾ hcj¼ ubaubjÌ)rÄ }rÅ (hbUhcj´ hdhghijÏhk}rÆ (jÑX*hm]hn]ho]hp]hq]uhsMŒhthh]]rÇ (j†)rÈ }rÉ (hbXzYou can use this method as a replacement for the :term:`HTTP` authentication (for example, if you're running :term:`IIS`).hcjÄ hdhghij‰hk}rÊ (ho]hp]hn]hm]hq]uhsNhthh]]rË hŒ)rÌ }rÍ (hbXzYou can use this method as a replacement for the :term:`HTTP` authentication (for example, if you're running :term:`IIS`).hcjÈ hdhghihhk}rÎ (ho]hp]hn]hm]hq]uhsMŒh]]rÏ (hˆX1You can use this method as a replacement for the rÐ …rÑ }rÒ (hbX1You can use this method as a replacement for the hcjÌ ubh­)rÓ }rÔ (hbX :term:`HTTP`rÕ hcjÌ hdhghih±hk}rÖ (UreftypeXtermh³ˆh´XhttpU refdomainXstdr× hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMŒh]]rØ h•)rÙ }rÚ (hbjÕ hk}rÛ (ho]hp]rÜ (h½j× Xstd-termrÝ ehn]hm]hq]uhcjÓ h]]rÞ hˆXHTTPrß …rà }rá (hbUhcjÙ ubahihŸubaubhˆX0 authentication (for example, if you're running râ …rã }rä (hbX0 authentication (for example, if you're running hcjÌ ubh­)rå }ræ (hbX :term:`IIS`rç hcjÌ hdhghih±hk}rè (UreftypeXtermh³ˆh´XiisU refdomainXstdré hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMŒh]]rê h•)rë }rì (hbjç hk}rí (ho]hp]rî (h½jé Xstd-termrï ehn]hm]hq]uhcjå h]]rð hˆXIISrñ …rò }ró (hbUhcjë ubahihŸubaubhˆX).rô …rõ }rö (hbX).hcjÌ ubeubaubj†)r÷ }rø (hbXsObviously, the user must enable cookies in the browser, but this is now a requirement for all authentication modes.hcjÄ hdhghij‰hk}rù (ho]hp]hn]hm]hq]uhsNhthh]]rú hŒ)rû }rü (hbXsObviously, the user must enable cookies in the browser, but this is now a requirement for all authentication modes.rý hcj÷ hdhghihhk}rþ (ho]hp]hn]hm]hq]uhsMŽh]]rÿ hˆXsObviously, the user must enable cookies in the browser, but this is now a requirement for all authentication modes.r …r }r (hbjý hcjû ubaubaubj†)r }r (hbX`With this mode, the user can truly log out of phpMyAdmin and log in back with the same username.hcjÄ hdhghij‰hk}r (ho]hp]hn]hm]hq]uhsNhthh]]r hŒ)r }r (hbX`With this mode, the user can truly log out of phpMyAdmin and log in back with the same username.r hcj hdhghihhk}r (ho]hp]hn]hm]hq]uhsMh]]r hˆX`With this mode, the user can truly log out of phpMyAdmin and log in back with the same username.r …r }r (hbj hcj ubaubaubj†)r }r (hbXfIf you want to log in to arbitrary server see :config:option:`$cfg['AllowArbitraryServer']` directive.r hcjÄ hdhghij‰hk}r (ho]hp]hn]hm]hq]uhsNhthh]]r hŒ)r }r (hbj hcj hdhghihhk}r (ho]hp]hn]hm]hq]uhsM’h]]r (hˆX.If you want to log in to arbitrary server see r …r }r (hbX.If you want to log in to arbitrary server see hcj ubj•)r }r (hbUhk}r (hm]hn]ho]hp]hq]jš]r ((jœX$cfg['AllowArbitraryServer']r Uindex-9r j tr! (jœX2configuration option; $cfg['AllowArbitraryServer']j j tr" euhcj h]]hij˜ubh_)r# }r$ (hbUhk}r% (ho]hp]hn]hm]r& j ahq]uhcj h]]hihjubh­)r' }r( (hbX-:config:option:`$cfg['AllowArbitraryServer']`r) hcj hdhghih±hk}r* (UreftypeXoptionh³‰h´j U refdomainXconfigr+ hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM’h]]r, hü)r- }r. (hbj) hk}r/ (ho]hp]r0 (h½j+ X config-optionr1 ehn]hm]hq]uhcj' h]]r2 hˆX$cfg['AllowArbitraryServer']r3 …r4 }r5 (hbUhcj- ubahijubaubhˆX directive.r6 …r7 }r8 (hbX directive.hcj ubeubaubj†)r9 }r: (hbX„As mentioned in the :ref:`require` section, having the ``mcrypt`` extension will speed up access considerably, but is not required. hcjÄ hdhghij‰hk}r; (ho]hp]hn]hm]hq]uhsNhthh]]r< hŒ)r= }r> (hbXƒAs mentioned in the :ref:`require` section, having the ``mcrypt`` extension will speed up access considerably, but is not required.hcj9 hdhghihhk}r? (ho]hp]hn]hm]hq]uhsM“h]]r@ (hˆXAs mentioned in the rA …rB }rC (hbXAs mentioned in the hcj= ubh­)rD }rE (hbX:ref:`require`rF hcj= hdhghih±hk}rG (UreftypeXrefh³ˆh´XrequireU refdomainXstdrH hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM“h]]rI h•)rJ }rK (hbjF hk}rL (ho]hp]rM (h½jH Xstd-refrN ehn]hm]hq]uhcjD h]]rO hˆXrequirerP …rQ }rR (hbUhcjJ ubahihŸubaubhˆX section, having the rS …rT }rU (hbX section, having the hcj= ubhü)rV }rW (hbX ``mcrypt``hk}rX (ho]hp]hn]hm]hq]uhcj= h]]rY hˆXmcryptrZ …r[ }r\ (hbUhcjV ubahijubhˆXB extension will speed up access considerably, but is not required.r] …r^ }r_ (hbXB extension will speed up access considerably, but is not required.hcj= ubeubaubeubj•)r` }ra (hbUhcj´ hdhghij˜hk}rb (hm]hn]ho]hp]hq]jš]rc (j·XSignon; Authentication modeUindex-10rd Utre ajŸ‰uhsM—hthh]]ubh_)rf }rg (hbUhcj´ hdhghihjhk}rh (hm]hn]ho]hp]hq]hrjd uhsM—hthh]]ubeubhu)ri }rj (hbUhcjÔhdhghx}hihzhk}rk (ho]hp]hn]hm]rl (h;jd ehq]rm h auhsM™hthh~}rn jd jf sh]]ro (h)rp }rq (hbXSignon authentication moderr hcji hdhghih…hk}rs (ho]hp]hn]hm]hq]uhsM™hthh]]rt hˆXSignon authentication moderu …rv }rw (hbjr hcjp ubaubjÌ)rx }ry (hbUhcji hdhghijÏhk}rz (jÑX*hm]hn]ho]hp]hq]uhsM›hthh]]r{ (j†)r| }r} (hbXjThis mode is a convenient way of using credentials from another application to authenticate to phpMyAdmin.hcjx hdhghij‰hk}r~ (ho]hp]hn]hm]hq]uhsNhthh]]r hŒ)r€ }r (hbXjThis mode is a convenient way of using credentials from another application to authenticate to phpMyAdmin.r‚ hcj| hdhghihhk}rƒ (ho]hp]hn]hm]hq]uhsM›h]]r„ hˆXjThis mode is a convenient way of using credentials from another application to authenticate to phpMyAdmin.r… …r† }r‡ (hbj‚ hcj€ ubaubaubj†)rˆ }r‰ (hbXHThe other application has to store login information into session data. hcjx hdhghij‰hk}rŠ (ho]hp]hn]hm]hq]uhsNhthh]]r‹ hŒ)rŒ }r (hbXGThe other application has to store login information into session data.rŽ hcjˆ hdhghihhk}r (ho]hp]hn]hm]hq]uhsMh]]r hˆXGThe other application has to store login information into session data.r‘ …r’ }r“ (hbjŽ hcjŒ ubaubaubeubcsphinx.addnodes seealso r” )r• }r– (hbUhcji hdNhiUseealsor— hk}r˜ (ho]hp]r™ Uadmonition-see-alsorš ahn]hm]hq]uhsNhthh]]r› (h)rœ }r (hbXSee alsorž hk}rŸ (ho]hp]hn]hm]hq]uhcj• h]]r  hˆXSee alsor¡ …r¢ }r£ (hbjž hcjœ ubahih…ubhŒ)r¤ }r¥ (hbUhk}r¦ (ho]hp]hn]hm]hq]uhcj• h]]r§ (j•)r¨ }r© (hbUhk}rª (hm]hn]ho]hp]hq]jš]r« ((jœX $cfg['Servers'][$i]['auth_type']r¬ Uindex-11r­ j¬ tr® (jœX6configuration option; $cfg['Servers'][$i]['auth_type']j­ j¬ tr¯ euhcj¤ h]]hij˜ubh_)r° }r± (hbUhk}r² (ho]hp]hn]hm]r³ j­ ahq]uhcj¤ h]]hihjubh­)r´ }rµ (hbX1:config:option:`$cfg['Servers'][$i]['auth_type']`r¶ hcj¤ hdhghih±hk}r· (UreftypeXoptionh³‰h´j¬ U refdomainXconfigr¸ hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM h]]r¹ hü)rº }r» (hbj¶ hk}r¼ (ho]hp]r½ (h½j¸ X config-optionr¾ ehn]hm]hq]uhcj´ h]]r¿ hˆX $cfg['Servers'][$i]['auth_type']rÀ …rÁ }r (hbUhcjº ubahijubaubhˆX, rà …rÄ }rÅ (hbX, hcj¤ ubj•)rÆ }rÇ (hbUhk}rÈ (hm]hn]ho]hp]hq]jš]rÉ ((jœX$$cfg['Servers'][$i]['SignonSession']rÊ Uindex-12rË jÊ trÌ (jœX:configuration option; $cfg['Servers'][$i]['SignonSession']jË jÊ trÍ euhcj¤ h]]hij˜ubh_)rÎ }rÏ (hbUhk}rÐ (ho]hp]hn]hm]rÑ jË ahq]uhcj¤ h]]hihjubh­)rÒ }rÓ (hbX5:config:option:`$cfg['Servers'][$i]['SignonSession']`rÔ hcj¤ hdhghih±hk}rÕ (UreftypeXoptionh³‰h´jÊ U refdomainXconfigrÖ hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM h]]r× hü)rØ }rÙ (hbjÔ hk}rÚ (ho]hp]rÛ (h½jÖ X config-optionrÜ ehn]hm]hq]uhcjÒ h]]rÝ hˆX$$cfg['Servers'][$i]['SignonSession']rÞ …rß }rà (hbUhcjØ ubahijubaubhˆX, rá …râ }rã (hbX, hcj¤ ubj•)rä }rå (hbUhk}ræ (hm]hn]ho]hp]hq]jš]rç ((jœX#$cfg['Servers'][$i]['SignonScript']rè Uindex-13ré jè trê (jœX9configuration option; $cfg['Servers'][$i]['SignonScript']jé jè trë euhcj¤ h]]hij˜ubh_)rì }rí (hbUhk}rî (ho]hp]hn]hm]rï jé ahq]uhcj¤ h]]hihjubh­)rð }rñ (hbX4:config:option:`$cfg['Servers'][$i]['SignonScript']`rò hcj¤ hdhghih±hk}ró (UreftypeXoptionh³‰h´jè U refdomainXconfigrô hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM h]]rõ hü)rö }r÷ (hbjò hk}rø (ho]hp]rù (h½jô X config-optionrú ehn]hm]hq]uhcjð h]]rû hˆX#$cfg['Servers'][$i]['SignonScript']rü …rý }rþ (hbUhcjö ubahijubaubhˆX, rÿ …r }r (hbX, hcj¤ ubj•)r }r (hbUhk}r (hm]hn]ho]hp]hq]jš]r ((jœX $cfg['Servers'][$i]['SignonURL']r Uindex-14r j tr (jœX6configuration option; $cfg['Servers'][$i]['SignonURL']j j tr euhcj¤ h]]hij˜ubh_)r }r (hbUhk}r (ho]hp]hn]hm]r j ahq]uhcj¤ h]]hihjubh­)r }r (hbX1:config:option:`$cfg['Servers'][$i]['SignonURL']`r hcj¤ hdhghih±hk}r (UreftypeXoptionh³‰h´j U refdomainXconfigr hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM h]]r hü)r }r (hbj hk}r (ho]hp]r (h½j X config-optionr ehn]hm]hq]uhcj h]]r hˆX $cfg['Servers'][$i]['SignonURL']r …r }r (hbUhcj ubahijubaubehihubeubj•)r }r (hbUhcji hdhghij˜hk}r (hm]hn]ho]hp]hq]jš]r (j·XConfig; Authentication modeUindex-15r! Utr" ajŸ‰uhsM¨hthh]]ubh_)r# }r$ (hbUhcji hdhghihjhk}r% (hm]hn]ho]hp]hq]hrj! uhsM¨hthh]]ubeubhu)r& }r' (hbUhcjÔhdhghx}hihzhk}r( (ho]hp]hn]hm]r) (hSj! ehq]r* h#auhsMªhthh~}r+ j! j# sh]]r, (h)r- }r. (hbXConfig authentication moder/ hcj& hdhghih…hk}r0 (ho]hp]hn]hm]hq]uhsMªhthh]]r1 hˆXConfig authentication moder2 …r3 }r4 (hbj/ hcj- ubaubjÌ)r5 }r6 (hbUhcj& hdhghijÏhk}r7 (jÑX*hm]hn]ho]hp]hq]uhsM¬hthh]]r8 (j†)r9 }r: (hbX—This 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.hcj5 hdhghij‰hk}r; (ho]hp]hn]hm]hq]uhsNhthh]]r< hŒ)r= }r> (hbX—This 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.hcj9 hdhghihhk}r? (ho]hp]hn]hm]hq]uhsM¬h]]r@ (hˆXEThis mode is the less secure one because it requires you to fill the rA …rB }rC (hbXEThis mode is the less secure one because it requires you to fill the hcj= ubj•)rD }rE (hbUhk}rF (hm]hn]ho]hp]hq]jš]rG ((jœX$cfg['Servers'][$i]['user']rH Uindex-16rI jH trJ (jœX1configuration option; $cfg['Servers'][$i]['user']jI jH trK euhcj= h]]hij˜ubh_)rL }rM (hbUhk}rN (ho]hp]hn]hm]rO jI ahq]uhcj= h]]hihjubh­)rP }rQ (hbX,:config:option:`$cfg['Servers'][$i]['user']`rR hcj= hdhghih±hk}rS (UreftypeXoptionh³‰h´jH U refdomainXconfigrT hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM¬h]]rU hü)rV }rW (hbjR hk}rX (ho]hp]rY (h½jT X config-optionrZ ehn]hm]hq]uhcjP h]]r[ hˆX$cfg['Servers'][$i]['user']r\ …r] }r^ (hbUhcjV ubahijubaubhˆX and r_ …r` }ra (hbX and hcj= ubj•)rb }rc (hbUhk}rd (hm]hn]ho]hp]hq]jš]re ((jœX$cfg['Servers'][$i]['password']rf Uindex-17rg jf trh (jœX5configuration option; $cfg['Servers'][$i]['password']jg jf tri euhcj= h]]hij˜ubh_)rj }rk (hbUhk}rl (ho]hp]hn]hm]rm jg ahq]uhcj= h]]hihjubh­)rn }ro (hbX0:config:option:`$cfg['Servers'][$i]['password']`rp hcj= hdhghih±hk}rq (UreftypeXoptionh³‰h´jf U refdomainXconfigrr hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM¬h]]rs hü)rt }ru (hbjp hk}rv (ho]hp]rw (h½jr X config-optionrx ehn]hm]hq]uhcjn h]]ry hˆX$cfg['Servers'][$i]['password']rz …r{ }r| (hbUhcjt ubahijubaubhˆX3 fields (and as a result, anyone who can read your r} …r~ }r (hbX3 fields (and as a result, anyone who can read your hcj= ubhü)r€ }r (hbUhk}r‚ (hm]hn]ho]hp]rƒ Xfiler„ aUrolej„ hq]uhcj= h]]r… hˆXconfig.inc.phpr† …r‡ }rˆ (hbXconfig.inc.phphcj€ ubahijubhˆXh can discover your username and password). But you don't need to setup a "controluser" here: using the r‰ …rŠ }r‹ (hbXh can discover your username and password). But you don't need to setup a "controluser" here: using the hcj= ubj•)rŒ }r (hbUhk}rŽ (hm]hn]ho]hp]hq]jš]r ((jœX$cfg['Servers'][$i]['only_db']r Uindex-18r‘ j tr’ (jœX4configuration option; $cfg['Servers'][$i]['only_db']j‘ j tr“ euhcj= h]]hij˜ubh_)r” }r• (hbUhk}r– (ho]hp]hn]hm]r— j‘ ahq]uhcj= h]]hihjubh­)r˜ }r™ (hbX/:config:option:`$cfg['Servers'][$i]['only_db']`rš hcj= hdhghih±hk}r› (UreftypeXoptionh³‰h´j U refdomainXconfigrœ hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM¬h]]r hü)rž }rŸ (hbjš hk}r  (ho]hp]r¡ (h½jœ X config-optionr¢ ehn]hm]hq]uhcj˜ h]]r£ hˆX$cfg['Servers'][$i]['only_db']r¤ …r¥ }r¦ (hbUhcjž ubahijubaubhˆX might be enough.r§ …r¨ }r© (hbX might be enough.hcj= ubeubaubj†)rª }r« (hbXhIn the :ref:`faqmultiuser` section, there is an entry explaining how to protect your configuration file.hcj5 hdhghij‰hk}r¬ (ho]hp]hn]hm]hq]uhsNhthh]]r­ hŒ)r® }r¯ (hbXhIn the :ref:`faqmultiuser` section, there is an entry explaining how to protect your configuration file.hcjª hdhghihhk}r° (ho]hp]hn]hm]hq]uhsM²h]]r± (hˆXIn the r² …r³ }r´ (hbXIn the hcj® ubh­)rµ }r¶ (hbX:ref:`faqmultiuser`r· hcj® hdhghih±hk}r¸ (UreftypeXrefh³ˆh´X faqmultiuserU refdomainXstdr¹ hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM²h]]rº h•)r» }r¼ (hbj· hk}r½ (ho]hp]r¾ (h½j¹ Xstd-refr¿ ehn]hm]hq]uhcjµ h]]rÀ hˆX faqmultiuserrÁ …r }rà (hbUhcj» ubahihŸubaubhˆXN section, there is an entry explaining how to protect your configuration file.rÄ …rÅ }rÆ (hbXN section, there is an entry explaining how to protect your configuration file.hcj® ubeubaubj†)rÇ }rÈ (hbXêFor 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.hcj5 hdhghij‰hk}rÉ (ho]hp]hn]hm]hq]uhsNhthh]]rÊ hŒ)rË }rÌ (hbXêFor 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.hcjÇ hdhghihhk}rÍ (ho]hp]hn]hm]hq]uhsM´h]]rÎ (hˆXWFor additional security in this mode, you may wish to consider the Host authentication rÏ …rÐ }rÑ (hbXWFor additional security in this mode, you may wish to consider the Host authentication hcjË ubj•)rÒ }rÓ (hbUhk}rÔ (hm]hn]ho]hp]hq]jš]rÕ ((jœX)$cfg['Servers'][$i]['AllowDeny']['order']rÖ Uindex-19r× jÖ trØ (jœX?configuration option; $cfg['Servers'][$i]['AllowDeny']['order']j× jÖ trÙ euhcjË h]]hij˜ubh_)rÚ }rÛ (hbUhk}rÜ (ho]hp]hn]hm]rÝ j× ahq]uhcjË h]]hihjubh­)rÞ }rß (hbX::config:option:`$cfg['Servers'][$i]['AllowDeny']['order']`rà hcjË hdhghih±hk}rá (UreftypeXoptionh³‰h´jÖ U refdomainXconfigrâ hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM´h]]rã hü)rä }rå (hbjà hk}ræ (ho]hp]rç (h½jâ X config-optionrè ehn]hm]hq]uhcjÞ h]]ré hˆX)$cfg['Servers'][$i]['AllowDeny']['order']rê …rë }rì (hbUhcjä ubahijubaubhˆX and rí …rî }rï (hbX and hcjË ubj•)rð }rñ (hbUhk}rò (hm]hn]ho]hp]hq]jš]ró ((jœX)$cfg['Servers'][$i]['AllowDeny']['rules']rô Uindex-20rõ jô trö (jœX?configuration option; $cfg['Servers'][$i]['AllowDeny']['rules']jõ jô tr÷ euhcjË h]]hij˜ubh_)rø }rù (hbUhk}rú (ho]hp]hn]hm]rû jõ ahq]uhcjË h]]hihjubh­)rü }rý (hbX::config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']`rþ hcjË hdhghih±hk}rÿ (UreftypeXoptionh³‰h´jô U refdomainXconfigr hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM´h]]r hü)r }r (hbjþ hk}r (ho]hp]r (h½j X config-optionr ehn]hm]hq]uhcjü h]]r hˆX)$cfg['Servers'][$i]['AllowDeny']['rules']r …r }r (hbUhcj ubahijubaubhˆX configuration directives.r …r }r (hbX configuration directives.hcjË ubeubaubj†)r }r (hbX½Unlike 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). hcj5 hdhghij‰hk}r (ho]hp]hn]hm]hq]uhsNhthh]]r hŒ)r }r (hbX¼Unlike 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).hcj hdhghihhk}r (ho]hp]hn]hm]hq]uhsM·h]]r (hˆXáUnlike 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 r …r }r (hbXáUnlike 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 hcj ubh­)r }r (hbX:term:`.htaccess`r hcj hdhghih±hk}r (UreftypeXtermh³ˆh´X .htaccessU refdomainXstdr hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsM·h]]r h•)r }r (hbj hk}r! (ho]hp]r" (h½j Xstd-termr# ehn]hm]hq]uhcj h]]r$ hˆX .htaccessr% …r& }r' (hbUhcj ubahihŸubaubhˆXÊ 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( …r) }r* (hbXÊ 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).hcj ubeubaubeubj•)r+ }r, (hbUhcj& hdhghij˜hk}r- (hm]hn]ho]hp]hq]jš]r. (j·XSwekey; Authentication modeUindex-21r/ Utr0 ajŸ‰uhsMÀhthh]]ubh_)r1 }r2 (hbUhcj& hdhghihjhk}r3 (hm]hn]ho]hp]hq]hrj/ uhsMÀhthh]]ubh_)r4 }r5 (hbX .. _swekey:hcj& hdhghx}hihjhk}r6 (hm]hn]ho]hp]hq]hrh\uhsMÁhthh~}r7 j/ j1 sh]]ubeubhu)r8 }r9 (hbUhcjÔhdhghx}r: h,j4 shihzhk}r; (ho]hp]hn]hm]r< (hUh\j/ ehq]r= (h%h,euhsMÄhthh~}r> (h\j4 j/ j1 uh]]r? (h)r@ }rA (hbXSwekey authentication moderB hcj8 hdhghih…hk}rC (ho]hp]hn]hm]hq]uhsMÄhthh]]rD hˆXSwekey authentication moderE …rF }rG (hbjB hcj@ ubaubhŒ)rH }rI (hbX{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`:hcj8 hdhghihhk}rJ (ho]hp]hn]hm]hq]uhsMÆhthh]]rK (hˆXdThe 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 rL …rM }rN (hbXdThe 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 hcjH ubhü)rO }rP (hbUhk}rQ (hm]hn]ho]hp]rR XfilerS aUrolejS hq]uhcjH h]]rT hˆXconfig.inc.phprU …rV }rW (hbXconfig.inc.phphcjO ubahijubhˆX:…rX }rY (hbX:hcjH ubeubj`)rZ }r[ (hbX?$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey.conf';hcj8 hdhghijchk}r\ (je‰jfXphpjgjhhm]hn]ho]hp]hq]uhsMÍhthh]]r] hˆX?$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey.conf';r^ …r_ }r` (hbUhcjZ ubaubhŒ)ra }rb (hbXYou 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.hcj8 hdhghihhk}rc (ho]hp]hn]hm]hq]uhsMÑhthh]]rd (hˆXYou then have to create the re …rf }rg (hbXYou then have to create the hcja ubhü)rh }ri (hbX``swekey.conf``hk}rj (ho]hp]hn]hm]hq]uhcja h]]rk hˆX swekey.confrl …rm }rn (hbUhcjh ubahijubhˆXª 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 ro …rp }rq (hbXª 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 hcja ubhü)rr }rs (hbX``/etc``hk}rt (ho]hp]hn]hm]hq]uhcja h]]ru hˆX/etcrv …rw }rx (hbUhcjr ubahijubhˆX4). A self documented sample file is provided in the ry …rz }r{ (hbX4). A self documented sample file is provided in the hcja ubhü)r| }r} (hbX ``examples``hk}r~ (ho]hp]hn]hm]hq]uhcja h]]r hˆXexamplesr€ …r }r‚ (hbUhcj| ubahijubhˆXp directory. Feel free to use it with your own users' information. If you want to purchase a Swekey please visit rƒ …r„ }r… (hbXp directory. Feel free to use it with your own users' information. If you want to purchase a Swekey please visit hcja ubjR)r† }r‡ (hbXC`http://phpmyadmin.net/auth\_key `_hk}rˆ (UnamehjVXhttp://phpmyadmin.net/auth_keyr‰ hm]hn]ho]hp]hq]uhcja h]]rŠ hˆXhttp://phpmyadmin.net/auth_keyr‹ …rŒ }r (hbUhcj† ubahij\ubh_)rŽ }r (hbX! hk}r (Urefurij‰ hm]r‘ h>ahn]ho]hp]hq]r’ hauhcja h]]hihjubhˆX1 since this link provides funding for phpMyAdmin.r“ …r” }r• (hbX1 since this link provides funding for phpMyAdmin.hcja ubeubj” )r– }r— (hbUhcj8 hdNhij— hk}r˜ (ho]hp]r™ Uadmonition-see-alsorš ahn]hm]hq]uhsNhthh]]r› (h)rœ }r (hbXSee alsorž hk}rŸ (ho]hp]hn]hm]hq]uhcj– h]]r  hˆXSee alsor¡ …r¢ }r£ (hbjž hcjœ ubahih…ubhŒ)r¤ }r¥ (hbUhk}r¦ (ho]hp]hn]hm]hq]uhcj– h]]r§ (j•)r¨ }r© (hbUhk}rª (hm]hn]ho]hp]hq]jš]r« ((jœX)$cfg['Servers'][$i]['auth_swekey_config']r¬ Uindex-22r­ j¬ tr® (jœX?configuration option; $cfg['Servers'][$i]['auth_swekey_config']j­ j¬ tr¯ euhcj¤ h]]hij˜ubh_)r° }r± (hbUhk}r² (ho]hp]hn]hm]r³ j­ ahq]uhcj¤ h]]hihjubh­)r´ }rµ (hbX::config:option:`$cfg['Servers'][$i]['auth_swekey_config']`r¶ hcj¤ hdhghih±hk}r· (UreftypeXoptionh³‰h´j¬ U refdomainXconfigr¸ hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMÚh]]r¹ hü)rº }r» (hbj¶ hk}r¼ (ho]hp]r½ (h½j¸ X config-optionr¾ ehn]hm]hq]uhcj´ h]]r¿ hˆX)$cfg['Servers'][$i]['auth_swekey_config']rÀ …rÁ }r (hbUhcjº ubahijubaubehihubeubeubeubhu)rà }rÄ (hbUhchvhdhghihzhk}rÅ (ho]hp]hn]hm]rÆ hOahq]rÇ hauhsMÞhthh]]rÈ (h)rÉ }rÊ (hbX%Securing your phpMyAdmin installationrË hcjà hdhghih…hk}rÌ (ho]hp]hn]hm]hq]uhsMÞhthh]]rÍ hˆX%Securing your phpMyAdmin installationrÎ …rÏ }rÐ (hbjË hcjÉ ubaubhŒ)rÑ }rÒ (hbX…The phpMyAdmin team tries hardly to make the application secure, however there are always ways to make your installation more secure:rÓ hcjà hdhghihhk}rÔ (ho]hp]hn]hm]hq]uhsMàhthh]]rÕ hˆX…The phpMyAdmin team tries hardly to make the application secure, however there are always ways to make your installation more secure:rÖ …r× }rØ (hbjÓ hcjÑ ubaubjÌ)rÙ }rÚ (hbUhcjà hdhghijÏhk}rÛ (jÑX*hm]hn]ho]hp]hq]uhsMãhthh]]rÜ (j†)rÝ }rÞ (hbX\remove ``setup`` directory from phpMyAdmin, you will probably not use it after initial setuphcjÙ hdhghij‰hk}rß (ho]hp]hn]hm]hq]uhsNhthh]]rà hŒ)rá }râ (hbX\remove ``setup`` directory from phpMyAdmin, you will probably not use it after initial setuphcjÝ hdhghihhk}rã (ho]hp]hn]hm]hq]uhsMãh]]rä (hˆXremove rå …ræ }rç (hbXremove hcjá ubhü)rè }ré (hbX ``setup``hk}rê (ho]hp]hn]hm]hq]uhcjá h]]rë hˆXsetuprì …rí }rî (hbUhcjè ubahijubhˆXL directory from phpMyAdmin, you will probably not use it after initial setuprï …rð }rñ (hbXL directory from phpMyAdmin, you will probably not use it after initial setuphcjá ubeubaubj†)rò }ró (hbXdproperly choose authentication method - :ref:`cookie` is probably the best choice for shared hostinghcjÙ hdhghij‰hk}rô (ho]hp]hn]hm]hq]uhsNhthh]]rõ hŒ)rö }r÷ (hbXdproperly choose authentication method - :ref:`cookie` is probably the best choice for shared hostinghcjò hdhghihhk}rø (ho]hp]hn]hm]hq]uhsMåh]]rù (hˆX(properly choose authentication method - rú …rû }rü (hbX(properly choose authentication method - hcjö ubh­)rý }rþ (hbX :ref:`cookie`rÿ hcjö hdhghih±hk}r (UreftypeXrefh³ˆh´XcookieU refdomainXstdr hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMåh]]r h•)r }r (hbjÿ hk}r (ho]hp]r (h½j Xstd-refr ehn]hm]hq]uhcjý h]]r hˆXcookier …r }r (hbUhcj ubahihŸubaubhˆX/ is probably the best choice for shared hostingr …r }r (hbX/ is probably the best choice for shared hostinghcjö ubeubaubj†)r }r (hbXœin 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 themhcjÙ hdhghij‰hk}r (ho]hp]hn]hm]hq]uhsNhthh]]r hŒ)r }r (hbXœin 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 themhcj hdhghihhk}r (ho]hp]hn]hm]hq]uhsMçh]]r (hˆXTin case you don't want all MySQL users to be able to access phpMyAdmin, you can use r …r }r (hbXTin case you don't want all MySQL users to be able to access phpMyAdmin, you can use hcj ubj•)r }r (hbUhk}r (hm]hn]ho]hp]hq]jš]r ((jœX)$cfg['Servers'][$i]['AllowDeny']['rules']r Uindex-23r j tr (jœX?configuration option; $cfg['Servers'][$i]['AllowDeny']['rules']j j tr! euhcj h]]hij˜ubh_)r" }r# (hbUhk}r$ (ho]hp]hn]hm]r% j ahq]uhcj h]]hihjubh­)r& }r' (hbX::config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']`r( hcj hdhghih±hk}r) (UreftypeXoptionh³‰h´j U refdomainXconfigr* hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMçh]]r+ hü)r, }r- (hbj( hk}r. (ho]hp]r/ (h½j* X config-optionr0 ehn]hm]hq]uhcj& h]]r1 hˆX)$cfg['Servers'][$i]['AllowDeny']['rules']r2 …r3 }r4 (hbUhcj, ubahijubaubhˆX to limit themr5 …r6 }r7 (hbX to limit themhcj ubeubaubj†)r8 }r9 (hbXqconsider hiding phpMyAdmin behind authentication proxy, so that MySQL credentials are not all users need to loginhcjÙ hdhghij‰hk}r: (ho]hp]hn]hm]hq]uhsNhthh]]r; hŒ)r< }r= (hbXqconsider hiding phpMyAdmin behind authentication proxy, so that MySQL credentials are not all users need to loginr> hcj8 hdhghihhk}r? (ho]hp]hn]hm]hq]uhsMéh]]r@ hˆXqconsider hiding phpMyAdmin behind authentication proxy, so that MySQL credentials are not all users need to loginrA …rB }rC (hbj> hcj< ubaubaubj†)rD }rE (hbX²if you are afraid of automated attacks, enabling Captcha by :config:option:`$cfg['CaptchaLoginPublicKey']` and :config:option:`$cfg['CaptchaLoginPrivateKey']` might be an option.hcjÙ hdhghij‰hk}rF (ho]hp]hn]hm]hq]uhsNhthh]]rG hŒ)rH }rI (hbX²if you are afraid of automated attacks, enabling Captcha by :config:option:`$cfg['CaptchaLoginPublicKey']` and :config:option:`$cfg['CaptchaLoginPrivateKey']` might be an option.hcjD hdhghihhk}rJ (ho]hp]hn]hm]hq]uhsMëh]]rK (hˆX<if you are afraid of automated attacks, enabling Captcha by rL …rM }rN (hbX<if you are afraid of automated attacks, enabling Captcha by hcjH ubj•)rO }rP (hbUhk}rQ (hm]hn]ho]hp]hq]jš]rR ((jœX$cfg['CaptchaLoginPublicKey']rS Uindex-24rT jS trU (jœX3configuration option; $cfg['CaptchaLoginPublicKey']jT jS trV euhcjH h]]hij˜ubh_)rW }rX (hbUhk}rY (ho]hp]hn]hm]rZ jT ahq]uhcjH h]]hihjubh­)r[ }r\ (hbX.:config:option:`$cfg['CaptchaLoginPublicKey']`r] hcjH hdhghih±hk}r^ (UreftypeXoptionh³‰h´jS U refdomainXconfigr_ hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMëh]]r` hü)ra }rb (hbj] hk}rc (ho]hp]rd (h½j_ X config-optionre ehn]hm]hq]uhcj[ h]]rf hˆX$cfg['CaptchaLoginPublicKey']rg …rh }ri (hbUhcja ubahijubaubhˆX and rj …rk }rl (hbX and hcjH ubj•)rm }rn (hbUhk}ro (hm]hn]ho]hp]hq]jš]rp ((jœX$cfg['CaptchaLoginPrivateKey']rq Uindex-25rr jq trs (jœX4configuration option; $cfg['CaptchaLoginPrivateKey']jr jq trt euhcjH h]]hij˜ubh_)ru }rv (hbUhk}rw (ho]hp]hn]hm]rx jr ahq]uhcjH h]]hihjubh­)ry }rz (hbX/:config:option:`$cfg['CaptchaLoginPrivateKey']`r{ hcjH hdhghih±hk}r| (UreftypeXoptionh³‰h´jq U refdomainXconfigr} hm]hn]U refexplicit‰ho]hp]hq]h¶h·uhsMëh]]r~ hü)r }r€ (hbj{ hk}r (ho]hp]r‚ (h½j} X config-optionrƒ ehn]hm]hq]uhcjy h]]r„ hˆX$cfg['CaptchaLoginPrivateKey']r… …r† }r‡ (hbUhcj ubahijubaubhˆX might be an option.rˆ …r‰ }rŠ (hbX might be an option.hcjH ubeubaubeubeubeubehbUU transformerr‹ NU footnote_refsrŒ }r UrefnamesrŽ }r Usymbol_footnotesr ]r‘ Uautofootnote_refsr’ ]r“ Usymbol_footnote_refsr” ]r• U citationsr– ]r— hthU current_liner˜ NUtransform_messagesr™ ]rš (cdocutils.nodes system_message r› )rœ }r (hbUhk}rž (ho]UlevelKhm]hn]Usourcehghp]hq]UlineKUtypeUINFOrŸ uh]]r  hŒ)r¡ }r¢ (hbUhk}r£ (ho]hp]hn]hm]hq]uhcjœ h]]r¤ hˆX+Hyperlink target "setup" is not referenced.r¥ …r¦ }r§ (hbUhcj¡ ubahihubahiUsystem_messager¨ ubj› )r© }rª (hbUhk}r« (ho]UlevelKhm]hn]Usourcehghp]hq]UlineK%UtypejŸ uh]]r¬ hŒ)r­ }r® (hbUhk}r¯ (ho]hp]hn]hm]hq]uhcj© h]]r° hˆX<Hyperlink target "opensuse build service" is not referenced.r± …r² }r³ (hbUhcj­ ubahihubahij¨ ubj› )r´ }rµ (hbUhk}r¶ (ho]UlevelKhm]hn]Usourcehghp]hq]UlineK+UtypejŸ uh]]r· hŒ)r¸ }r¹ (hbUhk}rº (ho]hp]hn]hm]hq]uhcj´ h]]r» hˆX<Hyperlink target "ppa for michal ÄihaÅ™" is not referenced.r¼ …r½ }r¾ (hbUhcj¸ ubahihubahij¨ ubj› )r¿ }rÀ (hbUhk}rÁ (ho]UlevelKhm]hn]Usourcehghp]hq]UlineKFUtypejŸ uh]]r hŒ)rà }rÄ (hbUhk}rÅ (ho]hp]hn]hm]hq]uhcj¿ h]]rÆ hˆXPHyperlink target "extra packages for enterprise linux (epel)" is not referenced.rÇ …rÈ }rÉ (hbUhcjà ubahihubahij¨ ubj› )rÊ }rË (hbUhk}rÌ (ho]UlevelKhm]hn]Usourcehghp]hq]UlineKFUtypejŸ uh]]rÍ hŒ)rÎ }rÏ (hbUhk}rÐ (ho]hp]hn]hm]hq]uhcjÊ h]]rÑ hˆX-Hyperlink target "enabled" is not referenced.rÒ …rÓ }rÔ (hbUhcjÎ ubahihubahij¨ ubj› )rÕ }rÖ (hbUhk}r× (ho]UlevelKhm]hn]Usourcehghp]hq]UlineKSUtypejŸ uh]]rØ hŒ)rÙ }rÚ (hbUhk}rÛ (ho]hp]hn]hm]hq]uhcjÕ h]]rÜ hˆX+Hyperlink target "xampp" is not referenced.rÝ …rÞ }rß (hbUhcjÙ ubahihubahij¨ ubj› )rà }rá (hbUhk}râ (ho]UlevelKhm]hn]Usourcehghp]hq]UlineKWUtypejŸ uh]]rã hŒ)rä }rå (hbUhk}ræ (ho]hp]hn]hm]hq]uhcjà h]]rç hˆX/Hyperlink target "wikipedia" is not referenced.rè …ré }rê (hbUhcjä ubahihubahij¨ ubj› )rë }rì (hbUhk}rí (ho]UlevelKhm]hn]Usourcehghp]hq]UlineKZUtypejŸ uh]]rî hŒ)rï }rð (hbUhk}rñ (ho]hp]hn]hm]hq]uhcjë h]]rò hˆX3Hyperlink target "quick-install" is not referenced.ró …rô }rõ (hbUhcjï ubahihubahij¨ ubj› )rö }r÷ (hbUhk}rø (ho]UlevelKhm]hn]Usourcehghp]hq]UlineKŸUtypejŸ uh]]rù hŒ)rú }rû (hbUhk}rü (ho]hp]hn]hm]hq]uhcjö h]]rý hˆX-Hyperlink target "index-0" is not referenced.rþ …rÿ }r(hbUhcjú ubahihubahij¨ ubj› )r}r(hbUhk}r(ho]UlevelKhm]hn]Usourcehghp]hq]UlineK UtypejŸ uh]]rhŒ)r}r(hbUhk}r(ho]hp]hn]hm]hq]uhcjh]]rhˆX2Hyperlink target "setup-script" is not referenced.r …r }r (hbUhcjubahihubahij¨ ubj› )r }r (hbUhk}r(ho]UlevelKhm]hn]Usourcehghp]hq]UlineK¥UtypejŸ uh]]rhŒ)r}r(hbUhk}r(ho]hp]hn]hm]hq]uhcj h]]rhˆX2Hyperlink target "setup script" is not referenced.r…r}r(hbUhcjubahihubahij¨ ubj› )r}r(hbUhk}r(ho]UlevelKhm]hn]Usourcehghp]hq]UlineKÞUtypejŸ uh]]rhŒ)r}r(hbUhk}r(ho]hp]hn]hm]hq]uhcjh]]rhˆX?Hyperlink target "main phpmyadmin directory" is not referenced.r…r }r!(hbUhcjubahihubahij¨ ubj› )r"}r#(hbUhk}r$(ho]UlevelKhm]hn]Usourcehghp]hq]UlineKòUtypejŸ uh]]r%hŒ)r&}r'(hbUhk}r((ho]hp]hn]hm]hq]uhcj"h]]r)hˆX-Hyperlink target "index-1" is not referenced.r*…r+}r,(hbUhcj&ubahihubahij¨ ubj› )r-}r.(hbUhk}r/(ho]UlevelKhm]hn]Usourcehghp]hq]UlineKóUtypejŸ uh]]r0hŒ)r1}r2(hbUhk}r3(ho]hp]hn]hm]hq]uhcj-h]]r4hˆX3Hyperlink target "linked-tables" is not referenced.r5…r6}r7(hbUhcj1ubahihubahij¨ ubj› )r8}r9(hbUhk}r:(ho]UlevelKhm]hn]Usourcehghp]hq]UlineMUtypejŸ uh]]r;hŒ)r<}r=(hbUhk}r>(ho]hp]hn]hm]hq]uhcj8h]]r?hˆX/Hyperlink target "upgrading" is not referenced.r@…rA}rB(hbUhcj<ubahihubahij¨ ubj› )rC}rD(hbUhk}rE(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM)UtypejŸ uh]]rFhŒ)rG}rH(hbUhk}rI(ho]hp]hn]hm]hq]uhcjCh]]rJhˆX-Hyperlink target "index-2" is not referenced.rK…rL}rM(hbUhcjGubahihubahij¨ ubj› )rN}rO(hbUhk}rP(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM*UtypejŸ uh]]rQhŒ)rR}rS(hbUhk}rT(ho]hp]hn]hm]hq]uhcjNh]]rUhˆX:Hyperlink target "authentication-modes" is not referenced.rV…rW}rX(hbUhcjRubahihubahij¨ ubj› )rY}rZ(hbUhk}r[(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM7UtypejŸ uh]]r\hŒ)r]}r^(hbUhk}r_(ho]hp]hn]hm]hq]uhcjYh]]r`hˆX-Hyperlink target "index-3" is not referenced.ra…rb}rc(hbUhcj]ubahihubahij¨ ubj› )rd}re(hbUhk}rf(ho]UlevelKhm]hn]Usourcehghp]hq]UlineMDUtypejŸ uh]]rghŒ)rh}ri(hbUhk}rj(ho]hp]hn]hm]hq]uhcjdh]]rkhˆX-Hyperlink target "index-4" is not referenced.rl…rm}rn(hbUhcjhubahihubahij¨ ubj› )ro}rp(hbUhk}rq(ho]UlevelKhm]hn]Usourcehghp]hq]UlineMDUtypejŸ uh]]rrhŒ)rs}rt(hbUhk}ru(ho]hp]hn]hm]hq]uhcjoh]]rvhˆX-Hyperlink target "index-5" is not referenced.rw…rx}ry(hbUhcjsubahihubahij¨ ubj› )rz}r{(hbUhk}r|(ho]UlevelKhm]hn]Usourcehghp]hq]UlineMtUtypejŸ uh]]r}hŒ)r~}r(hbUhk}r€(ho]hp]hn]hm]hq]uhcjzh]]rhˆX-Hyperlink target "index-6" is not referenced.r‚…rƒ}r„(hbUhcj~ubahihubahij¨ ubj› )r…}r†(hbUhk}r‡(ho]UlevelKhm]hn]Usourcehghp]hq]UlineMyUtypejŸ uh]]rˆhŒ)r‰}rŠ(hbUhk}r‹(ho]hp]hn]hm]hq]uhcj…h]]rŒhˆX-Hyperlink target "index-7" is not referenced.r…rŽ}r(hbUhcj‰ubahihubahij¨ ubj› )r}r‘(hbUhk}r’(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM†UtypejŸ uh]]r“hŒ)r”}r•(hbUhk}r–(ho]hp]hn]hm]hq]uhcjh]]r—hˆX-Hyperlink target "index-8" is not referenced.r˜…r™}rš(hbUhcj”ubahihubahij¨ ubj› )r›}rœ(hbUhk}r(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM‡UtypejŸ uh]]ržhŒ)rŸ}r (hbUhk}r¡(ho]hp]hn]hm]hq]uhcj›h]]r¢hˆX,Hyperlink target "cookie" is not referenced.r£…r¤}r¥(hbUhcjŸubahihubahij¨ ubj› )r¦}r§(hbUhk}r¨(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM’UtypejŸ uh]]r©hŒ)rª}r«(hbUhk}r¬(ho]hp]hn]hm]hq]uhcj¦h]]r­hˆX-Hyperlink target "index-9" is not referenced.r®…r¯}r°(hbUhcjªubahihubahij¨ ubj› )r±}r²(hbUhk}r³(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM—UtypejŸ uh]]r´hŒ)rµ}r¶(hbUhk}r·(ho]hp]hn]hm]hq]uhcj±h]]r¸hˆX.Hyperlink target "index-10" is not referenced.r¹…rº}r»(hbUhcjµubahihubahij¨ ubj› )r¼}r½(hbUhk}r¾(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM™UtypejŸ uh]]r¿hŒ)rÀ}rÁ(hbUhk}rÂ(ho]hp]hn]hm]hq]uhcj¼h]]rÃhˆX.Hyperlink target "index-11" is not referenced.rÄ…rÅ}rÆ(hbUhcjÀubahihubahij¨ ubj› )rÇ}rÈ(hbUhk}rÉ(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM™UtypejŸ uh]]rÊhŒ)rË}rÌ(hbUhk}rÍ(ho]hp]hn]hm]hq]uhcjÇh]]rÎhˆX.Hyperlink target "index-12" is not referenced.rÏ…rÐ}rÑ(hbUhcjËubahihubahij¨ ubj› )rÒ}rÓ(hbUhk}rÔ(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM™UtypejŸ uh]]rÕhŒ)rÖ}r×(hbUhk}rØ(ho]hp]hn]hm]hq]uhcjÒh]]rÙhˆX.Hyperlink target "index-13" is not referenced.rÚ…rÛ}rÜ(hbUhcjÖubahihubahij¨ ubj› )rÝ}rÞ(hbUhk}rß(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM™UtypejŸ uh]]ràhŒ)rá}râ(hbUhk}rã(ho]hp]hn]hm]hq]uhcjÝh]]rähˆX.Hyperlink target "index-14" is not referenced.rå…ræ}rç(hbUhcjáubahihubahij¨ ubj› )rè}ré(hbUhk}rê(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM¨UtypejŸ uh]]rëhŒ)rì}rí(hbUhk}rî(ho]hp]hn]hm]hq]uhcjèh]]rïhˆX.Hyperlink target "index-15" is not referenced.rð…rñ}rò(hbUhcjìubahihubahij¨ ubj› )ró}rô(hbUhk}rõ(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM¬UtypejŸ uh]]röhŒ)r÷}rø(hbUhk}rù(ho]hp]hn]hm]hq]uhcjóh]]rúhˆX.Hyperlink target "index-16" is not referenced.rû…rü}rý(hbUhcj÷ubahihubahij¨ ubj› )rþ}rÿ(hbUhk}r(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM¬UtypejŸ uh]]rhŒ)r}r(hbUhk}r(ho]hp]hn]hm]hq]uhcjþh]]rhˆX.Hyperlink target "index-17" is not referenced.r…r}r(hbUhcjubahihubahij¨ ubj› )r }r (hbUhk}r (ho]UlevelKhm]hn]Usourcehghp]hq]UlineM¬UtypejŸ uh]]r hŒ)r }r(hbUhk}r(ho]hp]hn]hm]hq]uhcj h]]rhˆX.Hyperlink target "index-18" is not referenced.r…r}r(hbUhcj ubahihubahij¨ ubj› )r}r(hbUhk}r(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM´UtypejŸ uh]]rhŒ)r}r(hbUhk}r(ho]hp]hn]hm]hq]uhcjh]]rhˆX.Hyperlink target "index-19" is not referenced.r…r}r(hbUhcjubahihubahij¨ ubj› )r}r (hbUhk}r!(ho]UlevelKhm]hn]Usourcehghp]hq]UlineM´UtypejŸ uh]]r"hŒ)r#}r$(hbUhk}r%(ho]hp]hn]hm]hq]uhcjh]]r&hˆX.Hyperlink target "index-20" is not referenced.r'…r(}r)(hbUhcj#ubahihubahij¨ ubj› )r*}r+(hbUhk}r,(ho]UlevelKhm]hn]Usourcehghp]hq]UlineMÀUtypejŸ uh]]r-hŒ)r.}r/(hbUhk}r0(ho]hp]hn]hm]hq]uhcj*h]]r1hˆX.Hyperlink target "index-21" is not referenced.r2…r3}r4(hbUhcj.ubahihubahij¨ ubj› )r5}r6(hbUhk}r7(ho]UlevelKhm]hn]Usourcehghp]hq]UlineMÁUtypejŸ uh]]r8hŒ)r9}r:(hbUhk}r;(ho]hp]hn]hm]hq]uhcj5h]]r<hˆX,Hyperlink target "swekey" is not referenced.r=…r>}r?(hbUhcj9ubahihubahij¨ ubj› )r@}rA(hbUhk}rB(ho]UlevelKhm]hn]Usourcehghp]hq]UlineMÑUtypejŸ uh]]rChŒ)rD}rE(hbUhk}rF(ho]hp]hn]hm]hq]uhcj@h]]rGhˆXDHyperlink target "http://phpmyadmin.net/auth_key" is not referenced.rH…rI}rJ(hbUhcjDubahihubahij¨ ubj› )rK}rL(hbUhk}rM(ho]UlevelKhm]hn]Usourcehghp]hq]UlineMÄUtypejŸ uh]]rNhŒ)rO}rP(hbUhk}rQ(ho]hp]hn]hm]hq]uhcjKh]]rRhˆX.Hyperlink target "index-22" is not referenced.rS…rT}rU(hbUhcjOubahihubahij¨ ubj› )rV}rW(hbUhk}rX(ho]UlevelKhm]hn]Usourcehghp]hq]UlineMçUtypejŸ uh]]rYhŒ)rZ}r[(hbUhk}r\(ho]hp]hn]hm]hq]uhcjVh]]r]hˆX.Hyperlink target "index-23" is not referenced.r^…r_}r`(hbUhcjZubahihubahij¨ ubj› )ra}rb(hbUhk}rc(ho]UlevelKhm]hn]Usourcehghp]hq]UlineMëUtypejŸ uh]]rdhŒ)re}rf(hbUhk}rg(ho]hp]hn]hm]hq]uhcjah]]rhhˆX.Hyperlink target "index-24" is not referenced.ri…rj}rk(hbUhcjeubahihubahij¨ ubj› )rl}rm(hbUhk}rn(ho]UlevelKhm]hn]Usourcehghp]hq]UlineMëUtypejŸ uh]]rohŒ)rp}rq(hbUhk}rr(ho]hp]hn]hm]hq]uhcjlh]]rshˆX.Hyperlink target "index-25" is not referenced.rt…ru}rv(hbUhcjpubahihubahij¨ ubeUreporterrwNUid_startrxKU autofootnotesry]rzU citation_refsr{}r|Uindirect_targetsr}]r~Usettingsr(cdocutils.frontend Values r€or}r‚(Ufootnote_backlinksrƒKUrecord_dependenciesr„NU rfc_base_urlr…Uhttp://tools.ietf.org/html/r†U tracebackr‡KUpep_referencesrˆNUstrip_commentsr‰NU toc_backlinksrŠUentryr‹U language_coderŒUenrU datestamprŽNU report_levelrKU _destinationrNU halt_levelr‘KU strip_classesr’Nh…NUerror_encoding_error_handlerr“Ubackslashreplacer”Udebugr•NUembed_stylesheetr–‰Uoutput_encoding_error_handlerr—Ustrictr˜U sectnum_xformr™KUdump_transformsršNU docinfo_xformr›KUwarning_streamrœNUpep_file_url_templaterUpep-%04držUexit_status_levelrŸKUconfigr NUstrict_visitorr¡NUcloak_email_addressesr¢ˆUtrim_footnote_reference_spacer£‰Uenvr¤NUdump_pseudo_xmlr¥NUexpose_internalsr¦NUsectsubtitle_xformr§‰U source_linkr¨NUrfc_referencesr©NUoutput_encodingrªUutf-8r«U source_urlr¬NUinput_encodingr­U utf-8-sigr®U_disable_configr¯NU id_prefixr°UU tab_widthr±KUerror_encodingr²UANSI_X3.4-1968r³U_sourcer´U=/var/www/phpmyadmin/release/phpMyAdmin-4.1.14.3/doc/setup.rstrµUgettext_compactr¶ˆU generatorr·NUdump_internalsr¸NU pep_base_urlr¹Uhttp://www.python.org/dev/peps/rºUinput_encoding_error_handlerr»j˜Uauto_id_prefixr¼Uidr½Udoctitle_xformr¾‰Ustrip_elements_with_classesr¿NU _config_filesrÀ]Ufile_insertion_enabledrÁKU raw_enabledrÂKU dump_settingsrÃNubUsymbol_footnote_startrÄKUidsrÅ}rÆ(h6jKhWjyhGjÒh8jMhjŽ j× jÚ hNjÔhEj´ j­ j° hXj]jÃjÆh?jyhAjÐj‘ j” hJjjI jL jg jj j j hHj½hCjbjé jì jd ji h:jlhQjjájäj›jžj¸j½jj§jnjyjËjÔj;j>j« j´ j j# hLj h7jïjõ jø hUj8 hFjˆh9j§hIj=hDjÔhKj´ h=j§j/ j8 hMjdh@jlhPjhSj& hRhvj! j& j­ j° hThvh[jMhVjjr ju jT jW j j" hBjjË jÎ hZj±hOjà h\j8 hYjùh;ji uUsubstitution_namesrÇ}rÈhihthk}rÉ(ho]hm]hn]Usourcehghp]hq]uU footnotesrÊ]rËUrefidsrÌ}rÍ(h\]rÎj4 ah?]rÏjuahT]rÐh`aj! ]rÑj# ah8]rÒjJah9]rÓj£ajd ]rÔjf aj¸]rÕjºahD]rÖjÐaj]r×j ajn]rØjrajË]rÙjÍahK]rÚj° ah@]rÛjiaj« ]rÜj­ aj/ ]rÝj1 auub.