DonatShell
Server IP : 180.180.241.3  /  Your IP : 216.73.216.252
Web Server : Microsoft-IIS/7.5
System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586
User : IUSR ( 0)
PHP Version : 5.3.28
Disable Function : NONE
MySQL : ON  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /AppServ/www/app/webroot/phpMyAdmin/a/doc/doctrees/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /AppServ/www/app/webroot/phpMyAdmin/a/doc/doctrees/setup.doctree
cdocutils.nodes
document
q)q}q(U	nametypesq}q(Xsignon authentication modeqNXsetup_scriptqX
quick installqNXusing setup scriptq	NXhttp://phpmyadmin.net/auth_keyq
X
quick_installqX	upgradingqXauthentication_modesq
X
linked-tablesqXsetup scriptqXhttp authentication modeqNXconfig authentication modeqNXcookieqXupgrading from an older versionqNXusing authentication modesqNX%securing your phpmyadmin installationqNXmanually creating the fileqNXinstallationqNXsetupqXswekey authentication modeqNX phpmyadmin configuration storageqNXmain phpmyadmin directoryqXcookie authentication modeqNXswekeyquUsubstitution_defsq}qUparse_messagesq ]q!Ucurrent_sourceq"NU
decorationq#NUautofootnote_startq$KUnameidsq%}q&(hUsignon-authentication-modeq'hUsetup-scriptq(hUid1q)h	Uusing-setup-scriptq*h
Uhttp-phpmyadmin-net-auth-keyq+hU
quick-installq,hU	upgradingq-h
Uauthentication-modesq.hU
linked-tablesq/hUid2q0hUhttp-authentication-modeq1hUconfig-authentication-modeq2hUcookieq3hUupgrading-from-an-older-versionq4hUusing-authentication-modesq5hU%securing-your-phpmyadmin-installationq6hUmanually-creating-the-fileq7hUinstallationq8hUsetupq9hUswekey-authentication-modeq:hU phpmyadmin-configuration-storageq;hUmain-phpmyadmin-directoryq<hUcookie-authentication-modeq=hUswekeyq>uUchildrenq?]q@(cdocutils.nodes
target
qA)qB}qC(U	rawsourceqDX
.. _setup:qEUparentqFhUsourceqGcdocutils.nodes
reprunicode
qHX?/opt/pma-git/phpmyadmin/release/phpMyAdmin-4.0.10/doc/setup.rstqIqJ}qKbUtagnameqLUtargetqMU
attributesqN}qO(UidsqP]qQUbackrefsqR]qSUdupnamesqT]qUUclassesqV]qWUnamesqX]qYUrefidqZh9uUlineq[KUdocumentq\hh?]q]ubcdocutils.nodes
section
q^)q_}q`(hDUhFhhGhJUexpect_referenced_by_nameqa}qbhhBshLUsectionqchN}qd(hT]qehV]qfhR]qghP]qh(h8h9ehX]qi(hheuh[Kh\hUexpect_referenced_by_idqj}qkh9hBsh?]ql(cdocutils.nodes
title
qm)qn}qo(hDXInstallationqphFh_hGhJhLUtitleqqhN}qr(hT]qshV]qthR]quhP]qvhX]qwuh[Kh\hh?]qxcdocutils.nodes
Text
qyXInstallationqzq{}q|(hDhphFhnubaubcdocutils.nodes
paragraph
q})q~}q(hDXphpMyAdmin does not apply any special security methods to the MySQL
database server. It is still the system administrator's job to grant
permissions on the MySQL databases properly. phpMyAdmin's :guilabel:`Users`
page can be used for this.qhFh_hGhJhLU	paragraphqhN}q(hT]qhV]qhR]qhP]qhX]quh[Kh\hh?]q(hyXphpMyAdmin does not apply any special security methods to the MySQL
database server. It is still the system administrator's job to grant
permissions on the MySQL databases properly. phpMyAdmin's qq}q(hDXphpMyAdmin does not apply any special security methods to the MySQL
database server. It is still the system administrator's job to grant
permissions on the MySQL databases properly. phpMyAdmin's qhFh~ubcdocutils.nodes
emphasis
q)q}q(hDUhN}q(UrawtextqX:guilabel:`Users`qhP]qhR]qhT]qhV]qXguilabelqahX]quhFh~h?]qhyXUsersqq}q(hDUhFhubahLUemphasisqubhyX
page can be used for this.qq}q(hDX
page can be used for this.qhFh~ubeubcdocutils.nodes
warning
q)q}q(hDX=:term:`Mac` users should note that if you are on a version before
:term:`Mac OS X`, StuffIt unstuffs with :term:`Mac` formats. So you'll have
to resave as in BBEdit to Unix style ALL phpMyAdmin scripts before
uploading them to your server, as PHP seems not to like :term:`Mac`-style
end of lines character ("``\r``").qhFh_hGhJhLUwarningqhN}q(hT]qhV]qhR]qhP]qhX]quh[Nh\hh?]qh})q}q(hDX=:term:`Mac` users should note that if you are on a version before
:term:`Mac OS X`, StuffIt unstuffs with :term:`Mac` formats. So you'll have
to resave as in BBEdit to Unix style ALL phpMyAdmin scripts before
uploading them to your server, as PHP seems not to like :term:`Mac`-style
end of lines character ("``\r``").qhFhhGhJhLhhN}q(hT]qhV]qhR]qhP]qhX]quh[K
h?]q(csphinx.addnodes
pending_xref
q)q}q(hDX:term:`Mac`qhFhhGhJhLUpending_xrefqhN}q(UreftypeqXtermqUrefwarnqU	reftargetqXmacqU	refdomainqXstdqhP]qhR]qUrefexplicitqljhT]qhV]qhX]qUrefdocqUsetupquh[K
h?]qh)q}q(hDhhN}q(hT]qhV]q(UxrefqhXstd-termqehR]qhP]qhX]quhFhh?]qhyXMacqمq}q(hDUhFhubahLhubaubhyX7 users should note that if you are on a version before
q܅q}q(hDX7 users should note that if you are on a version before
qhFhubh)q}q(hDX:term:`Mac OS X`qhFhhGhJhLhhN}q(UreftypeqXtermqhhXmac os xqU	refdomainqXstdqhP]qhR]qUrefexplicitqhT]qhV]qhX]qhhuh[K
h?]qh)q}q(hDhhN}q(hT]qhV]q(hhXstd-termqehR]qhP]qhX]quhFhh?]qhyXMac OS Xqq}q(hDUhFhubahLhubaubhyX, StuffIt unstuffs with qq}q(hDX, StuffIt unstuffs with rhFhubh)r}r(hDX:term:`Mac`rhFhhGhJhLhhN}r(UreftyperXtermrhhXmacrU	refdomainrXstdr	hP]r
hR]rUrefexplicitrhT]r
hV]rhX]rhhuh[K
h?]rh)r}r(hDjhN}r(hT]rhV]r(hj	Xstd-termrehR]rhP]rhX]ruhFjh?]rhyXMacrr}r(hDUhFjubahLhubaubhyX formats. So you'll have
to resave as in BBEdit to Unix style ALL phpMyAdmin scripts before
uploading them to your server, as PHP seems not to like rr}r (hDX formats. So you'll have
to resave as in BBEdit to Unix style ALL phpMyAdmin scripts before
uploading them to your server, as PHP seems not to like r!hFhubh)r"}r#(hDX:term:`Mac`r$hFhhGhJhLhhN}r%(Ureftyper&Xtermr'hhXmacr(U	refdomainr)Xstdr*hP]r+hR]r,Urefexplicitr-hT]r.hV]r/hX]r0hhuh[K
h?]r1h)r2}r3(hDj$hN}r4(hT]r5hV]r6(hj*Xstd-termr7ehR]r8hP]r9hX]r:uhFj"h?]r;hyXMacr<r=}r>(hDUhFj2ubahLhubaubhyX -style
end of lines character ("r?r@}rA(hDX -style
end of lines character ("rBhFhubcdocutils.nodes
literal
rC)rD}rE(hDX``\r``rFhN}rG(hT]rHhV]rIhR]rJhP]rKhX]rLuhFhh?]rMhyX\rrNrO}rP(hDUhFjDubahLUliteralrQubhyX").rRrS}rT(hDX").rUhFhubeubaubhA)rV}rW(hDX.. _quick_install:rXhFh_hGhJhLhMhN}rY(hP]rZhR]r[hT]r\hV]r]hX]r^hZh,uh[Kh\hh?]r_ubh^)r`}ra(hDUhFh_hGhJha}rbhjVshLhchN}rc(hT]rdhV]rehR]rfhP]rg(h,h)ehX]rh(hheuh[Kh\hhj}rih,jVsh?]rj(hm)rk}rl(hDX
Quick InstallrmhFj`hGhJhLhqhN}rn(hT]rohV]rphR]rqhP]rrhX]rsuh[Kh\hh?]rthyX
Quick Installrurv}rw(hDjmhFjkubaubcdocutils.nodes
enumerated_list
rx)ry}rz(hDUhFj`hGhJhLUenumerated_listr{hN}r|(Usuffixr}U.hP]r~hR]rhT]rUprefixrUhV]rhX]rUenumtyperUarabicruh[Kh\hh?]r(cdocutils.nodes
list_item
r)r}r(hDXChoose an appropriate distribution kit from the phpmyadmin.net
Downloads page. Some kits contain only the English messages, others
contain all languages. We'll assume you chose a kit whose name
looks like ``phpMyAdmin-x.x.x -all-languages.tar.gz``.rhFjyhGhJhLU	list_itemrhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXChoose an appropriate distribution kit from the phpmyadmin.net
Downloads page. Some kits contain only the English messages, others
contain all languages. We'll assume you chose a kit whose name
looks like ``phpMyAdmin-x.x.x -all-languages.tar.gz``.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh?]r(hyXChoose an appropriate distribution kit from the phpmyadmin.net
Downloads page. Some kits contain only the English messages, others
contain all languages. We'll assume you chose a kit whose name
looks like rr}r(hDXChoose an appropriate distribution kit from the phpmyadmin.net
Downloads page. Some kits contain only the English messages, others
contain all languages. We'll assume you chose a kit whose name
looks like rhFjubjC)r}r(hDX*``phpMyAdmin-x.x.x -all-languages.tar.gz``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX&phpMyAdmin-x.x.x -all-languages.tar.gzrr}r(hDUhFjubahLjQubhyX.r}r(hDX.hFjubeubaubj)r}r(hDX^Untar or unzip the distribution (be sure to unzip the subdirectories):
``tar -xzvf phpMyAdmin_x.x.x-all-languages.tar.gz`` in your
webserver's document root. If you don't have direct access to your
document root, put the files in a directory on your local machine,
and, after step 4, transfer the directory on your web server using,
for example, ftp.rhFjyhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDX^Untar or unzip the distribution (be sure to unzip the subdirectories):
``tar -xzvf phpMyAdmin_x.x.x-all-languages.tar.gz`` in your
webserver's document root. If you don't have direct access to your
document root, put the files in a directory on your local machine,
and, after step 4, transfer the directory on your web server using,
for example, ftp.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh?]r(hyXGUntar or unzip the distribution (be sure to unzip the subdirectories):
rr}r(hDXGUntar or unzip the distribution (be sure to unzip the subdirectories):
rhFjubjC)r}r(hDX3``tar -xzvf phpMyAdmin_x.x.x-all-languages.tar.gz``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX/tar -xzvf phpMyAdmin_x.x.x-all-languages.tar.gzrr}r(hDUhFjubahLjQubhyX in your
webserver's document root. If you don't have direct access to your
document root, put the files in a directory on your local machine,
and, after step 4, transfer the directory on your web server using,
for example, ftp.rr}r(hDX in your
webserver's document root. If you don't have direct access to your
document root, put the files in a directory on your local machine,
and, after step 4, transfer the directory on your web server using,
for example, ftp.rhFjubeubaubj)r}r(hDXEnsure that all the scripts have the appropriate owner (if PHP is
running in safe mode, having some scripts with an owner different from
the owner of other scripts will be a problem). See :ref:`faq4_2` and
:ref:`faq1_26` for suggestions.rhFjyhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXEnsure that all the scripts have the appropriate owner (if PHP is
running in safe mode, having some scripts with an owner different from
the owner of other scripts will be a problem). See :ref:`faq4_2` and
:ref:`faq1_26` for suggestions.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[K"h?]r(hyXEnsure that all the scripts have the appropriate owner (if PHP is
running in safe mode, having some scripts with an owner different from
the owner of other scripts will be a problem). See rr}r(hDXEnsure that all the scripts have the appropriate owner (if PHP is
running in safe mode, having some scripts with an owner different from
the owner of other scripts will be a problem). See rhFjubh)r}r(hDX
:ref:`faq4_2`rhFjhGhJhLhhN}r(UreftyperXrefrhhXfaq4_2rU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[K"h?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]r	uhFjh?]r
hyXfaq4_2rr}r
(hDUhFjubahLhubaubhyX and
rr}r(hDX and
rhFjubh)r}r(hDX:ref:`faq1_26`rhFjhGhJhLhhN}r(UreftyperXrefrhhXfaq1_26rU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]r hhuh[K"h?]r!h)r"}r#(hDjhN}r$(hT]r%hV]r&(hjXstd-refr'ehR]r(hP]r)hX]r*uhFjh?]r+hyXfaq1_26r,r-}r.(hDUhFj"ubahLhubaubhyX for suggestions.r/r0}r1(hDX for suggestions.r2hFjubeubaubj)r3}r4(hDXgNow you must configure your installation. There are two methods that
can be used. Traditionally, users have hand-edited a copy of
:file:`config.inc.php`, but now a wizard-style setup script is provided
for those who prefer a graphical installation. Creating a
:file:`config.inc.php` is still a quick way to get started and needed for
some advanced features.

