Documentation.html

   1 <!DOCTYPE html
   2     PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   3     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   4 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-US" lang="en-US">
   5 <!-- $Id$ -->
   6
   7 <head>
   8     <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
   9     <title>phpMyAdmin 2.2.1-dev - Documentation</title>
  10     <style type="text/css">
  11     <!--
  12     .navigation {
  13         font-family: Verdana, Arial, Helvetica, sans-serif;
  14         text-decoration: none;
  15         font-size: 10pt;
  16         color:#000099;
  17         font-weight: normal;
  18     }
  19     .navigation:hover {
  20         background-color: #99CCFF;
  21         font-weight: bolder
  22     }
  23     .navigation2 {
  24         font-family: Verdana, Arial, Helvetica, sans-serif;
  25         text-decoration: none;
  26         font-size: 14pt;
  27         color:#000099;
  28         font-weight: normal;
  29     }
  30     .navigation2:hover {
  31         background-color: #99CCFF;
  32         font-weight: bolder
  33     }
  34     h1 {
  35         font-family: Verdana, Arial, Helvetica, sans-serif;
  36         font-size: x-large;
  37         font-weight:bold;
  38         color: #000066
  39     }
  40     .simple {
  41         font-family: Arial, Helvetica, sans-serif;
  42         font-size: smaller;
  43         color: #000000
  44     }
  45     body {
  46         font-family: Arial, Helvetica, sans-serif;
  47         font-size: 10pt
  48     }
  49     td {
  50         font-family: Arial, Helvetica, sans-serif;
  51         font-size: 10pt
  52     }
  53     ul {
  54         font-family: Arial, Helvetica, sans-serif;
  55         font-size: 10pt
  56     }
  57     ol {
  58         font-family: Arial, Helvetica, sans-serif;
  59         font-size: 10pt
  60     }
  61     p {
  62         font-family: Arial, Helvetica, sans-serif;
  63         font-size: 10pt
  64     }
  65     h2 {
  66         font-family: Verdana, Arial, Helvetica, sans-serif;
  67         font-size:large;
  68         font-weight:bold; color: #000066
  69     }
  70     -->
  71     </style>
  72 </head>
  73
  74 <body bgcolor="#FFFFFF">
  75 <a name="top"></a>
  76 <h1>phpMyAdmin 2.2.1-rc1 Documentation</h1>
  77
  78
  79 <!-- TOP MENU -->
  80 <ul>
  81     <li><a class="navigation" href="http://www.phpwizard.net/projects/phpMyAdmin/">Official phpMyAdmin project homepage  &nbsp;&nbsp;&nbsp;[ http://www.phpwizard.net/projects/phpMyAdmin/ ]</a></li>
  82     <li><a class="navigation" href="http://phpmyadmin.sourceforge.net/">Sourceforge phpMyAdmin download page  &nbsp;&nbsp;&nbsp;[ http://phpmyadmin.sourceforge.net/ ]</a></li>
  83     <li>Local documents:
  84     <ul>
  85         <li>Version history: <a class="navigation" href="ChangeLog">ChangeLog</a></li>
  86         <li>General notes: <a class="navigation" href="README">README</a></li>
  87         <li>License: <a class="navigation" href="LICENSE">LICENSE</a></li>
  88     </ul>
  89     </li>
  90     <li>Documentation version: <i>$Id$</i></li>
  91 </ul>
  92
  93
  94 <!-- REQUIREMENTS -->
  95 <a name="require"></a><br />
  96 <hr noshade="noshade" width="100%" />
  97 <font size="+1">
  98     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
  99     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
 100     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
 101     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
 102     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
 103     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
 104     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
 105     <a class="navigation2" href="#credits">Credits</a>
 106 </font>
 107 <hr noshade="noshade" width="100%" />
 108
 109 <h2>Requirements</h2>
 110
 111 <ul>
 112     <li>
 113         PHP3 or PHP4: phpMyAdmin widely uses the 'str_replace()' php function
 114         that was added in PHP&nbsp;3.0.6, but was buggy up until
 115         PHP&nbsp;3.0.8.
 116         Then <font color="#bb0000">you should not run this script with
 117         PHP3&nbsp;&lt;&nbsp;3.0.8</font>.<br />
 118         PHP also needs to be <font color="#bb0000">compiled with MySQL support</font>;
 119     </li>
 120     <li>
 121         MySQL (tested with 3.21.x, 3.22.x and 3.23.x);
 122     </li>
 123     <li>
 124         a web-browser (doh!).
 125     </li>
 126 </ul>
 127
 128
 129 <!-- INTRODUCTION -->
 130 <a name="intro"></a><br />
 131 <hr noshade="noshade" width="100%" />
 132 <font size="+1">
 133     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
 134     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
 135     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
 136     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
 137     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
 138     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
 139     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
 140     <a class="navigation2" href="#credits">Credits</a>
 141 </font>
 142 <hr noshade="noshade" width="100%" />
 143
 144 <h2>Introduction</h2>
 145
 146 <p>
 147     phpMyAdmin can administer a whole MySQL-server (needs a super-user)
 148     but also a single database. To accomplish the latter you'll need
 149     a properly set up MySQL-user who can read/write only the desired
 150     database. It's up to you to look up the appropiate part in the
 151     MySQL manual. Currently phpMyAdmin can:
 152 </p>
 153
 154 <ul>
 155     <li>create and drop databases</li>
 156     <li>create, copy, drop and alter tables</li>
 157     <li>delete, edit and add fields</li>
 158     <li>execute any SQL-statement, even batch-queries</li>
 159     <li>manage keys on fields</li>
 160     <li>load text files into tables</li>
 161     <li>create (*) and read dumps of tables</li>
 162     <li>export (*) and import data to CSV values</li>
 163     <li>administer multiple servers and single databases</li>
 164     <li>communicate in more than 20 different languages</li>
 165 </ul>
 166
 167 <table border="0" cellspacing="0" cellpadding="0">
 168 <tr>
 169     <td valign="top">(*)&nbsp;</td>
 170     <td>
 171         phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2 formats) dumps
 172         and CSV exports if you use PHP4&nbsp;>=&nbsp;4.0.4 with Zlib support
 173         (<tt>--with-zlib</tt>) and/or Bzip2 support (<tt>--with-bz2</tt>).
 174     </td>
 175 </tr>
 176 </table>
 177
 178
 179 <!-- INSTALLATION -->
 180 <a name="setup"></a><br />
 181 <hr noshade="noshade" width="100%" />
 182 <font size="+1">
 183     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
 184     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
 185     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
 186     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
 187     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
 188     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
 189     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
 190     <a class="navigation2" href="#credits">Credits</a>
 191 </font>
 192 <hr noshade="noshade" width="100%" />
 193
 194 <h2>Installation</h2>
 195
 196 <p>
 197     <font color="#bb0000">NOTE: phpMyAdmin does not apply any special security
 198     methods to the MySQL database server. It is still the sysadmin's job to
 199     grant permissions on the MySQL databases properly.</font>
 200 </p>
 201
 202 <p>
 203     <font color="#bb0000">Warning for Mac users:</font> php seems not to like
 204     Mac end of lines character (&quot;<tt>\r</tt>&quot;) and Stuffit unstuffs
 205     with Mac formats, of course.<br />
 206     So you'll have to resave as in Bbedit to unix style ALL phpMyAdmin scripts
 207     before uploading them to your server.
 208 </p>
 209
 210 <p>Quick Install:</p>
 211 <ol>
 212     <li> Untar or unzip the distribution (be sure to unzip the subdirectories):
 213          <tt>tar xzvf phpMyAdmin_x.x.x.tar.gz</tt></li>
 214     <li> Open the file config.inc.php3 in your favourite editor and change
 215          the values for host, user and password to fit your environment.
 216          Have a look at
 217          <a class="navigation" href="#config">Configuration section</a> for an
 218          explanation of all values.</li>
 219     <li> It is recommended that you protect the directory in which
 220          you installed phpMyAdmin (unless it's on a closed intranet, or you wish to use advanced authentication),
 221          for example with HTTP-AUTH (in a <i>.htaccess</i> file). See the
 222          <a class="navigation" href="#faq">FAQ section</a> for additional
 223          information.</li>
 224     <li> Open the file
 225          <i>&lt;www.your-host.com&gt;/&lt;your-install-dir&gt;/index.php3</i>
 226          in your browser. phpMyAdmin should now display a welcome screen
 227          and your databases, or a login dialog if using advanced authentication.</li>
 228 </ol>
 229
 230 <p>Upgrading from an older version:</p>
 231 <ul>
 232     <li> Please do not copy your older config.inc.php3 over the new one: it may offer new configuration variables, and the new version may depend on these for normal behavior.  It is suggested instead to insert your site values in the new one.</li>
 233 </ul>
 234
 235 <p>Using Advanced Authentication:</p>
 236 <ol>
 237 <li>
 238     phpMyAdmin needs a stduser that has <b>only</b> the <tt>SELECT</tt>
 239     privilege on the <i>mysql.db (Db,user,Select_priv)</i> &amp; <i>mysql.user (user,Select_priv)</i> tables. You
 240     must specify the details for the stduser in the <i>config.inc.php3</i> file
 241     under the <tt>$cfgServers[n]['stduser']</tt> &amp;
 242     <tt>$cfgServers[n]['stdpass']</tt> settings.
 243     To create the control account:<br />
 244     &nbsp;&nbsp;&nbsp;<tt>GRANT USAGE ON mysql.* TO 'stduser'@localhost IDENTIFIED BY 'password';</tt><br />
 245     &nbsp;&nbsp;&nbsp;<tt>GRANT SELECT (user, Select_priv) ON mysql.user TO 'stduser'@localhost;</tt><br />
 246     &nbsp;&nbsp;&nbsp;<tt>GRANT SELECT (Db,user,Select_priv) ON mysql.db TO 'stduser'@localhost;</tt>
 247 </li>
 248 <li>
 249     Then each of the <i>true</i> users should be granted of a set of
 250     privileges on a set of perticular databases but shouldn't have any global
 251     privileges. For example, to grant the user <i>real_user</i> with all
 252     privileges on the database <i>user_base</i>:<br />
 253     &nbsp;&nbsp;&nbsp;<tt>GRANT ALL PRIVILEGES ON user_base TO 'real_user'@localhost IDENTIFIED BY 'real_password';</tt>
 254     <br />
 255     What the user may now do is controlled entirely by the MySQL user management
 256     system.
 257 </li>
 258 </ol>
 259
 260 <!-- CONFIGURATION -->
 261 <a name="config"></a><br />
 262 <hr noshade="noshade" width="100%" />
 263 <font size="+1">
 264     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
 265     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
 266     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
 267     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
 268     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
 269     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
 270     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
 271     <a class="navigation2" href="#credits">Credits</a>
 272 </font>
 273 <hr noshade="noshade" width="100%" />
 274
 275 <h2>Configuration</h2>
 276
 277 <p>
 278     <font color="#bb0000">Warning for Mac users:</font> php seems not to like
 279     Mac end of lines character (&quot;<tt>\r</tt>&quot;). So ensure you choose
 280     the option that allows to use the *nix end of line character
 281     (&quot;<tt>\n</tt>&quot;) in your text editor before registering a script
 282     you have modified.
 283 </p>
 284
 285 <p>All configurable data is placed in <i>config.inc.php3</i>.</p>
 286 <dl>
 287     <dt><b>$cfgPmaAbsoluteUri</b> string</dt>
 288     <dd>
 289         Sets here the complete url (with full path) to your phpMyAdmin version.
 290         E.g. <tt>http://www.your_web.net/path_to_your_phpMyAdmin_directory/</tt>.
 291         <br />
 292         Don't forget the slash at the end of your url.
 293         <br /><br />
 294     </dd>
 295
 296     <dt><b>$cfgServers</b> array</dt>
 297     <dd>
 298         Since version 1.4.2, phpMyAdmin supports the administration of multiple
 299         MySQL servers.
 300         Therefore, a $cfgServers-array has been added which contains the login
 301         information for the different servers. <tt>$cfgServers[1]['host']</tt>
 302         contains the hostname of the first server,
 303         <tt>$cfgServers[2]['host']</tt> the hostname of the second server, etc.
 304         If you have only one server to administer, simply leave free the
 305         hostname of the other $cfgServer-entries.
 306         <br /><br />
 307     </dd>
 308
 309     <dt><b>$cfgServers[n]['host']</b> string</dt>
 310     <dd>
 311         The hostname of your n-th MySQL-server. E.g. localhost.
 312         <br /><br />
 313     </dd>
 314
 315     <dt><b>$cfgServers[n]['port']</b> string</dt>
 316     <dd>
 317         The port-number of your n-th MySQL-server. Default is 3306 (leave
 318         blank).
 319         <br /><br />
 320     </dd>
 321
 322     <dt><b>$cfgServers[n]['socket']</b> string</dt>
 323     <dd>
 324         The path to the socket to use. Leave blank for default.<br />
 325         To use the socket feature you must run php 3.0.10 or more.
 326         <br /><br />
 327     </dd>
 328
 329     <dt><b>$cfgServers[n]['connect_type']</b> string</dt>
 330     <dd>
 331         What type connection to use with the MySQL server. Your options are
 332         'socket' &amp; 'tcp'. It defaults to 'tcp' as that is nearly guarenteed
 333         to be available on all MySQL servers, while sockets are not supported
 334         on some platforms.
 335         <br /><br />
 336     </dd>
 337
 338     <dt>
 339         <b>$cfgServers[n]['stduser']</b> string<br />
 340         <b>$cfgServers[n]['stdpass']</b> string
 341     </dt>
 342     <dd>
 343         When using advanced authentication mode (or standard authentication
 344         mode since phpMyAdmin 2.2.1-rc3), you need to supply the details
 345         of a MySQL account that has <tt>SELECT</tt> access on the
 346         <i>mysql.db (Db,user,Select_priv)</i> &amp; <i>mysql.user (user,Select_priv)</i> tables.<br />
 347         This account is used to check what databases the user will see at login.
 348         Please see the install section on &quot;Using advanced authentication&quot; for more information.
 349         <br /><br />
 350         Please note that if you try login to phpMyAdmin with this stduser, you
 351         could get some errors, depending the exact privileges you gave to
 352         the stduser. phpMyAdmin does not support a direct login with the
 353         stduser.
 354         <br /><br />
 355     </dd>
 356
 357     <dt><b>$cfgServers[n]['adv_auth']</b> boolean</dt>
 358     <dd>
 359         Whether basic or advanced authentication should be used for this
 360         server.<br />
 361         Basic authentication (<tt>$adv_auth&nbsp;=&nbsp;FALSE</tt>) is the
 362         plain old way: username and password are stored in
 363         <i>config.inc.php3</i>.
 364         Advanced authentication (<tt>$adv_auth&nbsp;=&nbsp;TRUE</tt>) as
 365         introduced in 1.3.0 allows you to log in as any valid MySQL user via
 366         HTTP-Auth.<br />
 367         Please note that this authentication mode is
 368         <font color="#bb0000">only supported with PHP running as an Apache
 369         module</font>, and not with cgi.<br /><br />
 370
 371         Using advanced authentication is recommended:
 372         <ul>
 373             <li>
 374                 when phpMyAdmin is running in a multi-user environment where
 375                 people have shell-access that you don't want to know the
 376                 username/password for MySQL.
 377             </li>
 378             <li>
 379                 when you want to give users access to their own database and
 380                 don't want them to play around with others.
 381                 <br /><br />
 382             </li>
 383         </ul>
 384
 385         Advanced authentication is secure as the MySQL passwords does not need
 386         to be set in the phpMyAdmin configuration file. (except for the standard
 387         user -see above-).
 388         <br /><br />
 389
 390         Please see the install section on &quot;Using advanced authentication&quot; for more information.
 391         <br /><br />
 392     </dd>
 393
 394     <dt>
 395         <b>$cfgServers[n]['user']</b> string<br />
 396         <b>$cfgServers[n]['password']</b> string
 397     </dt>
 398     <dd>
 399         The user/password-pair which phpMyAdmin will use to connect to this
 400         MySQL-server. The password is not needed when advanced authentication
 401         is used, and should be empty.<br /><br />
 402     </dd>
 403
 404     <dt><b>$cfgServers[n]['only_db']</b> string or array</dt>
 405     <dd>
 406         If set to a(an array of) database name(s), only this(these) database(s)
 407         will be shown to the user.
 408         This setting is an efficient way to lower the server load since the
 409         latter does not need a to send requests to MySQL to build the database
 410         list.<br />
 411         <font color="#bb0000">Warning:</font> this setting does not replace the
 412         privileges rules of the MySQL database server. If set, it just means
 413         only these databases will be displayed but <font color="#bb0000">not at
 414         all other databases can't be used.</font>
 415         <br /><br />
 416     </dd>
 417
 418     <dt><b>$cfgServers[n]['verbose']</b> string</dt>
 419     <dd>
 420         Only useful when using phpMyAdmin with multiple server entries. If set,
 421         this string will be displayed instead of the hostname in the pulldown
 422         menu on the main page. This can be useful if you want to show only
 423         certain databases on your system, for example.
 424         <br /><br />
 425     </dd>
 426
 427     <dt>
 428         <b>$cfgServers[n]['bookmarkdb']</b> string<br />
 429         <b>$cfgServers[n]['bookmarktable']</b> string
 430     </dt>
 431     <dd>
 432         Since release 2.2.0 phpMyAdmin allows to bookmark queries. This can be
 433         useful for queries you often run.<br /><br />
 434
 435         To use this functionality you have to:
 436         <ul>
 437             <li>
 438                 create a table following this scheme:<br />
 439                 <tt>
 440                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CREATE TABLE bookmark (<br />
 441                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id int(11) DEFAULT '0' NOT NULL auto_increment,<br />
 442                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbase varchar(255) NOT NULL,<br />
 443                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user varchar(255) NOT NULL,<br />
 444                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;label varchar(255) NOT NULL,<br />
 445                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;query text NOT NULL,<br />
 446                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PRIMARY KEY (id)<br />
 447                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);
 448                 </tt>
 449             </li>
 450             <li>
 451                 then complete the two variables
 452                 <tt>$cfgServers[n]['bookmarkdb']</tt> and
 453                 <tt>$cfgServers[n]['bookmarktable']</tt> so phpMyAdmin will be
 454                 able to find the bookmark table.
 455             </li>
 456         </ul><br />
 457
 458         Note that <tt>stduser</tt> must have <tt>SELECT</tt>, <tt>INSERT</tt>
 459         and <tt>DELETE</tt> privileges on the bookmark table.
 460         Here is a query to set up those privileges:<br />
 461         <tt>GRANT SELECT,INSERT,DELETE ON &lt;bookmarkdb&gt;.&lt;bookmarktable&gt; to 'stduser'@localhost;</tt>
 462         <br /><br />
 463     </dd>
 464
 465     <dt><b>$cfgServerDefault</b> integer</dt>
 466     <dd>
 467         If you have more than one server configured, you can set
 468         $cfgServerDefault to any one of them to autoconnect to that server when
 469         phpMyAdmin is started, or set it to 0 to be given a list of servers
 470         without logging in.<br />
 471         If you have only one server configured, <tt>$cfgServerDefault</tt> MUST
 472         be set to that server.
 473         <br /><br />
 474     </dd>
 475
 476
 477     <dt><b>$cfgOBGzip </b>boolean</dt>
 478     <dd>
 479         Defines whether to use gzip output buffering for increased
 480         speed in HTTP transfers.
 481         <br /><br />
 482     </dd>
 483
 484     <dt><b>$cfgPersistentConnections </b>boolean</dt>
 485     <dd>
 486         Whether persistent connections should be used or not (mysql_connect or
 487         mysql_pconnect).
 488         <br /><br />
 489     </dd>
 490
 491     <dt><b>$cfgSkipLockedTables </b>boolean</dt>
 492     <dd>
 493         Mark used tables and make it possible to show databases with locked
 494         tables (since 3.23.30).
 495         <br /><br />
 496     </dd>
 497
 498     <dt><b>$cfgShowSQL </b>boolean</dt>
 499     <dd>
 500         Defines whether sql-queries generated by phpMyAdmin should be displayed
 501         or not.
 502         <br /><br />
 503     </dd>
 504
 505     <dt><b>$cfgAllowUserDropDatabase </b>boolean</dt>
 506     <dd>
 507         Defines whether standard users (non administrator) are allowed to
 508         delete their own database or not. If set as FALSE, the link &quot;Drop
 509         Database&quot; will not be shown, and even a &quot;DROP DATABASE
 510         mydatabase&quot; will be rejected. Quite practical for ISP's with many
 511         customers.
 512         <br /><br />
 513      </dd>
 514
 515     <dt><b>$cfgConfirm </b>boolean</dt>
 516     <dd>
 517         Whether a warning (&quot;Are your really sure..&quot;) should be
 518         displayed when you're about to loose data.
 519         <br /><br />
 520     </dd>
 521
 522     <dt><b>$cfgShowTooltip </b>boolean</dt>
 523     <dd>
 524         Defines whether to display table comment as tooltip in left frame or
 525         not.
 526         <br /><br />
 527     </dd>
 528
 529     <dt><b>$cfgShowStats </b>boolean</dt>
 530     <dd>
 531         Defines whether to display space usage and statistics about databases
 532         and tables or not.<br />
 533         Note that statistics requires at least MySQL 3.23.3 and that, at this
 534         date, MySQL doesn't return such information for Berkeley DB tables.
 535         <br /><br />
 536     </dd>
 537
 538     <dt><b>$cfgShowBlob </b>boolean</dt>
 539     <dd>
 540         Defines whether <tt>BLOB</tt> fields are shown when browsing a table's
 541         content or not.
 542         <br /><br />
 543     </dd>
 544
 545     <dt><b>$cfgShowAll </b>boolean</dt>
 546     <dd>
 547         Defines whether an user should be displayed a
 548         &quot;show all (records)&quot; button in browse mode or not.
 549         <br /><br />
 550     </dd>
 551
 552     <dt><b>$cfgMaxRows </b>integer</dt>
 553     <dd>
 554         Number of rows displayed when browsing a resultset. If the resultset
 555         contains more rows, Previous/Next links will be shown.
 556         <br /><br />
 557     </dd>
 558
 559     <dt><b>$cfgOrder </b>string [<tt>DESC</tt>|<tt>ASC</tt>|<tt>SMART</tt>]</dt>
 560     <dd>
 561         Defines whether fields are displayed in ascending (<tt>ASC</tt>) order,
 562         in descending (<tt>DESC</tt>) order or in a &quot;smart&quot;
 563         (<tt>SMART</tt>) order -ie descending order for fields of type TIME,
 564         DATE, DATETIME &amp; TIMESTAMP, ascending order else- by default.
 565         <br /><br />
 566     </dd>
 567
 568     <dt><b>$cfgProtectBinary </b>boolean</dt>
 569     <dd>
 570         Defines whether <tt>BLOB</tt> or <tt>BINARY</tt> fields are protected
 571         from edition when browsing a table's content or not.
 572         Valid values are:<br />
 573         - <tt>FALSE</tt> to allow edition of all fields;<br />
 574         - <tt>blob</tt> to allow edition of all fields except <tt>BLOBS</TT>;<br />
 575         - <tt>all</tt> to disallow edition of all <tt>BINARY</tt> or <tt>BLOB</tt> fields.
 576         <br /><br />
 577     </dd>
 578
 579     <dt>
 580         <b>$cfgZipDump </b>boolean<br />
 581         <b>$cfgGZipDump </b>boolean<br />
 582         <b>$cfgBZipDump </b>boolean
 583     </dt>
 584     <dd>
 585         Defines whether to allow the use of zip/gzip/bzip compression when
 586         creating a dump file or not.
 587         <br /><br />
 588     </dd>
 589
 590     <dt><b>$cfgManualBase</b> string</dt>
 591     <dd>
 592         If set to an URL which points to the MySQL documentation, appropriate
 593         help links are generated.
 594         <br /><br />
 595     </dd>
 596
 597     <dt><b>$cfgDefaultLang </b>string</dt>
 598     <dd>
 599         Defines the default language to use, if not browser-defined or
 600         user-defined.<br />
 601         See the <i>select_lang.inc.php3</i> script to know the valid values for
 602         this setting.
 603         <br /><br />
 604     </dd>
 605
 606     <dt><b>$cfgLang </b>string</dt>
 607     <dd>
 608         Force: always use this language (must be defined in the
 609         <i>select_lang.inc.php3</i> script).
 610         <br /><br />
 611     </dd>
 612
 613     <dt>
 614         <b>$cfgLeftBgColor </b>string [HTML color]
 615         <b>$cfgRightBgColor </b>string [HTML color]
 616     </dt>
 617     <dd>
 618         The background colors (HTML) used for both the frames.
 619         <br /><br />
 620     </dd>
 621
 622     <dt><b>$cfgBorder </b>integer</dt>
 623     <dd>
 624         The size of a table's border.
 625         <br /><br />
 626     </dd>
 627
 628     <dt><b>$cfgThBgcolor </b>string [HTML color]</dt>
 629     <dd>
 630         The color (HTML) used for table headers.
 631         <br /><br />
 632     </dd>
 633
 634     <dt><b>$cfgBgcolorOne </b>string [HTML color]</dt>
 635     <dd>
 636         The color (HTML) #1 for table rows.
 637         <br /><br />
 638     </dd>
 639
 640     <dt><b>$cfgBgcolorTwo </b>string [HTML color]</dt>
 641     <dd>
 642         The color (HTML) #2 for table rows.
 643         <br /><br />
 644     </dd>
 645
 646     <dt>
 647         <b>$cfgTextareaCols </b>integer<br />
 648         <b>$cfgTextareaRows </b>integer
 649     </dt>
 650     <dd>
 651         Number of columns and rows for the textareas.
 652         <br /><br />
 653     </dd>
 654
 655     <dt><b>$cfgLimitChars </b>integer</dt>
 656     <dd>
 657         Maximal number of Chars showed in a <tt>TEXT</tt> OR a <tt>BLOB</tt>
 658         field on browse view. Can be turned off by a toggle button on the
 659         browse page.
 660         <br /><br />
 661     </dd>
 662
 663     <dt>
 664         <b>$cfgModifyDeleteAtLeft </b>boolean<br />
 665         <b>$cfgModifyDeleteAtRight </b>boolean
 666     </dt>
 667     <dd>
 668         Defines the place where modify and delete links would be put when
 669         tables contents are displayed (you may have them displayed both at the
 670         left and at the right).
 671         <br /><br />
 672     </dd>
 673
 674     <dt><b>$cfgLeftWidth </b>integer</dt>
 675     <dd>
 676         Left frame width in pixel.
 677         <br /><br />
 678     </dd>
 679
 680     <dt><b>$cfgColumnTypes </b>array</dt>
 681     <dd>
 682         All possible types of a MySQL column. In most cases you don't need to
 683         edit this.
 684         <br /><br />
 685     </dd>
 686
 687     <dt><b>$cfgAttributeTypes </b>array</dt>
 688     <dd>
 689         Possible attributes for fields. In most cases you don't need to edit
 690         this.
 691     </dd>
 692
 693     <dt><b>$cfgFunctions </b>array</dt>
 694     <dd>
 695         A list of functions MySQL supports. In most cases you don't need to
 696         edit this.
 697         <br /><br />
 698     </dd>
 699 </dl>
 700
 701
 702 <!-- FAQ -->
 703 <a name="faq"></a><br />
 704 <hr noshade="noshade" width="100%" />
 705 <font size="+1">
 706     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
 707     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
 708     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
 709     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
 710     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
 711     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
 712     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
 713     <a class="navigation2" href="#credits">Credits</a>
 714 </font>
 715 <hr noshade="noshade" width="100%" />
 716
 717 <h2>FAQ - Frequently Asked Questions</h2>
 718
 719 <p>
 720     <b>I'm running php 4+ and my server is crashing each time a specific action
 721     is required or phpMyAdmin send a blank page to my browser, what can I
 722     do?</b>
 723     <br />
 724     There is some known php bugs with output buffering and compression.<br />
 725     Try to set the <tt>$cfgOBGzip</tt> directive to <tt>FALSE</tt> in your
 726     <i>config.inc.php or .php3</i> file and the
 727     <tt>zlib.output_compression</tt> directive to <tt>Off</tt> in your php
 728     configuration file.
 729 </p>
 730
 731 <p>
 732     <b>The error message &quot;Warning: Cannot add header information - headers
 733     already sent by ...&quot; is displayed, what's the problem?</b>
 734     <br />
 735     Edit your <i>config.inc.php or .php3</i> file and ensure there is nothing
 736     (ie no blank lines, no spaces, no characters...) neither before the
 737     <tt>&lt;?php</tt> tag at the beginning, neither after the <tt>?&gt;</tt>
 738     tag at the end.
 739 </p>
 740
 741 <p>
 742     <b>I can't insert new rows into a table - MySQL brings up a SQL-error.</b>
 743     <br />
 744     Examine the SQL error with care. I've found that many programmers
 745     specifying a wrong field-type.<br />
 746     Common errors include:
 747 </p>
 748 <ul>
 749     <li>Using <tt>VARCHAR</tt> without a size argument</li>
 750     <li>Using <tt>TEXT or</tt> BLOB with a size argument</li>
 751 </ul>
 752 <p>
 753     Also, look at the syntax chapter in the MySQL manual to confirm that your
 754     syntax is correct.
 755 </p>
 756
 757 <p>
 758     <b>phpMyAdmin can't connect to MySQL. What's wrong?</b>
 759     <br />
 760     Either there is an error with your PHP setup or your username/password is
 761     wrong. Try to make a small script which uses mysql_connect and see if it
 762     works. If it doesn't, it may be you haven't even compiled MySQL support
 763     into PHP.
 764 </p>
 765
 766 <p>
 767     <b>The error message &quot;Warning: MySQL Connection Failed: Can't connect
 768     to local MySQL server through socket '/tmp/mysql.sock' (111)...&quot;) is
 769     displayed. What can I do?</b>
 770     <br />
 771     Here is a fix suggested by Brad Ummer in the
 772     <a class="navigation" href="http://www.phpwizard.net/phorum/list.php?f=1" target="_blank">
 773          phpwizard forum</a>:
 774 </p>
 775 <ul>
 776     <li>
 777         First, you need to determine what socket is being used by MySQL.
 778         <br />
 779         To do this, telnet to your server and go to the MySQL bin directory. In
 780         this directory there should be a file named <i>mysqladmin</i>. Type
 781         <tt>./mysqladmin variables</tt>, and this should give you a bunch of
 782         info about your MySQL server, including the socket
 783         (<i>/tmp/mysql.sock</i>, for example).
 784     </li>
 785     <li>
 786         Then, you need to tell PHP to use this socket.<br />Assuming you are
 787         using PHP 3.0.10 or better, you can specify the socket to use when you
 788         open the connection. To do this in phpMyAdmin, you need to complete the
 789         socket information in the config.inc.php3.<br />
 790         For example:
 791         <tt>$cfgServers[n]['socket']&nbsp;=&nbsp;'/tmp/mysql.sock';</tt>
 792     </li>
 793 </ul>
 794 <p>
 795     Have also a look at the
 796     <a class="navigation" href="http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html" target="_blank">
 797          corresponding section of the MySQL documentation</a>.
 798 </p>
 799
 800 <p>
 801     <b>phpMyAdmin always gives &quot;Access denied&quot; when using advanced
 802     authentication.</b><br />
 803     This could happen for several reasons:
 804 </p>
 805 <ul>
 806     <li>
 807         <tt>$cfgServers[n]['stduser']</tt> and/or
 808         <tt>$cfgServers[n]['stdpass']</tt> are wrong.
 809     </li>
 810     <li>
 811         The username/password you specify in the login-dialog are invalid.
 812     </li>
 813     <li>
 814         You have already setup a security mechanism for the
 815         phpMyAdmin-directory, eg. a .htaccess file. This would interfere with
 816         phpMyAdmin's authentication, so remove it.
 817     </li>
 818 </ul>
 819
 820 <a name="login_bug"></a>
 821 <p>
 822     <b>When using advanced authentication, an user who logged out can not
 823     relogs in with the same nick.</b>
 824     <br />
 825     This is related to the authentication mechanism (protocol) used by
 826     phpMyAdmin. We plan to change it as soon as we may find enough free time
 827     to do it, but you can bypass this problem: just close all the opened
 828     browser windows and then go back to phpMyAdmin. You should be able to
 829     logs in again.
 830 </p>
 831
 832 <p>
 833     <b>I would like to help out with the development of phpMyAdmin. How should
 834     I proceed?</b>
 835     <br />
 836     The following method is preferred for new developers:
 837 </p>
 838 <ul>
 839     <li>
 840         fetch the current CVS tree over anonymous CVS:<br />
 841         <tt>cvs -d:pserver:anonymous@cvs.phpmyadmin.sourceforge.net:/cvsroot/phpmyadmin login</tt><br />
 842         [Password: simply press the Enter key]<br />
 843         <tt>cvs -z3 -d:pserver:anonymous@cvs.phpmyadmin.sourceforge.net:/cvsroot/phpmyadmin checkout phpMyAdmin</tt><br />
 844         [This will create a new sub-directory named phpMyAdmin]
 845     </li>
 846     <li>
 847         add your stuff
 848     </li>
 849     <li>
 850         put the modified files (tar'ed and gzip'ed) inside the patch tracker of
 851         the
 852         <a class="navigation" href="https://sourceforge.net/projects/phpmyadmin/" target="_blank">phpMyAdmin SourceForge account</a>.
 853     </li>
 854 </ul>
 855 <p>
 856     Write access to the CVS tree is granted only to experienced developers who
 857     have already contributed something useful to phpMyAdmin.<br />
 858     Also, have a look at the <a class="navigation" href="#developers">Developers section</a>.
 859 </p>
 860
 861 <p>
 862     <b>What's the preferred way of making phpMyAdmin secure against evil
 863     access?</b>
 864     <br />
 865     This depends on your system.<br />
 866     If you're running a server which cannot be accessed by other people, it's
 867     sufficient to use the directory protection bundled with your webserver
 868     (with Apache you can use <i>.htaccess</i> files, for example).<br />
 869     If other people have telnet access to your server, you should use
 870     phpMyAdmin's advanced authentication feature.
 871     <br /><br />
 872     Suggestions:
 873 </p>
 874 <ul>
 875     <li>
 876         Your <i>config.inc.php3</i> file should be <tt>chmod 660</tt>.
 877     </li>
 878     <li>
 879         All your phpMyAdmin files should be chown phpmy.apache, where phpmy
 880         is a user whose password is only known to you, and apache is the
 881         group under which Apache runs.
 882     </li>
 883     <li>
 884         You should use PHP safe mode, to protect from other users that try
 885         to include your <i>config.inc.php3</i> in their scripts.
 886     </li>
 887 </ul>
 888
 889 <p>
 890     <b>How can I insert a null value into my table?</b>
 891     <br />
 892     Enter &quot;null&quot;, without the quotes, as the field's value. This is
 893     especially useful for <tt>Timestamp</tt> or <tt>AutoIncrement</tt> fields.
 894 </p>
 895
 896 <p>
 897     <b>I'm an ISP. Can I setup one central copy of phpMyAdmin or do I need to
 898     install it for each customer?</b>
 899     <br />
 900     Since version 2.0.3, you can setup a central copy of phpMyAdmin for all
 901     your users. The development of this feature was kindly sponsored by
 902     NetCologne GmbH.
 903     This requires a properly setup MySQL user management and phpMyAdmin
 904     advanced authentication. See the install section on &quot;Using advanced authentication&quot;
 905 </p>
 906
 907 <p>
 908     <b>How can I GZip or Bzip a dump or a CSV export. It seem to not work?</b>
 909     <br />
 910     These features are based on the <tt>gzencode()</tt> and
 911     <tt>bzcompress()</tt> php functions to be more independent of the platform
 912     (Unix/Windows, Safe Mode or not, and so on).
 913     So, you must have PHP4&nbsp;>=&nbsp;4.0.4 and Zlib/Bzip2 support
 914     (<tt>--with-zlib</tt> and <tt>--with-bz2</tt>).
 915 </p>
 916
 917 <p>
 918     <b>I try to insert a text file in a table, and I get: <br />
 919     Error MySQL said: The file '/tmp/phpkvpp60' must be in the database
 920     directory or be readable by all</b>
 921     <br />
 922     Your uploaded file is saved by PHP in the &quot;upload dir&quot;, as
 923     defined in <i>php.ini</i> by the variable <tt>upload_tmp_dir</tt> (usually
 924     the system default is <i>/tmp</i>).
 925     If this directory is not readable by all, the MySQL server (which must be
 926     running on the same machine) cannot open the file (except if running as
 927     root, which is not recommended).
 928     <br />
 929     The system administrator can do a &quot;<tt>chmod 777 /tmp</tt>&quot;: then
 930     the MySQL server will accept to read it.  Also, the user must have
 931     <tt>File</tt> privilege.
 932 </p>
 933
 934 <p>
 935     <b>I'm having troubles when uploading files. In general file uploads don't
 936     work on my system and uploaded files have a <tt>Content-Type:</tt> header
 937     in the first line.</b>
 938     <br />
 939
 940     It's not really phpMyAdmin related but RedHat 7.0. You have a RedHat 7.0
 941     and you updated your php rpm to php-4.0.4pl1-3.i386.rpm, didn't you?
 942     <br />
 943     So the problem is that this package has a serious bug that was corrected
 944     ages ago in php (2001-01-28: see
 945     <a href="http://www.php.net/bugs.php?id=8966">php's bug tracking system</a>
 946     for more details). The problem is that the bugged package is still
 947     available though it was corrected (see
 948     <a href="http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=24933">redhat's bugzilla</a>
 949     for more details).
 950     <br />
 951     So please download
 952     <a href="http://people.redhat.com/nalin/test/php-4.0.4pl1-7.i386.rpm">the fixed package</a>
 953     and the problem should go away.
 954     <br />
 955     And that fixes the \r\n problem with file uploads!
 956 </p>
 957
 958 <p>
 959     <b>When I create a table, I click the Index checkbox for 2 fields and
 960     phpMyAdmin generates only one index with those 2 fields.</b>
 961     <br />
 962     In phpMyAdmin 2.2.0, this is the way to create a multi-fields index. If you
 963     want two indexes, create the first one when creating the table, save, then
 964     display the table properties and click the Index link to create the other
 965     index.
 966 </p>
 967
 968 <p>
 969     <b>I get an out of memory error, and my controls are non-functional, when
 970     trying to create a table with more than 14 fields.</b>
 971     <br />
 972     We could reproduce this problem only under Win98/98SE. Testing under
 973     WinNT4 or Win2K, we could easily create more than 60 fields.
 974     <br />
 975     A workaround is to create a smaller number of fields, then come back to
 976     your table properties and add the other fields.
 977 </p>
 978
 979 <p>
 980     <b>I get errors about not being able to include a file in <i>/lang</i></b>
 981     <br />
 982     Check <i>php.ini</i>, or ask your sysadmin to check it. The
 983     <tt>include_path</tt> must contain &quot;.&quot; somewhere in it, and
 984     <tt>open_basedir</tt>, if used, must contain &quot;.&quot; and
 985     &quot;./lang&quot; to allow normal operation of phpMyAdmin.
 986 </p>
 987
 988 <p>
 989     <b>I have found a bug. How do I inform developers?</b>
 990     <br />
 991     Our Bug Tracker is located at <a href="http://sourceforge.net/projects/phpmyadmin/">
 992         http://sourceforge.net/projects/phpmyadmin/</a> under the Bugs section.
 993     <br /><br />
 994     But please first discuss your bug with other users:
 995     <br />
 996     <a href="http://sourceforge.net/projects/phpmyadmin/">
 997         http://sourceforge.net/projects/phpmyadmin/</a> (and choose Forums)
 998     <br />
 999     <a href="http://www.phpwizard.net/projects/phpMyAdmin/">
1000         http://www.phpwizard.net/projects/phpMyAdmin/</a> (and choose Support
1001     Forum)
1002 </p>
1003
1004
1005 <!-- DEVELOPERS -->
1006 <a name="developers"></a><br />
1007 <hr noshade="noshade" width="100%" />
1008 <font size="+1">
1009     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
1010     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
1011     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
1012     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
1013     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
1014     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
1015     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
1016     <a class="navigation2" href="#credits">Credits</a>
1017 </font>
1018 <hr noshade="noshade" width="100%" />
1019
1020 <h2>Developers Information</h2>
1021
1022 <p>
1023     phpMyAdmin is Open Source, so you're invited to contribute to it. Many
1024     great features have been written by other people and you too can help to
1025     make phpMyAdmin a useful tool.
1026 </p>
1027
1028 <p>
1029     If you're planning to contribute source, please read the following
1030     information:
1031 </p>
1032 <ul>
1033     <li>
1034         All files include <i>header.inc.php3</i> (layout),
1035         <i>libraries/common.lib.php3</i> (common functions) and
1036         <i>config.inc.php3</i>.
1037         <br />
1038         All configuration data belongs in <i>config.inc.php3</i>. Please keep
1039         it free from other code.
1040         <br />
1041         Commonly used functions should be added to
1042         <i>libraries/lib.inc.php3</i> and more specific ones may be added
1043         within a library stored into the <i>libraries</i> sub-directory.
1044     </li>
1045     <li>
1046         Obviously, you're free to use whatever coding style you want. But
1047         please try to keep your code as simple as possible: beginners are
1048         using phpMyAdmin as an example application.<br />
1049         By the way, we're currently updating all the scripts so they will be
1050         XHTML1.0 and CSS2 compliant on one hand, they will fit
1051         <a class="navigation" href="http://pear.php.net/" target="_blank">PEAR coding standards</a>
1052         on the other hand. Please pay attention to this.
1053     </li>
1054     <li>
1055         Please try to keep up the file-naming conventions. Table-related stuff
1056         goes to <i>tbl_*.php3</i>, db-related code to <i>db_*.php3</i> and so
1057         on.
1058     </li>
1059     <li>
1060         Please don't use verbose strings in your code, instead add the string
1061         (at least) to <i>english.inc.php3</i> and print() it out.
1062     </li>
1063     <li>
1064         If you want to be really helpful, write an entry for the ChangeLog.
1065     </li>
1066 </ul>
1067
1068 <p>
1069     IMPORTANT: With 1.4.1, development has switched to CVS. The following
1070     method is preferred for new developers:
1071 </p>
1072 <ul>
1073     <li>
1074         fetch the current CVS tree over anonymous CVS:<br />
1075         <tt>cvs -d:pserver:anonymous@cvs.phpmyadmin.sourceforge.net:/cvsroot/phpmyadmin login</tt><br />
1076         [Password: simply press the Enter key]<br />
1077         <tt>cvs -z3 -d:pserver:anonymous@cvs.phpmyadmin.sourceforge.net:/cvsroot/phpmyadmin checkout phpMyAdmin</tt><br />
1078         [This will create a new sub-directory named phpMyAdmin]
1079     </li>
1080     <li>
1081         add your stuff
1082     </li>
1083     <li>
1084         put the modified files (tar'ed and gzip'ed) inside the patch tracker
1085         of the phpMyAdmin SourceForge account
1086         (<a class="navigation" href="http://sourceforge.net/projects/phpmyadmin/" target="_blank">http://sourceforge.net/projects/phpmyadmin/</a>)
1087     </li>
1088 </ul>
1089 <p>
1090     Write access to the CVS tree is granted only to developers who have already
1091     contributed something useful to phpMyAdmin.  If you're interested in that,
1092     please contact us using the phpmyadmin-devel mailing list.
1093 </p>
1094
1095
1096 <!-- CREDITS -->
1097 <a name="credits"></a><br />
1098 <hr noshade="noshade" width="100%" />
1099 <font size="+1">
1100     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
1101     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
1102     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
1103     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
1104     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
1105     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
1106     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
1107     <a class="navigation2" href="#credits">Credits</a>
1108 </font>
1109 <hr noshade="noshade" width="100%" />
1110
1111 <h2>Credits</h2>
1112
1113 <pre>
1114
1115 phpMyAdmin - Credits
1116 ====================
1117
1118 CREDITS, in chronological order
1119 -------------------------------
1120
1121 [tr] - Tobias Ratschiller &lt;tobias_at_phpwizard.net&gt;
1122         * creator of the phpmyadmin project
1123         * maintainer from 1998 to summer 2000
1124
1125 [md] - Marc Delisle &lt;DelislMa_at_CollegeSherbrooke.qc.ca&gt;
1126         * multi-language version
1127         * various fixes and improvements
1128
1129 [om] - Olivier Müller &lt;om_at_omnis.ch&gt;
1130         * started SourceForge phpMyAdmin project in March 2001
1131         * sync'ed different existing CVS trees with new features and bugfixes
1132         * multi-language improvements, dynamic language selection
1133         * current project maintainer, with Marc and Loic
1134
1135 [lc] - Loïc Chapeaux &lt;lolo_at_phpheaven.net&gt;
1136         * rewrote and optimized javascript, DHTML and DOM stuff
1137         * started to rewrite the scripts so they fit the PEAR coding standards
1138           and generate XHTML1.0 and CSS2 compliant codes
1139         * improved the language detection system
1140         * many bugfixes and improvements
1141
1142 [rj] - Robin Johnson &lt;robbat2_at_users.sourceforge.net&gt;
1143         * database maintence controls
1144         * table type code
1145
1146 [af] - Armel Fauveau &lt;armel.fauveau_at_globalis-ms.com&gt;
1147         * bookmarks feature
1148         * multiple dump feature
1149         * gzip dump feature
1150         * zip dump feature
1151
1152 [gl] - Geert Lund &lt;glund_at_silversoft.dk&gt;
1153         * various fixes
1154         * moderator of the phpMyAdmin users forum at phpwizard.net
1155
1156 [kc] - Korakot Chaovavanich &lt;korakot_at_iname.com&gt;
1157         * &quot;insert as new row&quot; feature
1158
1159 [pk] - Pete Kelly &lt;webmaster_at_trafficg.com&gt;
1160         * rewrote and fix dump code
1161         * bugfixes
1162
1163 [sa] - Steve Alberty &lt;alberty_at_neptunlabs.de&gt;
1164         * rewrote dump code for PHP4
1165         * mySQL table statistics
1166         * bugfixes
1167
1168 [bg] - Benjamin Gandon &lt;gandon_at_isia.cma.fr&gt;
1169         * main author of the version 2.1.0.1
1170         * bugfixes
1171
1172
1173 The following people have contributed minor changes, enhancements, bugfixes or
1174 or support for a new language since version 2.1.0:
1175 Bora Alioglu, Ricardo ?, Sven-Erik Andersen, Alessandro Astarita, Borges Botelho,
1176 Olivier Bussier, Michal Cihar, Neil Darlow, Kristof Hamann, Thomas Kläger,
1177 Lubos Klokner, Martin Marconcini, Girish Nair, David Nordenberg,
1178 Bernard M. Piller, Laurent Haas, &quot;Sakamoto&quot;, www.securereality.com.au,
1179 Michael Tacelosky, Daniel Villanueva, Vinay, Ignacio Vazquez-Abrams,
1180 Chee Wai, Jakub Wilk, Thomas Michael Winningham.
1181
1182
1183 Original Credits of Version 2.1.0
1184 ---------------------------------
1185
1186     This work is based on Peter Kuppelwieser's MySQL-Webadmin. It was his idea
1187     to create a web-based interface to MySQL using PHP3. Although I have not
1188     used any of his source-code, there are some concepts I've borrowed from
1189     him. phpMyAdmin was created because Peter told me he wasn't going to
1190     further develop his (great) tool.
1191     Thanks go to
1192     - Amalesh Kempf &lt;ak-lsml_at_living-source.com&gt; who contributed the
1193       code for the check when dropping a table or database. He also suggested
1194       that you should be able to specify the primary key on tbl_create.php3. To
1195       version 1.1.1 he contributed the ldi_*.php3-set (Import text-files) as
1196       well as a bug-report. Plus many smaller improvements.
1197     - Jan Legenhausen &lt;jan_at_nrw.net&gt;: He made many of the changes that
1198       were introduced in 1.3.0 (including quite significant ones like the
1199       authentication). For 1.4.1 he enhanced the table-dump feature. Plus
1200       bug-fixes and help.
1201     - Marc Delisle &lt;DelislMa_at_CollegeSherbrooke.qc.ca&gt; made phpMyAdmin
1202       language-independent by outsourcing the strings to a separate file. He
1203       also contributed the French translation.
1204     - Alexandr Bravo &lt;abravo_at_hq.admiral.ru&gt; who contributed
1205       tbl_select.php3, a feature to display only some fields from a table.
1206     - Chris Jackson &lt;chrisj_at_ctel.net&gt; added support for MySQL
1207       functions in tbl_change.php3. He also added the
1208       &quot;Query by Example&quot; feature in 2.0.
1209     - Dave Walton &lt;walton_at_nordicdms.com&gt; added support for multiple
1210       servers and is a regular contributor for bug-fixes.
1211     - Gabriel Ash &lt;ga244_at_is8.nyu.edu&gt; contributed the random access
1212       features for 2.0.6.
1213     The following people have contributed minor changes, enhancements, bugfixes
1214     or support for a new language:
1215     Jim Kraai, Jordi Bruguera, Miquel Obrador, Geert Lund, Thomas Kleemann,
1216     Alexander Leidinger, Kiko Albiol, Daniel C. Chao, Pavel Piankov,
1217     Sascha Kettler, Joe Pruett, Renato Lins, Mark Kronsbein, Jannis Hermanns,
1218     G. Wieggers.
1219
1220     And thanks to everyone else who sent me email with suggestions, bug-reports
1221     and or just some feedback.
1222 </pre>
1223
1224
1225
1226 <a name="bottom"></a><br />
1227 <hr noshade="noshade" width="100%" />
1228 <font size="+1">
1229     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
1230     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
1231     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
1232     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
1233     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
1234     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
1235     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
1236     <a class="navigation2" href="#credits">Credits</a>
1237 </font>
1238 <hr noshade="noshade" width="100%" />
1239
1240 <p align="right">
1241     <a href="http://validator.w3.org/check/referer" target="w3c">
1242         <img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" border="0" height="31" width="88" /></a>
1243     &nbsp;&nbsp;&nbsp;&nbsp;
1244     <a href="http://jigsaw.w3.org/css-validator/" target="w3c">
1245         <img src="http://www.w3.org/Icons/valid-css" alt="Valid CSS!" border="0" width="88" height="31" /></a>
1246 </p>
1247
1248 </body>
1249 </html>