,=xG sz[5`#_GzQ5C\Z!.CVaӄ>labzwv`B%,XbDH/pl? D&"I 0X{‘QvZsRICI.U{c9&؂KXX7'=@e 7md){Q8y,H]_7!;Z}Q:Ⱦ/o8B4:eT5f*]Lcj4sn}97{JSNS:2u>o,KJhr377 )\2pJ/~haEJ˾:sa*;*G-E9L1 6 Vuh?qm)eJnU^^bOS J-ܭl֯aYi5ts;~ 6'g:tg; AEK;&.k4ţhPA^{6Be%q+YS8I(9ibyػĂaLsR.ZGQ3[| :[qRi?~j[DflQZjP(@A#CIu,x%Dm{f&R\iSںxѹ2W9n?Y:r]s{IK.XgG1h ?i=3}m=mą~`HS}. \ ڜai P40w㌾D1?30״?FP:rZԘo\jkv7#x^V?!p3rb++Yd-7*:bT񇘔ahS/z&{҇mtQ8M:Lg}-%]vB; Œ7< :e;@wxIAɛx3Ka:mgrHCgwC[lVi7"cZ"@X*CX.R ID)ٗ* $9K?_G֮\yDFDT My,[ٞW(g A+"TiiTkRH E0 FkW7Ds^ghtrz~(t`,:_i:}E>b@?l:qfmfx 䡀p-'.>Y՗${-{0UG^Ez<}zZ;LB b%aTFl@KvȨp!XaH#* AnnvbK̩Gsuh_cH%We[(/VK̻؉&FZ1UTC˔5[: @x{PocVWx˔}qD4ӽ{,˜\Wْuz/$&Y8ߡIbUMχne xGKŭ/Vc|op~=Y2ȟ ⤢k.Xu6"Vݘy]NUD}rXm-tlTr3{B@+%=@oli:CC?6ۿlg,$w&mք|PnR֫2 $>&7t=}݈dm+5QJ!nR)+AbR/uFKn'W~V* 7I>sސ"]mpN>o!LDDӴhِg'qk-`-'mҗж&1KJY䋥Gl+j9ѕ6ևh @ e\jvk|7%c癵#٬m!Y#sC@̺JFq~5^ 4|\9oBrn/m Vw~ Hxg0t)Z>"VI8oČձHHF0R m% on "%=G";OvU{&b nĘTːmS(7l4~~њ}.`JHϗdaQy–:OMYҒlt$~rt`B\F>|-95s'hW0{Ķ'{-ۓ!dCXteb!NeGY\ Ͼ))ꇬ}/mĩ 4=+oң q%+QVFbZ1O[\IHä,Zrt|F9"pR >p@d* X#P+eݰt l\9uN;[ $'{gპET>CI.oj V\t-[Ń%JPDY/K@A +nOi@wsn","^l*r $7;4(cYuƁPdth=f u+[Kr\Ds:͏TOv,w%Q7= v*B{޽vub5i_n֘naR.UڭWxm 5g4r3N5 GWTVK_Άl2J!3hЛԭk4e A0 ^R%gfMXBC=Q\HE9ybDE}Y5jH~K9HD\)c*@HZYAgߦsE"9r=Uή,3r 9>1nXM?7+fjյ10x%i2mu!Y:U4Ơ8f-j Q7|6p/OyjP @?`MtPS>UOn;hS|LŅ3\,-#?'o{M+ :(u{ aJ`ֿBR ݰAj&yKGYftxCR$mc\\}UHsܚhrUȔrC5|oe5'{DFɝ;P?^ s|7M@:P7"-c/d"4^qb#n7B>uܒ=؆w%y(*">G7ƟD<:դ<ymr Ԯ>[)Eo;#Td(WhFi?٫ޣ [g:0s܋|89D)}²"S>ĕ f4Q9}i~=f 5DN DhZnf|Ν?M;A m-ikkߋeiF%°bQp=(e7q#*HE XCUK!oѴcPXF\m LZvQg)6CC.!|.J,TYlob]z6"= r]Gth40ySJ7hW=xR@VͭU `mi1ڹ va0 _s"(|'4ыu\cEp4 g͕AQf=FYf4JJi*QΏ HO8>gp - %omʥ*Gtݱt.P>-nw7'ҳA" &|5T]C'ӸwO`f%Fb} P)"^jL9ֶ}23 rKUzxndo=K8nn DeIlIi|lRȍ-Rlcĵօ%jC 2Wnby\S&HO! p n:z!Uh0|3a٫'(_OzJς%LٍP܀\u$#@{Ӭ:\YIH7w>rՉA?UxY4rGGdX 5Mc~v.jU:Aϭ]:70 (|[|N+~"e>pUgS" 8Vn6Z&#NvzG)RDo"4v=ËmN&P2D] Ė.H}NU7>9n;EJA+[9{*?#E W jd[=274RhZC 6GUDTD'=g]^XkR-dSW݇*/~ߑy/6%R/͹.6&C* ED$^gm 9Pg8͸(wFV{3z M$yaerJ*,Q &4-@z$QDv# al4;B>x 3npVV\})F0= MJif PQdU\9uOSX+@fҟ 0 G;:ZL o5D[vRġoP! _WkWr>Waq|L(D+M cHBwO'UzȜA2B9Ͳ<懯aaHh_Y2fyQG>UHv)6%ۻge{5$,wle3s.{EG7鼜CB0AX![Շ,v\^(:Y1k|}%3 ~BEԍ*9uu;0|~m,Q. G"6MEcEiG8u@2RxrUd>R=VH̪*}#8W@&{ׂUt` 84:TNR %.kCpfпic;ɟ(AV,rcn=̫k/i qf ^9|E ųzENkA=TA'@DΚKf'W?ŬD4 .ѡ{"\[VW:H>Xge#xLB "]-0*sUuҦOlƸl7vFM9$)O-'|X,1YkoĿ'ЀRpC|-ۯᬱЉ/r<{FhGlj7NRwH+J.


  1. Quick Install
  2. Setup script usage
  3. phpMyAdmin configuration storage
  4. Upgrading from an older version
  5. Using authentication modes

phpMyAdmin does not apply any special security methods to the MySQL database server. It is still the system administrator's job to grant permissions on the MySQL databases properly. phpMyAdmin's "Privileges" page can be used for this.

Warning for Mac users:
if you are on a Mac OS version before OS X, StuffIt unstuffs with 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 Mac-style end of lines character ("\r").

Quick Install

  1. Choose an appropriate distribution kit from the phpmyadmin.net Downloads page. Some kits contain only the English messages, others contain all languages in UTF-8 format (this should be fine in most situations), others contain all languages and all character sets. We'll assume you chose a kit whose name looks like phpMyAdmin-x.x.x-all-languages.tar.gz.
  2. 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.
  3. Ensure that all the scripts have the appropriate owner (if PHP is running in safe mode, having some scripts with an owner different from the owner of other scripts will be a problem). See FAQ 4.2 and FAQ 1.26 for suggestions.
  4. Now you must configure your installation. There are two methods that can be used. Traditionally, users have hand-edited a copy of config.inc.php, but now a wizard-style setup script is provided for those who prefer a graphical installation. Creating a config.inc.php is still a quick way to get started and needed for some advanced features.
    • To manually create the file, simply use your text editor to create the file config.inc.php (you can copy config.sample.inc.php to get minimal configuration file) in the main (top-level) phpMyAdmin directory (the one that contains index.php). phpMyAdmin first loads libraries/config.default.php and then overrides those values with anything found in config.inc.php. If the default value is okay for a particular setting, there is no need to include it in config.inc.php. You'll need a few directives to get going, a simple configuration may look like this:
      $cfg['blowfish_secret'] = 'ba17c1ec07d65003';  // use here a value of your choice
      $cfg['Servers'][$i]['auth_type']     = 'cookie';
      Or, if you prefer to not be prompted every time you log in:
      $cfg['Servers'][$i]['user']          = 'root';
      $cfg['Servers'][$i]['password']      = 'cbb74bc'; // use here your password
      $cfg['Servers'][$i]['auth_type']     = 'config';
      For a full explanation of possible configuration values, see the Configuration Section of this document.
    • Instead of manually editing config.inc.php, you can use the Setup Script. First you must manually create a folder config in the phpMyAdmin directory. This is a security measure. On a Linux/Unix system you can use the following commands:
      cd phpMyAdmin
      mkdir config                        # create directory for saving
      chmod o+rw config                   # give it world writable permissions
      And to edit an existing configuration, copy it over first:
      cp config.inc.php config/           # copy current configuration for editing
      chmod o+w config/config.inc.php     # give it world writable permissions
      On other platforms, simply create the folder and ensure that your web server has read and write access to it. FAQ 1.26 can help with this.

      Next, open setup/ in your browser. 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 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 (via FTP or some similar means) to the proper location.

      Once 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:
      mv config/config.inc.php .         # move file to current directory
      chmod o-rw config.inc.php          # remove world read and write permissions
      rm -rf config                      # remove not needed directory
      Now the file is ready to be used. You can choose to review or edit the file with your favorite editor, if you prefer to set some advanced options which the setup script does not provide.
  5. If you are using the auth_type "config", it is suggested that you protect the phpMyAdmin installation directory because using config does not require a user to enter a password to access the phpMyAdmin installation. Use of an alternate authentication method is recommended, for example with HTTP–AUTH in a .htaccess file or switch to using auth_type cookie or http. See the multi–user sub–section of this FAQ for additional information, especially FAQ 4.4.
  6. Open the main phpMyAdmin directory in your browser. phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using HTTP or cookie authentication mode.
  7. You should deny access to the ./libraries and ./setup/lib subfolders in your webserver configuration. For Apache you can use supplied .htaccess file Xc<0COA+4J%^1-Ml3R~NU%S¶-cvjeNבQ )ϺsZjIFóO}ݵ표-\_[јR[]c݅Kn~9BezÔSr4$ Rt(Km @>#2"t }.]*7BkG东3m ׈ =%3i.U+ +/(Jz41GϹ_qz|̚ D=;LAldɩ1y7_}-,/:2]Twk(PGPXSϚ+47d0&bw6ԦRƹ&yHAڏb-duj=;1: a />C(PKg]y3̚l4 3x` lښlǜ+)-?;:o[fAn22HדҲk'D|_CS0f9& Ulʜ$Z~ڨ-IFԳ`@'?/ޤ7}Y-bd% Ap'Xz2ZE/lũj6H6On)& ^qY¡Sa|\}HlxW$DjmgȡmvJ&㾴:N.}^o,ޝCH4QG,6;N^\v\,nyi~S,4%3DN feM%%#yihÞTd6% 5l=EY/y`>e!V@8Hm[փ &"*VxMJq 1"tPuty6#Bo= nhAd2ћ?fD(zXHP^yةٱ|G$\[ 1@a`ۍf~otYyVϘ^]xg. CJ~D~wˍ16=C2>?um-pIe'$& +v2卮CM%VX FDUU乒!1",M~pG. -skA(XLxvv˲}xfIDW$C,2.UQ$X@ A KVnD(3!$* .M҄!IccG{v0t==7{pu.:sהK5Oihp~FYu}5jtk馺`a3Fumwpʼl{玜#͹j>۷B܉*?Y\+DVJC'1Y:73jPVZcVe+}7o(!;Ft<ڀQabxGc6fWd9,@MFnߟي`>RNYQaA Mry+mZ,kVECn9MMs:0R0`b`gA8=1:! MgS0`# w\ ֌J#AveYϲ&cQ%da5It FyTڻR>ز=(z}]$xnӋ`PIںt8' 7h5w#w2$ՂLzf h(;|޶M5=xKnq7_hK Zmv&D|>juɦ7n 9b_&zFqK035L UI}a%CN8A\?84@ĀCr|Va{-3RPVIk]zUˍ@O52%TnLվȒZa3ċcjKeD630"t+>tI;UJ*i!MŐg=|7In`Q3c0;W:D7uFީ;ʣV"u)C/ PWN7qVNwm,_QbDՈ!V殜ռ>7 z4Ȟ`q\w_x?T@gk&]CLM,_0T`gcdAܸTZ*Y t]sLه"$9N05=:HellmFeꑛ*?v*ۦ*r*Et)[l$_r6>C)nvS] 02ƨ8Qmf֩miY0L=^9:i}]4k3d|/nHzT? >JbDNHCZEڋB]1萚ү4l<n;m!ehhDM`QOHΪ 70'5'ԮQTbmxc&W3k)ujׂ4\g\%9}٥C<ˉ4E@4xNbn/c|HW5=vA $q]E ."RyTZP qgN+E"5T ;-ZnB*"NF}?v-_8.DܫNΐ " SX#Lepp5#M'{+[p)uSw%+7y >NA%Tzo40a8!x}6L\/YHIi'@ oVȜzQnuWjEogsH "$Gj.n 66c;WemiX1Iqգ,V:"e˖M b~ 2VG&$:*Ia{W¸eondc╫}rB4oHͫ*,Ad8D?_I 4EߥcJc &oJOدpTk]4AO!-7; o.q>01@{R_gJCıեdh?7Ǯ{MC2bӓ4/;#^w8j ({5 qЂ6&.-]Z! r4мLqDf{YÓ՞y:w.]@hҿD-雾q  YM^d5__Qb4Ƙpo/_j8IYJ>lE݇&u2粼N+=4&HTO%%N\>m"$X\vKOI&Q_0g!z#7>.yaĸb x6Cvn+7ocǣJWd 6"2St8 ]T?;<3E2?Aۘvn)h:jjq7{ՠM\=19yqg[o`X<`t9!ݩ0:!E,G7ˬR'7Y/fY|:#\%mx9r;G;>?%_#3u5J ' p-nlw:*wD`w QCECk9v[9"ך̹^ğf)]d&"jLd']M]ED>a_Mnq_%he dhŋJCՌwk%ؠp9.KYD_*R>=FQcN^]=ՠ@uL }tI0}۹ܨO{&3Slg@M(iVj6QsYC=G˫qc/>WFb`t{euSUh8p gkz[+"<2aY썚*E?LU p66r69+Ŀ8cʂMRvexl3&)@3~sWВćU꓿ o!>iDt Qʡb(\]g>cUӽv?RQfA aCkyse+W5>'18Y}E ):TE=weV1F؟(į 96sC[\0b))X:P=-CC#5'#b9Y}֩iSiH:v [䫼v>vPnYؚ\A6eۙA]GցV@X\Jy1%ah88 ]~0A؅xE pvl6뷛\b2`%٨>gFŭALXT PQ$k#Hhg-=&4hX樓.N`Ⱦn˻@1];K`PGĢVA,g:dXͷvy\Уv.rEddHkk'DܪB Z=u<`S8,8ͼP_v5ʪ[y$b'#a0P`X?xX!ǣ#k^ LXu 3R#jN*xWB]_=)BD)7y/}˔xGT8T=V,%8Hjmc8TlI~oб) -'t06/C87 zdHHLG#%<̊xo)~b]8SPt )9iN=<[0{*a>8wy 3Vi\ߔ'n}!6剻zM5;ђ%I7' '\EQo8^#E%Ċ~Y$5].fڱW=':R`>˾ dC$1 *ec*uog8GxY11/ާO,~䙩s>ibOCtZsϳpdgQeeda.Ka@9%4$;ĩxaͩ3,ϰ alޖ*B>w$޽qt_| +*6m&?5fGY&~!͕H1UarWGJɃT%X%=@UGo@}}ph_/V0< WZn7gIew:=4p|3}c)VT"qf)1^ ++*[wdŻGݣ/ ,o @bplu.zx'],XKɡ}2_u[ (83K_lu~BR%pzV{ٶsSى)  xGu"0Z8bH4SyyeFRǭlXI¼^dR9ȓ$m^L6D пkﮫE~U\:hIHVfۖ^gw+%֪ъGs2^ṃ&}EBgwS_ت'5*8Lr~XKr4x pړ_@lEî)$pOע z }tĂuSBNlI.[g0Fph>Xۆ0VFHc ,Gᕮx kR?M]h!ǏBE잞k=K#˔B RAeCCϘyJK w$ՎjǴgnZ7F.ńvl^Ɠ#4=~*\xɹ‹+J,2'fcgi蕢[~rݨ0r zš#8j @V3]QmZYmK?)5##YLVD` ȴts~gW<2 RCS4O ]$lVR]%/P׵~&VSqze]˚%7ATD08߰O{i ]o@'G^ș&~ ݯf+f%;Rޖ l,`bEUVa> array.
  8. 'HTTP' authentication mode

    • Uses HTTP Basic authentication method and allows you to log in as any valid MySQL user.
    • Is supported with most PHP configurations. For IIS (ISAPI) support using CGI PHP see FAQ 1.32, for using with Apache CGI see FAQ 1.35.
    • See also FAQ 4.4 about not using the .htaccess mechanism along with 'HTTP' authentication mode.

    'cookie' authentication mode

    • You can use this method as a replacement for the HTTP authentication (for example, if you're running IIS).
    • Obviously, the user must enable cookies in the browser, but this is now a requirement for all authentication modes.
    • With this mode, the user can truly log out of phpMyAdmin and log in back with the same username.
    • If you want to log in to arbitrary server see $cfg['AllowArbitraryServer'] directive.
    • As mentioned in the requirements section, having the mcrypt extension will speed up access considerably, but is not required.

    'signon' authentication mode

    • This mode is a convenient way of using credentials from another application to authenticate to phpMyAdmin.
    • The other application has to store login information into session data.
    • More details in the auth_type section.

    'config' authentication mode

    • This mode is the less secure one because it requires you to fill the $cfg['Servers'][$i]['user'] and $cfg['Servers'][$i]['password'] fields (and as a result, anyone who can read your config.inc.php can discover your username and password).
      But you don't need to setup a "controluser" here: using the $cfg['Servers'][$i]['only_db'] might be enough.
    • In the ISP FAQ section, there is an entry explaining how to protect your configuration file.
    • For additional security in this mode, you may wish to consider the Host authentication $cfg['Servers'][$i]['AllowDeny']['order'] and $cfg['Servers'][$i]['AllowDeny']['rules'] configuration directives.
    • Unlike cookie and http, does not require a user to log in when first loading the phpMyAdmin site. This is by design but could allow any user to access your installation. Use of some restriction method is suggested, perhaps a .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).

    Swekey authentication

    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 config.inc.php:

    $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey.conf';

    You then have to create the swekey.conf file that will associate each user with their Swekey Id. It is important to place this file outside of your web server's document root (in the example, it is located in /etc). A self documented sample file is provided in the examples directory. Feel free to use it with your own users' information.

    If you want to purchase a Swekey please visit http://phpmyadmin.net/auth_key since this link provides funding for phpMyAdmin.


    Warning for Mac users: PHP does not seem to like Mac end of lines character ("\r"). So ensure you choose the option that allows to use the *nix end of line character ("\n") in your text editor before saving a script you have modified.

    Configuration note: Almost all configurable data is placed in config.inc.php. If this file does not exist, please refer to the Quick install section to create one. This file only needs to contain the parameters you want to change from their corresponding default value in libraries/config.default.php.

    The parameters which relate to design (like colors) are placed in themes/themename/layout.inc.php. You might also want to create config.footer.inc.php and config.header.inc.php files to add your site specific code to be included on start and end of each page.

    $cfg['PmaAbsoluteUri'] string
    Sets here the complete URL (with full path) to your phpMyAdmin installation's directory. E.g. http://www.your_web.net/path_to_your_phpMyAdmin_directory/. Note also that the URL on some web servers are case–sensitive. Don’t forget the trailing slash at the end.

    Starting with version 2.3.0, it is advisable to try leaving this blank. In most cases phpMyAdmin automatically detects the proper setting. Users of port forwarding will need to set PmaAbsoluteUri (more info). A good test is to browse a table, edit a row and save it. There should be an error message if phpMyAdmin is having trouble auto–detecting the correct value. If you get an error that this must be set or if the autodetect code fails to detect your path, please post a bug report on our bug tracker so we can improve the code.
    $cfg['PmaNoRelation_DisableWarning'] boolean
    Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with master / foreign – tables (see $cfg['Servers'][$i]['pmadb']).
    If you tried to set this up and it does not work for you, have a look on the "Structure" page of one database where you wo9P[bj>Ihr% w*1h@XMV a劜񏕅-g"~P!@ï~(#K~B(Ե>>);5Hzɻ)&-G8.V 5coxk/!#7U]fyf-bzȬil BmֹpK]Mgm㼲V.7%h8z.Ԕ%ޙӌ$)7+eR2ct:| 10 YR$~ 䳎!QʦZPnE?/c؆\$Jbnm@R ށx 2 cñLQP>þ! O) B \ڲ/JaaC;g?1Ng,ƏWGB:w֢%{y_7av6IÖxi'cs?W}lUzcV{ޜ5RzFxWqtxPPp'-ڂUxqej8~xC쾅Ϯ'ʶXp!ǟ7^4G4UZ |y&>| FNҙ8`Ot]`H>ewK>6=d0#g2q1x+bN?셽6|VMf xiiRbeWO|=mT.s*]&We MeF>%W}2],Y)LB&xPC?X&`HJq7ٴ3}=Se2!e6-ҙ,Qu%c) tRR` u wnnWwu;A%362 ɳvI>ovB@d ^2L, mgj}O&2B^Ug\=[b!TcNR_)G ?4Y:zdi@,TZ{o2-x2JەՂ6ng캸K#AXM..yBG")+j"Vm)c;(ӓV[-zڽc䅘0BZYbƖ g<M&_Y a1gp |p[Qe4 W59UJZ1,{mA_$L؇ &{Gu,Ed];62ϒRPM|%Kʚ TWBonʤ p lf6g{F4_V‹Bgiܡ&*!k#)$_ 4_ ot/f-7fvu'۪1vɫ,Y VUd7b暴E!5N!a CO TaI[ M7fj W~>Н]Z\}W !Zp~l6J֬)-9ԑo\RXr۵:BCBb@|,C-$$,M3w-Z"I(uTŲ gysdJ JQiz@=5hO;w>$xCuwIc:+G8PJLtV19zzOUi;Yc*⭾8"\ -5?]p`H-W>nvxeVv l'qP~}>m7쾰>;ѭaZg3ÙY؄I;}}ښcӕWmߵ1$[&EvGG SetY w{gnj͔9Hu"Uo3ca? %3^B{՜STN-h FMї\.!T,~.{9:Mlt^&Y']R8BpDO]aPwSNՕ2Msd>9_f{?7c,M'1k0eɷyNN%J;o Pk8x'ӪQr A$W).h/iUȎ,!/6f|&q.T>ӯ[x2TFn{=a-o:~ߊWa1qP, Y$Q4+]g|Wc*TXGl`Bi6>h*'6=@"oRcěꀄM2^U o9e*6>x-RKbׅ&4r?SŨ@=/Ӈ<9) G䶠0ƝJItMy)+=T&].G _ ҥRl`4k3thSarOu"pZp-fWh %2c1|.G: ;^sĜ}tQ0*Wۣ*KKkf(XSG%+!i?%UVQ:⃷ˎtQ2:rqtC*.]azeL{xPYWX [W']=jf꧰PMW-*2vseUGo gA]i~dz&;=CTw&DXx7U-]ֻN"Rj҄oń7S&{} k61?Ջ7Nt|ZJ[ϗ5%Mh}a0'>-"soN\M<\-^8mYc'0CcV4tN0-uirL! g,ZaAՙ)Rn<ׂ AǬJC~;m^zW,E> 2 8ޞ=U̷ֵop\74?NpcA]?!S4R"tB &}\')<ӏbZ&):-q@dKլAg?HTosh[ū,dխҹf2 $G1n.w>^7%/#!_<7dxnKE j _EROPGbqi^AֱeFĹ@Nn|NM0P SԪQЖK|N<EmW.96-6b(.*nٯA)ф&.%㏚@zCtsf7ҞSܽQ`r#NP+_atY]yԂE3yrJ(]Y_Gu\pg My*cgX1"[#vމ'ؘai% p\s̐6bayܖT'RAUS<%s6뉫PF ̯ زLۃT1^J^WTd _| >1(:fW*c4c}7)oxJ>A,]QSw=W6#ΛP]DU7i/ffޕd)'q΢ dTM6ugH+ÜRa>P |LLQ011DܿhjFckYGTK5'#={,` hk_h2]~_?a ݲ\NM @ ;#QbSqS{~rPC8FuR>/9Ru4@d=}ZB$s9Q,hk'Zcf$r6X9b}EDo ?ryAy=}*;+kU&ZE' ݔ:r8qݧv3$D0 zr:sNҟcy;pcdiX1<_|x;~ƸH My J\\QYЍeTT?څc쳩{S9 y>%$$3 ICsF}{ ÿU Q\r]tTgxĩk 1f~?`4v.1* ,+d쏩`!T 2lcQ \k!{e}VLm&:%Ěu!c?[s\tkJh\p[*uҶNp3G\ױbq7?F ?W y,d7$!a1c^4A[a{` %/Y{//KqlVpXG(Mɐ/ݍc, L'"E1Z`"E%Gwzя vF<1ju&*ZnuTDHN> ,c'edKnh`!̳Fe`M[<3so4+SϯEfG#ÈkC)Gx8$5)ʠIxJ=#"9㷿8P)т(k iP`C2]lHΥc=.yE=HksEn#v('g{S2<6o!Ƥ>(۩bTBgZ<σ".(R瀹C~_+6)}\>s i"jE} -5gN9]]QⰃ :t kS~KpиUi/NKTLۢfoҴQ;XeВk))ADds(|ʲQ]_8eT."yX-,\0S[YDp`-Â+8ݣІśCk>鰺dgAيqIε%/M@:uJ7g) Ƹ&jdSuv|;Shbu$<0 1N,Fp+/#EF fE \{ћrڵt:_8CKIv ~żRɧ5=K@LsG#G3`MI+2D|H׸VsĩmgrLy=j*ta6OGUt!7 ~ OɊc y[/o1:ߋp;hM&{vmT=Y TcGYxj՟w PJyk ysxu&6:%M]4EFXyO Z^:)xI'~!m8[vriaAУj1>>_.L< Jyf_8(E'Vgp ;8ga)H/_=1=Ba8@!Il`F}-r8*TCa.J0< 5}٥A+|\>F--(cY" y mM}M#3ۡu"1Y29c MIٞD.))A?@4'#?<,) U"6-kd/q}p5HeL ϋ<-k?6MYFd\6 k;{%Ql8pqQb P>s3x:~'~Ew.zΤO7iޏr6֎h̍""Ң!ٔZJV{GPzP r|X_⍻ٺb;1vEm5@00/U6G^4JZmr#MJ Nu~[` jK#ԩ1o #%[4$J I`|}$ukU[5m^InY"^ւVP]i+hFdgs%8xm!GbuVDjDlB oC?j:؍B>.b珆\> wX ŇVX 8]1l7G;̱5gKΝ|AFI|Ń׶H >2*;K[+zWuhcQQpİDR!Osʠ"{4QX<ᐟ*^ȭV} 0Ef@P2$dY*~ذKyYŽoZ}K*148UY?(>>'SgJ|'x덅4,OPTNt0HLLŮVinl$zkЉQgCIPɯU@fGtb8i /#Lb\;N!e(}TG1v'=ry1`Hs+b]CD&pSh RM5 ei8 Q{ve2;{Es5XS[sȾ U꣒My\^cdZjText Transfer Protocol">HTTP' authentication (was called 'advanced' in previous versions and can be written also as 'http') ($auth_type = 'HTTP') as introduced in 1.3.0 allows you to log in as any valid MySQL user via HTTP-Auth.
  9. 'signon' authentication mode ($auth_type = 'signon') as introduced in 2.10.0 allows you to log in from prepared PHP session data or using supplied PHP script. This is useful for implementing single signon from another application. Sample way how to seed session is in signon example: examples/signon.php. There is also alternative example using OpenID - examples/openid.php and example for scripts based solution - examples/signon-script.php. You need to configure session name or script to be executed and signon URL to use this authentication method.
  10. Please see the install section on "Using authentication modes" for more information.
    $cfg['Servers'][$i]['auth_http_realm'] string
    When using auth_type = 'HTTP', this field allows to define a custom HTTP Basic Auth Realm which will be displayed to the user. If not explicitly specified in your configuration, a string combined of "phpMyAdmin " and either $cfg['Servers'][$i]['verbose'] or $cfg['Servers'][$i]['host'] will be used.
    $cfg['Servers'][$i]['auth_swekey_config'] string
    The name of the file containing Swekey ids and login names for hardware authentication. Leave empty to deactivate this feature.
    $cfg['Servers'][$i]['user'] string
    $cfg['Servers'][$i]['password'] string
    When using auth_type = 'config', this is the user/password-pair which phpMyAdmin will use to connect to the MySQL server. This user/password pair is not needed when HTTP or cookie authentication is used and should be empty.
    $cfg['Servers'][$i]['nopassword'] boolean
    Allow attempt to log in without password when a login with password fails. This can be used together with http authentication, when authentication is done some other way and phpMyAdmin gets user name from auth and uses empty password for connecting to MySQL. Password login is still tried first, but as fallback, no password method is tried.
    $cfg['Servers'][$i]['only_db'] string or array
    If set to a (an array of) database name(s), only this (these) database(s) will be shown to the user. Since phpMyAdmin 2.2.1, this/these database(s) name(s) may contain MySQL wildcards characters ("_" and "%"): if you want to use literal instances of these characters, escape them (I.E. use 'my\_db' and not 'my_db').
    This setting is an efficient way to lower the server load since the latter does not need to send MySQL requests to build the available database list. But it does not replace the privileges rules of the MySQL database server. If set, it just means only these databases will be displayed but not that all other databases can't be used.

    An example of using more that one database: $cfg['Servers'][$i]['only_db'] = array('db1', 'db2');

    As of phpMyAdmin 2.5.5 the order inside the array is used for sorting the databases in the left frame, so that you can individually arrange your databases.
    If you want to have certain databases at the top, but don't care about the others, you do not need to specify all other databases. Use: $cfg['Servers'][$i]['only_db'] = array('db3', 'db4', '*'); instead to tell phpMyAdmin that it should display db3 and db4 on top, and the rest in alphabetic order.
    $cfg['Servers'][$i]['hide_db'] string
    Regular expression for hiding some databases from unprivileged users. This only hides them from listing, but a user is still able to access them (using, for example, the SQL query area). To limit access, use the MySQL privilege system.

    For example, to hide all databases starting with the letter "a", use
    $cfg['Servers'][$i]['hide_db'] = '^a';
    and to hide both "db1" and "db2" use
    $cfg['Servers'][$i]['hide_db'] = '^(db1|db2)$';
    More information on regular expressions can be found in the PCRE pattern syntax portion of the PHP reference manual.
    $cfg['Servers'][$i]['verbose'] string
    Only useful when using phpMyAdmin with multiple server entries. If set, this string will be displayed instead of the hostname in the pull-down menu on the main page. This can be useful if you want to show only certain databases on your system, for example. For HTTP auth, all non-US-ASCII characters will be stripped.
    $cfg['Servers'][$i]['pmadb'] string
    The name of the database containing the phpMyAdmin configuration storage.

    See the phpMyAdmin configuration storage section in this document to see the benefits of this feature, and for a quick way of creating this database and the needed tables.

    If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables; in this case, just put your current database name in $cfg['Servers'][$i]['pmadb']. For a multi-user installation, set this parameter to the name of your central database containing the phpMyAdmin configuration storage.
    $cfg['Servers'][$i]['bookmarktable'] string
    Since release 2.2.0 phpMyAdmin allows users to bookmark queries. This can be useful for queries you often run.

    To allow the usage of this functionality:
    • set up pmadb and the phpMyAdmin configuration storage
    • enter the table name in $cfg['Servers'][$i]['bookmarktable']
    ~k`~JӬ[],}EKЩn<S'>{y(`ȖLP"is3xf!Ϳt)sW$~SY%1U2nwG'j]$ўքP_>`vxMu>F54Fț|tdjA50Epo|28 k[n ;[UU#7JLNY/E{kb'')x-þ .谤 GUϹ"}iq<]ryM{M?pDp&oG@fA$y%q<_Έ] X:xd?D(v`~tz1tEY2努`Xm~a}d~Q_ݶcQ/KdXnKO=du +L3LJ=CO>ikUHIKʅskL R ~ WvŠ^E (Jn)ys%U*4"{'JJ^KL6BK1S $&3gP8p-[EjPbb3gLÛI߈GEG7ޡ%i L| &; S^|x5%<6BS\a10Ɠ DDyqV@Vv:<dPmYCp)˵iU(@A(*ޚ<Ifo69zMY3dق=}ѧ3Xy6{eCW>6J$ FJ0OZF~ I?=ѓ]O wYn4ɦ],  wwXP%o]=*K<sBèFӣ|Q<0=nPj\2vH? H[ g(1Xܟbb@\8#gxN"y hS@r!x|ȡy1 O3共0$׎ݕ~CیQ{U:(Mp( Go aI/-8 'rOU6vFe'!~< }>'b R;w7Ҋ nw_ޯqf#_) %N W!E t!ScA4+ࡦM4^J*5Y{SKdþ"D,d(wٗ4@hm"Y쌴∢ㅇR&ztj}I`aճ'IDkEa𤔙ySlZ/آHCD^!XjWRblKMP2*D ƏZCk_KcEֿؕ%AuF/P^|0L9(_|#IǠ#iq4VgMb~$Պ]-1w U?zhlv1u-#Ln$[҄IWʊYbra0!O>a8+AxAe:>, ٳkfPM709&P3ѡD=HYPiA/>U/?TwrzBRK}w8p=bPЩ;6J( &x Ps1ѠJ UPF(;/ tB}Ћmnn.R/;fex\@Bwo\F儲OO츹8RD#;q2@-9I}$0yȧ\d`ڶc - 7-`]Vp_.Ttq}'զYGS}ijzC(Cy-˗d{[sxsxӵ4{Rm}[4 sG"g«Ex ֲ\u&r-bYv=PzhQ0_C͠izJ p?6D%")b?<`>~Bװێ(&sHū;O1(`] m%f=⤃d=|d݀t;0b$(/0 1y)rQ(ۤ'> "ϸ̀9Sۑeܡ9Cl9#kȗm"6i8屶F5EEu㸀^b!R(O=؆5L2u;TP8KlGrgD낔2A'b~$F}ƒ|m z(*Ŧ ,8C0@~JtJvWF94­b)c˵]NփFVلj5"[Z9cZ3 A6jdU;@Y4BL18Ւ88!#ET7M)qxDLoyp$N-.EFigg{>Z? mq Av5*h䀇e8p^q0iP8n0Y#5 oDmKY>d󍙸EulI9)JkF޲Ig9up2sp |hؚ7o\݊/X `ToL Avgm6S=K7@W) ,p#Iw{ytsi^`SY-tNF khOirˁ,kґR<CjfĽt3rjv p&ƅŒ-59 2=2>]dSO搀9MCBNd$ڭs~0\'8$./T ࡑ ڤgx6TEdB~ˤA%UvނmhY4JprK1M%'=NǀaGF֘ʗ\*H*vKX/=ֹegcY*-Nu tYAIL 7ߜk{W򘊆^+/2X, g}Zx:4WܝHluT-&3&B4R 8~k 3kjL'[Yژ p|lƕ~x篢j,+ŽF3 v =437k *u(H5|Lo=7ZӼ*?Ĺp'v>{fa;ϲ%v=n4bLj$#V9R:Qm4kddsiZ Q)>ԵLi=ﻳӚu+qV6`7pG3{3ÇcgC[mUO$nbK} ߾V=s JO8֒pΨĸ̔ #$.\Jo7#ʜaacYa&N4iTշP 0ꖱ8UL< PH9MIf{yC9@.E9EcmW"(89im[#+1ЇUw,5GG1cQj/i)+g.N«q18t$E|IBT\mnp]d zh yӮ^ԢB#($WNj_Y"WBۖyX`*!a_lo$AÄtc=%M|kGzU~3\8/WkPL|1gW1[sEVWgHPw:>໓4Fk s:Hyef\seFJ"3YbGEXerd2gkCD\iYmb 0f¸ȋSZ.rdWdF qm|R7'@ipY#U4?gWby2k z({`fбF\>t V0f[D4q}>LUBXDd4Jldj+P9X9=a伳1E·:0C"mpt*s+BDɯSݒb-[Tү& E^𺨳v7\fJ]M ~^+_nvQ8wk;Nk'ih:c|ŢHֲ ~RO$\eO'¸GExN2f'ihÜ= N8r7ܲ{*Uqee۱74ПǠ& C-&7emͥŜNke?Ë\gV}mg7_=eѹƂT}B_bΩsQdҿY%iύw#IDa}*U6 DZ_%^jT|0+yßR hZm a_R:_%5wtEhSfcb| ʎ Z1 x^۴Fd hO$ *0L@ʴpZ~S/p/4,'|wf* O[!+9"s:[ *x i2;]P-O40-a<( yMJWXJ\geD&u.Mm(\='\(d7D#ex'fR 0j`D^F.Z}=+%6y*cYKAQtp9܃[z*V7ߴ.W`1ش|4͐t TL|w@Z)t.Wwӕl+\hj5 D>Ϣ,UUj9=M~M &8iV)ʾVgȕ5p=X&Om:nqr;Ĥ3@ 1upC&`{: ͘/E`azƨW$4Wù!rjJɩmv+Y8AK,H~İ|X 4*oyt(pQ~:'ۙ4(s2AqS2ߣ@8P:v9B'RX欲;d6hrMk;pݓS, ť蜊'O F>Ϸ(,a.;U m+3|2tտGER%?HqB$%E:%`nZ8՞ǼeBM(n dv34lgrOVu|͏o2Iii2|534;VKTnM2t-V !2;VT vdz6}XՠBUP>lfug 93+Cu1|*V~mذc$)vZc+DC~kbL끵x_Ut1K8}dG5,a2TsM@҆g?t:SUPs[qއgmzldGEX)DBkk).%wt1 n1ͺpPdKo Ԭ'hn_FWGQ#40j:"5ڏ3VU{fO[hgY[H&u603[8UbRB/v~dx U%\7W,!Zj"W.%Yd?ZbI,"ߠC`~dbg'tIC<|UJ}kFKɸx#%1/E^<\;̣iZ'𒆊!>մ3$cfg['LeftRecentTable'] you can configure the maximum number of recent tables shown. When you select a table from the list, it will jump to the page specified in $cfg['LeftDefaultTabTable'].

    Without configuring the storage, you can still access the recently used tables, but it will disappear after you logout.

    To allow the usage of this functionality persistently:
    • set up pmadb and the phpMyAdmin configuration storage
    • put the table name in $cfg['Servers'][$i]['recent'] (e.g. 'pma_recent')
    $cfg['Servers'][$i]['table_uiprefs'] string
    Since release 3.5.0 phpMyAdmin can be configured to remember several things (sorted column $cfg['RememberSorting'] , column order, and column visibility from a database table) for browsing tables. Without configuring the storage, these features still can be used, but the values will disappear after you logout.

    To allow the usage of these functionality persistently:
    • set up pmadb and the phpMyAdmin configuration storage
    • put the table name in $cfg['Servers'][$i]['table_uiprefs'] (e.g. 'pma_table_uiprefs')
    $cfg['Servers'][$i]['tracking'] string
    Since release 3.3.x a tracking mechanism is available. It helps you to track every SQL command which is executed by phpMyAdmin. The mechanism supports logging of data manipulation and data definition statements. After enabling it you can create versions of tables.

    The creation of a version has two effects:
    • phpMyAdmin saves a snapshot of the table, including structure and indexes.
    • phpMyAdmin logs all commands which change the structure and/or data of the table and links these commands with the version number.
    Of course you can view the tracked changes. On the "Tracking" page a complete report is available for every version. For the report you can use filters, for example you can get a list of statements within a date range. When you want to filter usernames you can enter * for all names or you enter a list of names separated by ','. In addition you can export the (filtered) report to a file or to a temporary database.

    To allow the usage of this functionality:
    • set up pmadb and the phpMyAdmin configuration storage
    • put the table name in $cfg['Servers'][$i]['tracking'] (e.g. 'pma_tracking')
    $cfg['Servers'][$i]['tracking_version_auto_create'] boolean
    Whether the tracking mechanism creates versions for tables and views automatically. Default value is false.

    If this is set to true and you create a table or view with
    • CREATE TABLE ...
    • CREATE VIEW ...
    and no version exists for it, the mechanism will create a version for you automatically.
    $cfg['Servers'][$i]['tracking_default_statements'] string
    Defines the list of statements the auto-creation uses for new versions. Default value is
    $cfg['Servers'][$i]['tracking_add_drop_view'] boolean
    Whether a DROP VIEW IF EXISTS statement will be added as first line to the log when creating a view. Default value is true.

    $cfg['Servers'][$i]['tracking_add_drop_table'] boolean
    Whether a DROP TABLE IF EXISTS statement will be added as first line to the log when creating a table. Default value is true.

    $cfg['Servers'][$i]['tracking_add_drop_database'] boolean
    Whether a DROP DATABASE IF EXISTS statement will be added as first line to the log when creating a database. Default value is true.

    $cfg['Servers'][$i]['userconfig'] string
    Since release 3.4.x phpMyAdmin allows users to set most preferences by themselves and store them in the database.

    If you don't allow for storing preferences in pmadb, users can still personalize phpMyAdmin, but settings will be saved in browser's local storage, or, it is is unavailable, until the end of session.

    To allow the usage of this functionality:
    • set up pmadb and the phpMyAdmin configuration storage
    • put the table name in $cfg['Servers'][$i]['userconfig']
    $cfg['Servers'][$i]['designer_coords'] string
    Since release 2.10.0 a Designer interface is available; it permits to visually manage the relations.

    To allow the usage of this functionality:
    • set up pmadb and the phpMyAdmin configuration storage
    • put the table name in $cfg['Servers'][$i]['designer_coords'] (e.g. 'pma_designer_coords')
    $cfg['Servers'][$i]['MaxTableUiprefs'] integer
    Maximum number of rows saved in $cfg['Servers'][$i]['table_uiprefs'] table.

    When tables are dropped or renamed, table_uiprefs may contain invalid data (referring to tables which no longer exist).
    We only keep this number of newest rows in table_uiprefs and automatically delete older rows.
    $cfg['Servers'][$i]['verbose_check'] boolean
    Because release 2.5.0 introduced the new MIME-transformation support, the column_info table got enhanced with three new columns. If the above variable is set to TRUE (default) phpMyAdmin will check if you have the latest table structure available. If not, it will emit a warning to the superuser.

    You can disable this checking behavior by setting the variable to false, which should offer a performance increase.

    Recommended to set to FALSE, when you are sure, your table structure is up to date.
    $cfg['Servers'][$i]['AllowRoot'] boolean
    Whether to allow root access. This is just a shortcut for the AllowDeny rules below.
    z+x[K!u̱moBx&UCx,\,^^ЙYp)dJ3{1xdxgOA +N[)so#!}ق0B>H%9x볐]}tXVK,sk!b ShaOwqOoilOѮT)#<]oX=(_!G|TښXH,/˥P8ޔ#^zT6]V00ZJ5#U:Jr]QHXfl2s?@/azy018Qzs}beGv{$Co*uV4}S\"`L1"Z 3qq]^vW znD ]c&Rsc{6fV@d!gtҠ\0ʅ#ZM{)kYpkn&uIۼ6'7 Bo}/j6[δ<=]U"GxP[к&,9(r%"=~v=LrNK=~aM{ַqmpUE\s_ WHQFO/OB0q0ٔqzHW-6Ik9|,w=2妐K#j$4Onҕ~xb#WsJ yUX0=t=sfc^4Jbg"df-N uQSk&MI"zf^a.yF:m5 )y ҽE%bjzr*Q^#;@lm JU&ǐG-pj<ݜ P]4k< ]i<=gy4+(d9dIc+q֯ѥlAע?.0ZV g2(tnGK_!|su62*L=ԽR 6-U) _G,*8iLg)Yb; w*ICZs *'2~F48oShNYxV>L:ԾS? ܅d(ƚ x@rP\e: wwEtY^!Iؽ43ł!<s| ?}7f9>$ص0R&l~M%>:se\(g![z oR{'@/=9E&n F]Zn!{ޅExϔt֗8[Tc$҂m0 hf#r9"ku|rw{2Ayw1+7yPY!#]0Em5*ZB־ |#+!jvZ{2P 3wu 0I%RɣRXv@wr >D87͚i#ωhw pE K~ qAh;$猲ӎ֭ ~&A~V}@XL0y`^Y{KÚva @1>aS)`pbوh L/tU c(}i=:˜cXȣ-gQCX7?㍈1]w?TQFU6C:Ӏ,~~-'.El߂ӯWq]e=~V/oyiḨ(6Bpf?G r2"ő]ڗ(8aH9s#2dP6]pu-M=u`ub JГ`Aug#` 7+^)]LaS;| Zz ]y0#c%O+9NS-i[jNkDp rD1 ]u`51_/atλeWc)aM 7Kd.RveIƤP!Yck[d%á;L) dhnerKD缵D"-_QxtBxxΒ.1˞|azq!#i&Lz gӋM"^Q/ y!ֈGSئ?A#8`8'"lkQDXd OqhOBX824=㚜ENsFo@-z<0 .sM2c IWi'Gfg=׊!w*oaȏ7m/U˷ʱI¬N63Ziʹ>5lo$'XFdИ>x]+ h>@#VB|EL+>;1`Ds\%_r:GLHEg8V'쎐ҴFu6co>BByfߠ85"}bQʾzgBO.|utOLlG5T I:ǸU7|rkBv_}j4:L'n27:Y1aPDfDr<?}[ߪ'd4(Quo-E(,)m]Dƺigj`a:R %>u>OYM± #T&-HIOp@$c|5K]`slTkY::ܠ@`+GD"xU~\Hym!b$ˈlI8M)]*떵 7tR4$kzk*p=xܛB9M kf['t ?#٠ow_ؒ B0 IThɘŗjb rZL%OҵnNF[Y1`SS.c*t@m18L2COSu0rKZu3߼&Xua.Tլ: =bH ]+=MB)#Sk,kIЎִQ:tREǙl ESϳ ?LoϮuD}{O-86J^UkUR /B}iY>`U]SKa@lwVkUwlȽe!5qI{~ܡyk4= Yux!+$뚗j 5Tɐ=RE%<'. {zS%`B@Uu[œdb0{TM]m`#ʕF? DkP^_m|5KE(xvM(x՘w΁^X|2-(ӧg(u#Gr )!6Ï^kvW߭Y):@slj8l!@M\G=BgzՃ"y>n \Ϛ]i@pwUŧr8ym!"='ۇ1T[O{#nIDƺKf&yfZqFI[L15\[(xfs=D=@1s;{%}幸x|^0"7/0Hnx/G[4na_8IS;LYu2`O-ݾݕr~48L aӉ|؋-O u0e)4w,`e&V!@W4|.쐆06G,8sPٍ^#?wrнX8U3-;aoIv߯4Uon*3~'-0 qأ1h}5Ny}wB$2vW'X`?:U$h,`LQoƽdOLV9]e)3m |J C d/s5o{;bsפc@q@l 7 Y,Q|9U_/6@f:З ̝+O+iXNNϿ5^30嵜m*hu|Ckr+\wXd2:ЏvhQ61hMƒԄu dnVM֙ޑj-hOIkGSq^8~B:qbUyю)bƲ ~hz#@p uN:߭Zʝ}@5X aCd}N#p\]'y~k4ʏ*g,*xbMb7V}G_ '`e;IptHˈ`&T3/f|G̎0Ԙ0s i>#/m>M8˸)xd~ myŽ+X5a6v+bYzƃD:e4ʔX0yLx7>w1(mҰy, rVKx9z0L˶^32VW)eʷZMw\yӞIwڇ;X 0&R71%cl^~3A2^ tR4J- n pn8V A:{p&K|ZJK&[ψ}^$N hRJCF诿ˏg;W+ZSLoU7%zEKftKd;}jaX0Z6)1"(aA |MA|HqNʞ'ōk;PeN7wc[j*wx*݄vSJ{ME^6j,3.uهkp,eZ\2ZJo2$+Lփ``+f@b==)ޫ3F\ҳY;.vqLaTrqcdOulWw0 u?E1 Qt4cF9~+l!cδE%b9I-& APMDZh[ ]lgvVꆽ7FtFY4`tG .K5&+\IsM(46) =Pd2V MhŋY.X5?@/6<ی1v}'G^MHֳ;.G0}K^a?C3hZ% dy˜/np;I`k>h|,Xr7AiXw<^{#²$M3Zp=2>lpueI$&ozO}S@t [$4DP1^+0/PZ=,?j^ (#Ω08:Ժný )ޒ/UcCquZ;AGprG#ʲˮX$I$NM5)CϨŨinfUʪ'~Yc*l. ,A hF'lIA/^.3Pv|ݽj{j,iHIM *N/.;:1/ ͺ ˋAg/qKOQTؑ,=k_ .aIADcOLP7Ov+#8DwE9܍dnZU%7Ũ[N^S ǒw$c?4Rp e%b28;?aDIݢv#rueGtl5Ddǣ{?vlHqjzj'#r IهdV$d$塚,dۢgG Ns\v7GVw.h}e a՛?cA[C+SBf )m_ an4r4k5 50 Ԛk`/M#yTM` -q> |tN4M,U%}] R%klrt 'tKE4Mf.K鍬ZSbzٿjrHb 0 tʛY;0\OPߠ޾еok1ݠ7W]k^`f}]۠Jx򎉵0(l…MR.C'Ⱥ9!-4&"&D.?`vcP;^j72nPB lw2uhװ iS_&!wwfwv/-THD7i#Ww") 4bG{[8wپ"&ż $gxBڴ1)KP ?—R+]n2AܨcxK؞ 1SW8(L[A$9UHh4(=p85Tg+:!w+3k3̈#(+OvAM%/G 6z͋luUT%I Q*ٮ9mf5몾&uDyc)֘,E>;JU+]F5^Izآv~.ivdbow_wa lo,n{x`+V*mCVTqCO r^e7G#F7m3GnW\i(*+u
    $cfg['OBGzip'] string/boolean
    Defines whether to use GZip output buffering for increased speed in HTTP transfers.
    Set to true/false for enabling/disabling. When set to 'auto' (string), phpMyAdmin tries to enable output buffering and will automatically disable it if your browser has some problems with buffering. IE6 with a certain patch is known to cause data corruption when having enabled buffering.
    $cfg['PersistentConnections'] boolean
    Whether persistent connections should be used or not. Works with following extensions:
    $cfg['ForceSSL'] boolean
    Whether to force using https while accessing phpMyAdmin.
    $cfg['ExecTimeLimit'] integer [number of seconds]
    Set the number of seconds a script is allowed to run. If seconds is set to zero, no time limit is imposed.
    This setting is used while importing/exporting dump files and in the Synchronize feature but has no effect when PHP is running in safe mode.
    $cfg['SessionSavePath'] string
    Path for storing session data (session_save_path PHP parameter).
    $cfg['MemoryLimit'] string [number of bytes]
    Set the number of bytes a script is allowed to allocate. If set to zero, no limit is imposed.
    This setting is used while importing/exporting dump files and at some other places in phpMyAdmin so you definitely don't want to put here a too low value. It has no effect when PHP is running in safe mode.
    You can also use any string as in php.ini, eg. '16M'. Ensure you don't omit the suffix (16 means 16 bytes!)
    $cfg['SkipLockedTables'] boolean
    Mark used tables and make it possible to show databases with locked tables (since MySQL 3.23.30).
    $cfg['ShowSQL'] boolean
    Defines whether SQL queries generated by phpMyAdmin should be displayed or not.
    $cfg['RetainQueryBox'] boolean
    Defines whether the SQL query box should be kept displayed after its submission.
    $cfg['AllowUserDropDatabase'] boolean
    Defines whether normal users (non-administrator) are allowed to delete their own database or not. If set as FALSE, the link "Drop Database" will not be shown, and even a "DROP DATABASE mydatabase" will be rejected. Quite practical for ISP's with many customers.
    Please note that this limitation of SQL queries is not as strict as when using MySQL privileges. This is due to nature of SQL queries which might be quite complicated. So this choice should be viewed as help to avoid accidental dropping rather than strict privilege limitation.
    $cfg['Confirm'] boolean
    Whether a warning ("Are your really sure...") should be displayed when you're about to lose data.
    $cfg['LoginCookieRecall'] boolean
    Define whether the previous login should be recalled or not in cookie authentication mode.

    This is automatically disabled if you do not have configured $cfg['blowfish_secret'].
    $cfg['LoginCookieValidity'] integer [number of seconds]
    Define how long is login cookie valid. Please note that php configuration option session.gc_maxlifetime might limit session validity and if session is lost, login cookie is also invalidated. So it is a good idea to set session.gc_maxlifetime not lower than the value of $cfg['LoginCookieValidity'].
    $cfg['LoginCookieStore'] integer [number of seconds]
    Define how long login cookie should be stored in browser. Default 0 means that it will be kept for existing session. This is recommended for not trusted environments.
    $cfg['LoginCookieDeleteAll'] boolean
    If enabled (default), logout deletes cookies for all servers, otherwise only for current one. Setting this to false makes it easy to forget to log out from other server, when you are using more of them.
    $cfg['UseDbSearch'] boolean
    Define whether the "search string inside database" is enabled or not.
    $cfg['IgnoreMultiSubmitErrors'] boolean
    Define whether phpMyAdmin will continue executing a multi-query statement if one of the queries fails. Default is to abort execution.
    $cfg['VerboseMultiSubmit'] boolean
    Define whether phpMyAdmin will output the results of each query of a multi-query statement embedded into the SQL output as inline comments. Defaults to TRUE.
    $cfg['AllowArbitraryServer'] boolean
    If enabled, allows you to log in to arbitrary servers using cookie auth and permits to specify servers of your choice in the Synchronize dialog.

    NOTE: Please use this carefully, as this may allow users access to MySQL servers behind the firewall where your HTTP server is placed.
    $cfg['Error_Handler']['display'] boolean
    Whether to display errors from PHP or not.
    $cfg['Error_Handler']['gather'] boolean
    Whether to gather errors from PHP or not.
    $cfg['LeftFrameLight'] boolean
    Defines whether to use a select-based menu and display only the current tables in the left frame (smaller page). Only in Non-Lightmode you can use the feature to display nested folders using $cfg['LeftFrameTableSeparator']
    $cfg['LeftFrameDBTree'] boolean
    Defines whether to display the names of databases (in the selector) using a tree, see also $cfg['LeftFrameDBSeparator'].
    $cfg['LeftFrameDBSeparator'] string or array
    The string used to separate the parts of the database name when showing them in a tree. Alternatively you can specify more strings in an array and all of them will be used as a separator.
    8ok*2a= nqWƞÜJ\4ܩɈY{ ,7{jB')cloj _/}_3~P3E,LmxQ[w`5S5Y&$e`W ZJb꧰Mq-Ȧ]t|л5Uhߞdv1յqF7zn!8 :E-/wu#2e=F| ċU>@A1%wڟmoX!K0|1X}X=Es>^ Ē<C~!82gC+w{ #6M[E+ⱬ*-L8^r=R9`dqm_ݘJ"O* e. wq(%[}ZA~EtBDn;wՂ tH[:Ui `g1<5Ӄ߰d<;$IsX ʖ:܍C fxZy,AC'adX@}|6jIq;G[A,vzRZ,@ %/1fCBr80_o5^ٛq  E_/!t,;>M3*?pR,&&w> ë5ᒆd"{_D0Ϣ8$猕$ 0Ex&)51p'2xg a``sv3dơH@M vkԨv\$~`bHi+ 6BoJ rSWeٳeގCo@ yB#$'R"mJgdXKš'K#zcAkyeL\--&p'JO@_ha$K֫rj a w^1I:VP ˏsi]ҶVzGr`Ê*΢َ2Lch]x]U Ad ^:38 Cݞ2.Ζn|l\ 2<=8@`Y'+ Oo˘#ppcpn2-_fPEi^Ԭ^9$ .~%${absx 0`ڬL+J5af}7FJ%gu8[ǾvXOX YhVMz|yVtV}Ӻ}y@\`/iBre?7,]389+ ?$ e!DVې=En͛)bb)كUYk/QGrGVke:wLl `@Eo\p̳[U&;+*`"EhmZYz8fQPW.'8 Pp__q%%? cY(7ߴtpZv̊Q`r ~d_"$҇9Pl74TV;4(a/vfY :,Mp -Ц݌ ~:I;]٥ uTQ7]$k/·o bV~ɹP;5H:MGnSKZҚou(ip3G0@oű]Dd{0in4ltmVf.ot˥baM<_=a Z 9zOk?n b/}g9( /o!p1sାW jʱ&Gzx`aWeFC"navkȇ>: u[>F2IkyK̓*A H{KGIW5KF`4ؐprz"@T*1lW1;oO4KYcnhvbK!fwTS6$A7_dw3ך<Mս2 qLwwbq˸d;%%8`皖-;b9yEfjYN:cK8ENFVN )kk ~EשFSRWp75 P3~6bJYQ`dNOq3qTs=7wEO4<A[F?1 5֗W})~` c;ç>_Еc<VOi݀ƅi)~;<^8>mgnxpuI[HC&Ye.Q)AXA4Bn|6(‚]6rvR+n3mrmEc$y`ڰ o3C} 5Ye CcCuХ?ۯo7N$H'E4L69/ 9F|JX|kq5>\kCZ G~'|VqWeDqP 2z8[KƑ!s-Bʼnq0;{rm ?ͫs ǞѤ.rmw7Ѿ~iy/շpk1߃̣sk'osbWQe+Lr֠OҮʘt抣@yq`FU-;5J&Y~tdH@ݮ+fY2yxL>E)%$k>)*B\j ``oK]$`ߒ^Iϓj^xBjFƘ\)Z|8׼'TZBЀ’$W0# :Ֆ}ϡU6QA)ulmo.l^oC`O "eNüv<Rc}5?G!x~&x_-nkGL5?p+'"F^Km(Vv)p8A+q" ]rǚ>Õ LcwmN_(8S;:eT6(T<;rB&`PlV%+e2{DJbOA48Y>KJJ.}7)Z嗰rR<69IGdV=YHY|Q B VX@yr [~.U $zwCz\o|"p/FSߣ NB`G uׯZ|:*n1%3}GI>jk9X36o8swg,7$_xCjD"ӏ[| ;Sgi#@&٦D/r&ByJ0lsX73<@~&8ZS=n:(2@$ULYlw*|Ԓ\)4y n\TqmP KWϨn慎p" F>l' KQw,b+6Be qfo}=ؚ{x,G4$=p;0/b V^̈AiXld˶|7 w`՟4Y []5<(^XcAS{ s!{E޷( љ1v?Kԣ~Vm/i!Q{FS͸lZߌ3țI?5?}=8Wdƌ\gڴ%;`(o>@/p& zBC?0~)9?4`~l-)SKʌrHLtD!OܙNz7T80 C?!P;zХq-W~VY>(g:f K<`%7eHP%A\QuΑ. q|誄T MGx19'6Eʻ]VC9B]dRU'ݾŠc`c>kNmiz߽@Րը:pZ!Ibo-~GwBk)f1FԳ(KnGĒ4bFn]ҝ1=S}* {ʖ?35ݺf^J/r@7Pǽtw6;4|Q!:0KBBݿي>z TL"8ofӽ_ѣLVkRj$#b~ ؽv?jϴ@ucE'8qjs*g-KZ~\a_OȐ3Toy9d+f:.ۊ&A.mUdF 2x0_Y1ۯ𚧠Rvj|*nXK`bĨx"ۚQŕ8mQE ʒ0# н&l%% N]nD{) Þea?|ÎD63*_0;8Aܒ(Y5cUKş:C"ڕ(r ݮ{ t4Al\Erf׈4vD=渿lqݽ[Q?_1U^pٿBs=D8lJ'S-y*Kc3fW\Ye3z90V5< 7~[=Iw?,2B0A)7~P-kZ>5KO( W?#H H2~+CpjlmiA۰OgC{t9QGK+8K`bqRnvŷAJqEFC4M]]HMj{zG!Չ4O&Ү0la:Ρ)~QH>WN:S;W[>>)Lq 3Ol֤WCz<.VBxe ZuWka6B<잤g=δ PsKh>:5s)`kOľ!h _3}P~"W\B/ERږb|kק5eY.~*\^Y\mjY.[ %zua{h >Kc%5®Ȗ5 ^-tƑnA~>Fp"TP7Yeh/M b3jHc5Umq=>o6RZ<|xDX{/,GixI columns.
    $cfg['ShowFunctionFields'] boolean
    Defines whether or not MySQL functions fields should be initially displayed in edit/insert mode. Since version 2.10, the user can toggle this setting from the interface.
    $cfg['ShowFieldTypesInDataEditView'] boolean
    Defines whether or not type fields should be initially displayed in edit/insert mode. The user can toggle this setting from the interface.
    $cfg['CharEditing'] string
    Defines which type of editing controls should be used for CHAR and VARCHAR columns. Possible values are:
    • input - this allows to limit size of text to size of columns in MySQL, but has problems with newlines in columns
    • textarea - no problems with newlines in columns, but also no length limitations
    Default is old behavior so input.
    $cfg['MinSizeForInputField'] integer
    Defines the minimum size for input fields generated for CHAR and VARCHAR columns.
    $cfg['MaxSizeForInputField'] integer
    Defines the maximum size for input fields generated for CHAR and VARCHAR columns.
    $cfg['InsertRows'] integer
    Defines the maximum number of concurrent entries for the Insert page.
    $cfg['ForeignKeyMaxLimit'] integer
    If there are fewer items than this in the set of foreign keys, then a drop-down box of foreign keys is presented, in the style described by the $cfg['ForeignKeyDropdownOrder'] setting.
    $cfg['ForeignKeyDropdownOrder'] array
    For the foreign key drop-down fields, there are several methods of display, offering both the key and value data. The contents of the array should be one or both of the following strings: 'content-id', 'id-content'.
    $cfg['ZipDump'] boolean
    $cfg['GZipDump'] boolean
    $cfg['BZipDump'] boolean
    Defines whether to allow the use of zip/GZip/BZip2 compression when creating a dump file
    $cfg['CompressOnFly'] boolean
    Defines whether to allow on the fly compression for GZip/BZip2 compressed exports. This doesn't affect smaller dumps and allows users to create larger dumps that won't otherwise fit in memory due to php memory limit. Produced files contain more GZip/BZip2 headers, but all normal programs handle this correctly.
    $cfg['LightTabs'] boolean
    If set to TRUE, use less graphically intense tabs on the top of the mainframe.
    $cfg['PropertiesIconic'] string
    If set to TRUE, will display icons instead of text for db and table properties links (like 'Browse', 'Select', 'Insert', ...).
    Can be set to 'both' if you want icons AND text.
    When set to FALSE, will only show text.
    $cfg['PropertiesNumColumns'] integer
    How many columns will be utilized to display the tables on the database property view? Default is 1 column. When setting this to a value larger than 1, the type of the database will be omitted for more display space.
    $cfg['DefaultTabServer'] string
    Defines the tab displayed by default on server view. Possible values: "main.php" (recommended for multi-user setups), "server_databases.php", "server_status.php", "server_variables.php", "server_privileges.php" or "server_processlist.php".
    $cfg['DefaultTabDatabase'] string
    Defines the tab displayed by default on database view. Possible values: "db_structure.php", "db_sql.php" or "db_search.php".
    $cfg['DefaultTabTable'] string
    Defines the tab displayed by default on table view. Possible values: "tbl_structure.php", "tbl_sql.php", "tbl_select.php", "tbl_change.php" or "sql.php".
    $cfg['MySQLManualBase'] string
    If set to an URL which points to the MySQL documentation (type depends on $cfg['MySQLManualType']), appropriate help links are generated.
    See MySQL Documentation page for more information about MySQL manuals and their types.
    $cfg['MySQLManualType'] string
    Type of MySQL documentation:
    • viewable - "viewable online", current one used on MySQL website
    • searchable - "Searchable, with user comments"
    • chapters - "HTML, one page per chapter"
    • big - "HTML, all on one page"
    • none - do not show documentation links
    $cfg['DefaultLang'] string
    Defines the default language to use, if not browser-defined or user-defined.
    The corresponding language file needs to be in locale/code/LC_MESSAGES/phpmyadmin.mo.
    $cfg['DefaultConnectionCollation'] string
    Defines the default connection collation to use, if not user-defined.
    See the MySQL documentation for list of possible values. This setting is ignored when connected to Drizzle server.
    $cfg['Lang'] string
    Force language to use.
    The corresponding language file needs to be in locale/code/LC_MESSAGES/phpmyadmin.mo.
    $cfg['FilterLanguages'] string
    Limit list of available languages to those matching the given regular expression. For example if you want only Czech and English, you should set filter to '^(cs|en)'.
    $cfg['RecodingEngine'] string
    You can select here which functions will be used for character set conversion. Possible values are:
    • auto - automatically use available one (first is tested iconv, then recode)
    • iconv - use iconv or libiconv functions
    • recode - use recode_string function
    • none - disable encoding conversion
    Default is auto.
    Enabled charset conversion activates a pull-down menu in the Export and Import pages, to choose the character set when exporting a file. The default value in this menu comes from $cfg['Export']['charset'] and $cfg['Import']['charset'].
    $cfg['IconvExtraParams'] string
    Specify some parameters for iconv used in charset conversion. See ico$.X^pGh ^ atҭ~*#8(K{iL$}Ż,Ta(r `A}KwUjӝO]: vGIS10%( (3 )  liZlER_-%Bs!ߊZdh>&Mi ]薕@g7.Ul?F9kْƂ`%]v?d3<ޔp\m=XTav3c6El'v; #*U)h'' Wxϔ;B{.Tw#TC+"g;SD,&mB\h-[!⟪Z3)6U(1}loE BX-yTXqE>R&S߲Q fqv-B,W=> jiNpNGtÓޭ<s7N:O _sDk9|+= [2e/ֲdV iY^1=Ht3umnQ Лdr# E5%\?m)8Ϩ{AYGf ) 2$srasX_69 ]bAJiKLnDT8I̞&t/ 5{cke50?H*L)ۢ8Ge٢!W񲩸J,$xHhϬY&XQ=6s秝020xK쑗}8T۠GOyg{ :!7ɭ|˫ONxnd<+'Y*xNk# W6KxlK&ďGZ-Qm*4-Zƀf 7ZGp+9EЎs{nL[#rIM> ⷸ"Sn}A'!}Me 3"1G/_6 R`BU_E(id*zA^2_kkZzƇ<- K^Ǘ);̌ЮAzDM1 EUѠdlyen1Z܋K iEox]Hd)T&/Kǚg9oRӖȑB⊕3j6+Y" Nٝ{/ձ`ؗUSru̩oBBڮB Bw vC.yk(t5h){਩딡t澌W_ T 6ޓ> ?Fa:sKMul5둓!\oZ5zy/aeӆT *mt=D<pTϛSKe2F+fU^YZCJCZG"6v>_^O?P"R ˺$:}Wgjixqt4I8@ϼo3.`#,)Q;, hT8vK_2,lj}q[ka%Z[Qȳ9NI'ٺ. +eN _hHbՀLh~ 0S``t Ceg_l=,]ģ2@K4Sq~Aх۶:Ǽ@'p{iWTiˉkJzj]!a\)ONM3ހvܤ@OrH[Xֲea$'Pq VIC|uZTM-ʰS2\ !_8M:]jsC-]E:3D!LpCr*8 ` W[6XB L[u-yzBJB$BVˁč' CIУ&\m/ 5]0#d~=? 쫞||[d9i{]!!'q2ly iͮipjg5϶m# ,8#(vCpX 7V;1t d>}C(8AfII֚F* N ߛȖ!uy5d$󞭳? ߪ0 xxPXVZoOZC$凬KbpR<&s?֫kr6z$2]Y;NJX-PYHv_q=S6 }}<^Sdd>,)FcmYWzKSqN9$e߄5d=Á R G zIs;/a,Y:-s!(8zJsxfߑ00%A$̻6`ږ<"N^4cE܆Y}Ox?lB2"EhX }NW"zȔ +P Br"l!^<~tk!DK*ER gN^p)vcDT1= JHRҵ$fuqk@'scp+ہ9k$2cCjJwʙ`D(ѾyDx!UziI @sV0F/x;q՛0/^GdG~1- ]0n$<mVLKK#FAANL5$GIx% Q`uv{L%S+2@ʽk=1O;'14дz'CA@ܒɮ,WTM=Vc܃;"fÁԦlмϐNRձ1hR`3r%Hxo9Xfx@CXllzv=$w<}{W^`.ω>('΢%j( pRK?˹@@_?c^($L-ۇ;8jq "/%RbD@Hȼ5I3_K:t@%|$lxey )0"d;Wl-mxR%) n/":q b/5( T+nš\ 5CՋ?J#syLXAiTAW+&hA]1sS;mb7[/QOwyPh0*"\abxyFԒ 2Djkq(@XF[޸ z2d#_c, z2xuQ7/,!LGӆ$ܶ3>x/܂+5s?AhRy%oNl#TO4.tûl^$Wu %!9yBTC/s 8]gPCmi ECi/nCԨtWb,PFhSL);Z<"ys_fZxO%o{pVyztX( zWLxڏvEJ2UadtZBg(B,)wMQ˫b }!aR2aoɯ55|û:2]Kľ_mȭahMk9i/ؐad~J? 3Ipk$>\6Yz, JW>q0ʍS63cv˶y},kS.-,(ucq=A?ˆ>b@W Pd4:z6qCG /oJG<=[V}avnf|qovh\)^U"1xpFPTy)y_?\q݄[x5+ Ƈxm#(+("JAڨ̼--eܶk|"3#Œ}1D8FЩxm5NNK 54oB8>Jt=Ge XSE@w?6 g~`mwgM4a*lbg $"d~< 7mwjx1Ya0r xdXR`AX_ d9{g> ܱslasKqU={n{6FGo8E^~p\P[q}o> ^("21ʤ4_ !VxDrb0c$Vd70(#|6ok4P4uyO&Gpu ~U8=q4PZh^p w1Fx{]sw}O4f7Gyɯ׿ _b SzIp[vK3=Gܽqn)0t RvysdԆߠ3tެgZG9:༳W@זΦ, > 132eBm,5tX ^_yS^%/QM\adGh |!1Ǻ ”1VSc 4! 6Cbu ȨCĸJ2`(}͐=AX<6_#ح3*\xgG}){51Róx:'z"BL<ŭP[KP$.q--vG#\fe+I<8Gv|Py;b`Q+15M&TkI3*e&V;!z7 iMͻoS,vt|:Oh_4N!ݭUԞcIt7R-}()>;v!:8b['WfvzU>/0{,E&dtpe45K:`_~uƏݡC٠SUorSD˽.Hq(Bbm4͔qw,| 3)\;-[bċށ}H@ m{L:cpurWi+ʔD(JCUژ7W]t]hUkSt\-d͚TGFH[Z쩀f@t_)ZY;/$b)#7tsU 1*?AF,p]i(I-䖇؃TɧVtI;rLinϑ7t؏Nzq陁nw_a3$pW=W6$&&Wl?}©(M{"ϲk?@F5^ FWD"1>axlInYAK!Կd`븸l9";hP2|nޮ~z}X9N j|}(FG|ɱ?%[Zg˼, R `KW0,["@MrBjds)X dYP ܄/¥V3LYKݧEz;͟ %c`_!`y?c7wgU%8^@#8K2r5 )CK9y-ommahY冱%Wc#qwtML}}{&ȅWVl$|mTvAm}B^- d#Px4F+-LėT[w 1!u07PK.?:gU!%0pӞwlXPFwNlo{cyx}z`TS\soN޸BkkJ4]aUDB&Jc mՐ3MZ5` k@"3O+-z!7%/}\)Rf!O1/Co ЌAkPM3!TсB`)rijF^Pל̉zz" S\̜DNjS;ݓSL:ylKz#؀HBqTj-SkgO6 ^,2L`jftpn7K^ MK={pbP|&/*34ը2٩B)"O6 Th 1evC!6+ ?V5U݈IfE[F(Y_'Is#rgP(tX/>Y
    $cfg['DefaultDisplay'] string
    There are 3 display modes: horizontal, horizontalflipped and vertical. Define which one is displayed by default. The first mode displays each row on a horizontal line, the second rotates the headers by 90 degrees, so you can use descriptive headers even though columns only contain small values and still print them out. The vertical mode sorts each row on a vertical lineup.
    $cfg['RememberSorting'] boolean
    If enabled, remember the sorting of each table when browsing them.
    $cfg['HeaderFlipType'] string
    The HeaderFlipType can be set to 'auto', 'css' or 'fake'. When using 'css' the rotation of the header for horizontalflipped is done via CSS. The CSS transformation currently works only in Internet Explorer.If set to 'fake' PHP does the transformation for you, but of course this does not look as good as CSS. The 'auto' option enables CSS transformation when browser supports it and use PHP based one otherwise.
    $cfg['ShowBrowseComments'] boolean
    $cfg['ShowPropertyComments'] boolean
    By setting the corresponding variable to TRUE you can enable the display of column comments in Browse or Property display. In browse mode, the comments are shown inside the header. In property mode, comments are displayed using a CSS-formatted dashed-line below the name of the column. The comment is shown as a tool-tip for that column.
    $cfg['SQLQuery']['Edit'] boolean
    Whether to display an edit link to change a query in any SQL Query box.
    $cfg['SQLQuery']['Explain'] boolean
    Whether to display a link to explain a SELECT query in any SQL Query box.
    $cfg['SQLQuery']['ShowAsPHP'] boolean
    Whether to display a link to wrap a query in PHP code in any SQL Query box.
    $cfg['SQLQuery']['Validate'] boolean
    Whether to display a link to validate a query in any SQL Query box. See also $cfg_SQLValidator.
    $cfg['SQLQuery']['Refresh'] boolean
    Whether to display a link to refresh a query in any SQL Query box.
    $cfg['UploadDir'] string
    The name of the directory where SQL files have been uploaded by other means than phpMyAdmin (for example, ftp). Those files are available under a drop-down box when you click the database or table name, then the Import tab.

    If you want different directory for each user, %u will be replaced with username.

    Please note that the file names must have the suffix ".sql" (or ".sql.bz2" or ".sql.gz" if support for compressed formats is enabled).

    This feature is useful when your file is too big to be uploaded via HTTP, or when file uploads are disabled in PHP.

    Please note that if PHP is running in safe mode, this directory must be owned by the same user as the owner of the phpMyAdmin scripts.

    See also FAQ 1.16 for alternatives.
    $cfg['SaveDir'] string
    The name of the directory where dumps can be saved.

    If you want different directory for each user, %u will be replaced with username.

    Please note that the directory must exist and has to be writable for the user running webserver.

    Please note that if PHP is running in safe mode, this directory must be owned by the same user as the owner of the phpMyAdmin scripts.
    $cfg['TempDir'] string
    The name of the directory where temporary files can be stored.

    This is needed for importing ESRI Shapefiles, see FAQ 6.30 and to work around limitations of open_basedir for uploaded files, see FAQ 1.11.

    If the directory where phpMyAdmin is installed is subject to an open_basedir restriction, you need to create a temporary directory in some directory accessible by the web server. However for security reasons, this directory should be outside the tree published by webserver. If you cannot avoid having this directory published by webserver, place at least an empty index.html file there, so that directory listing is not possible.

    This directory should have as strict permissions as possible as the only user required to access this directory is the one who runs the webserver. If you have root privileges, simply make this user owner of this directory and make it accessible only by it:

    chown www-data:www-data tmp
    chmod 700 tmp
    If you cannot change owner of the directory, you can achieve a similar setup using ACL:
    chmod 700 tmp
    setfacl -m "g:www-data:rwx" tmp
    setfacl -d -m "g:www-data:rwx" tmp
    If neither of above works for you, you can still make the directory chmod 777, but it might impose risk of other users on system reading and writing data in this directory.
    $cfg['Export'] array
    In this array are defined default parameters for export, names of items are similar to texts seen on export page, so you can easily identify what they mean.
    $cfg['Export']['method'] string
    Defines how the export form is displayed when it loads. Valid values are:
    • quick to display the minimum number of options to configure
    • custom to display every available option to configure
    • custom-no-form same as custom but does not display the option of using quick export
    $cfg['Import'] array
    In this array are defined default parameters for import, names of items are similar to texts seen on import page, so you can easily identify what they mean.
    $cfg['SaveCellsAtOnce'] boolean
    Defines whether or not to save all edited cells at once in browse-mode.
    $cfg['ShowDisplayDirection'] boolean
    Defines whether or not type display direction option is shown when browsing a table.
    $cfg['RepeatCells'] integer
    Repeat the headers every X cells, or 0 to deactivate.
    $cfg['EditInWindow'] boolean
    $cfg['QueryWindowWidth'] integer
    $cfg['QueryWindowHeight'] integer
    $cfg['QueryHistoryDB'] boolean
    $cfg['QueryWindowDefTab'] st-|¿*(. 3xLpԗqc(ٯn;*Hm#x%ӂX m ΅Es6Ix1IAڬSj~$գcXi8 Ճ{泞bkXF!{&WnϺbZJpz*b_#^@Vb& f@Qb9H ',Eb3TE%y[Q_=݅Wp W._=甏9\8F!ϕR^b"FDo ( Xj$'3Ð< +)B[%Jp'Cq]IndVD&VLg\Jo~8=` 8:pJ,3|C}s^]o{jQ8h9sҺ|x62ެpb=@yatrkE~ݺ<l??@l?.QG6e~3oϲRPN-l9XѰob5+!2qTҡLumYF`HhQ?1_s-]AM5r;dT 5c1Гd#b[ޓK%R.& ؠ{y84ZXݽ$*N ۍ}5K+2fEXVSsAJ/f7!$~:p_I9p }$owWʉ̅ Aluo->-&^Ùw7MKꗊN/njz32͓Gx=U~\>n;>g#{Ԏߕ]orhje0``?uok%Xoc .~kQDl1ISB#k{ 4ZwP ٴ%yÂM 7,h 8xWȳ2%p`B;^@/9!?!˹)k#zW㕟WE75(nɅރ4*֐Q# Sl\AJ#8tCm:0er`'`4ƻI0г;ZZFA%c D1DARna,hP&O2j;+P4r(nB!qG\m*mEsŁs'`q=QI+NrA o\f+e+wI~CkB;suAq.1WidUƬ9,E@SpQhin܊Y+yI9$%8jVX.0ƿynxxǖXVXE][j(Q&FŅɫ SnXŎNo8z8dpݾti  N.}%+*{!sD#2)hK\{v `)[[SUPb@? >/%/ \|@JJa_{fku + \,=/Ϯk@FM\յ;{$P+y 7ӂckp쓿TnA4簑KطK_Dg9]$Kə=%BV+O,b1JybWxL!3p=]C}r6Q 0ْ1+04'C,L3~41&ks5ɃZkJӌ*+5U1QgPygB)E?jiO4Q.rLi9/AHIx$@)"% >Ho9e]qiz3jcޞ.]8DK 5Lփ ºJS,di|"c]w g"5%9_=2J&|NkM'ء! V͗'/eJ \ ]KBf-8Ao Lk!,Ū7 iF"7kLIUqYk񌰷*`Bc-b<Nu6el"J!tz\:*keòB>Z{kOo;:wV#|b٩ Ŗ^f4H%e-DjS郰]ImDVr:uNUt PPc} t&W$V!T<- )%C*nRtM|~w3,I%^|Օ0H+#2Z cT?Kް/Kz:ssb7;RyaԜ6EC܉K,<Qv1+*Tͅveo_Ii]A>@RL9;懙poVdQ5!.\[~[tm#7%861U'\NZ]rCFT˥(#jl~sVX`.֕ @qY)Ԩb'fx[Wmu~qՄI3s u]Ni#HxZz9t|9Eej^RgLl1\X6`U `UZ9mTV4*:&kD(>~9^ u9ΐΈ?%;Ztp@ŷ( q9`z2=k+VOs]4ٷ{(՜\34((_y9潆Lu䀅0˵]dOKD |'.Z{|CRH-QWzɺ~obFh'%]%aC56Nވ4DQ u675$ł+ߗ_Ib+Vz gۆO(:CvYȝhmކ&Xٴ)y@.!ӵr bCG`s'4#>v7TTldIoIvAS]|6o9-}o%L@.u8LP'&Lm⽑LrI۪N }4^f6BI.)?\7n{Q}KۏͲL[OvQA˝Qs0D0$͒zUŎ1i7a)iJ 8ZWV!,~>I1 )\2j!,%yN!ukf3Ch>+ҡ a}>J?L)໻) ("N9ɀ2& okdB?\"XkVǦuGg`L'a$-fskkPd^W7?~4qAppE55ΰ4QW Ć&!L.ll+ֽ}M< \a^BKU_2cLzr"uųѿM93bq)i58JĘvCW{ e,q^!TOASH8j:E$#JMfJqi-nl}c'`0;H<NrjZ }%Q9"ep? 3g3!םe>rƓMץrT>O"/%Z qzjlńSа844.n:# r`R/J "G$QXi|f!D?=`9J?;.1T-ˉU!~sbSMՌ5}賭jIJc+k j,vЩcSU:(c)"5ܷQ΅.I'X"u}"#t >K '.)3Va[o 9T'g[xFkfOPB Y} !7{ /MCA ԍl^!O 'Gb@z 6x5.TۘW w3M4ZI?1-H 9FkO?H҂ MXfR,ܱ瘤QGŋ1C7 xW/8ңc'h6=hϡEa԰ezv-Є.QTKb$DUO{mݕ2w;Fr9 &0Z騫>3$[`~5>_vF X%l3  ɖ:phuh鎶NZ_+$؉H6bܦJ'Q!/؀A /oF0,HCA$%%̙QL'L'%].Hv)d^6(߯vrP#;lV=ڢ)OZ 3KJ"e]7/$:GGe ^$iVr޲x~$eFTjt+_hr(3K5fCYb[i)cTH0K&!׌˳0AO֟Zے'aB[NsE@88ufn@$mnCZii+#|lz.PE0/8A*7"B@JM[3Q_-yc賖1>/ ]՛)#㍩-{dЪo oqrҬ?۽*A~ZW[:A.v0x7*h,x 18"VF`_6𳊉K).wc@e1EE(*Nd_tw$a=!?l8rުFEJ =2eӗH$bNY -gG $=<$:4/m[+gWRҾ8SVCw%gV?OƩ!/p gtbxiM~j|1٭4pFlg*Ս$ϐ|!*pg˸^sΰ>i2łnmUUQ<[%xʢaј(YJicJvj Gsi"BrM /ub&v_VO6z$9M#;pgtk$?is_s >MTO5op|qDdIwzW9!Ie1 ct_:'q~ j*bݳA e?fE9Y>)0Y=]f paPe Q/ہ>pSlTK/Xu6OĈ`ww"(G xtAambai*y t) x>^J^eIu73JШ}@=PDiͩޡCx DMyɫZλ#E2YÍu ~̀fmAH& 'ü 9[w)[e%p(f {4z.'GaN 03E^G68|Aw%,8^Ǚtc*j Jy%Έ Go2Ϲ ,t$&ywk%O;`U>x:A |so9+oA.WL?Z!ScP ?%=?jW(Xӳ`)*ŧ"0ǜq($Bng~n2閠NNBmHnits of the indent amount that you specified. This is used via stylesheets.
    $cfg['SQP']['fmtColor'] array of string tuples
    This array is used to define the colours for each type of element of the pretty-printed SQL queries. The tuple format is
    class => [HTML colour code | empty string]
    If you specify an empty string for the color of a class, it is ignored in creating the stylesheet. You should not alter the class names, only the colour strings.
    Class name key:
    • comment Applies to all comment sub-classes
    • comment_mysql Comments as "#...\n"
    • comment_ansi Comments as "-- ...\n"
    • comment_c Comments as "/*...*/"
    • digit Applies to all digit sub-classes
    • digit_hex Hexadecimal numbers
    • digit_integer Integer numbers
    • digit_float Floating point numbers
    • punct Applies to all punctuation sub-classes
    • punct_bracket_open_round Opening brackets"("
    • punct_bracket_close_round Closing brackets ")"
    • punct_listsep List item Separator ","
    • punct_qualifier Table/Column Qualifier "."
    • punct_queryend End of query marker ";"
    • alpha Applies to all alphabetic classes
    • alpha_columnType Identifiers matching a column type
    • alpha_columnAttrib Identifiers matching a database/table/column attribute
    • alpha_functionName Identifiers matching a MySQL function name
    • alpha_reservedWord Identifiers matching any other reserved word
    • alpha_variable Identifiers matching a SQL variable "@foo"
    • alpha_identifier All other identifiers
    • quote Applies to all quotation mark classes
    • quote_double Double quotes "
    • quote_single Single quotes '
    • quote_backtick Backtick quotes `
    $cfg['SQLValidator'] boolean
    $cfg['SQLValidator']['use'] boolean
    phpMyAdmin now supports use of the Mimer SQL Validator service, as originally published on Slashdot.
    For help in setting up your system to use the service, see the FAQ 6.14.
    $cfg['SQLValidator']['username'] string
    $cfg['SQLValidator']['password'] string
    The SOAP service allows you to log in with anonymous and any password, so we use those by default. Instead, if you have an account with them, you can put your login details here, and it will be used in place of the anonymous login.
    $cfg['DBG']['sql'] boolean
    Enable logging queries and execution times to be displayed in the bottom of main page (right frame).
    $cfg['ColumnTypes'] array
    All possible types of a MySQL column. In most cases you don't need to edit this.
    $cfg['AttributeTypes'] array
    Possible attributes for columns. In most cases you don't need to edit this.
    $cfg['Functions'] array
    A list of functions MySQL supports. In most cases you don't need to edit this.
    $cfg['RestrictColumnTypes'] array
    Mapping of column types to meta types used for preferring displayed functions. In most cases you don't need to edit this.
    $cfg['RestrictFunctions'] array
    Functions preferred for column meta types as defined in $cfg['RestrictColumnTypes']. In most cases you don't need to edit this.
    $cfg['DefaultFunctions'] array
    Functions selected by default when inserting/changing row, Functions are defined for meta types from $cfg['RestrictColumnTypes'] and for first_timestamp, which is used for first timestamp column in table.


    1. Introduction
    2. Usage
    3. File structure

    1. Introduction

    To enable transformations, you have to setup the column_info table and the proper directives. Please see the Configuration section on how to do so.

    You can apply different transformations to the contents of each column. The transformation will take the content of each column and transform it with certain rules defined in the selected transformation.

    Say you have a column 'filename' which contains a filename. Normally you would see in phpMyAdmin only this filename. Using transformations you can transform that filename into a HTML link, so you can click inside of the phpMyAdmin structure on the column's link and will see the file displayed in a new browser window. Using transformation options you can also specify strings to append/prepend to a string or the format you want the output stored in.

    For a general overview of all available transformations and their options, you can consult your <www.your-host.com>/<your-install-dir>/transformation_overview.php installation.

    For a tutorial on how to effectively use transformations, see our Link section on the official phpMyAdmin homepage.

    2. Usage

    Go to your tbl_structure.php page (i.e. reached through clicking on the 'Structure' link for a table). There click on "Change" (or change icon) and there you will see three new fields at the end of the line. They are called 'MIME-type', 'Browser transformation' and 'Transformation options'.

    In theme directory there is file info.inc.php which contains theme verbose name, theme generation and theme version. These versions and generations are enumerated from 1 and do not have any direct dependence on phpMyAdmin version. Themes within same generation should be backwards compatible - theme with version 2 should work in phpMyAdmin requiring version 1. Themes with different generation are incompatible.

    If you do not want to use your own symbols and buttons, remove the directory "img" in "your_theme_name". phpMyAdmin will use the default icons and buttons (from the system-theme "original").

    2.8 I get "Missing parameters" errors, what can I do?

    Here are a few points to check:

    • In config.inc.php, try to leave the $cfg['PmaAbsoluteUri'] directive empty. See also FAQ 4.7.
    • Maybe you have a broken PHP installation or you need to upgrade your Zend Optimizer. See http://bugs.php.net/bug.php?id=31134.
    • If you are using Hardened PHP with the ini directive varfilter.max_request_variables set to the default (200) or another low value, you could get this error if your table has a high number of columns. Adjust this setting accordingly. (Thanks to Klaus Dorninger for the hint).
    • In the php.ini directive arg_separator.input, a value of ";" will cause this error. Replace it with "&;".
    • If you are using Hardened-PHP, you might want to increase request limits.
    • The directory specified in the php.ini directive session.save_path does not exist or is read-only.

    2.9 Seeing an upload progress bar

    To be able to see a progress bar during your uploads, your server must have either the APC extension or the uploadprogress one. Moreover, the JSON extension has to be enabled in your PHP.

    If using APC, you must set apc.rfc1867 to on in your php.ini.

    Known limitations

    3.1 When using HTTP authentication, a user who logged out can not log in again in with the same nick.

    This is related to the authentication mechanism (protocol) used by phpMyAdmin. To bypass this problem: just close all the opened browser windows and then go back to phpMyAdmin. You should be able to log in again.

    3.2 When dumping a large table in compressed mode, I get a memory limit error or a time limit error.

    Compressed dumps are built in memory and because of this are limited to php's memory limit. For GZip/BZip2 exports this can be overcome since 2.5.4 using $cfg['CompressOnFly'] (enabled by default). Zip exports can not be handled this way, so if you need Zip files for larger dump, you have to use another way.

    3.3 With InnoDB tables, I lose foreign key relationships when I rename a table or a column.

    This is an InnoDB bug, see http://bugs.mysql.com/bug.php?id=21704.

    3.4 I am unable to import dumps I created with the mysqldump tool bundled with the MySQL server distribution.

    The problem is that older versions of mysqldump created invalid comments like this:

    -- MySQL dump 8.22
    -- Host: localhost Database: database
    -- Server version 3.23.54

    The invalid part of the code is the horizontal line made of dashes that appears once in every dump created with mysqldump. If you want to run your dump you have to turn it into valid MySQL. This means, you have to add a whitespace after the first two dashes of the line or add a # before it:
    -- -------------------------------------------------------

    3.5 When using nested folders there are some multiple hierarchies displayed in a wrong manner?! ($cfg['LeftFrameTableSeparator'])

    Please note that you should not use the separating string multiple times without any characters between them, or at the beginning/end of your table name. If you have to, think about using another TableSeparator or disabling that feature

    3.6 What is currently not supported in phpMyAdmin about InnoDB?

    In Relation view, being able to choose a table in another database, or having more than one index column in the foreign key.

    In Query-by-example (Query), automatic generation of the query LEFT JOIN from the foreign table.

    3.7 I have table with many (100+) columns and when I try to browse table I get series of errors like "Warning: unable to parse url". How can this be fixed?

    Your table neither have a primary key nor an unique one, so we must use a long expression to identify this row. This causes problems to parse_url function. The workaround is to create a primary or unique key.

    3.8 I cannot use (clickable) HTML-forms in columns where I put a MIME-Transformation onto!

    Due to a surrounding form-container (for multi-row delete checkboxes), no nested forms can be put inside the table where phpMyAdmin displays the results. You can, however, use any form inside of a table if keep the parent form-container with the target to tbl_row_delete.php and just put your own input-elements inside. If you use a custom submit input field, the form will submit itself to the displaying page again, where you can validate the $HTTP_POST_VARS in a transformation. For a tutorial on how to effectively use transformations, see our Link section on the official phpMyAdmin-homepage.

    3.9 I get error messages when using "--sql_mode=ANSI" for the MySQL server

    When MySQL is running in ANSI-compatibility mode, there are some major differences in how SQL is structured (see http://dev.mysql.com/doc/mysql/en/ansi-mode.html). Most important of all, the quote-character (") is interpreted as an identifier quote character and not as a string quote character, which makes many internal phpMyAdmin operations into invalid XQr-¶lFB XT_ $Gw#4|- @!Z?\J&vV(Frܑj3]b[ϴk\S!+>%)BC)_}L2jtP$Fٙt&X^F#B%-+]PǹIAY0OiKbw(@ū1@ mѮpg/.c\"4q7եT<(wΧXysfT%q!NڎTܤWL_b. ,~)! jfo['6.h廴8فXV\3?XD˓a7Yd(-Z*}y&"ǖ]y)"ʇG7N;n1gf2E4FJfϟ\$6_u}0Zt.馲VjU\|觬ƪV{_%k9W5 yLFI8gud:fDq>uGDūPQν,<@gu.ֆZ` /vU_XXvu${r7KI]y'Sp4}]t_QoPCRPw E>C@^X?CQ\]joinjLȦLvq_iiw};letm"NJ~ޣ4+" 3_Ep8wP(-, ^>xXhKn0g1do՚ >܆pNe=ܑMc?{`;^0IS-@Ɣ8-|'*\ĭQhbbsvD'A(M7nb-[BL3QWO+~ltگG{Ls<:fAwd'ث$f-Sn-FN z1`{ꡥ2R,sRt + ~N$2GFBW BsS#Ȁ`[zQD}X*6~LQGgv̹ oef 6 o Y,::l8MN 8ޤ*]/jXU1M\W 5Q8j8@~~vtLf=1NZ\'oP3$vԜmXLʄ[ 9@{Lb3ЛPX* D9$n\>a{5?tH1?T%;̲G->ӣqs3M]Y^2{!V4KU$T)3eQudiSL!%:2zfC)Mu]Ws3u!"OTLzmmIgRYӨ<V7$Y3χ~SUô]slCъ~ߖ~;:I2G8N&f F6kh&瞛W v;sQZwdeN%E4&4>y](=`;xXsʚ㗭5-Nǐe YEQd3I{Vx6&vJ]LҖ'rb4TGX;:̰dMyW0hcox\TwYph# Z0y6B Fl_%L19u 408kͪ. SLH&ҏKv #kCz3^af}^m+uAVmYS:rB$^'!R`hM'z$m jP2Mt 9|)R%bM?QkGngsT2LP/y=1œq\xͲM&^A'' N턜^b[?Ep/%k,tZ.@:QSKsMru6/D]In)sVy%h-{X*G"(NPb%(64@7z]{ h'ky'eqBF>yF <|3>YlZ+8F)qΊ eKA+M}!i״UtYQ6P4nK{F9𿲬~ګZlYM$4ovԪ8N{wПE2k΋O %:M׶m:bxg)YEX]Vˍ \JR{S2?`{Mn:.|?[r \6;Z%Y0iZ7Eؖ$ d~Z:7ˆ?%6osWʧP#TVvfV ehPO`缵%5M5JkaYy%6e>mё.Y7lHO9&})V&k  mP7?}Yȷ@8)-q ,T{S68Ft)8k PT1.Dd\* u7TF)G[W@@"~soހ zv~>}/ @'yikihȹ;yS]{~`H Er0E :fP i ֫+(&bՙ ΆG @ŅyAm2<-9>t+,UAxiw.,ؕkY:Cm,P tئz]p d AhJ'!TƮ0E ޣI&,AxIYn#u$77 mڨϑw phG fCIa|/x|>f;g)uI3~f#%E^~[g*R2/k@]3Rt0>5( ݖ+5 PFʽI7upaL#Q^]pJ]UNMC2Vٚ jດQJ+uwp)iigxεkQ" ޒf% R.]lW&< .ws^Ylнut P[y$lA;sf6곖Mױ zZb jDw5J(ğ:USJ SJԺ6͢`fy; MY|V`UV iEh=pڽI=}yiFV77mBͪr]3y!pUk/2|LֲŸB+,TL?T@Y)x2hTȽ?V[|'hp9\X. FS|D̈0ά\%LGil\373y?x1sEEn5E aOu"k,SN\qW!Mc.՟$BY\A&4.Z'Ni7K6S;M &͆m@9rW\h#`'?=[JEol .~-uր,r$~D]~ W5$)؄8_}(a]ucK 0ߛmҧU x54?РH6RFbg&?1QCL$̈jw9D# Ƌ2pq-e;R+m{1)˽Yeu#c\VUVcO\^A7$TnJ/):fif\u%O3; k=LZHO+YWE—8'WAe@^: ۟2KI+J!p箄yl?,F+)Z=6Jo؃?ɄX#'28/͕id(|zSpVڟߒ%*RVdZx=>6"7^zԱ?gY09݊bJlIch+D6CbXN++AͽޚAϟjj,DAX*f<$OPFv,?Gp&RSVi-FU|6_N2н?ă<.4{PPkv먇7gTK ЂñЕ Z ;޺ӁJy)b^|r fANGx@~A L¢`&uN h)dZ ZRdos-(!-0ڂ+)V*tD?(-!c9AZRxenA~_K[I|=*RW*+Jw;?LEdyLb_&n[^8x`;ozIX,::hj-BA"W(Uxy5`,E§Ĩ2sШl5@7~X> '?/YP2 a68 9;aXxI]HY}ŐG4átz|z17^z(Ş%n!ܶs<[ ~-+a⛍J| `Ұ&E+a1f?e$4,@bľ;6굳e9ly5%+/D Kl}qb4ڋ/Q3@Q<|",#i,~wwaS/VwFjT .F._{݋ډfE1cJ*t0CF!_>4nsQU!xԊ]~L,qĶNBԵ5n^&9)M_R08?F.TY^6[ֶB|9}hmFxGK-iԴŽ 5ˑ RpЦ*;j3JQ\=4!OMVX=;j<z?|K'+Q:?M;]'u) Pg [A69kA U|bܽLq<Wl*hbs6;ry,&lpxLs~ ziYb򈋄xD;>eCVl#}5)VH~˘|X(_',<xPez!vՆMŎe `ݎin5x6b{g;h䀃wȐ+4\yt2MOjAQ (Qqw/0f8 ΌRJdcnތ 8C^4)T2lHs^oOEӸJ<)i"IuԧI4/'NO9S UHD3:(,G~-(*oyI}D:L(Cpix|m,=Q(j狒SM݄..a[ LT: W2{A! *S/ 胓F¯E([FCL 3k mq6Ve} #TH[wTkrLrm^>x@+J|G :NdęXFVb~yfF, kSg|I~, aKݳ$} -xaHHLx O[oԜYtR-jqpg ?0bkj|IA]JhVps6}fSBYn88f&`xW[[+S'!f Q$+5"p.XCYW:hxiM8xR0A cբ1^I3OQw /mOx/QZ+ 2ޮy\")6o S]zZbO&a!׶Z*4g&7.;X2O zp + B#faq4_7">4.7 Authentication window is displayed more than once, why?

    This happens if you are using a URL to start phpMyAdmin which is different than the one set in your $cfg['PmaAbsoluteUri']. For example, a missing "www", or entering with an IP address while a domain name is defined in the config file.

    4.8 Which parameters can I use in the URL that starts phpMyAdmin?

    When starting phpMyAdmin, you can use the db, pma_username, pma_password and server parameters. This last one can contain either the numeric host index (from $i of the configuration file) or one of the host names present in the configuration file. Using pma_username and pma_password has been tested along with the usage of 'cookie' auth_type.

    Browsers or client OS

    5.1 I get an out of memory error, and my controls are non-functional, when trying to create a table with more than 14 columns.

    We could reproduce this problem only under Win98/98SE. Testing under WinNT4 or Win2K, we could easily create more than 60 columns.
    A workaround is to create a smaller number of columns, then come back to your table properties and add the other columns.

    5.2 With Xitami 2.5b4, phpMyAdmin won't process form fields.

    This is not a phpMyAdmin problem but a Xitami known bug: you'll face it with each script/website that use forms.
    Upgrade or downgrade your Xitami server.

    5.3 I have problems dumping tables with Konqueror (phpMyAdmin 2.2.2).

    With Konqueror 2.1.1: plain dumps, zip and GZip dumps work ok, except that the proposed file name for the dump is always 'tbl_dump.php'. Bzip2 dumps don't seem to work.
    With Konqueror 2.2.1: plain dumps work; zip dumps are placed into the user's temporary directory, so they must be moved before closing Konqueror, or else they disappear. GZip dumps give an error message.
    Testing needs to be done for Konqueror 2.2.2.

    5.4 I can't use the cookie authentication mode because Internet Explorer never stores the cookies.

    MS Internet Explorer seems to be really buggy about cookies, at least till version 6.

    5.5 In Internet Explorer 5.0, I get JavaScript errors when browsing my rows.

    Upgrade to at least Internet Explorer 5.5 SP2.

    5.6 In Internet Explorer 5.0, 5.5 or 6.0, I get an error (like "Page not found") when trying to modify a row in a table with many columns, or with a text column

    Your table neither have a primary key nor an unique one, so we must use a long URL to identify this row. There is a limit on the length of the URL in those browsers, and this not happen in Netscape, for example. The workaround is to create a primary or unique key, or use another browser.

    5.7 I refresh (reload) my browser, and come back to the welcome page.

    Some browsers support right-clicking into the frame you want to refresh, just do this in the right frame.

    5.8 With Mozilla 0.9.7 I have problems sending a query modified in the query box.

    Looks like a Mozilla bug: 0.9.6 was OK. We will keep an eye on future Mozilla versions.

    5.9 With Mozilla 0.9.? to 1.0 and Netscape 7.0-PR1 I can't type a whitespace in the SQL-Query edit area: the page scrolls down.

    This is a Mozilla bug (see bug #26882 at BugZilla).

    5.10 With Netscape 4.75 I get empty rows between each row of data in a CSV exported file.

    This is a known Netscape 4.75 bug: it adds some line feeds when exporting data in octet-stream mode. Since we can't detect the specific Netscape version, we cannot workaround this bug.

    5.11 Extended-ASCII characters like German umlauts are displayed wrong.

    Please ensure that you have set your browser's character set to the one of the language file you have selected on phpMyAdmin's start page. Alternatively, you can try the auto detection mode that is supported by the recent versions of the most browsers.

    5.12 Mac OS X: Safari browser changes special characters to "?".

    This issue has been reported by a OS X user, who adds that Chimera, Netscape and Mozilla do not have this problem.

    5.13 With Internet Explorer 5.5 or 6, and HTTP authentication type, I cannot manage two servers: I log in to the first one, then the other one, but if I switch back to the first, I have to log in on each operation.

    This is a bug in Internet Explorer, other browsers do not behave this way.

    5.14 Using Opera6, I can manage to get to the authentication, but nothing happens after that, only a blank screen.

    Please upgrade to Opera7 at least.

    5.15 I have display problems with Safari.

    Please upgrade to at least version 1.2.3.

    5.16 With Internet Explorer, I get "Access is denied" Javascript errors. Or I cannot make phpMyAdmin work under Windows.

    Please check the following points:

    • Maybe you have defined your PmaAbsoluteUri setting in config.inc.php to an IP address and you are starting phpMyAdmin with a URL containing a domain name, or the reverse situation.
    • Security settings in IE and/or Microsoft Security Center are too high, thus blocking scripts execution.
    • The Windows Firewall is blocking Apache and MySQL. You must allow HTTP ports (80 or 443) and MySQL port (usually 3306) in the "in" and "out" directions.

    5.17 With Firefox, I cannot delete rows of data or drop a database.

    Many users have confirmed that the Tabbrowser Extensions plugin they installed in their Firefox is causing the problem.

    5.18 With Konqueror 4.2.x an invalid LIMIT clause is generated when I browse a table.

    This happens only when both of these conditions are met: using the http authentication mode and register_globals being set to On on the server. It seems to be a browser-specific problem; meanwhile use the cookie authentication mode.

    5.19 I get JavaScript errors in my browser.

    Issues have been reported with some combinations of browser extensԙ ^"?D4DY Lto͹Рpe)pXʪJ:ͦсJқT 3YZL;=Oo߲UXnĽ֥,V y,^ ל^Qw@+ k)s駰 ( .6t[7@8 Ѓݨ|\zHE]NRX0;\ZȗJr R=A X4cֶ'e+u]}5g:m*-{$☶,!O@⩈n5 b )+j mcЌ;<T/9*T% a̜Qٽ2ZUkN]'GO30"tگEQCж&MS=xT,B杘St/ N,>}2z,KFw9~GId4Z?q`l2i~mU6mҁtx5U9{] m\7(n|=|{b:,=b7Igz6CKӓ}ُ;4wwdȿR0"in;??w:y81kG%`hl.2 TrJB s ?@2CQ YrT 'X1;rrBbJ YŊq&Af^ʆ2FCm(ylͶƾLS=AUӒםA61z|.+).obscTg$ xKO^|T7rÔ{Xtj_Zm` zJX;9u"i눖,U4 ȎkX'm;pڵ_>!rEw*-a dof+8e;0/?SY|\TV?`wD-X8}ˉ\4"2fbI zؓ__ N˂UdyjG9+yW֔VK;:YNjpCqvi `R {P5XJ 3%OUkgFrq<\;N0H̾ "7U4gɄʛ1d %m8SQFyc41y8,qhPB8E݂(Ԕni5Fb4tn`Y2)mIdୈr@a^p @6,\aT;EQ g0}-5s", EЙ_H+5JԽ<9--?KP+ulp}^7uv3ߔWΓpBI&? ftq "jImCe/嫷?jScX|c8q+[x~!z*ON~^G Me}|#G][8[B+\{@~; YPh~Y;%=3 )VuF'κIyU[ft9Mpi$S8hm0zIh*)!CD#Rym,^x^2!nY5!w&tN;.NtwTaE JR_Kp),`jڅ_DWæimŔK{ƬRCvEx>ִ* ʄc^`ͯLe )jc$N@jvm 6]`NY\4_H]1 wd2yNzJW:%MsD|;i,DىJ3~$ԀAi[?I^epygg{pN1P]ng1Z<#l"q~ 0bnذ>/"6EU Cא Q"|zW&ѹT} (uC6NؓZ&VPiyczჩ*hوnF;UJ:ˊG{`Z:x:9)ZH2BY,PPvBV!8 ˜ ?K߉jRjVG7YOĤ@oSo5aB' <{ T2j-'[JvŘ DN&ي\35_nwP̼0"Bd+JZKIzrrĸW)`sfH [(YdSe":s ;h:zJoKFNj2<67rǼmbކ3 5LN;%MkU%F0yb02[ģ jc/~[8O#/|0 >Ẩi\ǢC28 tH[e-a3.? 3K8QٞtIRvF!د!vbZcށYr' \z;e~x@r&72Qm]^iQus w1g'E[P?'Y(*B7}ӇWs)υhDJ<PA8)M? HֳL,8s:? bا N,+{d+V9r;2T.#/IQߔsM\!1bB$x&_ϷQןW.$ l]a4RN1p ){SX\ͻLZ`r򑬲hŽoOX d.w# J+Q'$Cu&Gx`bCA2,υ'X*B6ox $'h_0 >8ݱ~ l%P9B;șOlyu EI}Z+Aj#4[Ymss+>i)`՗w6]|q{,Flz 4 wXA2m6{ 6H/( 4#6JϛVrWqҧKYaMOQׯ(~FRup禄UmDzKJfIN)XԵ0=q: Nc$)[W~ʚCxd]?NE7,ϕf9/4 8;AV#t<_bu"36s`24F TT0_uQփ!cMg/\cS*KC'k8u!aMOv HC ) ca)SbQ$i7J[9qv3c /62+0Lp3.kTWHI-ENuO% {xGkF) 4uja{N];9XTL??V fћ=='e |7C.phǁŁ/'0gٰ4aཡ Qz5yzP"W+)܂(f!w|' 9N-),ğa|A۳.M(g/t G~-U`Kͥ-cߠ$uzuC\'ZXG\ЪMu<]BMۼwd#R)Ȁ;GMZ:vb(Gwq#{#̟7AU5+MO(_[@d]]Bf9 e5Ec1e:CM| n?"N1sLR~{fz= &jT{, !Mc kqQ$~>Iׇt5NteYطxw5;-~7(Q4 RdjPG}~Ӆ,ًNu IBDw,8#js~5SbSѽà) pI(A#nʅmg B&ϒH5m}Rwt9`0BKsI hܬVy|̏pH?2)?L<:6\&~Y1ƭIЕimp= ,JJE#C dRY3gKBM5UfD E8KЉEVsYũ 4l ) -+0?}1D&)eG{: EK. fl .*Yw0il֎p<ɕ*HZi$RAsŚW"ҥĭ^i~~+Z+H5=a]=rgmMٰva1=@ ET|߃^R$0kTY+I4y 1 ]if ;d^?7=ZUPR6M;fB!=~BN0Qw m]٠;wsxQu7%Qͺ0!(3ac+IE5#bNC h#i֕\#\L}oumH~5tdkdV q<+S~TlM~$ZZ+_~0A# !ֺ!i2e0 m #p U_ГY!H<Fj$=:&X6Wc%(I;ؤ Kz,RtG7Y-ocR11,(Bo_0#-f˪ YM3FtK`uRǼF_0e{W T-/':mЮs2P)8# 2R)،kGղqR2y[߸%zTu|v q;S}wet{MDf &y,Tv\:Gv[J"p%lGc")\;@Km:5^N\nD$fe|Tl u!FX|4V $4ˡ/$Yf¶Q`&':\q6;o{`G 6v7 HtڌmB{-WS3%+YgO1o3Lckg#pŲ4./aAaIym&!hWv&0EɓJ+ny5bw1:X 2Vg|YAC eip[*&_ TjѡG#% DdWA?宱'Vw(('2ӏZܯ2=ʼn?]AMh|-34}-!$ub&p"A kXSդN萅j?FEv缮 #;!H|S@f[Viu EkREO4|] oWeeIE,4}& 1֙T p75'm¦SѡlVP^a92|F,zk.KpA& d-(7SbO tlg,};*˼+tTl$R[8~,]b`6YqV -#0c-s ÌT5\@ͺ;+Bw|`j؟v3O; o\B΄rxo${HPAkus͛@r $Bd; ((=P/H+ck_խqߪSJˉ$UvLH;)VZ FcwS[ӰAx>E;F!DP; XD nI݌w@Mu=\lQL+R~m<: C%ޥ%C&5Se*ܭVjDgɰBJʛegRqpux&$f?9}WlzW, !ajH/-e Ѵm|<+o ~v`C&.<0&4 r˓e:M2 ƞgxgW4}d>ɱ۰}ܱPEpH$9Yn&] 죣p$Ŵ4aӣ/1D-J^rgU˯*+l6ݢu]醄'XVYSmXf)($fiŅ=Zyb7=w|[ž _P}d ~-K>h"rņY>Jb]) pv$N 1 Sq h|<@+/&ument Format">PDF options you want, and click Go.

  11. Internet Explorer for Windows may suggest an incorrect filename when you try to save a generated PDF. When saving a generated PDF, be sure that the filename ends in ".pdf", for example "schema.pdf". Browsers on other operating systems, and other browsers on Windows, do not have this problem.
  12. 6.9 phpMyAdmin is changing the type of one of my columns!

    No, it's MySQL that is doing silent column type changing.

    6.10 When creating a privilege, what happens with underscores in the database name?

    If you do not put a backslash before the underscore, this is a wildcard grant, and the underscore means "any character". So, if the database name is "john_db", the user would get rights to john1db, john2db ...

    If you put a backslash before the underscore, it means that the database name will have a real underscore.

    6.11 What is the curious symbol ø in the statistics pages?

    It means "average".

    6.12 I want to understand some Export options.


    • "Add DROP TABLE" will add a line telling MySQL to drop the table, if it already exists during the import. It does NOT drop the table after your export, it only affects the import file.
    • "If Not Exists" will only create the table if it doesn't exist. Otherwise, you may get an error if the table name exists but has a different structure.
    • "Add AUTO_INCREMENT value" ensures that AUTO_INCREMENT value (if any) will be included in backup.
    • "Enclose table and column names with backquotes" ensures that column and table names formed with special characters are protected.
    • "Add into comments" includes column comments, relations, and MIME types set in the pmadb in the dump as SQL comments (/* xxx */).


    • "Complete inserts" adds the column names on every INSERT command, for better documentation (but resulting file is bigger).
    • "Extended inserts" provides a shorter dump file by using only once the INSERT verb and the table name.
    • "Delayed inserts" are best explained in the MySQL manual.
    • "Ignore inserts" treats errors as a warning instead. Again, more info is provided in the MySQL manual, but basically with this selected, invalid values are adjusted and inserted rather than causing the entire statement to fail.

    6.13 I would like to create a database with a dot in its name.

    This is a bad idea, because in MySQL the syntax "database.table" is the normal way to reference a database and table name. Worse, MySQL will usually let you create a database with a dot, but then you cannot work with it, nor delete it.

    6.14 How do I set up the SQL Validator?

    To use SQL Validator, you need PHP with XML, PCRE and PEAR support. In addition you need a SOAP support, either as a PHP extension or as a PEAR SOAP module.

    To install PEAR SOAP module, run "pear install Net_Socket Net_URL HTTP_Request Mail_Mime Net_DIME SOAP" to get the necessary PEAR modules for usage.

    If you use the Validator, you should be aware that any SQL statement you submit will be stored anonymously (database/table/column names, strings, numbers replaced with generic values). The Mimer SQL Validator itself, is © 2001 Upright Database Technology. We utilize it as free SOAP service.

    6.15 I want to add a BLOB column and put an index on it, but MySQL says "BLOB column '...' used in key specification without a key length".

    The right way to do this, is to create the column without any indexes, then display the table structure and use the "Create an index" dialog. On this page, you will be able to choose your BLOB column, and set a size to the index, which is the condition to create an index on a BLOB column.

    6.16 How can I simply move in page with plenty editing fields?

    You can use Ctrl+arrows (Option+Arrows in Safari) for moving on most pages with many editing fields (table structure changes, row editing, etc.).

    6.17 Transformations: I can't enter my own mimetype! WTF is this feature then useful for?

    Slow down :). Defining mimetypes is of no use, if you can't put transformations on them. Otherwise you could just put a comment on the column. Because entering your own mimetype will cause serious syntax checking issues and validation, this introduces a high-risk false-user-input situation. Instead you have to initialize mimetypes using functions or empty mimetype definitions.
    Plus, you have a whole overview of available mimetypes. Who knows all those mimetypes by heart so he/she can enter it at will?

    6.18 Bookmarks: Where can I store bookmarks? Why can't I see any bookmarks below the query box? What is this variable for?

    Any query you have executed can be stored as a bookmark on the page where the results are displayed. You will find a button labeled 'Bookmark this query' just at the end of the page.
    As soon as you have stored a bookmark, it is related to the database you run the query on. You can now access a bookmark dropdown on each page, the query box appears on for that database.

    Since phpMyAdmin 2.5.0 you are also able to store variables for the bookmarks. Just use the string /*[VARIABLE]*/ anywhere in your query. Everything which is put into the value input box on the query box page will replace the string "/*[VARIABLE]*/" in your stored query. Just be aware of that you HAVE to create a valid query, otherwise your query won't be even able to be stored in the database.
    Also remember, that everything else inside the /*[VARIABLE]*/ string for your query will remain the way it is, but will be stripped of the /**/ chars. So you can use:

    /*, [VARIABLE] AS myname */

    which will be expanded to

    , VARIABLE as myname

    in your query, where VARIABLE is the string you entered in the input box. If an em,S6)CZ;𨉏]]*MhC˙tN2P+ͭqNJ}|T@q S}ۆ?Nutj n1Dd&<;UCTת_Wi\damvqS;twa-Nӟb]#J1woyʥi<`/{o^iRQ_Eۈ Q-Jsy pQ g< {4iNUԡcF323 5vg6~ܮ<;Wz@! Q9T:Ϊ szoKD+O'C;ϳ_1<+FxD(S &Lfmb|/#JC\ALtesub;<%A3ʍnUԟ뿅-Ll"cEmC[LFn܁ " y,[[C=CeZ0 kL?sjFMNQ-MLԁe#t5nE-" $-_?K(L5CDžo$8C*4a^[kA8`4*~8=lP4dkA{Q wuEX:N+kYz@@' D lCDsb;pcl1 pÇn$ B`5{J&_Ct,%BS[y :wvm1@ W@h g:Z+8hPLqIlH6Ȣ@נ>Gl+Rˍb<jZ>bxMݹ>ozm>Hq]-hM| tǬ::>dN^gUV}kZ;N€'ApOZ}_g<;( 9`jf\1X׸^#b]v#X}bQrS=f'&!-%$jn l %Bkgּ&2#kHj!{_9G4Q[& 8=Q& CU)(wXD0bIلG|vujڥ#5eBq 3 wMׄ:i~!B*cnMh䀡 6 ࠋ;<[HR[6Iy@+m3i%pTܞ*gk $tUFY RQK_pg*$/OT_h!kaFhAEN4^xz-ʾr\9T?s@Mj?r@̵s^Пۖ?<^c@2 |v1[J PFsSM|0bX}P8Uu=IL<2UtCHG0na&R\3m3%.yA S lCr}b[#UnH ,zKFOTbRooE\`D0z{dY(KSXr%ʁfPcEouW'oEeaY9nZ&WI_h9ᄗ+lH`,B7<+ ^xYUa{*r0PNRKOSB"r@aEQp\%o۳9 ,R; AεXl;XOe[lWhF!`OE|ˆ x𻿉A,[pM\r}>kzտ 1OtF,Sx( eK-̍d>p,8d4<9hBd<}!"9c1R]/0풁qĵ-Wo<t/}JF('T \;I 8{i;!FX Z7J+Yݧ]J=f:~EZ~,-ҖN( jQ&!TOôa)=\© EҔBJ BitT\8p[$%9.O( *`?UU !U[훘m. [p5nG8PFvMxN ﯰ`YT [W;īW"gygnJV8ZЧcx2 ۖ@N]vѱT=kXMpSI캆e*)tS}nOsh ?K`],.? Ąr9h{D$QٙID <9CDPlj $+ÐsB ,kCRnB%w8A2L=&zW{rC08yעkR\&S[3I8! -]~_L6lj E<)d$p-vDw%%O+JؓzVl&}r`r SmVs^,B(R=3 |]7Dk ۦz&?ηTcD9Qup0 d4yhޱj[TFGZG&[Ed=2?s*FUԐOCLFvggxBc 5S 7*5Ig\)| $%bW+F4˿:[E$aI`ylP']~<*=ܮ3he Nz}M{ߎ䘹d˄Ai8%^['y߭S 4 sXYՙf= 6ť I2{<̙̜4Hf m }5QqI\rϘPznR$/z%*.?\n@,N[ԮK[ tRнbn}QMVFAxV+Y Q\H^b?~55oO07G>X__C;[V&^PH}W"ZE] Z~\YKޏq%Ϛ(`nB\ℏ'qc ?u G!Qh^`KIB{ V>[:8}\zmj$0XP];BS ]-cjp"i#)z۠NanU_:CNPl͔ !VL+haLS$B'Hg~r,7C{[5V|&̒We߀.Ѷ;I.+k| QhjIa Ru+כy/T Y1'ݕ WYяe~NT3,_/f'<@lBV̓bڿ zBcm)Z;(AYE mx'qg%"7^3*c΃;D.J0a=ؗ^:=Ċ}1^"zoHc^=wt7p]^+ٜ6}mh@Swxsƛװ$:t?!Y+^"k[7yP(}[Ѷ\"YUU!Y!%v&Nd`TXbȹ@ax봥r'Oզj&SruS=iDD_ ^7j>L%+}|`mR>K5Aa^o3A*]~ʤ`4&ZAc˸kPh&P0p Yn Lg MR~W'FQqVbX#pA4i) $R`7/YfDW&'ӡ$SQo} >FGm?,c{"%W3 = ulH5BYetQW#uV t|^z2VTÄ@#*DȰ'<ܺND.'ޖ ;lS2~8C(>85!@28$ٔ<#:*HC~>P/fxETx"/R9T~/[ F dAaӭe:]ww.mPqFHoRmwFY'|E@(w_)'?P(/|ձ1(n|bɨ ~:z!ycI`)-s6]dxwgkc.<sUK.D^HMN 6N8\8k1r6dQ7v(+ `{?4g/G27|0Zc`swgJӃu}RP-4N xhB0T&ONgp]!'l$iSA,Y'5.NPoa|8W>fn\QݽK2izN7qTaKze* !}0U!&8VlЁC t^:G>H/S2~Q=SI>**b&hux:8V?6[zMywlgW|[^9}ۚ}| 3+ #yuzׄ!D PT9YZs 'a˧5D.OyX |XCPzt|wF͸i2RF|Y7b3BL"(p0.aC!V&va#؁RM@ W<`(HƽA>]k< =ky2Uaj ƘPN:8b8l39!uCX͒1G^xIN$&XM<~6Wup`;|F}47AT{V2g%΂j9P?WcDG- ]'9Ǽ^{*pcF,kbdPCYKϨ03  ƯB+1JY|HZFLiђaD lQ|rD}qp)v]ЅЍn!I=8 b5ly.z̠N1#Dl-Sv|#`|f&֘]`<@b}Ҿ+3njoOVZ! Y+V8:S nű,[Ü'~KK C Z5Z; ,ZT*^i 7SgC;G9槖%q3@b4BOMBvzP|ڟ AG2i\A.q BRD^~"n!Tk7SHijdd+$O؇LDT+s5W0Avs`̛χ 2Q=F~ƝSslb_[, ~'%WU[o9ZFOq)ٻ"w޹=}1Lv * ]S))*$:Vnq#iJ ;Asnho#' MOW !$-L##8G jJ7͍ep.i>Td%>ЏMg'Z0Gm:Ϲ+zyGv>4 - %p a7y Cj-s•٠9[~lL M$N*5FK sV.kW 9ۯ~h&_5 ɁnRE3PxFB`s҃՚ۣA=ڿy띉u2+%"f]u\Tsw(@rbVYp(Rm~"k#E9tSIbRQvY+|:\:ەcrޔU<@(H\\[?}7OKu++L[^T) :sՕ&]  [؀$@ T޵1!+hLfE*QLI8Rx @KɁbV]K>y^YCy~";}ۅLٞ86݌vp)QY S`<] S_垊v!dP=M䦌$8/s?oJɥ>eo ˼>hWPZo \B Jm%:~tӢkPyD~eӊN-drLX|.ez0 CcGGu3p*~ 09uhO" bfZgԜ41EսW6OI $eKy1RAGF/)TeX ' ߹a}P=lדZ61TF]΂+C<֔2ϰWszP;yH3Q.d*,WNhD\DHz@dT`$Y^R+h0]g~J@+<(R׃ڨ?ڏQH<&m Xo<}:ud;I4KܘkX{R8^5p ;AQ@qrϿSg-m.#ՠ,~;,~ =DQL?.A S2p J^ÊM* zyMl[M3HqKu O =nw Ρ0B*198kxrO3q_djKB@y'MjUH\J$5v>i֭98X-Dv0<H~1I*Z!|yC01X0Ec7c5.@օEUXNmTȒ9kZPR~Y|^D{L/ov)g۹ Ii8J(V2!xiӤ8Xs9!y_L9Sp2hgL#*kĻ 4ˆRჸFpj5f T MS(+ψaݏU!=Ov_T18Kc\^Ѻ=gbw#2 KM"#~H4b4?}|owCv$՚e#68}d~uįr>ҭ$yg[-Ts1pq˵^ܢ]RN,ּFhpP65Qyn

    If ever an element gets out of range you can either enlarge the paper size or click on the 'reset' button to place all elements below each other.

    6.29 Why can't I get a chart from my query result table?

    Not every table can be put to the chart. Only tables with one, two or three columns can be visualised as a chart. Moreover the table must be in a special format for chart script to understand it. Currently supported formats can be found in the wiki.

    6.30 Import: How can I import ESRI Shapefiles

    An ESRI Shapefile is actually a set of several files, where .shp file contains geometry data and .dbf file contains data related to those geometry data. To read data from .dbf file you need to have PHP compiled with the dBase extension (--enable-dbase). Otherwise only geometry data will be imported.

    To upload these set of files you can use either of the following methods:

    • Configure upload directory with $cfg['UploadDir'], upload both .shp and .dbf files with the same filename and chose the .shp file from the import page.

    • Create a Zip archive with .shp and .dbf files and import it. For this to work, you need to set $cfg['TempDir'] to a place where the web server user can write (for example './tmp').

      To create the temporary directory on a UNIX-based system, you can do:

      cd phpMyAdmin
      mkdir tmp
      chmod o+rwx tmp

    6.31 How do I create a relation in designer?

    To select relation, click:
    [relation icon]
    The display column is shown in pink. To set/unset a column as the display column, click the "Choose column to display" icon, then click on the appropriate column name.

    6.32 How can I use the zoom search feature?

    The Zoom search feature is an alternative to table search feature. It allows you to explore a table by representing its data in a scatter plot. You can locate this feature by selecting a table and clicking the 'Search' tab. One of the sub-tabs in the 'Table Search' page is 'Zoom Search'.

    Consider the table REL_persons in FAQ 6.6 for an example. To use zoom search, two columns need to be selected, for example, id and town_code. The id values will be represented on one axis and town_code values on the other axis. Each row will be represented as a point in a scatter plot based on its id and town_code. You can include two additional search criteria apart from the two fields to display.

    You can choose which field should be displayed as label for each point. If a display column has been set for the table (see FAQ 6.7), it is taken as the label unless you specify otherwise. You can also select the maximum number of rows you want to be displayed in the plot by specifing it in the 'Max rows to plot' field. Once you have decided over your criteria, click 'Go' to display the plot.

    After the plot is generated, you can use the mousewheel to zoom in and out of the plot. In addition, panning feature is enabled to navigate through the plot. You can zoom-in to a certail level of detail and use panning to locate your area of interest. Clicking on a point opens a dialogue box, displaying field values of the data row represented by the point. You can edit the values if required and click on submit to issue an update query. Basic instructions on how to use can be viewed by clicking the 'How to use?' link located just above the plot.

    phpMyAdmin project

    7.1 I have found a bug. How do I inform developers?

    Our Bug Tracker is located at http://sf.net/projects/phpmyadmin/ under the Bugs section.

    But please first discuss your bug with other users:

    7.2 I want to translate the messages to a new language or upgrade an existing language, where do I start?

    Translations are very welcome and all you need to have are the language skills. The easiest way is to use our online translation service. You can check out all the possibilities to translate in the translate section on our website.

    7.3 I would like to help out with the development of phpMyAdmin. How should I proceed?

    We welcome every contribution to the development of phpMyAdmin. You can check out all the possibilities to contribute in the contribute section on our website.


    8.1 Where can I get information about the security alerts issued for phpMyAdmin?

    Please refer to http://www.phpmyadmin.net/home_page/security.php

    8.2 How can I protect phpMyAdmin against brute force attacks?

    If you use Apache web server, phpMyAdmin exports information about authentication to the Apache environment and it can be used in Apache logs. Currently there are two variables available:

    User name of currently active user (he does not have to be logged in).
    Status of currently active user, one of ok (user is logged in), mysql-denied (MySQL denied user login), allow-denied (user denied by allow/deny rules), root-denied (root is denied in configuration), empty-denied (empty password is denied).

    LogFormat directive for Apache can look like following:

    LogFormat "%h %l %u %t \"%r\" %>s %b \
    \"%{Referer}i\" \"%{User-Agent}i\" %{userID}n %{userStatus}n"   pma_combined

    You can then use any log analyzing tools to detect possible break-in attempts.


    9.1 How can I synchronize two databases/tables in phpMyAdmin?

    You can now synchronize databases/tables in phpMyAdmin using the Synchronize feature. It allows you to connect to local as well as remote servers. This requires you to enter server host name, username, password, port and the name of the database. Therefore you can now synchronize your databases placed on the same server or some remote server.

    This feature is helpful for developers who need to replicate their database’s structure as well as data. Moreover, this feature not only hel(-N}W[m kM H@ 㮉7%Mܮc9 aYgRO蕞Ğ#E+DS7ksI \R`;Qƣ]ݓ8m E r? XIFڕ机" N{ԫ#kz[I6*TGwQj`f恝@fԈcޑf@͕ACDQhV=LrB(וv *0JăwH ޲W|-{J"aww7Nnx^4T4\r~# >~N%hݓ$16_ ,[t*ϴ`Y|ܒS;o^U;P^loƎto8Jms<-CۜPkkF xDV'B\^1P$~\%>9l'F՟uAayן98~'E_bD\V%Nw7 "AԨ4J:ɡDf˥AК2Sr /S(Y:Pլs/yH;G`NB#\RnsIBakcE~HPQ[Ig8Yx`Hv%RbȓP0_GO۱F ee)ј bb$zL}4Țd^6w$AYtW |LmŕV{{v"@uNCfׂ_ 41\2ݞgqApf‚ *3?'9{Z4]f*GWT8@ O}1 KGcLy(dmjC ZJyc 5C5xV.* \Ŀܷx!;3#-T<`pDTpkS'e%w]*kCKZn := 0z"j7", odBBɩYi`H_RDa6! -%̝Ĩ$*X:/?aŷ} dQA=.OX f_ewr(-KTxfːخa+l3T^gs`Jvvy1'6# RXi,K%0`m`riwGgڨtwFH|yo,Ǖc}%hC,~jnc )ϩD& 6,zbI۝EHφm JZ I'^T6S돷-;ڳ9*|[2Xi/W.Tm(mcӜl5qtbj ᢚHt0nIV n'՘{ Gpw  jp-QhoL d>ȏy2Vd~v64zEyF>GUsCѫdmM@\ΰvX*龬$CE= Q[QN 7lA5l.aacQD/1~Nm2GݝaRa.^:1\X=3^<\Ę걡W$)ux¸:˙䁚D~x{oAޗUj,`pa*~x+9HT?L iIX W 3+ շ.%%zu:Їy-OpNO0o GofQ7 ijհZIo1|qdqnRG{M {?c'+8ps&@hST#upUCzmYldup&9ˮ&ވ왕Lqs~銖m0Y*Ucg^g&!}8b.,UlX %^M2g}Rc Vǿf.yHzߌKt⟥w&\LCH) Oh^롃}'. cB= B(k!e iQ_QM?]z9}iy %P; zMi5t%&ʮp64 k t!N/+0d}C0N:|֝r+_>3@(<6*4w8kޤA8P%\F^Iv9n OKU_6887RNn!r)Pv A$2>+Lg\Uܙ .2y.0s<ݦ W)x--@:2Iq3ej$ftEIJ'<(!=:n,620 yܣ_f"(1/ ~_5KMʹdۀ}=v'(`b` ZY; ;C5#'l}i1p:<8F/O\öVgwy;F-=ÂQO"|dz̩u[vI:kυR~fUP-h s|Cܮgr-ÜYҹ,Jr+P>!>pdZ-VNL.o Ĝz9Zh|fPvMi; ^q-R"ޑcơc9G+JgU*pj&䆇~Vh*c 0>yu;{d eP2Rs~jg@`]h MQDVYHȢ.2EA!3Z_F51/Qa2=E, ZWL|cŋ\ Z[8#k'S(44jN\ X>A3;6rsԣOfb %t}_W+At-Yڍ6HmX~ qJd09H:y'r%6tN! TΧ.0[:yp%HR3 @u2&OY ^=i "Az}VLv%R @YOc9r> 1dcݨ!tEje>N~yXI70yAF02H~(q5tFӭOAh-XR"_/B/r Jtu()"+t {2ΜfזZSFj̮/ "X^%*LI|p: EPVxiwGU~wliUÄw88s] -kwqIeyNGm;Sf+ۓst1 F^ 'lbT" 'F@zbV) Uɉ}(rqfsLݒ',u-ZDBLHKwv&ibmY+:QZ`1u]S-*%J߉'ފy=Z׋IŝX0i?f l >q.fsV=a]E#w{?f`E"Z/*iNqd ͞@R,5Z6}gmԘ&A9 kƛ ͺ0{~IZ蛎X :;XY&4jז[&"L K &+}N+ VV%e~p K|n:Dh!]pވ1r6\G[ ћZm73),_*MO]n,݅,a!{s&%){܏ `OaNkr˽E'Eg;` !]Y X p }Y]:ut)a2x t/ӎAξM=!LcoѐW\ZHN}F%^C**<.p6 ^ ⍳ïٟ|ӂPԇ9YdghΚQW$D+3P_KӃdb#`2B-Z$󔡜<[= ~se$0& 8kXa0y!amvׁ]`JiN4`c{َ:p*/%xpE[uݨm \DTY&sə Q*zto-#p"LbqV DC\_5PQWvt*%t`sD8v=Ժ^zl[IucėJз4 Dן?$}N4j1:LenJɽOӒW61|W@IvbVY^MZ} z"?o%n@:ƴjʲlIE~ǂn:԰{2HNcO\7&Qꉾ[ ?IpH- AeF6 CU^%HRR@_h32}FP ̠\UshűDB>`鶵7 [P`2ȱc[%ryexQFo_(8"YtUoc3F>Nv㝈P{+,UK:f_:gGC{r ns.7  Jd+[cP(m4uGd ;z jİ~!_h@1 tAY "#U8ݰZ; lV&6߭3,8TstIG6 D"A1驱 X(JAkrq rrgp\^^N*[ QHW>܁d]D:H JEGp.si?T~@þiPpإMxNDž.38*$ YpS]AVl_F2~Za@O#ΊIjBi EvdJ5ENylRM.p԰3>z2Z%<6!<_>'iaM0YO3h;}$,9v]0Gw{h{k bSH\JRΣVB1>H`a!\F&OuRva9M \k p7Q{ZE^u"b)!DȳiXۜs`EF6x UoYxɑBsm[mdbM.e4T^ Zx5wT?R|S/D0N_a2B/eY@hsS|v8*uQ}27 SyyHtж<⣞~'VA2M֏1v$j&A&aAC.KÇY^:OE ?b."<Ӭ1pa: Ĺpңd.#kh Q;_rà w_)Й9n-Ig%wQwR2N"~p<4+ژ^rK;Y[/j  |p+?5A\+xO=Eje&:u[.TFH2<2l9.O52I9']}f)˝¶|XMZj#r.a_$Ff)\gt}A$1(vt{OQPS~u(C+):ށCgL^b]4M2~h'S11kp_NR" jQA y tq"mK+++,Hx˷=l *:EJUPAyu0v\'T )^x{phBM1 π:ȃd2bE?EqOts]*}y1s&݊nL-s XoMs-=x6Me5? ^pEҔG҄ث4Oa lrӣ7zf N \^ӻUTTCV)؋v*6/YZk)K@>'>6qڢ6j[9aSߊko6ut99JzYm-uYH by$>{߅^uqSPP-6 anWNf%YN zplׅh4wbzb :' { ~] jΐdNҕkdVzHpR-12tz%lbGO"!%ccKQN]y86+:}^ m ߽/P|i<"8P˗ǒ)g(UPL Ӡ|~9Qhڋq\CKV(n~5F?݉C92rMZU||aIF1 ت+)f fyT"5bf6)7?W3kyL@$B[9G/#աBC oyibPQg,0ȁ@|L X(F;n&flUl'Os:f0$R1=)Cы!^P5k0-})[$##rԊf{ʨ 11v̗۫XUiJ&|7 ln[~0(pDq!c $6 %1ڦV}UD|GٜOi&*3n#c(F=x)nu{k1{^Egn̈%]KωTl\e`(ֲ͑}V4`LnFLK{|E@Eq&L ,b6o&k`lS|4%~n{Tzu*37^U>MBlzj `J{͠x?IX)xfͼHOByԷ2śOь-scratchboard for WYSIWYG-distribution of PDF relations

  13. new icon sets
  14. vertical display of column properties page
  15. some bugfixes, features, support, German language additions
  16. Yukihiro Kawada <kawada_at_den.fujifilm.co.jp>
    • japanese kanji encoding conversion feature
  17. Piotr Roszatycki <d3xter_at_users.sourceforge.net> and Dan Wilson
    • the Cookie authentication mode
  18. Axel Sander <n8falke_at_users.sourceforge.net>
    • table relation-links feature
  19. Maxime Delorme <delorme.maxime_at_free.fr>
  20. Olof Edlund <olof.edlund_at_upright.se>
    • SQL validator server
  21. Ivan R. Lanin <ivanlanin_at_users.sourceforge.net>
    • phpMyAdmin logo (until June 2004)
  22. Mike Cochrane <mike_at_graftonhall.co.nz>
    • blowfish library from the Horde project
  23. Marcel Tschopp <ne0x_at_users.sourceforge.net>
    • mysqli support
    • many bugfixes and improvements
  24. Nicola Asuni (Tecnick.com)
  25. Michael Keck <mkkeck_at_users.sourceforge.net>
    • redesign for 2.6.0
    • phpMyAdmin sailboat logo (June 2004)
  26. Mathias Landhäußer
    • Representation at conferences
  27. Sebastian Mendel <cybot_tm_at_users.sourceforge.net>
    • interface improvements
    • various bugfixes
  28. Ivan A Kirillov
    • new relations Designer
  29. Raj Kissu Rajandran (Google Summer of Code 2008)
    • BLOBstreaming support
  30. Piotr Przybylski (Google Summer of Code 2008, 2010 and 2011)
    • improved setup script
    • user preferences
    • Drizzle support
  31. Derek Schaefer (Google Summer of Code 2009)
    • Improved the import system
  32. Alexander Rutkowski (Google Summer of Code 2009)
    • Tracking mechanism
  33. Zahra Naeem (Google Summer of Code 2009)
    • Synchronization feature
  34. Tomáš Srnka (Google Summer of Code 2009)
    • Replication support
  35. Muhammad Adnan (Google Summer of Code 2010)
    • Relation schema export to multiple formats
  36. Lori Lee (Google Summer of Code 2010)
    • User interface improvements
    • ENUM/SET editor
    • Simplified interface for export/import
  37. Ninad Pundalik (Google Summer of Code 2010)
    • AJAXifying the interface
  38. Martynas Mickevičius (Google Summer of Code 2010)
    • Charts
  39. Barrie Leslie
    • BLOBstreaming support with PBMS PHP extension
  40. Ankit Gupta (Google Summer of Code 2010)
    • Visual query builder
  41. Rouslan Placella (Google Summer of Code 2011)
    • Improved support for Stored Routines, Triggers and Events
    • Italian translation updates
  42. Dieter Adriaenssens
    • Various bugfixes
    • Dutch translation updates
  43. And also to the following people who have contributed minor changes, enhancements, bugfixes or support for a new language since version 2.1.0:

    Bora Alioglu, Ricardo ?, Sven-Erik Andersen, Alessandro Astarita, Péter Bakondy, Borges Botelho, Olivier Bussier, Neil Darlow, Mats Engstrom, Ian Davidson, Laurent Dhima, Kristof Hamann, Thomas Kläger, Lubos Klokner, Martin Marconcini, Girish Nair, David Nordenberg, Andreas Pauley, Bernard M. Piller, Laurent Haas, "Sakamoto", Yuval Sarna, www.securereality.com.au, Alexis Soulard, Alvar Soome, Siu Sun, Peter Svec, Michael Tacelosky, Rachim Tamsjadi, Kositer Uros, Luís V., Martijn W. van der Lee, Algis Vainauskas, Daniel Villanueva, Vinay, Ignacio Vazquez-Abrams, Chee Wai, Jakub Wilk, Thomas Michael Winningham, Vilius Zigmantas, "Manuzhai".

    Original Credits of Version 2.1.0

    This work is based on Peter Kuppelwieser's MySQL-Webadmin. It was his idea to create a web-based interface to MySQL using PHP3. Although I have not used any of his source-code, there are some concepts I've borrowed from him. phpMyAdmin was created because Peter told me he wasn't going to further develop his (great) tool.

    Thanks go to

    • Amalesh Kempf <ak-lsml_at_living-source.com> who contributed the code for the check when dropping a table or database. He also suggested that you should be able to specify the primary key on tbl_create.php3. To version 1.1.1 he contributed the ldi_*.php3-set (Import text-files) as well as a bug-report. Plus many smaller improvements.
    • Jan Legenhausen <jan_at_nrw.net>: He made many of the changes that were introduced in 1.3.0 (including quite significant ones like the authentication). For 1.4.1 he enhanced the table-dump feature. Plus bug-fixes and help.
    • Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca> made phpMyAdmin language-independent by outsourcing the strings to a separate file. He also contributed the French translation.
    • Alexandr Bravo <abravo_at_hq.admiral.ru> who contributed tbl_select.php3, a feature to display only some columns from a table.
    • Chris Jackson <chrisj_at_ctel.net> added support for MySQL functions in tbl_change.php3. He also added the "Query by Example" feature in 2.0.
    • Dave Walton <walton_at_nordicdms.com> added support for multiple servers and is a regular contributor for bug-fixes.
    • Gabriel Ash <ga244_at_is8.nyu.edu> contributed the random access features for 2.0.6.

    The following people have contributed minor changes, enhancements, bugfixes or support for a new language:

    Jim Kraai, Jordi Bruguera, Miquel Obrador, Geert Lund, Thomas Kleemann, Alexander Leidinger, Kiko Albiol, Daniel C. Chao, Pavel Piankov, Sascha Kettler, Joe Pruett, Renato Lins, Mark Kronsbein, Jannis Hermanns, G. Wieggers.

    And thanks to everyone else who sent me email with suggestions, bug-reports and or just some feedback.


    From Wikipedia, the free encyclopedia

    l~'([d02zDC,NJʪX`O15MMf?3Q9~F(84܁&srҫO+/?7t#=[2gޙK2*,67 69 24 04 B1 31 58 CA B2 C8 BB 64 8A C6 BF 91 60 6F 15 5D 5A 1A 32 44 FC DD A9 F8 9E 0D 21 89 90 6A 72 5A 7D 7A F5 17 A8 24 59 CB 0F 42 30 C5 9F 4E 27 C9 7E 17 88 4D 1B A2 DA 45 31 15 68 37 23 BB 6F 64 E1 94 18 77 D1 58 5E 63 39 D0 FB B9 C9 CB 0F 53 61 48 2E 03 19 19 7A 60 C8 21 58 4A 36 F5 3F 8C 16 DA 51 06 10 1D 4A 6F 0D AC 62 5F 33 88 65 A8 64 BF 82 52 59 05 5F C5 A3 6C D3 5C 24 45 19 35 2A 14 85 1E 3A 4C 60 D6 51 E2 38 9D 13 1D 7F B4 42 8E 33 9D 8D CD D0 86 3A F6 0B C1 F3 41 7E 92 42 35 AE 09 0D 61 E5 57 D5 66 75 5F 3F 24 24 7A C7 5E 12 B4 4B 7B 6B DE 3A 68 AC DC FB 3C C9 6A 66 6D 3A 5F 21 07 F9 56 00 D0 9B 9B A6 3B 57 46 31 97 03 D6 9E EA A2 78 7D BA 7D E6 4E 0C 27 77 22 75 B7 82 89 93 85 04 A3 F6 1F 13 31 0A 96 01 B6 FE FC B7 96 86 C5 E2 F9 52 98 79 [oXw+LJ=''klsv_:0 VD