r5hFjyhGhJhLjhN}r6(hT]r7hV]r8hR]r9hP]r:hX]r;uh[Nh\hh?]r<h})r=}r>(hDXeNow you must configure your installation. There are two methods that
can be used. Traditionally, users have hand-edited a copy of
:file:`config.inc.php`, but now a wizard-style setup script is provided
for those who prefer a graphical installation. Creating a
:file:`config.inc.php` is still a quick way to get started and needed for
some advanced features.r?hFj3hGhJhLhhN}r@(hT]rAhV]rBhR]rChP]rDhX]rEuh[K&h?]rF(hyXNow you must configure your installation. There are two methods that
can be used. Traditionally, users have hand-edited a copy of
rGrH}rI(hDXNow you must configure your installation. There are two methods that
can be used. Traditionally, users have hand-edited a copy of
rJhFj=ubjC)rK}rL(hDUhN}rM(hP]rNhR]rOhT]rPhV]rQXfilerRaUrolerSjRhX]rTuhFj=h?]rUhyXconfig.inc.phprVrW}rX(hDXconfig.inc.phprYhFjKubahLjQubhyXl, but now a wizard-style setup script is provided
for those who prefer a graphical installation. Creating a
rZr[}r\(hDXl, but now a wizard-style setup script is provided
for those who prefer a graphical installation. Creating a
r]hFj=ubjC)r^}r_(hDUhN}r`(hP]rahR]rbhT]rchV]rdXfilereaUrolerfjehX]rguhFj=h?]rhhyXconfig.inc.phprirj}rk(hDXconfig.inc.phprlhFj^ubahLjQubhyXK is still a quick way to get started and needed for
some advanced features.rmrn}ro(hDXK is still a quick way to get started and needed for
some advanced features.rphFj=ubeubaubeubh^)rq}rr(hDUhFj`hGhJhLhchN}rs(hT]rthV]ruhR]rvhP]rwh7ahX]rxhauh[K/h\hh?]ry(hm)rz}r{(hDXManually creating the filer|hFjqhGhJhLhqhN}r}(hT]r~hV]rhR]rhP]rhX]ruh[K/h\hh?]rhyXManually creating the filerr}r(hDj|hFjzubaubh})r}r(hDX[To manually create the file, simply use your text editor to create the
file :file:`config.inc.php` (you can copy :file:`config.sample.inc.php` to get
minimal configuration file) in the main (top-level) phpMyAdmin
directory (the one that contains :file:`index.php`). phpMyAdmin first
loads :file:`libraries/config.default.php` and then overrides those values
with anything found in :file:`config.inc.php`. If the default value is
okay for a particular setting, there is no need to include it in
:file:`config.inc.php`. You'll need a few directives to get going, a
simple configuration may look like this:rhFjqhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[K1h\hh?]r(hyXLTo manually create the file, simply use your text editor to create the
file rr}r(hDXLTo manually create the file, simply use your text editor to create the
file rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX (you can copy rr}r(hDX (you can copy rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.sample.inc.phprr}r(hDXconfig.sample.inc.phprhFjubahLjQubhyXh to get
minimal configuration file) in the main (top-level) phpMyAdmin
directory (the one that contains rr}r(hDXh to get
minimal configuration file) in the main (top-level) phpMyAdmin
directory (the one that contains rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyX	index.phprr}r(hDX	index.phprhFjubahLjQubhyX). phpMyAdmin first
loads rr}r(hDX). phpMyAdmin first
loads rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXlibraries/config.default.phprr}r(hDXlibraries/config.default.phprhFjubahLjQubhyX8 and then overrides those values
with anything found in rr}r(hDX8 and then overrides those values
with anything found in rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX[. If the default value is
okay for a particular setting, there is no need to include it in
rr}r(hDX[. If the default value is
okay for a particular setting, there is no need to include it in
rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyXW. You'll need a few directives to get going, a
simple configuration may look like this:rr}r(hDXW. You'll need a few directives to get going, a
simple configuration may look like this:rhFjubeubcdocutils.nodes
literal_block
r)r}r	(hDX<?php
$cfg['blowfish_secret'] = 'ba17c1ec07d65003';  // use here a value of your choice

$i=0;
$i++;
$cfg['Servers'][$i]['auth_type']     = 'cookie';
?>r
hFjqhGhJhLU
literal_blockrhN}r(Ulinenosr
UlanguagerXphprU	xml:spacerUpreserverhP]rhR]rhT]rhV]rhX]ruh[K;h\hh?]rhyX<?php
$cfg['blowfish_secret'] = 'ba17c1ec07d65003';  // use here a value of your choice

$i=0;
$i++;
$cfg['Servers'][$i]['auth_type']     = 'cookie';
?>rr}r(hDUhFjubaubh})r}r(hDX;Or, if you prefer to not be prompted every time you log in:rhFjqhGhJhLhhN}r(hT]rhV]r hR]r!hP]r"hX]r#uh[KFh\hh?]r$hyX;Or, if you prefer to not be prompted every time you log in:r%r&}r'(hDjhFjubaubj)r(}r)(hDX<?php

$i=0;
$i++;
$cfg['Servers'][$i]['user']          = 'root';
$cfg['Servers'][$i]['password']      = 'cbb74bc'; // use here your password
$cfg['Servers'][$i]['auth_type']     = 'config';
?>r*hFjqhGhJhLjhN}r+(j
jXphpr,jjhP]r-hR]r.hT]r/hV]r0hX]r1uh[KHh\hh?]r2hyX<?php

$i=0;
$i++;
$cfg['Servers'][$i]['user']          = 'root';
$cfg['Servers'][$i]['password']      = 'cbb74bc'; // use here your password
$cfg['Servers'][$i]['auth_type']     = 'config';
?>r3r4}r5(hDUhFj(ubaubh})r6}r7(hDX`For a full explanation of possible configuration values, see the
:ref:`config` of this document.r8hFjqhGhJhLhhN}r9(hT]r:hV]r;hR]r<hP]r=hX]r>uh[KTh\hh?]r?(hyXAFor a full explanation of possible configuration values, see the
r@rA}rB(hDXAFor a full explanation of possible configuration values, see the
rChFj6ubh)rD}rE(hDX
:ref:`config`rFhFj6hGhJhLhhN}rG(UreftyperHXrefrIhhXconfigrJU	refdomainrKXstdrLhP]rMhR]rNUrefexplicitrOhT]rPhV]rQhX]rRhhuh[KTh?]rSh)rT}rU(hDjFhN}rV(hT]rWhV]rX(hjLXstd-refrYehR]rZhP]r[hX]r\uhFjDh?]r]hyXconfigr^r_}r`(hDUhFjTubahLhubaubhyX of this document.rarb}rc(hDX of this document.rdhFj6ubeubcsphinx.addnodes
index
re)rf}rg(hDUhFjqhGhJhLUindexrhhN}ri(hP]rjhR]rkhT]rlhV]rmhX]rnUentriesro]rp(UsinglerqXSetup scriptUindex-0rrUtrsaUinlinertuh[KXh\hh?]ruubhA)rv}rw(hDUhFjqhGhJhLhMhN}rx(hP]ryhR]rzhT]r{hV]r|hX]r}hZjruh[KXh\hh?]r~ubhA)r}r(hDX.. _setup_script:rhFjqhGhJha}rhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZh(uh[KYh\hhj}rjrjvsh?]rubeubh^)r}r(hDUhFj`hGhJha}rhjshLhchN}r(hT]rhV]rhR]rhP]r(h*h(jrehX]r(h	heuh[K\h\hhj}r(jrjvh(juh?]r(hm)r}r(hDXUsing Setup scriptrhFjhGhJhLhqhN}r(hT]rhV]rhR]rhP]rhX]ruh[K\h\hh?]rhyXUsing Setup scriptrr}r(hDjhFjubaubh})r}r(hDXInstead of manually editing :file:`config.inc.php`, you can use the `Setup
Script <setup/>`_. First you must manually create a folder ``config``
in the phpMyAdmin directory. This is a security measure. On a
Linux/Unix system you can use the following commands:rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[K^h\hh?]r(hyXInstead of manually editing rr}r(hDXInstead of manually editing rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX, you can use the rr}r(hDX, you can use the rhFjubcdocutils.nodes
reference
r)r}r(hDX`Setup
Script <setup/>`_rhN}r(UnamerXSetup ScriptrUrefurirXsetup/rhP]rhR]rhT]rhV]rhX]ruhFjh?]rhyXSetup
Scriptrr}r(hDUhFjubahLU	referencerubhA)r}r(hDX	 <setup/>rU
referencedrKhFjhLhMhN}r(UrefurirjhP]rh0ahR]rhT]rhV]rhX]rhauh?]rubhyX*. First you must manually create a folder rr}r(hDX*. First you must manually create a folder rhFjubjC)r}r(hDX
``config``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXconfigrr}r(hDUhFjubahLjQubhyXt
in the phpMyAdmin directory. This is a security measure. On a
Linux/Unix system you can use the following commands:rr}r(hDXt
in the phpMyAdmin directory. This is a security measure. On a
Linux/Unix system you can use the following commands:rhFjubeubj)r}r(hDXcd phpMyAdmin
mkdir config                        # create directory for saving
chmod o+rw config                   # give it world writable permissionsrhFjhGhJhLjhN}r(j
jXshrjjhP]rhR]rhT]rhV]rhX]ruh[Kch\hh?]rhyXcd phpMyAdmin
mkdir config                        # create directory for saving
chmod o+rw config                   # give it world writable permissionsrr}r(hDUhFjubaubh})r}r(hDX:And to edit an existing configuration, copy it over first:rhFjhGhJhLhhN}r	(hT]r
hV]rhR]rhP]r
hX]ruh[Kjh\hh?]rhyX:And to edit an existing configuration, copy it over first:rr}r(hDjhFjubaubj)r}r(hDXcp config.inc.php config/           # copy current configuration for editing
chmod o+w config/config.inc.php     # give it world writable permissionsrhFjhGhJhLjhN}r(j
jXshrjjhP]rhR]rhT]rhV]rhX]ruh[Klh\hh?]rhyXcp config.inc.php config/           # copy current configuration for editing
chmod o+w config/config.inc.php     # give it world writable permissionsrr}r (hDUhFjubaubh})r!}r"(hDXOn other platforms, simply create the folder and ensure that your web
server has read and write access to it. :ref:`faq1_26` can help with
this.r#hFjhGhJhLhhN}r$(hT]r%hV]r&hR]r'hP]r(hX]r)uh[Krh\hh?]r*(hyXnOn other platforms, simply create the folder and ensure that your web
server has read and write access to it. r+r,}r-(hDXnOn other platforms, simply create the folder and ensure that your web
server has read and write access to it. r.hFj!ubh)r/}r0(hDX:ref:`faq1_26`r1hFj!hGhJhLhhN}r2(Ureftyper3Xrefr4hhXfaq1_26r5U	refdomainr6Xstdr7hP]r8hR]r9Urefexplicitr:hT]r;hV]r<hX]r=hhuh[Krh?]r>h)r?}r@(hDj1hN}rA(hT]rBhV]rC(hj7Xstd-refrDehR]rEhP]rFhX]rGuhFj/h?]rHhyXfaq1_26rIrJ}rK(hDUhFj?ubahLhubaubhyX can help with
this.rLrM}rN(hDX can help with
this.rOhFj!ubeubh})rP}rQ(hDXNext, open ``setup/`` in your browser. If you have an existing configuration,
use the ``Load`` button to bring its content inside the setup panel.
Note that **changes are not saved to disk until explicitly choose ``Save``**
from the *Configuration* area of the screen. Normally the script saves the new
:file:`config.inc.php` to the ``config/`` directory, but if the webserver does
not have the proper permissions you may see the error "Cannot load or
save configuration." Ensure that the ``config/`` directory exists and
has the proper permissions - or use the ``Download`` link to save the
config file locally and upload it (via FTP or some similar means) to the
proper location.rRhFjhGhJhLhhN}rS(hT]rThV]rUhR]rVhP]rWhX]rXuh[Kvh\hh?]rY(hyXNext, open rZr[}r\(hDXNext, open r]hFjPubjC)r^}r_(hDX
``setup/``r`hN}ra(hT]rbhV]rchR]rdhP]rehX]rfuhFjPh?]rghyXsetup/rhri}rj(hDUhFj^ubahLjQubhyXA in your browser. If you have an existing configuration,
use the rkrl}rm(hDXA in your browser. If you have an existing configuration,
use the rnhFjPubjC)ro}rp(hDX``Load``rqhN}rr(hT]rshV]rthR]ruhP]rvhX]rwuhFjPh?]rxhyXLoadryrz}r{(hDUhFjoubahLjQubhyX? button to bring its content inside the setup panel.
Note that r|r}}r~(hDX? button to bring its content inside the setup panel.
Note that rhFjPubcdocutils.nodes
strong
r)r}r(hDXB**changes are not saved to disk until explicitly choose ``Save``**rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjPh?]rhyX>changes are not saved to disk until explicitly choose ``Save``rr}r(hDUhFjubahLUstrongrubhyX

from the rr}r(hDX

from the rhFjPubh)r}r(hDX*Configuration*rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjPh?]rhyX
Configurationrr}r(hDUhFjubahLhubhyX7 area of the screen. Normally the script saves the new
rr}r(hDX7 area of the screen. Normally the script saves the new
rhFjPubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjPh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX to the rr}r(hDX to the rhFjPubjC)r}r(hDX``config/``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjPh?]rhyXconfig/rr}r(hDUhFjubahLjQubhyX directory, but if the webserver does
not have the proper permissions you may see the error "Cannot load or
save configuration." Ensure that the rr}r(hDX directory, but if the webserver does
not have the proper permissions you may see the error "Cannot load or
save configuration." Ensure that the rhFjPubjC)r}r(hDX``config/``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjPh?]rhyXconfig/rr}r(hDUhFjubahLjQubhyX> directory exists and
has the proper permissions - or use the rr}r(hDX> directory exists and
has the proper permissions - or use the rhFjPubjC)r}r(hDX``Download``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjPh?]rhyXDownloadrr}r(hDUhFjubahLjQubhyXk link to save the
config file locally and upload it (via FTP or some similar means) to the
proper location.rr}r(hDXk link to save the
config file locally and upload it (via FTP or some similar means) to the
proper location.rhFjPubeubh})r}r(hDXOnce the file has been saved, it must be moved out of the ``config/``
directory and the permissions must be reset, again as a security
measure:rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r(hyX:Once the file has been saved, it must be moved out of the rr}r(hDX:Once the file has been saved, it must be moved out of the rhFjubjC)r}r(hDX``config/``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXconfig/rr}r(hDUhFjubahLjQubhyXJ
directory and the permissions must be reset, again as a security
measure:rr}r(hDXJ
directory and the permissions must be reset, again as a security
measure:rhFjubeubj)r	}r
(hDXmv config/config.inc.php .         # move file to current directory
chmod o-rw config.inc.php          # remove world read and write permissions
rm -rf config                      # remove not needed directoryrhFjhGhJhLjhN}r(j
jXshr
jjhP]rhR]rhT]rhV]rhX]ruh[Kh\hh?]rhyXmv config/config.inc.php .         # move file to current directory
chmod o-rw config.inc.php          # remove world read and write permissions
rm -rf config                      # remove not needed directoryrr}r(hDUhFj	ubaubh})r}r(hDXNow the file is ready to be used. You can choose to review or edit the
file with your favorite editor, if you prefer to set some advanced
options which the setup script does not provide.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r hyXNow the file is ready to be used. You can choose to review or edit the
file with your favorite editor, if you prefer to set some advanced
options which the setup script does not provide.r!r"}r#(hDjhFjubaubjx)r$}r%(hDUhFjhGhJhLj{hN}r&(j}U.hP]r'hR]r(hT]r)jUhV]r*hX]r+jjuh[Kh\hh?]r,(j)r-}r.(hDXIf you are using the ``auth_type`` "config", it is suggested that you
protect the phpMyAdmin installation directory because using config
does not require a user to enter a password to access the phpMyAdmin
installation. Use of an alternate authentication method is
recommended, for example with HTTP–AUTH in a :term:`.htaccess` file or switch to using
``auth_type`` cookie or http. See the :ref:`faqmultiuser`
for additional information, especially :ref:`faq4_4`.r/hFj$hGhJhLjhN}r0(hT]r1hV]r2hR]r3hP]r4hX]r5uh[Nh\hh?]r6h})r7}r8(hDXIf you are using the ``auth_type`` "config", it is suggested that you
protect the phpMyAdmin installation directory because using config
does not require a user to enter a password to access the phpMyAdmin
installation. Use of an alternate authentication method is
recommended, for example with HTTP–AUTH in a :term:`.htaccess` file or switch to using
``auth_type`` cookie or http. See the :ref:`faqmultiuser`
for additional information, especially :ref:`faq4_4`.r9hFj-hGhJhLhhN}r:(hT]r;hV]r<hR]r=hP]r>hX]r?uh[Kh?]r@(hyXIf you are using the rArB}rC(hDXIf you are using the rDhFj7ubjC)rE}rF(hDX
``auth_type``rGhN}rH(hT]rIhV]rJhR]rKhP]rLhX]rMuhFj7h?]rNhyX	auth_typerOrP}rQ(hDUhFjEubahLjQubhyX "config", it is suggested that you
protect the phpMyAdmin installation directory because using config
does not require a user to enter a password to access the phpMyAdmin
installation. Use of an alternate authentication method is
recommended, for example with HTTP–AUTH in a rRrS}rT(hDX "config", it is suggested that you
protect the phpMyAdmin installation directory because using config
does not require a user to enter a password to access the phpMyAdmin
installation. Use of an alternate authentication method is
recommended, for example with HTTP–AUTH in a rUhFj7ubh)rV}rW(hDX:term:`.htaccess`rXhFj7hGhJhLhhN}rY(UreftyperZXtermr[hhX	.htaccessr\U	refdomainr]Xstdr^hP]r_hR]r`UrefexplicitrahT]rbhV]rchX]rdhhuh[Kh?]reh)rf}rg(hDjXhN}rh(hT]rihV]rj(hj^Xstd-termrkehR]rlhP]rmhX]rnuhFjVh?]rohyX	.htaccessrprq}rr(hDUhFjfubahLhubaubhyX file or switch to using
rsrt}ru(hDX file or switch to using
rvhFj7ubjC)rw}rx(hDX
``auth_type``ryhN}rz(hT]r{hV]r|hR]r}hP]r~hX]ruhFj7h?]rhyX	auth_typerr}r(hDUhFjwubahLjQubhyX cookie or http. See the rr}r(hDX cookie or http. See the rhFj7ubh)r}r(hDX:ref:`faqmultiuser`rhFj7hGhJhLhhN}r(UreftyperXrefrhhXfaqmultiuserrU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[Kh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFjh?]rhyXfaqmultiuserrr}r(hDUhFjubahLhubaubhyX(
for additional information, especially rr}r(hDX(
for additional information, especially rhFj7ubh)r}r(hDX
:ref:`faq4_4`rhFj7hGhJhLhhN}r(UreftyperXrefrhhXfaq4_4rU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[Kh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFjh?]rhyXfaq4_4rr}r(hDUhFjubahLhubaubhyX.r}r(hDX.hFj7ubeubaubj)r}r(hDXOpen the `main phpMyAdmin directory <index.php>`_ in your browser.
phpMyAdmin should now display a welcome screen and your databases, or
a login dialog if using :term:`HTTP` or
cookie authentication mode.rhFj$hGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXOpen the `main phpMyAdmin directory <index.php>`_ in your browser.
phpMyAdmin should now display a welcome screen and your databases, or
a login dialog if using :term:`HTTP` or
cookie authentication mode.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh?]r(hyX	Open the rr}r(hDX	Open the rhFjubj)r}r(hDX(`main phpMyAdmin directory <index.php>`_rhN}r(UnamerXmain phpMyAdmin directoryrjX	index.phprhP]rhR]rhT]rhV]rhX]ruhFjh?]rhyXmain phpMyAdmin directoryrr}r(hDUhFjubahLjubhA)r}r(hDX <index.php>rjKhFjhLhMhN}r(UrefurirjhP]rh<ahR]rhT]rhV]rhX]rhauh?]rubhyXp in your browser.
phpMyAdmin should now display a welcome screen and your databases, or
a login dialog if using rr}r(hDXp in your browser.
phpMyAdmin should now display a welcome screen and your databases, or
a login dialog if using rhFjubh)r}r(hDX:term:`HTTP`rhFjhGhJhLhhN}r(UreftyperXtermrhhXhttprU	refdomainrXstdrhP]rhR]r	Urefexplicitr
hT]rhV]rhX]r
hhuh[Kh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-termrehR]rhP]rhX]ruhFjh?]rhyXHTTPrr}r(hDUhFjubahLhubaubhyX or
cookie authentication mode.rr}r(hDX or
cookie authentication mode.rhFjubeubaubj)r }r!(hDX|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.r"hFj$hGhJhLjhN}r#(hT]r$hV]r%hR]r&hP]r'hX]r(uh[Nh\hh?]r)h})r*}r+(hDX|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.r,hFj hGhJhLhhN}r-(hT]r.hV]r/hR]r0hP]r1hX]r2uh[Kh?]r3(hyXYou should deny access to the r4r5}r6(hDXYou should deny access to the r7hFj*ubjC)r8}r9(hDX``./libraries``r:hN}r;(hT]r<hV]r=hR]r>hP]r?hX]r@uhFj*h?]rAhyX./librariesrBrC}rD(hDUhFj8ubahLjQubhyX and rErF}rG(hDX and rHhFj*ubjC)rI}rJ(hDX``./setup/lib``rKhN}rL(hT]rMhV]rNhR]rOhP]rPhX]rQuhFj*h?]rRhyX./setup/librSrT}rU(hDUhFjIubahLjQubhyXM
subfolders in your webserver configuration. For Apache you can use
supplied rVrW}rX(hDXM
subfolders in your webserver configuration. For Apache you can use
supplied rYhFj*ubh)rZ}r[(hDX:term:`.htaccess`r\hFj*hGhJhLhhN}r](Ureftyper^Xtermr_hhX	.htaccessr`U	refdomainraXstdrbhP]rchR]rdUrefexplicitrehT]rfhV]rghX]rhhhuh[Kh?]rih)rj}rk(hDj\hN}rl(hT]rmhV]rn(hjbXstd-termroehR]rphP]rqhX]rruhFjZh?]rshyX	.htaccessrtru}rv(hDUhFjjubahLhubaubhyX  file in that folder, for other webservers, you should
configure this yourself. Such configuration prevents from possible
path exposure and cross side scripting vulnerabilities that might
happen to be found in that code.rwrx}ry(hDX  file in that folder, for other webservers, you should
configure this yourself. Such configuration prevents from possible
path exposure and cross side scripting vulnerabilities that might
happen to be found in that code.rzhFj*ubeubaubj)r{}r|(hDXIt is generally good idea to protect public phpMyAdmin installation
against access by robots as they usually can not do anything good
there. You can do this using ``robots.txt`` file in root of your
webserver or limit access by web server configuration, see
:ref:`faq1_42`.
r}hFj$hGhJhLjhN}r~(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXIt is generally good idea to protect public phpMyAdmin installation
against access by robots as they usually can not do anything good
there. You can do this using ``robots.txt`` file in root of your
webserver or limit access by web server configuration, see
:ref:`faq1_42`.rhFj{hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh?]r(hyXIt is generally good idea to protect public phpMyAdmin installation
against access by robots as they usually can not do anything good
there. You can do this using rr}r(hDXIt is generally good idea to protect public phpMyAdmin installation
against access by robots as they usually can not do anything good
there. You can do this using rhFjubjC)r}r(hDX``robots.txt``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX
robots.txtrr}r(hDUhFjubahLjQubhyXQ file in root of your
webserver or limit access by web server configuration, see
rr}r(hDXQ file in root of your
webserver or limit access by web server configuration, see
rhFjubh)r}r(hDX:ref:`faq1_42`rhFjhGhJhLhhN}r(UreftyperXrefrhhXfaq1_42rU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[Kh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFjh?]rhyXfaq1_42rr}r(hDUhFjubahLhubaubhyX.r}r(hDX.hFjubeubaubeubje)r}r(hDUhFjhGhJhLjhhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqXConfiguration storageUindex-1rUtr(jqX phpMyAdmin configuration storagejUtr(jqXpmadbjUtrejtuh[Kh\hh?]rubhA)r}r(hDUhFjhGhJhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZjuh[Kh\hh?]rubhA)r}r(hDX.. _linked-tables:rhFjhGhJha}rhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZh/uh[Kh\hhj}rjjsh?]rubeubeubh^)r}r(hDUhFh_hGhJha}rhjshLhchN}r(hT]rhV]rhR]rhP]r(h;h/jehX]r(hheuh[Kh\hhj}r(jjh/juh?]r(hm)r}r(hDX phpMyAdmin configuration storagerhFjhGhJhLhqhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]rhyX phpMyAdmin configuration storagerr}r(hDjhFjubaubh})r}r(hDXFor a whole set of new features (bookmarks, comments, :term:`SQL`-history,
tracking mechanism, :term:`PDF`-generation, column contents transformation,
etc.) you need to create a set of special tables.  Those tables can be located
in your own database, or in a central database for a multi-user installation
(this database would then be accessed by the controluser, so no other user
should have rights to it).rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r(hyX6For a whole set of new features (bookmarks, comments, rr	}r
(hDX6For a whole set of new features (bookmarks, comments, rhFjubh)r}r
(hDX:term:`SQL`rhFjhGhJhLhhN}r(UreftyperXtermrhhXsqlrU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[Kh?]rh)r}r(hDjhN}r(hT]rhV]r (hjXstd-termr!ehR]r"hP]r#hX]r$uhFjh?]r%hyXSQLr&r'}r((hDUhFjubahLhubaubhyX-history,
tracking mechanism, r)r*}r+(hDX-history,
tracking mechanism, r,hFjubh)r-}r.(hDX:term:`PDF`r/hFjhGhJhLhhN}r0(Ureftyper1Xtermr2hhXpdfr3U	refdomainr4Xstdr5hP]r6hR]r7Urefexplicitr8hT]r9hV]r:hX]r;hhuh[Kh?]r<h)r=}r>(hDj/hN}r?(hT]r@hV]rA(hj5Xstd-termrBehR]rChP]rDhX]rEuhFj-h?]rFhyXPDFrGrH}rI(hDUhFj=ubahLhubaubhyX.-generation, column contents transformation,
etc.) you need to create a set of special tables.  Those tables can be located
in your own database, or in a central database for a multi-user installation
(this database would then be accessed by the controluser, so no other user
should have rights to it).rJrK}rL(hDX.-generation, column contents transformation,
etc.) you need to create a set of special tables.  Those tables can be located
in your own database, or in a central database for a multi-user installation
(this database would then be accessed by the controluser, so no other user
should have rights to it).rMhFjubeubh})rN}rO(hDXPlease look at your ``./examples/`` directory, where you should find a
file called *create\_tables.sql*. (If you are using a Windows server,
pay special attention to :ref:`faq1_23`).rPhFjhGhJhLhhN}rQ(hT]rRhV]rShR]rThP]rUhX]rVuh[Kh\hh?]rW(hyXPlease look at your rXrY}rZ(hDXPlease look at your r[hFjNubjC)r\}r](hDX``./examples/``r^hN}r_(hT]r`hV]rahR]rbhP]rchX]rduhFjNh?]rehyX./examples/rfrg}rh(hDUhFj\ubahLjQubhyX0 directory, where you should find a
file called rirj}rk(hDX0 directory, where you should find a
file called rlhFjNubh)rm}rn(hDX*create\_tables.sql*rohN}rp(hT]rqhV]rrhR]rshP]rthX]ruuhFjNh?]rvhyXcreate_tables.sqlrwrx}ry(hDUhFjmubahLhubhyX?. (If you are using a Windows server,
pay special attention to rzr{}r|(hDX?. (If you are using a Windows server,
pay special attention to r}hFjNubh)r~}r(hDX:ref:`faq1_23`rhFjNhGhJhLhhN}r(UreftyperXrefrhhXfaq1_23rU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[Kh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFj~h?]rhyXfaq1_23rr}r(hDUhFjubahLhubaubhyX).rr}r(hDX).rhFjNubeubh})r}r(hDXIf you already had this infrastructure and upgraded to MySQL 4.1.2 or
newer, please use :file:`examples/upgrade_tables_mysql_4_1_2+.sql`
and then create new tables by importing
:file:`examples/create_tables.sql`.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r(hyXXIf you already had this infrastructure and upgraded to MySQL 4.1.2 or
newer, please use rr}r(hDXXIf you already had this infrastructure and upgraded to MySQL 4.1.2 or
newer, please use rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyX(examples/upgrade_tables_mysql_4_1_2+.sqlrr}r(hDX(examples/upgrade_tables_mysql_4_1_2+.sqlrhFjubahLjQubhyX)
and then create new tables by importing
rr}r(hDX)
and then create new tables by importing
rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXexamples/create_tables.sqlrr}r(hDXexamples/create_tables.sqlrhFjubahLjQubhyX.r}r(hDX.hFjubeubh})r}r(hDXYou can use your phpMyAdmin to create the tables for you. Please be
aware that you may need special (administrator) privileges to create
the database and tables, and that the script may need some tuning,
depending on the database name.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]rhyXYou can use your phpMyAdmin to create the tables for you. Please be
aware that you may need special (administrator) privileges to create
the database and tables, and that the script may need some tuning,
depending on the database name.rr}r(hDjhFjubaubh})r}r(hDXKAfter having imported the :file:`examples/create_tables.sql` file, you
should specify the table names in your :file:`config.inc.php` file. The
directives used for that can be found in the :ref:`config`. You will also need to
have a controluser with the proper rights to those tables (see section
:ref:`authentication_modes` below).rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r(hyXAfter having imported the rr}r(hDXAfter having imported the rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXexamples/create_tables.sqlrr}r(hDXexamples/create_tables.sqlrhFjubahLjQubhyX2 file, you
should specify the table names in your rr}r(hDX2 file, you
should specify the table names in your rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]r	hyXconfig.inc.phpr
r}r(hDXconfig.inc.phpr
hFjubahLjQubhyX8 file. The
directives used for that can be found in the rr}r(hDX8 file. The
directives used for that can be found in the rhFjubh)r}r(hDX
:ref:`config`rhFjhGhJhLhhN}r(UreftyperXrefrhhXconfigrU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]r hhuh[Kh?]r!h)r"}r#(hDjhN}r$(hT]r%hV]r&(hjXstd-refr'ehR]r(hP]r)hX]r*uhFjh?]r+hyXconfigr,r-}r.(hDUhFj"ubahLhubaubhyX_. You will also need to
have a controluser with the proper rights to those tables (see section
r/r0}r1(hDX_. You will also need to
have a controluser with the proper rights to those tables (see section
r2hFjubh)r3}r4(hDX:ref:`authentication_modes`r5hFjhGhJhLhhN}r6(Ureftyper7Xrefr8hhXauthentication_modesr9U	refdomainr:Xstdr;hP]r<hR]r=Urefexplicitr>hT]r?hV]r@hX]rAhhuh[Kh?]rBh)rC}rD(hDj5hN}rE(hT]rFhV]rG(hj;Xstd-refrHehR]rIhP]rJhX]rKuhFj3h?]rLhyXauthentication_modesrMrN}rO(hDUhFjCubahLhubaubhyX below).rPrQ}rR(hDX below).rShFjubeubhA)rT}rU(hDX.. _upgrading:rVhFjhGhJhLhMhN}rW(hP]rXhR]rYhT]rZhV]r[hX]r\hZh-uh[Kh\hh?]r]ubeubh^)r^}r_(hDUhFh_hGhJha}r`hjTshLhchN}ra(hT]rbhV]rchR]rdhP]re(h4h-ehX]rf(hheuh[Kh\hhj}rgh-jTsh?]rh(hm)ri}rj(hDXUpgrading from an older versionrkhFj^hGhJhLhqhN}rl(hT]rmhV]rnhR]rohP]rphX]rquh[Kh\hh?]rrhyXUpgrading from an older versionrsrt}ru(hDjkhFjiubaubh})rv}rw(hDX\Simply copy :file:`config.inc.php` from your previous installation into
the newly unpacked one. Configuration files from old versions may
require some tweaking as some options have been changed or removed.
For compatibility with PHP 6, remove a
``set_magic_quotes_runtime(0);`` statement that you might find near
the end of your configuration file.rxhFj^hGhJhLhhN}ry(hT]rzhV]r{hR]r|hP]r}hX]r~uh[Kh\hh?]r(hyXSimply copy rr}r(hDXSimply copy rhFjvubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjvh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX from your previous installation into
the newly unpacked one. Configuration files from old versions may
require some tweaking as some options have been changed or removed.
For compatibility with PHP 6, remove a
rr}r(hDX from your previous installation into
the newly unpacked one. Configuration files from old versions may
require some tweaking as some options have been changed or removed.
For compatibility with PHP 6, remove a
rhFjvubjC)r}r(hDX ``set_magic_quotes_runtime(0);``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjvh?]rhyXset_magic_quotes_runtime(0);rr}r(hDUhFjubahLjQubhyXG statement that you might find near
the end of your configuration file.rr}r(hDXG statement that you might find near
the end of your configuration file.rhFjvubeubh})r}r(hDXYou should **not** copy :file:`libraries/config.default.php` over
:file:`config.inc.php` because the default configuration file is version-
specific.rhFj^hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r(hyXYou should rr}r(hDXYou should rhFjubj)r}r(hDX**not**rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXnotrr}r(hDUhFjubahLjubhyX copy rr}r(hDX copy rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXlibraries/config.default.phprr}r(hDXlibraries/config.default.phprhFjubahLjQubhyX over
rr}r(hDX over
rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX= because the default configuration file is version-
specific.rr}r(hDX= because the default configuration file is version-
specific.rhFjubeubh})r}r(hDXIf you have upgraded your MySQL server from a version previous to 4.1.2 to
version 5.x or newer and if you use the phpMyAdmin configuration storage, you
should run the :term:`SQL` script found in
:file:`examples/upgrade_tables_mysql_4_1_2+.sql`.rhFj^hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Kh\hh?]r(hyXIf you have upgraded your MySQL server from a version previous to 4.1.2 to
version 5.x or newer and if you use the phpMyAdmin configuration storage, you
should run the rr}r(hDXIf you have upgraded your MySQL server from a version previous to 4.1.2 to
version 5.x or newer and if you use the phpMyAdmin configuration storage, you
should run the rhFjubh)r}r(hDX:term:`SQL`rhFjhGhJhLhhN}r(UreftyperXtermr	hhXsqlr	U	refdomainr	Xstdr	hP]r	hR]r	Urefexplicitr	hT]r	hV]r	hX]r		hhuh[Kh?]r
	h)r	}r	(hDjhN}r
	(hT]r	hV]r	(hj	Xstd-termr	ehR]r	hP]r	hX]r	uhFjh?]r	hyXSQLr	r	}r	(hDUhFj	ubahLhubaubhyX script found in
r	r	}r	(hDX script found in
r	hFjubjC)r	}r	(hDUhN}r	(hP]r	hR]r 	hT]r!	hV]r"	Xfiler#	aUroler$	j#	hX]r%	uhFjh?]r&	hyX(examples/upgrade_tables_mysql_4_1_2+.sqlr'	r(	}r)	(hDX(examples/upgrade_tables_mysql_4_1_2+.sqlr*	hFj	ubahLjQubhyX.r+	}r,	(hDX.hFjubeubje)r-	}r.	(hDUhFj^hGhJhLjhhN}r/	(hP]r0	hR]r1	hT]r2	hV]r3	hX]r4	jo]r5	(jqXAuthentication modeUindex-2r6	Utr7	ajtuh[Kh\hh?]r8	ubhA)r9	}r:	(hDUhFj^hGhJhLhMhN}r;	(hP]r<	hR]r=	hT]r>	hV]r?	hX]r@	hZj6	uh[Kh\hh?]rA	ubhA)rB	}rC	(hDX.. _authentication_modes:rD	hFj^hGhJha}rE	hLhMhN}rF	(hP]rG	hR]rH	hT]rI	hV]rJ	hX]rK	hZh.uh[Kh\hhj}rL	j6	j9	sh?]rM	ubeubh^)rN	}rO	(hDUhFh_hGhJha}rP	h
jB	shLhchN}rQ	(hT]rR	hV]rS	hR]rT	hP]rU	(h5h.j6	ehX]rV	(hh
euh[Kh\hhj}rW	(h.jB	j6	j9	uh?]rX	(hm)rY	}rZ	(hDXUsing authentication modesr[	hFjN	hGhJhLhqhN}r\	(hT]r]	hV]r^	hR]r_	hP]r`	hX]ra	uh[Kh\hh?]rb	hyXUsing authentication modesrc	rd	}re	(hDj[	hFjY	ubaubh})rf	}rg	(hDX:term:`HTTP` and cookie authentication modes are recommended in a **multi-user
environment** where you want to give users access to their own database and
don't want them to play around with others. Nevertheless be aware that MS
Internet Explorer seems to be really buggy about cookies, at least till version
6. Even in a **single-user environment**, you might prefer to use :term:`HTTP`
or cookie mode so that your user/password pair are not in clear in the
configuration file.rh	hFjN	hGhJhLhhN}ri	(hT]rj	hV]rk	hR]rl	hP]rm	hX]rn	uh[Kh\hh?]ro	(h)rp	}rq	(hDX:term:`HTTP`rr	hFjf	hGhJhLhhN}rs	(Ureftypert	Xtermru	hhXhttprv	U	refdomainrw	Xstdrx	hP]ry	hR]rz	Urefexplicitr{	hT]r|	hV]r}	hX]r~	hhuh[Kh?]r	h)r	}r	(hDjr	hN}r	(hT]r	hV]r	(hjx	Xstd-termr	ehR]r	hP]r	hX]r	uhFjp	h?]r	hyXHTTPr	r	}r	(hDUhFj	ubahLhubaubhyX6 and cookie authentication modes are recommended in a r	r	}r	(hDX6 and cookie authentication modes are recommended in a r	hFjf	ubj)r	}r	(hDX**multi-user
environment**r	hN}r	(hT]r	hV]r	hR]r	hP]r	hX]r	uhFjf	h?]r	hyXmulti-user
environmentr	r	}r	(hDUhFj	ubahLjubhyX where you want to give users access to their own database and
don't want them to play around with others. Nevertheless be aware that MS
Internet Explorer seems to be really buggy about cookies, at least till version
6. Even in a r	r	}r	(hDX where you want to give users access to their own database and
don't want them to play around with others. Nevertheless be aware that MS
Internet Explorer seems to be really buggy about cookies, at least till version
6. Even in a r	hFjf	ubj)r	}r	(hDX**single-user environment**r	hN}r	(hT]r	hV]r	hR]r	hP]r	hX]r	uhFjf	h?]r	hyXsingle-user environmentr	r	}r	(hDUhFj	ubahLjubhyX, you might prefer to use r	r	}r	(hDX, you might prefer to use r	hFjf	ubh)r	}r	(hDX:term:`HTTP`r	hFjf	hGhJhLhhN}r	(Ureftyper	Xtermr	hhXhttpr	U	refdomainr	Xstdr	hP]r	hR]r	Urefexplicitr	hT]r	hV]r	hX]r	hhuh[Kh?]r	h)r	}r	(hDj	hN}r	(hT]r	hV]r	(hj	Xstd-termr	ehR]r	hP]r	hX]r	uhFj	h?]r	hyXHTTPr	r	}r	(hDUhFj	ubahLhubaubhyX[
or cookie mode so that your user/password pair are not in clear in the
configuration file.r	r	}r	(hDX[
or cookie mode so that your user/password pair are not in clear in the
configuration file.r	hFjf	ubeubh})r	}r	(hDX:term:`HTTP` and cookie authentication
modes are more secure: the MySQL login information does not need to be
set in the phpMyAdmin configuration file (except possibly for the
:config:option:`$cfg['Servers'][$i]['controluser']`).
However, keep in mind that the password travels in plain text, unless
you are using the HTTPS protocol. In cookie mode, the password is
stored, encrypted with the blowfish algorithm, in a temporary cookie.r	hFjN	hGhJhLhhN}r	(hT]r	hV]r	hR]r	hP]r	hX]r	uh[Kh\hh?]r	(h)r	}r	(hDX:term:`HTTP`r	hFj	hGhJhLhhN}r	(Ureftyper	Xtermr	hhXhttpr	U	refdomainr	Xstdr	hP]r	hR]r	Urefexplicitr	hT]r	hV]r	hX]r	hhuh[Kh?]r	h)r	}r	(hDj	hN}r	(hT]r	hV]r	(hj	Xstd-termr	ehR]r	hP]r	hX]r	uhFj	h?]r	hyXHTTPr	r	}r	(hDUhFj	ubahLhubaubhyX and cookie authentication
modes are more secure: the MySQL login information does not need to be
set in the phpMyAdmin configuration file (except possibly for the
r	r	}r	(hDX and cookie authentication
modes are more secure: the MySQL login information does not need to be
set in the phpMyAdmin configuration file (except possibly for the
r	hFj	ubje)r	}r
(hDUhN}r
(hP]r
hR]r
hT]r
hV]r
hX]r
jo]r
((jqX"$cfg['Servers'][$i]['controluser']r
Uindex-3r	
j
tr

(jqX8configuration option; $cfg['Servers'][$i]['controluser']j	
j
tr
euhFj	h?]r
hLjhubhA)r
}r
(hDUhN}r
(hT]r
hV]r
hR]r
hP]r
j	
ahX]r
uhFj	h?]r
hLhMubh)r
}r
(hDX3:config:option:`$cfg['Servers'][$i]['controluser']`r
hFj	hGhJhLhhN}r
(Ureftyper
Xoptionr
hhj
U	refdomainr
Xconfigr
hP]r
hR]r
Urefexplicitr 
hT]r!
hV]r"
hX]r#
hhuh[Kh?]r$
jC)r%
}r&
(hDj
hN}r'
(hT]r(
hV]r)
(hj
X
config-optionr*
ehR]r+
hP]r,
hX]r-
uhFj
h?]r.
hyX"$cfg['Servers'][$i]['controluser']r/
r0
}r1
(hDUhFj%
ubahLjQubaubhyX).
However, keep in mind that the password travels in plain text, unless
you are using the HTTPS protocol. In cookie mode, the password is
stored, encrypted with the blowfish algorithm, in a temporary cookie.r2
r3
}r4
(hDX).
However, keep in mind that the password travels in plain text, unless
you are using the HTTPS protocol. In cookie mode, the password is
stored, encrypted with the blowfish algorithm, in a temporary cookie.r5
hFj	ubeubcdocutils.nodes
comment
r6
)r7
}r8
(hDXenote:

This section is only applicable if your MySQL server is running
with ``--skip-show-database``.r9
hFjN	hGhJhLUcommentr:
hN}r;
(jjhP]r<
hR]r=
hT]r>
hV]r?
hX]r@
uh[Kh\hh?]rA
hyXenote:

This section is only applicable if your MySQL server is running
with ``--skip-show-database``.rB
rC
}rD
(hDUhFj7
ubaubh})rE
}rF
(hDXFor ':term:`HTTP`' and 'cookie' modes, phpMyAdmin needs a controluser that has
**only** the ``SELECT`` privilege on the *`mysql`.`user` (all columns except
`Password`)*, *`mysql`.`db` (all columns)*, *`mysql`.`host` (all columns)* and
*`mysql`.`tables\_priv` (all columns except `Grantor` and `Timestamp`)* tables.
You must specify the details for the controluser in the :file:`config.inc.php`
file under the :config:option:`$cfg['Servers'][$i]['controluser']` and
:config:option:`$cfg['Servers'][$i]['controlpass']` settings. The following
example assumes you want to use ``pma`` as the controluser and ``pmapass`` as
the controlpass, but **this is only an example: use something else in your
file!** Input these statements from the phpMyAdmin :term:`SQL` Query window or
mysql command–line client. Of course you have to replace ``localhost`` with the
webserver's host if it's not the same as the MySQL server's one.rG
hFjN	hGhJhLhhN}rH
(hT]rI
hV]rJ
hR]rK
hP]rL
hX]rM
uh[Kh\hh?]rN
(hyXFor 'rO
rP
}rQ
(hDXFor 'rR
hFjE
ubh)rS
}rT
(hDX:term:`HTTP`rU
hFjE
hGhJhLhhN}rV
(UreftyperW
XtermrX
hhXhttprY
U	refdomainrZ
Xstdr[
hP]r\
hR]r]
Urefexplicitr^
hT]r_
hV]r`
hX]ra
hhuh[Kh?]rb
h)rc
}rd
(hDjU
hN}re
(hT]rf
hV]rg
(hj[
Xstd-termrh
ehR]ri
hP]rj
hX]rk
uhFjS
h?]rl
hyXHTTPrm
rn
}ro
(hDUhFjc
ubahLhubaubhyX>' and 'cookie' modes, phpMyAdmin needs a controluser that has
rp
rq
}rr
(hDX>' and 'cookie' modes, phpMyAdmin needs a controluser that has
rs
hFjE
ubj)rt
}ru
(hDX**only**rv
hN}rw
(hT]rx
hV]ry
hR]rz
hP]r{
hX]r|
uhFjE
h?]r}
hyXonlyr~
r
}r
(hDUhFjt
ubahLjubhyX the r
r
}r
(hDX the r
hFjE
ubjC)r
}r
(hDX
``SELECT``r
hN}r
(hT]r
hV]r
hR]r
hP]r
hX]r
uhFjE
h?]r
hyXSELECTr
r
}r
(hDUhFj
ubahLjQubhyX privilege on the r
r
}r
(hDX privilege on the r
hFjE
ubh)r
}r
(hDX0*`mysql`.`user` (all columns except
`Password`)*r
hN}r
(hT]r
hV]r
hR]r
hP]r
hX]r
uhFjE
h?]r
hyX.`mysql`.`user` (all columns except
`Password`)r
r
}r
(hDUhFj
ubahLhubhyX, r
r
}r
(hDX, r
hFjE
ubh)r
}r
(hDX*`mysql`.`db` (all columns)*r
hN}r
(hT]r
hV]r
hR]r
hP]r
hX]r
uhFjE
h?]r
hyX`mysql`.`db` (all columns)r
r
}r
(hDUhFj
ubahLhubhyX, r
r
}r
(hDX, r
hFjE
ubh)r
}r
(hDX*`mysql`.`host` (all columns)*r
hN}r
(hT]r
hV]r
hR]r
hP]r
hX]r
uhFjE
h?]r
hyX`mysql`.`host` (all columns)r
r
}r
(hDUhFj
ubahLhubhyX and
r
r
}r
(hDX and
r
hFjE
ubh)r
}r
(hDXG*`mysql`.`tables\_priv` (all columns except `Grantor` and `Timestamp`)*r
hN}r
(hT]r
hV]r
hR]r
hP]r
hX]r
uhFjE
h?]r
hyXD`mysql`.`tables_priv` (all columns except `Grantor` and `Timestamp`)r
r
}r
(hDUhFj
ubahLhubhyXA tables.
You must specify the details for the controluser in the r
r
}r
(hDXA tables.
You must specify the details for the controluser in the r
hFjE
ubjC)r
}r
(hDUhN}r
(hP]r
hR]r
hT]r
hV]r
Xfiler
aUroler
j
hX]r
uhFjE
h?]r
hyXconfig.inc.phpr
r
}r
(hDXconfig.inc.phpr
hFj
ubahLjQubhyX
file under the r
r
}r
(hDX
file under the r
hFjE
ubje)r
}r
(hDUhN}r
(hP]r
hR]r
hT]r
hV]r
hX]r
jo]r
((jqX"$cfg['Servers'][$i]['controluser']r
Uindex-4r
j
tr
(jqX8configuration option; $cfg['Servers'][$i]['controluser']j
j
tr
euhFjE
h?]r
hLjhubhA)r
}r
(hDUhN}r
(hT]r
hV]r
hR]rhP]rj
ahX]ruhFjE
h?]rhLhMubh)r}r(hDX3:config:option:`$cfg['Servers'][$i]['controluser']`rhFjE
hGhJhLhhN}r(UreftyperXoptionr	hhj
U	refdomainr
XconfigrhP]rhR]r
UrefexplicitrhT]rhV]rhX]rhhuh[Kh?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX
config-optionrehR]rhP]rhX]ruhFjh?]rhyX"$cfg['Servers'][$i]['controluser']rr}r(hDUhFjubahLjQubaubhyX and
r r!}r"(hDX and
r#hFjE
ubje)r$}r%(hDUhN}r&(hP]r'hR]r(hT]r)hV]r*hX]r+jo]r,((jqX"$cfg['Servers'][$i]['controlpass']r-Uindex-5r.j-tr/(jqX8configuration option; $cfg['Servers'][$i]['controlpass']j.j-tr0euhFjE
h?]r1hLjhubhA)r2}r3(hDUhN}r4(hT]r5hV]r6hR]r7hP]r8j.ahX]r9uhFjE
h?]r:hLhMubh)r;}r<(hDX3:config:option:`$cfg['Servers'][$i]['controlpass']`r=hFjE
hGhJhLhhN}r>(Ureftyper?Xoptionr@hhj-U	refdomainrAXconfigrBhP]rChR]rDUrefexplicitrEhT]rFhV]rGhX]rHhhuh[Kh?]rIjC)rJ}rK(hDj=hN}rL(hT]rMhV]rN(hjBX
config-optionrOehR]rPhP]rQhX]rRuhFj;h?]rShyX"$cfg['Servers'][$i]['controlpass']rTrU}rV(hDUhFjJubahLjQubaubhyX9 settings. The following
example assumes you want to use rWrX}rY(hDX9 settings. The following
example assumes you want to use rZhFjE
ubjC)r[}r\(hDX``pma``r]hN}r^(hT]r_hV]r`hR]rahP]rbhX]rcuhFjE
h?]rdhyXpmarerf}rg(hDUhFj[ubahLjQubhyX as the controluser and rhri}rj(hDX as the controluser and rkhFjE
ubjC)rl}rm(hDX``pmapass``rnhN}ro(hT]rphV]rqhR]rrhP]rshX]rtuhFjE
h?]ruhyXpmapassrvrw}rx(hDUhFjlubahLjQubhyX as
the controlpass, but ryrz}r{(hDX as
the controlpass, but r|hFjE
ubj)r}}r~(hDX=**this is only an example: use something else in your
file!**rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjE
h?]rhyX9this is only an example: use something else in your
file!rr}r(hDUhFj}ubahLjubhyX, Input these statements from the phpMyAdmin rr}r(hDX, Input these statements from the phpMyAdmin rhFjE
ubh)r}r(hDX:term:`SQL`rhFjE
hGhJhLhhN}r(UreftyperXtermrhhXsqlrU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[Kh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-termrehR]rhP]rhX]ruhFjh?]rhyXSQLrr}r(hDUhFjubahLhubaubhyXL Query window or
mysql command–line client. Of course you have to replace rr}r(hDXL Query window or
mysql command–line client. Of course you have to replace rhFjE
ubjC)r}r(hDX
``localhost``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjE
h?]rhyX	localhostrr}r(hDUhFjubahLjQubhyXJ with the
webserver's host if it's not the same as the MySQL server's one.rr}r(hDXJ with the
webserver's host if it's not the same as the MySQL server's one.rhFjE
ubeubh})r}r(hDXIf you want to use the many new relation and bookmark features:  (this of
course requires that your :ref:`linked-tables` be set up).rhFjN	hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[M
h\hh?]r(hyXdIf you want to use the many new relation and bookmark features:  (this of
course requires that your rr}r(hDXdIf you want to use the many new relation and bookmark features:  (this of
course requires that your rhFjubh)r}r(hDX:ref:`linked-tables`rhFjhGhJhLhhN}r(UreftyperXrefrhhX
linked-tablesrU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[M
h?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFjh?]rhyX
linked-tablesrr}r(hDUhFjubahLhubaubhyX be set up).rr}r(hDX be set up).rhFjubeubj)r}r(hDX|GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';
GRANT SELECT (
Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
Execute_priv, Repl_slave_priv, Repl_client_priv
) ON mysql.user TO 'pma'@'localhost';
GRANT SELECT ON mysql.db TO 'pma'@'localhost';
GRANT SELECT ON mysql.host TO 'pma'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
ON mysql.tables_priv TO 'pma'@'localhost';rhFjN	hGhJhLjhN}r(j
jXmysqlrjjhP]rhR]rhT]rhV]rhX]ruh[M
h\hh?]rhyX|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';rr}r(hDUhFjubaubh})r}r(hDX?If you want to use the many new relation and bookmark features:rhFjN	hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mh\hh?]rhyX?If you want to use the many new relation and bookmark features:rr}r	(hDjhFjubaubj)r
}r(hDXHGRANT SELECT, INSERT, UPDATE, DELETE ON <pma_db>.* TO 'pma'@'localhost';rhFjN	hGhJhLjhN}r
(j
jXmysqlrjjhP]rhR]rhT]rhV]rhX]ruh[Mh\hh?]rhyXHGRANT SELECT, INSERT, UPDATE, DELETE ON <pma_db>.* TO 'pma'@'localhost';rr}r(hDUhFj
ubaubh})r}r(hDXO(this of course requires that your phpMyAdmin
configuration storage be set up).rhFjN	hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]r uh[M"h\hh?]r!hyXO(this of course requires that your phpMyAdmin
configuration storage be set up).r"r#}r$(hDjhFjubaubh})r%}r&(hDXfThen each of the *true* users should be granted a set of privileges
on a set of particular databases. Normally you shouldn't give global
privileges to an ordinary user, unless you understand the impact of those
privileges (for example, you are creating a superuser).
For example, to grant the user *real_user* with all privileges on
the database *user_base*:r'hFjN	hGhJhLhhN}r((hT]r)hV]r*hR]r+hP]r,hX]r-uh[M%h\hh?]r.(hyXThen each of the r/r0}r1(hDXThen each of the r2hFj%ubh)r3}r4(hDX*true*r5hN}r6(hT]r7hV]r8hR]r9hP]r:hX]r;uhFj%h?]r<hyXtruer=r>}r?(hDUhFj3ubahLhubhyX users should be granted a set of privileges
on a set of particular databases. Normally you shouldn't give global
privileges to an ordinary user, unless you understand the impact of those
privileges (for example, you are creating a superuser).
For example, to grant the user r@rA}rB(hDX users should be granted a set of privileges
on a set of particular databases. Normally you shouldn't give global
privileges to an ordinary user, unless you understand the impact of those
privileges (for example, you are creating a superuser).
For example, to grant the user rChFj%ubh)rD}rE(hDX*real_user*rFhN}rG(hT]rHhV]rIhR]rJhP]rKhX]rLuhFj%h?]rMhyX	real_userrNrO}rP(hDUhFjDubahLhubhyX% with all privileges on
the database rQrR}rS(hDX% with all privileges on
the database rThFj%ubh)rU}rV(hDX*user_base*rWhN}rX(hT]rYhV]rZhR]r[hP]r\hX]r]uhFj%h?]r^hyX	user_baser_r`}ra(hDUhFjUubahLhubhyX:rb}rc(hDX:hFj%ubeubj)rd}re(hDX[GRANT ALL PRIVILEGES ON user_base.* TO 'real_user'@localhost IDENTIFIED BY 'real_password';rfhFjN	hGhJhLjhN}rg(j
jXmysqlrhjjhP]rihR]rjhT]rkhV]rlhX]rmuh[M,h\hh?]rnhyX[GRANT ALL PRIVILEGES ON user_base.* TO 'real_user'@localhost IDENTIFIED BY 'real_password';rorp}rq(hDUhFjdubaubh})rr}rs(hDXWhat the user may now do is controlled entirely by the MySQL user management
system. With HTTP or cookie authentication mode, you don't need to fill the
user/password fields inside the :config:option:`$cfg['Servers']`.rthFjN	hGhJhLhhN}ru(hT]rvhV]rwhR]rxhP]ryhX]rzuh[M1h\hh?]r{(hyXWhat the user may now do is controlled entirely by the MySQL user management
system. With HTTP or cookie authentication mode, you don't need to fill the
user/password fields inside the r|r}}r~(hDXWhat the user may now do is controlled entirely by the MySQL user management
system. With HTTP or cookie authentication mode, you don't need to fill the
user/password fields inside the rhFjrubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX$cfg['Servers']rUindex-6rjtr(jqX%configuration option; $cfg['Servers']jjtreuhFjrh?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFjrh?]rhLhMubh)r}r(hDX :config:option:`$cfg['Servers']`rhFjrhGhJhLhhN}r(UreftyperXoptionrhhjU	refdomainrXconfigrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[M1h?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX
config-optionrehR]rhP]rhX]ruhFjh?]rhyX$cfg['Servers']rr}r(hDUhFjubahLjQubaubhyX.r}r(hDX.hFjrubeubje)r}r(hDUhFjN	hGhJhLjhhN}r(hP]rhR]rhT]rhV]rhX]rjo]r(UpairrXHTTP; Authentication modeUindex-7rUtrajtuh[M6h\hh?]rubhA)r}r(hDUhFjN	hGhJhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZjuh[M6h\hh?]rubh^)r}r(hDUhFjN	hGhJha}rhLhchN}r(hT]rhV]rhR]rhP]r(h1jehX]rhauh[M8h\hhj}rjjsh?]r(hm)r}r(hDXHTTP authentication moderhFjhGhJhLhqhN}r(hT]rhV]rhR]rhP]rhX]ruh[M8h\hh?]rhyXHTTP authentication moderr}r(hDjhFjubaubcdocutils.nodes
bullet_list
r)r}r(hDUhFjhGhJhLUbullet_listrhN}r(UbulletrX*hP]rhR]rhT]rhV]rhX]ruh[M:h\hh?]r(j)r}r(hDX_Uses :term:`HTTP` Basic authentication
method and allows you to log in as any valid MySQL user.rhFjhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDX_Uses :term:`HTTP` Basic authentication
method and allows you to log in as any valid MySQL user.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]r
hX]r
uh[M:h?]r
(hyXUses r
r
}r
(hDXUses r
hFjubh)r
}r
(hDX:term:`HTTP`r	
hFjhGhJhLhhN}r

(Ureftyper
Xtermr
hhXhttpr

U	refdomainr
Xstdr
hP]r
hR]r
Urefexplicitr
hT]r
hV]r
hX]r
hhuh[M:h?]r
h)r
}r
(hDj	
hN}r
(hT]r
hV]r
(hj
Xstd-termr
ehR]r
hP]r
hX]r
uhFj
h?]r 
hyXHTTPr!
r"
}r#
(hDUhFj
ubahLhubaubhyXN Basic authentication
method and allows you to log in as any valid MySQL user.r$
r%
}r&
(hDXN Basic authentication
method and allows you to log in as any valid MySQL user.r'
hFjubeubaubj)r(
}r)
(hDXIs supported with most PHP configurations. For :term:`IIS` (:term:`ISAPI`)
support using :term:`CGI` PHP see :ref:`faq1_32`, for using with Apache
:term:`CGI` see :ref:`faq1_35`.r*
hFjhGhJhLjhN}r+
(hT]r,
hV]r-
hR]r.
hP]r/
hX]r0
uh[Nh\hh?]r1
h})r2
}r3
(hDXIs supported with most PHP configurations. For :term:`IIS` (:term:`ISAPI`)
support using :term:`CGI` PHP see :ref:`faq1_32`, for using with Apache
:term:`CGI` see :ref:`faq1_35`.r4
hFj(
hGhJhLhhN}r5
(hT]r6
hV]r7
hR]r8
hP]r9
hX]r:
uh[M<h?]r;
(hyX/Is supported with most PHP configurations. For r<
r=
}r>
(hDX/Is supported with most PHP configurations. For r?
hFj2
ubh)r@
}rA
(hDX:term:`IIS`rB
hFj2
hGhJhLhhN}rC
(UreftyperD
XtermrE
hhXiisrF
U	refdomainrG
XstdrH
hP]rI
hR]rJ
UrefexplicitrK
hT]rL
hV]rM
hX]rN
hhuh[M<h?]rO
h)rP
}rQ
(hDjB
hN}rR
(hT]rS
hV]rT
(hjH
Xstd-termrU
ehR]rV
hP]rW
hX]rX
uhFj@
h?]rY
hyXIISrZ
r[
}r\
(hDUhFjP
ubahLhubaubhyX (r]
r^
}r_
(hDX (r`
hFj2
ubh)ra
}rb
(hDX
:term:`ISAPI`rc
hFj2
hGhJhLhhN}rd
(Ureftypere
Xtermrf
hhXisapirg
U	refdomainrh
Xstdri
hP]rj
hR]rk
Urefexplicitrl
hT]rm
hV]rn
hX]ro
hhuh[M<h?]rp
h)rq
}rr
(hDjc
hN}rs
(hT]rt
hV]ru
(hji
Xstd-termrv
ehR]rw
hP]rx
hX]ry
uhFja
h?]rz
hyXISAPIr{
r|
}r}
(hDUhFjq
ubahLhubaubhyX)
support using r~
r
}r
(hDX)
support using r
hFj2
ubh)r
}r
(hDX:term:`CGI`r
hFj2
hGhJhLhhN}r
(Ureftyper
Xtermr
hhXcgir
U	refdomainr
Xstdr
hP]r
hR]r
Urefexplicitr
hT]r
hV]r
hX]r
hhuh[M<h?]r
h)r
}r
(hDj
hN}r
(hT]r
hV]r
(hj
Xstd-termr
ehR]r
hP]r
hX]r
uhFj
h?]r
hyXCGIr
r
}r
(hDUhFj
ubahLhubaubhyX	 PHP see r
r
}r
(hDX	 PHP see r
hFj2
ubh)r
}r
(hDX:ref:`faq1_32`r
hFj2
hGhJhLhhN}r
(Ureftyper
Xrefr
hhXfaq1_32r
U	refdomainr
Xstdr
hP]r
hR]r
Urefexplicitr
hT]r
hV]r
hX]r
hhuh[M<h?]r
h)r
}r
(hDj
hN}r
(hT]r
hV]r
(hj
Xstd-refr
ehR]r
hP]r
hX]r
uhFj
h?]r
hyXfaq1_32r
r
}r
(hDUhFj
ubahLhubaubhyX, for using with Apache
r
r
}r
(hDX, for using with Apache
r
hFj2
ubh)r
}r
(hDX:term:`CGI`r
hFj2
hGhJhLhhN}r
(Ureftyper
Xtermr
hhXcgir
U	refdomainr
Xstdr
hP]r
hR]r
Urefexplicitr
hT]r
hV]r
hX]r
hhuh[M<h?]r
h)r
}r
(hDj
hN}r
(hT]r
hV]r
(hj
Xstd-termr
ehR]r
hP]r
hX]r
uhFj
h?]r
hyXCGIr
r
}r
(hDUhFj
ubahLhubaubhyX see r
r
}r
(hDX see r
hFj2
ubh)r
}r
(hDX:ref:`faq1_35`r
hFj2
hGhJhLhhN}r
(Ureftyper
Xrefr
hhXfaq1_35r
U	refdomainr
Xstdr
hP]r
hR]r
Urefexplicitr
hT]r
hV]r
hX]r
hhuh[M<h?]r
h)r
}r
(hDj
hN}r
(hT]r
hV]r
(hj
Xstd-refr
ehR]r
hP]r
hX]r
uhFj
h?]r
hyXfaq1_35r
r}r(hDUhFj
ubahLhubaubhyX.r}r(hDX.hFj2
ubeubaubj)r}r(hDXvSee also :ref:`faq4_4` about not using the :term:`.htaccess` mechanism along with
':term:`HTTP`' authentication mode.
rhFjhGhJhLjhN}r(hT]rhV]r	hR]r
hP]rhX]ruh[Nh\hh?]r
h})r}r(hDXuSee also :ref:`faq4_4` about not using the :term:`.htaccess` mechanism along with
':term:`HTTP`' authentication mode.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[M?h?]r(hyX	See also rr}r(hDX	See also rhFjubh)r}r(hDX
:ref:`faq4_4`rhFjhGhJhLhhN}r(Ureftyper Xrefr!hhXfaq4_4r"U	refdomainr#Xstdr$hP]r%hR]r&Urefexplicitr'hT]r(hV]r)hX]r*hhuh[M?h?]r+h)r,}r-(hDjhN}r.(hT]r/hV]r0(hj$Xstd-refr1ehR]r2hP]r3hX]r4uhFjh?]r5hyXfaq4_4r6r7}r8(hDUhFj,ubahLhubaubhyX about not using the r9r:}r;(hDX about not using the r<hFjubh)r=}r>(hDX:term:`.htaccess`r?hFjhGhJhLhhN}r@(UreftyperAXtermrBhhX	.htaccessrCU	refdomainrDXstdrEhP]rFhR]rGUrefexplicitrHhT]rIhV]rJhX]rKhhuh[M?h?]rLh)rM}rN(hDj?hN}rO(hT]rPhV]rQ(hjEXstd-termrRehR]rShP]rThX]rUuhFj=h?]rVhyX	.htaccessrWrX}rY(hDUhFjMubahLhubaubhyX mechanism along with
'rZr[}r\(hDX mechanism along with
'r]hFjubh)r^}r_(hDX:term:`HTTP`r`hFjhGhJhLhhN}ra(UreftyperbXtermrchhXhttprdU	refdomainreXstdrfhP]rghR]rhUrefexplicitrihT]rjhV]rkhX]rlhhuh[M?h?]rmh)rn}ro(hDj`hN}rp(hT]rqhV]rr(hjfXstd-termrsehR]rthP]ruhX]rvuhFj^h?]rwhyXHTTPrxry}rz(hDUhFjnubahLhubaubhyX' authentication mode.r{r|}r}(hDX' authentication mode.r~hFjubeubaubeubje)r}r(hDUhFjhGhJhLjhhN}r(hP]rhR]rhT]rhV]rhX]rjo]r(jXCookie; Authentication modeUindex-8rUtrajtuh[MCh\hh?]rubhA)r}r(hDUhFjhGhJhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZjuh[MCh\hh?]rubhA)r}r(hDX.. _cookie:rhFjhGhJha}rhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZh3uh[MDh\hhj}rjjsh?]rubeubh^)r}r(hDUhFjN	hGhJha}rhjshLhchN}r(hT]rhV]rhR]rhP]r(h=h3jehX]r(hheuh[MGh\hhj}r(jjh3juh?]r(hm)r}r(hDXCookie authentication moderhFjhGhJhLhqhN}r(hT]rhV]rhR]rhP]rhX]ruh[MGh\hh?]rhyXCookie authentication moderr}r(hDjhFjubaubj)r}r(hDUhFjhGhJhLjhN}r(jX*hP]rhR]rhT]rhV]rhX]ruh[MIh\hh?]r(j)r}r(hDXzYou can use this method as a replacement for the :term:`HTTP` authentication
(for example, if you're running :term:`IIS`).rhFjhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXzYou can use this method as a replacement for the :term:`HTTP` authentication
(for example, if you're running :term:`IIS`).rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[MIh?]r(hyX1You can use this method as a replacement for the rr}r(hDX1You can use this method as a replacement for the rhFjubh)r}r(hDX:term:`HTTP`rhFjhGhJhLhhN}r(UreftyperXtermrhhXhttprU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[MIh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-termrehR]rhP]rhX]ruhFjh?]rhyXHTTPrr}r(hDUhFjubahLhubaubhyX0 authentication
(for example, if you're running rr}r(hDX0 authentication
(for example, if you're running rhFjubh)r}r(hDX:term:`IIS`rhFjhGhJhLhhN}r(UreftyperXtermrhhXiisrU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[MIh?]r	h)r
}r(hDjhN}r(hT]r
hV]r(hjXstd-termrehR]rhP]rhX]ruhFjh?]rhyXIISrr}r(hDUhFj
ubahLhubaubhyX).rr}r(hDX).rhFjubeubaubj)r}r(hDXsObviously, the user must enable cookies in the browser, but this is
now a requirement for all authentication modes.rhFjhGhJhLjhN}r(hT]rhV]r hR]r!hP]r"hX]r#uh[Nh\hh?]r$h})r%}r&(hDXsObviously, the user must enable cookies in the browser, but this is
now a requirement for all authentication modes.r'hFjhGhJhLhhN}r((hT]r)hV]r*hR]r+hP]r,hX]r-uh[MKh?]r.hyXsObviously, the user must enable cookies in the browser, but this is
now a requirement for all authentication modes.r/r0}r1(hDj'hFj%ubaubaubj)r2}r3(hDX`With this mode, the user can truly log out of phpMyAdmin and log in
back with the same username.r4hFjhGhJhLjhN}r5(hT]r6hV]r7hR]r8hP]r9hX]r:uh[Nh\hh?]r;h})r<}r=(hDX`With this mode, the user can truly log out of phpMyAdmin and log in
back with the same username.r>hFj2hGhJhLhhN}r?(hT]r@hV]rAhR]rBhP]rChX]rDuh[MMh?]rEhyX`With this mode, the user can truly log out of phpMyAdmin and log in
back with the same username.rFrG}rH(hDj>hFj<ubaubaubj)rI}rJ(hDXfIf you want to log in to arbitrary server see :config:option:`$cfg['AllowArbitraryServer']` directive.rKhFjhGhJhLjhN}rL(hT]rMhV]rNhR]rOhP]rPhX]rQuh[Nh\hh?]rRh})rS}rT(hDjKhFjIhGhJhLhhN}rU(hT]rVhV]rWhR]rXhP]rYhX]rZuh[MOh?]r[(hyX.If you want to log in to arbitrary server see r\r]}r^(hDX.If you want to log in to arbitrary server see r_hFjSubje)r`}ra(hDUhN}rb(hP]rchR]rdhT]rehV]rfhX]rgjo]rh((jqX$cfg['AllowArbitraryServer']riUindex-9rjjitrk(jqX2configuration option; $cfg['AllowArbitraryServer']jjjitrleuhFjSh?]rmhLjhubhA)rn}ro(hDUhN}rp(hT]rqhV]rrhR]rshP]rtjjahX]ruuhFjSh?]rvhLhMubh)rw}rx(hDX-:config:option:`$cfg['AllowArbitraryServer']`ryhFjShGhJhLhhN}rz(Ureftyper{Xoptionr|hhjiU	refdomainr}Xconfigr~hP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[MOh?]rjC)r}r(hDjyhN}r(hT]rhV]r(hj~X
config-optionrehR]rhP]rhX]ruhFjwh?]rhyX$cfg['AllowArbitraryServer']rr}r(hDUhFjubahLjQubaubhyX directive.rr}r(hDX directive.rhFjSubeubaubj)r}r(hDXAs mentioned in the :ref:`require` section, having the ``mcrypt`` extension will
speed up access considerably, but is not required.
rhFjhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXAs mentioned in the :ref:`require` section, having the ``mcrypt`` extension will
speed up access considerably, but is not required.rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[MPh?]r(hyXAs mentioned in the rr}r(hDXAs mentioned in the rhFjubh)r}r(hDX:ref:`require`rhFjhGhJhLhhN}r(UreftyperXrefrhhXrequirerU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[MPh?]rh)r}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFjh?]rhyXrequirerr}r(hDUhFjubahLhubaubhyX section, having the rr}r(hDX section, having the rhFjubjC)r}r(hDX
``mcrypt``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXmcryptrr}r(hDUhFjubahLjQubhyXB extension will
speed up access considerably, but is not required.rr}r(hDXB extension will
speed up access considerably, but is not required.rhFjubeubaubeubje)r}r(hDUhFjhGhJhLjhhN}r(hP]rhR]rhT]rhV]rhX]rjo]r(jXSignon; Authentication modeUindex-10rUtrajtuh[MTh\hh?]rubhA)r}r(hDUhFjhGhJhLhMhN}r(hP]rhR]rhT]rhV]rhX]rhZjuh[MTh\hh?]rubeubh^)r}r(hDUhFjN	hGhJha}rhLhchN}r(hT]rhV]rhR]rhP]r(h'jehX]rhauh[MVh\hhj}rjjsh?]r(hm)r}r(hDXSignon authentication moderhFjhGhJhLhqhN}r(hT]rhV]rhR]rhP]rhX]r	uh[MVh\hh?]r
hyXSignon authentication moderr}r
(hDjhFjubaubj)r}r(hDUhFjhGhJhLjhN}r(jX*hP]rhR]rhT]rhV]rhX]ruh[MXh\hh?]r(j)r}r(hDXjThis mode is a convenient way of using credentials from another
application to authenticate to phpMyAdmin.rhFjhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]r h})r!}r"(hDXjThis mode is a convenient way of using credentials from another
application to authenticate to phpMyAdmin.r#hFjhGhJhLhhN}r$(hT]r%hV]r&hR]r'hP]r(hX]r)uh[MXh?]r*hyXjThis mode is a convenient way of using credentials from another
application to authenticate to phpMyAdmin.r+r,}r-(hDj#hFj!ubaubaubj)r.}r/(hDXHThe other application has to store login information into session
data.
r0hFjhGhJhLjhN}r1(hT]r2hV]r3hR]r4hP]r5hX]r6uh[Nh\hh?]r7h})r8}r9(hDXGThe other application has to store login information into session
data.r:hFj.hGhJhLhhN}r;(hT]r<hV]r=hR]r>hP]r?hX]r@uh[MZh?]rAhyXGThe other application has to store login information into session
data.rBrC}rD(hDj:hFj8ubaubaubeubcsphinx.addnodes
seealso
rE)rF}rG(hDUhFjhGNhLUseealsorHhN}rI(hT]rJhV]rKUadmonition-see-alsorLahR]rMhP]rNhX]rOuh[Nh\hh?]rP(hm)rQ}rR(hDXSee alsorShN}rT(hT]rUhV]rVhR]rWhP]rXhX]rYuhFjFh?]rZhyXSee alsor[r\}r](hDjShFjQubahLhqubh})r^}r_(hDUhN}r`(hT]rahV]rbhR]rchP]rdhX]reuhFjFh?]rf(je)rg}rh(hDUhN}ri(hP]rjhR]rkhT]rlhV]rmhX]rnjo]ro((jqX $cfg['Servers'][$i]['auth_type']rpUindex-11rqjptrr(jqX6configuration option; $cfg['Servers'][$i]['auth_type']jqjptrseuhFj^h?]rthLjhubhA)ru}rv(hDUhN}rw(hT]rxhV]ryhR]rzhP]r{jqahX]r|uhFj^h?]r}hLhMubh)r~}r(hDX1:config:option:`$cfg['Servers'][$i]['auth_type']`rhFj^hGhJhLhhN}r(UreftyperXoptionrhhjpU	refdomainrXconfigrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[M]h?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX
config-optionrehR]rhP]rhX]ruhFj~h?]rhyX $cfg['Servers'][$i]['auth_type']rr}r(hDUhFjubahLjQubaubhyX,
rr}r(hDX,
rhFj^ubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX$$cfg['Servers'][$i]['SignonSession']rUindex-12rjtr(jqX:configuration option; $cfg['Servers'][$i]['SignonSession']jjtreuhFj^h?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFj^h?]rhLhMubh)r}r(hDX5:config:option:`$cfg['Servers'][$i]['SignonSession']`rhFj^hGhJhLhhN}r(UreftyperXoptionrhhjU	refdomainrXconfigrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[M]h?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX
config-optionrehR]rhP]rhX]ruhFjh?]rhyX$$cfg['Servers'][$i]['SignonSession']rr}r(hDUhFjubahLjQubaubhyX,
rr}r(hDX,
rhFj^ubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX#$cfg['Servers'][$i]['SignonScript']rUindex-13rjtr(jqX9configuration option; $cfg['Servers'][$i]['SignonScript']jjtreuhFj^h?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFj^h?]rhLhMubh)r}r(hDX4:config:option:`$cfg['Servers'][$i]['SignonScript']`rhFj^hGhJhLhhN}r(UreftyperXoptionrhhjU	refdomainrXconfigrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[M]h?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX
config-optionrehR]rhP]rhX]ruhFjh?]rhyX#$cfg['Servers'][$i]['SignonScript']rr}r(hDUhFjubahLjQubaubhyX,
rr	}r
(hDX,
rhFj^ubje)r}r
(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX $cfg['Servers'][$i]['SignonURL']rUindex-14rjtr(jqX6configuration option; $cfg['Servers'][$i]['SignonURL']jjtreuhFj^h?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]r jahX]r!uhFj^h?]r"hLhMubh)r#}r$(hDX1:config:option:`$cfg['Servers'][$i]['SignonURL']`r%hFj^hGhJhLhhN}r&(Ureftyper'Xoptionr(hhjU	refdomainr)Xconfigr*hP]r+hR]r,Urefexplicitr-hT]r.hV]r/hX]r0hhuh[M]h?]r1jC)r2}r3(hDj%hN}r4(hT]r5hV]r6(hj*X
config-optionr7ehR]r8hP]r9hX]r:uhFj#h?]r;hyX $cfg['Servers'][$i]['SignonURL']r<r=}r>(hDUhFj2ubahLjQubaubehLhubeubje)r?}r@(hDUhFjhGhJhLjhhN}rA(hP]rBhR]rChT]rDhV]rEhX]rFjo]rG(jXConfig; Authentication modeUindex-15rHUtrIajtuh[Meh\hh?]rJubhA)rK}rL(hDUhFjhGhJhLhMhN}rM(hP]rNhR]rOhT]rPhV]rQhX]rRhZjHuh[Meh\hh?]rSubeubh^)rT}rU(hDUhFjN	hGhJha}rVhLhchN}rW(hT]rXhV]rYhR]rZhP]r[(h2jHehX]r\hauh[Mgh\hhj}r]jHjKsh?]r^(hm)r_}r`(hDXConfig authentication moderahFjThGhJhLhqhN}rb(hT]rchV]rdhR]rehP]rfhX]rguh[Mgh\hh?]rhhyXConfig authentication moderirj}rk(hDjahFj_ubaubj)rl}rm(hDUhFjThGhJhLjhN}rn(jX*hP]rohR]rphT]rqhV]rrhX]rsuh[Mih\hh?]rt(j)ru}rv(hDXThis mode is the less secure one because it requires you to fill the
:config:option:`$cfg['Servers'][$i]['user']` and
:config:option:`$cfg['Servers'][$i]['password']`
fields (and as a result, anyone who can read your :file:`config.inc.php`
can discover your username and password).  But you don't need to setup
a "controluser" here: using the :config:option:`$cfg['Servers'][$i]['only_db']` might be enough.rwhFjlhGhJhLjhN}rx(hT]ryhV]rzhR]r{hP]r|hX]r}uh[Nh\hh?]r~h})r}r(hDXThis mode is the less secure one because it requires you to fill the
:config:option:`$cfg['Servers'][$i]['user']` and
:config:option:`$cfg['Servers'][$i]['password']`
fields (and as a result, anyone who can read your :file:`config.inc.php`
can discover your username and password).  But you don't need to setup
a "controluser" here: using the :config:option:`$cfg['Servers'][$i]['only_db']` might be enough.rhFjuhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mih?]r(hyXEThis mode is the less secure one because it requires you to fill the
rr}r(hDXEThis mode is the less secure one because it requires you to fill the
rhFjubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX$cfg['Servers'][$i]['user']rUindex-16rjtr(jqX1configuration option; $cfg['Servers'][$i]['user']jjtreuhFjh?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFjh?]rhLhMubh)r}r(hDX,:config:option:`$cfg['Servers'][$i]['user']`rhFjhGhJhLhhN}r(UreftyperXoptionrhhjU	refdomainrXconfigrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[Mih?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX
config-optionrehR]rhP]rhX]ruhFjh?]rhyX$cfg['Servers'][$i]['user']rr}r(hDUhFjubahLjQubaubhyX and
rr}r(hDX and
rhFjubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX$cfg['Servers'][$i]['password']rUindex-17rjtr(jqX5configuration option; $cfg['Servers'][$i]['password']jjtreuhFjh?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFjh?]rhLhMubh)r}r(hDX0:config:option:`$cfg['Servers'][$i]['password']`rhFjhGhJhLhhN}r(UreftyperXoptionrhhjU	refdomainrXconfigrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[Mih?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX
config-optionrehR]rhP]rhX]ruhFjh?]rhyX$cfg['Servers'][$i]['password']rr}r(hDUhFjubahLjQubaubhyX3
fields (and as a result, anyone who can read your rr}r(hDX3
fields (and as a result, anyone who can read your rhFjubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phpr	hFjubahLjQubhyXh
can discover your username and password).  But you don't need to setup
a "controluser" here: using the r
r}r(hDXh
can discover your username and password).  But you don't need to setup
a "controluser" here: using the r
hFjubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX$cfg['Servers'][$i]['only_db']rUindex-18rjtr(jqX4configuration option; $cfg['Servers'][$i]['only_db']jjtreuhFjh?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]r hR]r!hP]r"jahX]r#uhFjh?]r$hLhMubh)r%}r&(hDX/:config:option:`$cfg['Servers'][$i]['only_db']`r'hFjhGhJhLhhN}r((Ureftyper)Xoptionr*hhjU	refdomainr+Xconfigr,hP]r-hR]r.Urefexplicitr/hT]r0hV]r1hX]r2hhuh[Mih?]r3jC)r4}r5(hDj'hN}r6(hT]r7hV]r8(hj,X
config-optionr9ehR]r:hP]r;hX]r<uhFj%h?]r=hyX$cfg['Servers'][$i]['only_db']r>r?}r@(hDUhFj4ubahLjQubaubhyX might be enough.rArB}rC(hDX might be enough.rDhFjubeubaubj)rE}rF(hDXhIn the :ref:`faqmultiuser` section, there is an entry explaining how
to protect your configuration file.rGhFjlhGhJhLjhN}rH(hT]rIhV]rJhR]rKhP]rLhX]rMuh[Nh\hh?]rNh})rO}rP(hDXhIn the :ref:`faqmultiuser` section, there is an entry explaining how
to protect your configuration file.rQhFjEhGhJhLhhN}rR(hT]rShV]rThR]rUhP]rVhX]rWuh[Moh?]rX(hyXIn the rYrZ}r[(hDXIn the r\hFjOubh)r]}r^(hDX:ref:`faqmultiuser`r_hFjOhGhJhLhhN}r`(UreftyperaXrefrbhhXfaqmultiuserrcU	refdomainrdXstdrehP]rfhR]rgUrefexplicitrhhT]rihV]rjhX]rkhhuh[Moh?]rlh)rm}rn(hDj_hN}ro(hT]rphV]rq(hjeXstd-refrrehR]rshP]rthX]ruuhFj]h?]rvhyXfaqmultiuserrwrx}ry(hDUhFjmubahLhubaubhyXN section, there is an entry explaining how
to protect your configuration file.rzr{}r|(hDXN section, there is an entry explaining how
to protect your configuration file.r}hFjOubeubaubj)r~}r(hDXFor additional security in this mode, you may wish to consider the
Host authentication :config:option:`$cfg['Servers'][$i]['AllowDeny']['order']`
and :config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']` configuration directives.rhFjlhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXFor additional security in this mode, you may wish to consider the
Host authentication :config:option:`$cfg['Servers'][$i]['AllowDeny']['order']`
and :config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']` configuration directives.rhFj~hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mqh?]r(hyXWFor additional security in this mode, you may wish to consider the
Host authentication rr}r(hDXWFor additional security in this mode, you may wish to consider the
Host authentication rhFjubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX)$cfg['Servers'][$i]['AllowDeny']['order']rUindex-19rjtr(jqX?configuration option; $cfg['Servers'][$i]['AllowDeny']['order']jjtreuhFjh?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFjh?]rhLhMubh)r}r(hDX::config:option:`$cfg['Servers'][$i]['AllowDeny']['order']`rhFjhGhJhLhhN}r(UreftyperXoptionrhhjU	refdomainrXconfigrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[Mqh?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX
config-optionrehR]rhP]rhX]ruhFjh?]rhyX)$cfg['Servers'][$i]['AllowDeny']['order']rr}r(hDUhFjubahLjQubaubhyX
and rr}r(hDX
and rhFjubje)r}r(hDUhN}r(hP]rhR]rhT]rhV]rhX]rjo]r((jqX)$cfg['Servers'][$i]['AllowDeny']['rules']rUindex-20rjtr(jqX?configuration option; $cfg['Servers'][$i]['AllowDeny']['rules']jjtreuhFjh?]rhLjhubhA)r}r(hDUhN}r(hT]rhV]rhR]rhP]rjahX]ruhFjh?]rhLhMubh)r}r(hDX::config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']`rhFjhGhJhLhhN}r(UreftyperXoptionrhhjU	refdomainrXconfigrhP]rhR]rUrefexplicitrhT]rhV]rhX]rhhuh[Mqh?]rjC)r}r(hDjhN}r(hT]rhV]r(hjX
config-optionrehR]rhP]rhX]ruhFjh?]rhyX)$cfg['Servers'][$i]['AllowDeny']['rules']rr}r(hDUhFjubahLjQubaubhyX configuration directives.rr}r(hDX configuration directives.rhFjubeubaubj)r}r(hDXUnlike cookie and http, does not require a user to log in when first
loading the phpMyAdmin site. This is by design but could allow any
user to access your installation. Use of some restriction method is
suggested, perhaps a :term:`.htaccess` file with the HTTP-AUTH directive or disallowing
incoming HTTP requests at one’s router or firewall will suffice (both
of which are beyond the scope of this manual but easily searchable
with Google).
rhFjlhGhJhLjhN}r(hT]rhV]r	hR]r
hP]rhX]ruh[Nh\hh?]r
h})r}r(hDXUnlike cookie and http, does not require a user to log in when first
loading the phpMyAdmin site. This is by design but could allow any
user to access your installation. Use of some restriction method is
suggested, perhaps a :term:`.htaccess` file with the HTTP-AUTH directive or disallowing
incoming HTTP requests at one’s router or firewall will suffice (both
of which are beyond the scope of this manual but easily searchable
with Google).rhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mth?]r(hyXUnlike cookie and http, does not require a user to log in when first
loading the phpMyAdmin site. This is by design but could allow any
user to access your installation. Use of some restriction method is
suggested, perhaps a rr}r(hDXUnlike cookie and http, does not require a user to log in when first
loading the phpMyAdmin site. This is by design but could allow any
user to access your installation. Use of some restriction method is
suggested, perhaps a rhFjubh)r}r(hDX:term:`.htaccess`rhFjhGhJhLhhN}r(Ureftyper Xtermr!hhX	.htaccessr"U	refdomainr#Xstdr$hP]r%hR]r&Urefexplicitr'hT]r(hV]r)hX]r*hhuh[Mth?]r+h)r,}r-(hDjhN}r.(hT]r/hV]r0(hj$Xstd-termr1ehR]r2hP]r3hX]r4uhFjh?]r5hyX	.htaccessr6r7}r8(hDUhFj,ubahLhubaubhyX file with the HTTP-AUTH directive or disallowing
incoming HTTP requests at one’s router or firewall will suffice (both
of which are beyond the scope of this manual but easily searchable
with Google).r9r:}r;(hDX file with the HTTP-AUTH directive or disallowing
incoming HTTP requests at one’s router or firewall will suffice (both
of which are beyond the scope of this manual but easily searchable
with Google).r<hFjubeubaubeubje)r=}r>(hDUhFjThGhJhLjhhN}r?(hP]r@hR]rAhT]rBhV]rChX]rDjo]rE(jXSwekey; Authentication modeUindex-21rFUtrGajtuh[M}h\hh?]rHubhA)rI}rJ(hDUhFjThGhJhLhMhN}rK(hP]rLhR]rMhT]rNhV]rOhX]rPhZjFuh[M}h\hh?]rQubhA)rR}rS(hDX.. _swekey:rThFjThGhJha}rUhLhMhN}rV(hP]rWhR]rXhT]rYhV]rZhX]r[hZh>uh[M~h\hhj}r\jFjIsh?]r]ubeubh^)r^}r_(hDUhFjN	hGhJha}r`hjRshLhchN}ra(hT]rbhV]rchR]rdhP]re(h:h>jFehX]rf(hheuh[Mh\hhj}rg(h>jRjFjIuh?]rh(hm)ri}rj(hDXSwekey authentication moderkhFj^hGhJhLhqhN}rl(hT]rmhV]rnhR]rohP]rphX]rquh[Mh\hh?]rrhyXSwekey authentication modersrt}ru(hDjkhFjiubaubh})rv}rw(hDX{The Swekey is a low cost authentication USB key that can be used in
web applications. When Swekey authentication is activated, phpMyAdmin
requires the users's Swekey to be plugged before entering the login
page (currently supported for cookie authentication mode only). Swekey
Authentication is disabled by default. To enable it, add the following
line to :file:`config.inc.php`:rxhFj^hGhJhLhhN}ry(hT]rzhV]r{hR]r|hP]r}hX]r~uh[Mh\hh?]r(hyXdThe Swekey is a low cost authentication USB key that can be used in
web applications. When Swekey authentication is activated, phpMyAdmin
requires the users's Swekey to be plugged before entering the login
page (currently supported for cookie authentication mode only). Swekey
Authentication is disabled by default. To enable it, add the following
line to rr}r(hDXdThe Swekey is a low cost authentication USB key that can be used in
web applications. When Swekey authentication is activated, phpMyAdmin
requires the users's Swekey to be plugged before entering the login
page (currently supported for cookie authentication mode only). Swekey
Authentication is disabled by default. To enable it, add the following
line to rhFjvubjC)r}r(hDUhN}r(hP]rhR]rhT]rhV]rXfileraUrolerjhX]ruhFjvh?]rhyXconfig.inc.phprr}r(hDXconfig.inc.phprhFjubahLjQubhyX:r}r(hDX:hFjvubeubj)r}r(hDX?$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey.conf';rhFj^hGhJhLjhN}r(j
jXphprjjhP]rhR]rhT]rhV]rhX]ruh[Mh\hh?]rhyX?$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey.conf';rr}r(hDUhFjubaubh})r}r(hDXYou then have to create the ``swekey.conf`` file that will associate
each user with their Swekey Id. It is important to place this file
outside of your web server's document root (in the example, it is
located in ``/etc``). A self documented sample file is provided in the
``examples`` directory. Feel free to use it with your own users'
information. If you want to purchase a Swekey please visit
`http://phpmyadmin.net/auth\_key <http://phpmyadmin.net/auth_key>`_
since this link provides funding for phpMyAdmin.rhFj^hGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mh\hh?]r(hyXYou then have to create the rr}r(hDXYou then have to create the rhFjubjC)r}r(hDX``swekey.conf``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXswekey.confrr}r(hDUhFjubahLjQubhyX file that will associate
each user with their Swekey Id. It is important to place this file
outside of your web server's document root (in the example, it is
located in rr}r(hDX file that will associate
each user with their Swekey Id. It is important to place this file
outside of your web server's document root (in the example, it is
located in rhFjubjC)r}r(hDX``/etc``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX/etcrr}r(hDUhFjubahLjQubhyX4). A self documented sample file is provided in the
rr}r(hDX4). A self documented sample file is provided in the
rhFjubjC)r}r(hDX``examples``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXexamplesrr}r(hDUhFjubahLjQubhyXp directory. Feel free to use it with your own users'
information. If you want to purchase a Swekey please visit
rr}r(hDXp directory. Feel free to use it with your own users'
information. If you want to purchase a Swekey please visit
rhFjubj)r}r(hDXC`http://phpmyadmin.net/auth\_key <http://phpmyadmin.net/auth_key>`_rhN}r(UnamerXhttp://phpmyadmin.net/auth_keyrjXhttp://phpmyadmin.net/auth_keyrhP]rhR]rhT]rhV]rhX]ruhFjh?]rhyXhttp://phpmyadmin.net/auth_keyrr}r(hDUhFjubahLjubhA)r}r(hDX! <http://phpmyadmin.net/auth_key>rjKhFjhLhMhN}r(UrefurirjhP]rh+ahR]rhT]rhV]rhX]rh
auh?]rubhyX1
since this link provides funding for phpMyAdmin.rr}r(hDX1
since this link provides funding for phpMyAdmin.rhFjubeubjE)r}r(hDUhFj^hGNhLjHhN}r(hT]rhV]rUadmonition-see-alsorahR]r	hP]r
hX]ruh[Nh\hh?]r(hm)r
}r(hDXSee alsorhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXSee alsorr}r(hDjhFj
ubahLhqubh})r}r(hDUhN}r(hT]rhV]rhR]rhP]r hX]r!uhFjh?]r"(je)r#}r$(hDUhN}r%(hP]r&hR]r'hT]r(hV]r)hX]r*jo]r+((jqX)$cfg['Servers'][$i]['auth_swekey_config']r,Uindex-22r-j,tr.(jqX?configuration option; $cfg['Servers'][$i]['auth_swekey_config']j-j,tr/euhFjh?]r0hLjhubhA)r1}r2(hDUhN}r3(hT]r4hV]r5hR]r6hP]r7j-ahX]r8uhFjh?]r9hLhMubh)r:}r;(hDX::config:option:`$cfg['Servers'][$i]['auth_swekey_config']`r<hFjhGhJhLhhN}r=(Ureftyper>Xoptionr?hhj,U	refdomainr@XconfigrAhP]rBhR]rCUrefexplicitrDhT]rEhV]rFhX]rGhhuh[Mh?]rHjC)rI}rJ(hDj<hN}rK(hT]rLhV]rM(hjAX
config-optionrNehR]rOhP]rPhX]rQuhFj:h?]rRhyX)$cfg['Servers'][$i]['auth_swekey_config']rSrT}rU(hDUhFjIubahLjQubaubehLhubeubeubeubh^)rV}rW(hDUhFh_hGhJhLhchN}rX(hT]rYhV]rZhR]r[hP]r\h6ahX]r]hauh[Mh\hh?]r^(hm)r_}r`(hDX%Securing your phpMyAdmin installationrahFjVhGhJhLhqhN}rb(hT]rchV]rdhR]rehP]rfhX]rguh[Mh\hh?]rhhyX%Securing your phpMyAdmin installationrirj}rk(hDjahFj_ubaubh})rl}rm(hDXThe phpMyAdmin team tries hardly to make the application secure, however there
are always ways to make your installation more secure:rnhFjVhGhJhLhhN}ro(hT]rphV]rqhR]rrhP]rshX]rtuh[Mh\hh?]ruhyXThe phpMyAdmin team tries hardly to make the application secure, however there
are always ways to make your installation more secure:rvrw}rx(hDjnhFjlubaubj)ry}rz(hDUhFjVhGhJhLjhN}r{(jX*hP]r|hR]r}hT]r~hV]rhX]ruh[Mh\hh?]r(j)r}r(hDX\remove ``setup`` directory from phpMyAdmin, you will probably not
use it after initial setuprhFjyhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDX\remove ``setup`` directory from phpMyAdmin, you will probably not
use it after initial setuprhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mh?]r(hyXremove rr}r(hDXremove rhFjubjC)r}r(hDX	``setup``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyXsetuprr}r(hDUhFjubahLjQubhyXL directory from phpMyAdmin, you will probably not
use it after initial setuprr}r(hDXL directory from phpMyAdmin, you will probably not
use it after initial setuprhFjubeubaubj)r}r(hDXrprevent access to ``libraries`` directory from browser,
as it is not needed, supplied ``.htaccess`` file does thisrhFjyhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXrprevent access to ``libraries`` directory from browser,
as it is not needed, supplied ``.htaccess`` file does thisrhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mh?]r(hyXprevent access to rr}r(hDXprevent access to rhFjubjC)r}r(hDX
``libraries``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX	librariesrr}r(hDUhFjubahLjQubhyX7 directory from browser,
as it is not needed, supplied rr}r(hDX7 directory from browser,
as it is not needed, supplied rhFjubjC)r}r(hDX
``.htaccess``rhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX	.htaccessrr}r(hDUhFjubahLjQubhyX file does thisrr}r(hDX file does thisrhFjubeubaubj)r}r(hDXdproperly choose authentication method - :ref:`cookie`
is probably the best choice for shared hostingrhFjyhGhJhLjhN}r(hT]rhV]rhR]rhP]rhX]ruh[Nh\hh?]rh})r}r(hDXdproperly choose authentication method - :ref:`cookie`
is probably the best choice for shared hostingrhFjhGhJhLhhN}r(hT]rhV]rhR]rhP]rhX]ruh[Mh?]r(hyX(properly choose authentication method - rr}r(hDX(properly choose authentication method - rhFjubh)r}r(hDX
:ref:`cookie`rhFjhGhJhLhhN}r(UreftyperXrefrhhXcookierU	refdomainrXstdrhP]rhR]rUrefexplicitrhT]r	hV]r
hX]rhhuh[Mh?]rh)r
}r(hDjhN}r(hT]rhV]r(hjXstd-refrehR]rhP]rhX]ruhFjh?]rhyXcookierr}r(hDUhFj
ubahLhubaubhyX/
is probably the best choice for shared hostingrr}r(hDX/
is probably the best choice for shared hostingrhFjubeubaubj)r}r(hDXin case you don't want all MySQL users to be able to access
phpMyAdmin, you can use :config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']` to limit themr hFjyhGhJhLjhN}r!(hT]r"hV]r#hR]r$hP]r%hX]r&uh[Nh\hh?]r'h})r(}r)(hDXin case you don't want all MySQL users to be able to access
phpMyAdmin, you can use :config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']` to limit themr*hFjhGhJhLhhN}r+(hT]r,hV]r-hR]r.hP]r/hX]r0uh[Mh?]r1(hyXTin case you don't want all MySQL users to be able to access
phpMyAdmin, you can use r2r3}r4(hDXTin case you don't want all MySQL users to be able to access
phpMyAdmin, you can use r5hFj(ubje)r6}r7(hDUhN}r8(hP]r9hR]r:hT]r;hV]r<hX]r=jo]r>((jqX)$cfg['Servers'][$i]['AllowDeny']['rules']r?Uindex-23r@j?trA(jqX?configuration option; $cfg['Servers'][$i]['AllowDeny']['rules']j@j?trBeuhFj(h?]rChLjhubhA)rD}rE(hDUhN}rF(hT]rGhV]rHhR]rIhP]rJj@ahX]rKuhFj(h?]rLhLhMubh)rM}rN(hDX::config:option:`$cfg['Servers'][$i]['AllowDeny']['rules']`rOhFj(hGhJhLhhN}rP(UreftyperQXoptionrRhhj?U	refdomainrSXconfigrThP]rUhR]rVUrefexplicitrWhT]rXhV]rYhX]rZhhuh[Mh?]r[jC)r\}r](hDjOhN}r^(hT]r_hV]r`(hjTX
config-optionraehR]rbhP]rchX]rduhFjMh?]rehyX)$cfg['Servers'][$i]['AllowDeny']['rules']rfrg}rh(hDUhFj\ubahLjQubaubhyX to limit themrirj}rk(hDX to limit themrlhFj(ubeubaubj)rm}rn(hDXqconsider hiding phpMyAdmin behind authentication proxy, so that
MySQL credentials are not all users need to loginrohFjyhGhJhLjhN}rp(hT]rqhV]rrhR]rshP]rthX]ruuh[Nh\hh?]rvh})rw}rx(hDXqconsider hiding phpMyAdmin behind authentication proxy, so that
MySQL credentials are not all users need to loginryhFjmhGhJhLhhN}rz(hT]r{hV]r|hR]r}hP]r~hX]ruh[Mh?]rhyXqconsider hiding phpMyAdmin behind authentication proxy, so that
MySQL credentials are not all users need to loginrr}r(hDjyhFjwubaubaubeubeubeubehDUUtransformerrNU
footnote_refsr}rUrefnamesr}rUsymbol_footnotesr]rUautofootnote_refsr]rUsymbol_footnote_refsr]rU	citationsr]rh\hUcurrent_linerNUtransform_messagesr]r(cdocutils.nodes
system_message
r)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKUtyperUINFOruh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX+Hyperlink target "setup" is not referenced.rr}r(hDUhFjubahLhubahLUsystem_messagerubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX3Hyperlink target "quick-install" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKXUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX-Hyperlink target "index-0" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKYUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX2Hyperlink target "setup-script" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKUtyperjuh?]rh})r}r	(hDUhN}r
(hT]rhV]rhR]r
hP]rhX]ruhFjh?]rhyX-Hyperlink target "index-1" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKUtyperjuh?]r h})r!}r"(hDUhN}r#(hT]r$hV]r%hR]r&hP]r'hX]r(uhFjh?]r)hyX3Hyperlink target "linked-tables" is not referenced.r*r+}r,(hDUhFj!ubahLhubahLjubj)r-}r.(hDUhN}r/(hT]r0Ulevelr1KhP]r2hR]r3Usourcer4hJhV]r5hX]r6Uliner7KUtyper8juh?]r9h})r:}r;(hDUhN}r<(hT]r=hV]r>hR]r?hP]r@hX]rAuhFj-h?]rBhyX/Hyperlink target "upgrading" is not referenced.rCrD}rE(hDUhFj:ubahLhubahLjubj)rF}rG(hDUhN}rH(hT]rIUlevelrJKhP]rKhR]rLUsourcerMhJhV]rNhX]rOUlinerPKUtyperQjuh?]rRh})rS}rT(hDUhN}rU(hT]rVhV]rWhR]rXhP]rYhX]rZuhFjFh?]r[hyX-Hyperlink target "index-2" is not referenced.r\r]}r^(hDUhFjSubahLhubahLjubj)r_}r`(hDUhN}ra(hT]rbUlevelrcKhP]rdhR]reUsourcerfhJhV]rghX]rhUlineriKUtyperjjuh?]rkh})rl}rm(hDUhN}rn(hT]rohV]rphR]rqhP]rrhX]rsuhFj_h?]rthyX:Hyperlink target "authentication-modes" is not referenced.rurv}rw(hDUhFjlubahLhubahLjubj)rx}ry(hDUhN}rz(hT]r{Ulevelr|KhP]r}hR]r~UsourcerhJhV]rhX]rUlinerKUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjxh?]rhyX-Hyperlink target "index-3" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX-Hyperlink target "index-4" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerKUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX-Hyperlink target "index-5" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerM1Utyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX-Hyperlink target "index-6" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerM6Utyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX-Hyperlink target "index-7" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMCUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]r	uhFjh?]r
hyX-Hyperlink target "index-8" is not referenced.rr}r
(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMDUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]r hP]r!hX]r"uhFjh?]r#hyX,Hyperlink target "cookie" is not referenced.r$r%}r&(hDUhFjubahLhubahLjubj)r'}r((hDUhN}r)(hT]r*Ulevelr+KhP]r,hR]r-Usourcer.hJhV]r/hX]r0Uliner1MOUtyper2juh?]r3h})r4}r5(hDUhN}r6(hT]r7hV]r8hR]r9hP]r:hX]r;uhFj'h?]r<hyX-Hyperlink target "index-9" is not referenced.r=r>}r?(hDUhFj4ubahLhubahLjubj)r@}rA(hDUhN}rB(hT]rCUlevelrDKhP]rEhR]rFUsourcerGhJhV]rHhX]rIUlinerJMTUtyperKjuh?]rLh})rM}rN(hDUhN}rO(hT]rPhV]rQhR]rRhP]rShX]rTuhFj@h?]rUhyX.Hyperlink target "index-10" is not referenced.rVrW}rX(hDUhFjMubahLhubahLjubj)rY}rZ(hDUhN}r[(hT]r\Ulevelr]KhP]r^hR]r_Usourcer`hJhV]rahX]rbUlinercMVUtyperdjuh?]reh})rf}rg(hDUhN}rh(hT]rihV]rjhR]rkhP]rlhX]rmuhFjYh?]rnhyX.Hyperlink target "index-11" is not referenced.rorp}rq(hDUhFjfubahLhubahLjubj)rr}rs(hDUhN}rt(hT]ruUlevelrvKhP]rwhR]rxUsourceryhJhV]rzhX]r{Uliner|MVUtyper}juh?]r~h})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjrh?]rhyX.Hyperlink target "index-12" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMVUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-13" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMVUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-14" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMeUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-15" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMiUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-16" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMiUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-17" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r	(hDUhN}r
(hT]rUlevelrKhP]r
hR]rUsourcerhJhV]rhX]rUlinerMiUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-18" is not referenced.rr}r (hDUhFjubahLhubahLjubj)r!}r"(hDUhN}r#(hT]r$Ulevelr%KhP]r&hR]r'Usourcer(hJhV]r)hX]r*Uliner+MqUtyper,juh?]r-h})r.}r/(hDUhN}r0(hT]r1hV]r2hR]r3hP]r4hX]r5uhFj!h?]r6hyX.Hyperlink target "index-19" is not referenced.r7r8}r9(hDUhFj.ubahLhubahLjubj)r:}r;(hDUhN}r<(hT]r=Ulevelr>KhP]r?hR]r@UsourcerAhJhV]rBhX]rCUlinerDMqUtyperEjuh?]rFh})rG}rH(hDUhN}rI(hT]rJhV]rKhR]rLhP]rMhX]rNuhFj:h?]rOhyX.Hyperlink target "index-20" is not referenced.rPrQ}rR(hDUhFjGubahLhubahLjubj)rS}rT(hDUhN}rU(hT]rVUlevelrWKhP]rXhR]rYUsourcerZhJhV]r[hX]r\Uliner]M}Utyper^juh?]r_h})r`}ra(hDUhN}rb(hT]rchV]rdhR]rehP]rfhX]rguhFjSh?]rhhyX.Hyperlink target "index-21" is not referenced.rirj}rk(hDUhFj`ubahLhubahLjubj)rl}rm(hDUhN}rn(hT]roUlevelrpKhP]rqhR]rrUsourcershJhV]rthX]ruUlinervM~Utyperwjuh?]rxh})ry}rz(hDUhN}r{(hT]r|hV]r}hR]r~hP]rhX]ruhFjlh?]rhyX,Hyperlink target "swekey" is not referenced.rr}r(hDUhFjyubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-22" is not referenced.rr}r(hDUhFjubahLhubahLjubj)r}r(hDUhN}r(hT]rUlevelrKhP]rhR]rUsourcerhJhV]rhX]rUlinerMUtyperjuh?]rh})r}r(hDUhN}r(hT]rhV]rhR]rhP]rhX]ruhFjh?]rhyX.Hyperlink target "index-23" is not referenced.rr}r(hDUhFjubahLhubahLjubeUreporterrNUid_startrKU
autofootnotesr]rU
citation_refsr}rUindirect_targetsr]rUsettingsr(cdocutils.frontend
Values
ror}r(Ufootnote_backlinksrKUrecord_dependenciesrNUrfc_base_urlrUhttp://tools.ietf.org/html/rU	tracebackrUpep_referencesrNUstrip_commentsrNU
toc_backlinksrUentryrU
language_coderUenrU	datestamprNUreport_levelrKU_destinationrNU
halt_levelrKU
strip_classesrNhqNUerror_encoding_error_handlerrUbackslashreplacerUdebugrNUembed_stylesheetrUoutput_encoding_error_handlerrUstrictrU
sectnum_xformrKUdump_transformsrNU
docinfo_xformrKUwarning_streamrNUpep_file_url_templaterUpep-%04drUexit_status_levelrKUconfigrNUstrict_visitorrNUcloak_email_addressesrUtrim_footnote_reference_spacerUenvrNUdump_pseudo_xmlrNUexpose_internalsrNUsectsubtitle_xformrUsource_linkrNUrfc_referencesrNUoutput_encodingrUutf-8rU
source_urlrNUinput_encodingrU	utf-8-sigrU_disable_configrNU	id_prefixrUU	tab_widthrKUerror_encodingrUANSI_X3.4-1968rU_sourcerU?/opt/pma-git/phpmyadmin/release/phpMyAdmin-4.0.10/doc/setup.rstrUgettext_compactrU	generatorrNUdump_internalsrNUsmart_quotesrUpep_base_urlrUhttp://www.python.org/dev/peps/rUsyntax_highlightrUlongrUinput_encoding_error_handlerrjUauto_id_prefixrUidrUdoctitle_xformrUstrip_elements_with_classesrNU
_config_filesr]rUfile_insertion_enabledrKUraw_enabledrKU
dump_settingsrNubUsymbol_footnote_startrKUidsr	}r
(h=jh;jh0jh*jh+jh5jN	jqjuh7jqjFj^jjjjjjjjjjh1jh-j^jjjjh)j`j
j
j.j2jjjjjrjjjj6	jN	j	
j
jjjjjnjjh:j^h/jh(jh.jN	h3jjHjTh,j`h2jTh8h_j@jDj-j1h9h_h4j^jjh6jVh>j^h<jh'juUsubstitution_namesr}rhLh\hN}r
(hT]rhP]rhR]rUsourcerhJhV]rhX]ruU	footnotesr]rUrefidsr}r(h>]rjRah/]rjah9]rhBajH]rjKah-]rjTah(]rjaj]rjaj]rjah.]r jB	ajr]r!jvaj]r"jaj6	]r#j9	ah3]r$jah,]r%jVaj]r&jajF]r'jIauub.

Anon7 - 2022
AnonSec Team