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.4 - 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;
  69         color: #000066;
  70         page-break-before: right;
  71     }
  72     -->
  73     </style>
  74 </head>
  75
  76 <body bgcolor="#FFFFFF">
  77 <a name="top"></a>
  78 <h1>phpMyAdmin 2.2.4 Documentation</h1>
  79
  80
  81 <!-- TOP MENU -->
  82 <ul>
  83     <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>
  84     <li><a class="navigation" href="http://phpmyadmin.sourceforge.net/">Sourceforge phpMyAdmin download page  &nbsp;&nbsp;&nbsp;[ http://phpmyadmin.sourceforge.net/ ]</a></li>
  85     <li>Local documents:
  86     <ul>
  87         <li>Version history: <a class="navigation" href="ChangeLog">ChangeLog</a></li>
  88         <li>General notes: <a class="navigation" href="README">README</a></li>
  89         <li>License: <a class="navigation" href="LICENSE">LICENSE</a></li>
  90     </ul>
  91     </li>
  92     <li>Documentation version: <i>$Id$</i></li>
  93 </ul>
  94
  95
  96 <!-- REQUIREMENTS -->
  97 <a name="require"></a><br />
  98 <hr noshade="noshade" width="100%" />
  99 <font size="+1">
 100     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
 101     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
 102     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
 103     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
 104     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
 105     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
 106     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
 107     <a class="navigation2" href="#credits">Credits</a>
 108 </font>
 109 <hr noshade="noshade" width="100%" />
 110
 111 <h2>Requirements</h2>
 112
 113 <ul>
 114     <li>
 115         PHP3 or PHP4: phpMyAdmin widely uses the 'str_replace()' php function
 116         that was added in PHP&nbsp;3.0.6, but was buggy up until
 117         PHP&nbsp;3.0.8.
 118         Then <font color="#bb0000">you should not run this script with
 119         PHP3&nbsp;&lt;&nbsp;3.0.8</font>.<br />
 120         PHP also needs to be <font color="#bb0000">compiled with MySQL support</font>;
 121     </li>
 122     <li>
 123         MySQL (tested with 3.21.x, 3.22.x and 3.23.x);
 124     </li>
 125     <li>
 126         a web-browser (doh!).
 127     </li>
 128 </ul>
 129
 130
 131 <!-- INTRODUCTION -->
 132 <a name="intro"></a><br />
 133 <hr noshade="noshade" width="100%" />
 134 <font size="+1">
 135     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
 136     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
 137     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
 138     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
 139     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
 140     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
 141     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
 142     <a class="navigation2" href="#credits">Credits</a>
 143 </font>
 144 <hr noshade="noshade" width="100%" />
 145
 146 <h2>Introduction</h2>
 147
 148 <p>
 149     phpMyAdmin can manage a whole MySQL-server (needs a super-user)
 150     but also a single database. To accomplish the latter you'll need
 151     a properly set up MySQL-user who can read/write only the desired
 152     database. It's up to you to look up the appropriate part in the
 153     MySQL manual. Currently phpMyAdmin can:
 154 </p>
 155
 156 <ul>
 157     <li>create and drop databases</li>
 158     <li>create, copy, drop and alter tables</li>
 159     <li>delete, edit and add fields</li>
 160     <li>execute any SQL-statement, even batch-queries</li>
 161     <li>manage keys on fields</li>
 162     <li>load text files into tables</li>
 163     <li>create (*) and read dumps of tables</li>
 164     <li>export (*) and import data to CSV values</li>
 165     <li>administer multiple servers and single databases</li>
 166     <li>communicate in more than 20 different languages</li>
 167 </ul>
 168
 169 <table border="0" cellspacing="0" cellpadding="0">
 170 <tr>
 171     <td valign="top">(*)&nbsp;</td>
 172     <td>
 173         phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2 formats) dumps
 174         and CSV exports if you use PHP4&nbsp;>=&nbsp;4.0.4 with Zlib support
 175         (<tt>--with-zlib</tt>) and/or Bzip2 support (<tt>--with-bz2</tt>).
 176     </td>
 177 </tr>
 178 </table>
 179
 180
 181 <!-- INSTALLATION -->
 182 <a name="setup"></a><br />
 183 <hr noshade="noshade" width="100%" />
 184 <font size="+1">
 185     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
 186     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
 187     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
 188     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
 189     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
 190     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
 191     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
 192     <a class="navigation2" href="#credits">Credits</a>
 193 </font>
 194 <hr noshade="noshade" width="100%" />
 195
 196 <h2>Installation</h2>
 197
 198 <p>
 199     <font color="#bb0000">NOTE: phpMyAdmin does not apply any special security
 200     methods to the MySQL database server. It is still the sysadmin's job to
 201     grant permissions on the MySQL databases properly.</font>
 202 </p>
 203
 204 <p>
 205     <font color="#bb0000">Warning for Mac users:</font> php seems not to like
 206     Mac end of lines character (&quot;<tt>\r</tt>&quot;) and Stuffit unstuffs
 207     with Mac formats, of course.<br />
 208     So you'll have to resave as in Bbedit to unix style ALL phpMyAdmin scripts
 209     before uploading them to your server.
 210 </p>
 211
 212 <p><b>Quick Install:</b></p>
 213 <ol>
 214     <li> Untar or unzip the distribution (be sure to unzip the subdirectories):
 215          <tt>tar xzvf phpMyAdmin_x.x.x.tar.gz</tt> in your webserver's
 216          document root.</li>
 217     <li> Open the file config.inc.php3 in your favourite editor and change
 218          the values for host, user, password and authentication mode to fit
 219          your environment.
 220          Also insert the correct value for <tt>$cfgPmaAbsoluteUri</tt>.
 221          Have a look at
 222          <a class="navigation" href="#config">Configuration section</a> for an
 223          explanation of all values.</li>
 224     <li> It is recommended that you protect the directory in which you
 225          installed phpMyAdmin (unless it's on a closed intranet, or you wish to
 226          use http or cookie authentication), for example with HTTP-AUTH (in a
 227          <i>.htaccess</i> file). See the
 228          <a class="navigation" href="#faq">FAQ section</a> for additional
 229          information.</li>
 230     <li> Open the file
 231          <i>&lt;www.your-host.com&gt;/&lt;your-install-dir&gt;/index.php3</i>
 232          in your browser. phpMyAdmin should now display a welcome screen
 233          and your databases, or a login dialog if using http or cookie
 234          authentication mode.</li>
 235 </ol>
 236
 237 <p><b>Upgrading from an older version:</b></p>
 238 <ul>
 239     <li>Please do not copy your older config.inc.php3 over the new one: it may
 240         offer new configuration variables, and the new version may depend on
 241         these for normal behavior.  It is suggested instead to insert your site
 242         values in the new one.</li>
 243 </ul>
 244
 245 <p><b>Using authentication modes:</b></p>
 246 <ul>
 247     <li>Http and cookie authentication modes are recommended in a multi-user
 248         environment where you want to give users access to their own database
 249         and don't want them to play around with others.<br /><br /></li>
 250
 251     <li>Http and cookie authentication modes are secure: the MySQL password
 252         does not need to be set in the phpMyAdmin configuration file. (except
 253         for the &quot;standard user&quot; -see the Configuration section-).
 254         <br />
 255         In cookie mode, we send the password in a temporary cookie, so most
 256         browsers should not store the password in their cookie file.
 257         <br /><br /></li>
 258
 259     <li>
 260         For 'http' and 'cookie' modes, phpMyAdmin needs a stduser that has
 261         <b>only</b> the <tt>SELECT</tt> privilege on the <i>mysql.user (all
 262         columns except &quot;Password&quot;)</i>, <i>mysql.db (all columns)</i>
 263         &amp; <i>mysql.tables_priv (all columns except &quot;Grantor&quot;
 264         &amp; &quot;Timestamp&quot;) </i>tables.<br />
 265         You must specify the details for the stduser in the
 266         <i>config.inc.php3</i> file under the
 267         <tt>$cfgServers[n]['stduser']</tt> &amp;
 268         <tt>$cfgServers[n]['stdpass']</tt> settings.<br />
 269         To create the control account (<tt>&lt;stduser&gt;</tt> and
 270         <tt>&lt;stdpass&gt;</tt> have to be replaced by your own values, of
 271         course):<br />
 272         <table border="0">
 273         <tr>
 274             <td>&nbsp;&nbsp;&nbsp;</td>
 275             <td>
 276                 <tt>GRANT USAGE ON mysql.* TO '&lt;stduser&gt;'@'localhost' IDENTIFIED BY '&lt;stdpass&gt;';</tt><br />
 277                 <tt>GRANT SELECT (Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) ON mysql.user TO '&lt;stduser&gt;'@'localhost';</tt><br />
 278                 <tt>GRANT SELECT ON mysql.db TO '&lt;stduser&gt;'@'localhost';</tt><br />
 279                 <tt>GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO '&lt;stduser&gt;'@'localhost';</tt>
 280             </td>
 281         </tr>
 282         <tr>
 283             <td colspan="2">
 284                 ... and if you want to use the bookmark feature:
 285             </td>
 286         </tr>
 287         <tr>
 288             <td>&nbsp;&nbsp;&nbsp;</td>
 289             <td>
 290                 <tt>GRANT SELECT, INSERT, DELETE ON &lt;bookmark_db&gt;.&lt;bookmark_table&gt; TO '&lt;stduser&gt;'@'localhost';</tt>
 291             </td>
 292         </tr>
 293         </table>
 294         <br />
 295     </li>
 296     <li>
 297         Then each of the <i>true</i> users should be granted of a set of
 298         privileges on a set of perticular databases but shouldn't have any
 299         global privileges. For example, to grant the user <i>real_user</i> with
 300         all privileges on the database <i>user_base</i>:<br />
 301         &nbsp;&nbsp;&nbsp;<tt>GRANT ALL PRIVILEGES ON user_base.* TO 'real_user'@localhost IDENTIFIED BY 'real_password';</tt>
 302         <br />
 303         What the user may now do is controlled entirely by the MySQL user
 304         management system.<br />
 305         With http or cookie auth mode, you don't need to fill the user/password
 306         fields inside the <tt>$cfgServers</tt> array.<br />
 307     </li>
 308 </ul>
 309
 310 <p><b>'http' authentication mode:</b></p>
 311 <ul>
 312     <li>Was called 'advanced' in versions before 2.2.3.</li>
 313     <li>Introduced in 1.3.0, it uses Basic HTTP authentication method and
 314         allows you to login as any valid MySQL user.</li>
 315     <li>Is only supported with PHP running as an Apache module, not with cgi.</li>
 316 </ul>
 317
 318 <p><b>'cookie' authentication mode:</b></p>
 319 <ul>
 320     <li>You can use this method as a replacement for the http
 321         authentication (for example, if you're running IIS).
 322     </li>
 323     <li>Obviously, the user must enable cookies in the browser.</li>
 324     <li>With this mode, the use can truly logout of phpMyAdmin and login back
 325         with the same username.</li>
 326 </ul>
 327
 328 <p><b>'config' authentication mode:</b></p>
 329 <ul>
 330     <li>This mode is the less secure one because it requires you to fill the
 331         <tt>$cfgServers[n]['user']</tt> and <tt>$cfgServers[n]['password']</tt>
 332         fields.<br />
 333         But usually you don't need to setup a &quot;standard user&quot; here:
 334         using the <tt>$cfgServers[n]['only_db']</tt> might be enough.<br />
 335         In the ISP FAQ section, there is an entry explaining how to protect
 336         your configuration file.<br /></li>
 337 </ul>
 338
 339
 340 <!-- CONFIGURATION -->
 341 <a name="config"></a><br />
 342 <hr noshade="noshade" width="100%" />
 343 <font size="+1">
 344     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
 345     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
 346     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
 347     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
 348     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
 349     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
 350     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
 351     <a class="navigation2" href="#credits">Credits</a>
 352 </font>
 353 <hr noshade="noshade" width="100%" />
 354
 355 <h2>Configuration</h2>
 356
 357 <p>
 358     <font color="#bb0000">Warning for Mac users:</font> php seems not to like
 359     Mac end of lines character (&quot;<tt>\r</tt>&quot;). So ensure you choose
 360     the option that allows to use the *nix end of line character
 361     (&quot;<tt>\n</tt>&quot;) in your text editor before registering a script
 362     you have modified.
 363 </p>
 364
 365 <p>All configurable data is placed in <i>config.inc.php3</i>.</p>
 366 <dl>
 367     <dt><b>$cfgPmaAbsoluteUri</b> string</dt>
 368     <dd>
 369         Sets here the complete url (with full path) to your phpMyAdmin version.
 370         E.g. <tt>http://www.your_web.net/path_to_your_phpMyAdmin_directory/</tt>.
 371         <br />
 372         Don't forget the slash at the end of your url.
 373         <br /><br />
 374     </dd>
 375
 376     <dt><b>$cfgServers</b> array</dt>
 377     <dd>
 378         Since version 1.4.2, phpMyAdmin supports the administration of multiple
 379         MySQL servers.
 380         Therefore, a $cfgServers-array has been added which contains the login
 381         information for the different servers. <tt>$cfgServers[1]['host']</tt>
 382         contains the hostname of the first server,
 383         <tt>$cfgServers[2]['host']</tt> the hostname of the second server, etc.
 384         If you have only one server to administer, simply leave free the
 385         hostname of the other $cfgServer-entries.
 386         <br /><br />
 387     </dd>
 388
 389     <dt><b>$cfgServers[n]['host']</b> string</dt>
 390     <dd>
 391         The hostname of your n-th MySQL-server. E.g. localhost.
 392         <br /><br />
 393     </dd>
 394
 395     <dt><b>$cfgServers[n]['port']</b> string</dt>
 396     <dd>
 397         The port-number of your n-th MySQL-server. Default is 3306 (leave
 398         blank).
 399         <br /><br />
 400     </dd>
 401
 402     <dt><b>$cfgServers[n]['socket']</b> string</dt>
 403     <dd>
 404         The path to the socket to use. Leave blank for default.<br />
 405         To use the socket feature you must run php 3.0.10 or more.
 406         <br /><br />
 407     </dd>
 408
 409     <dt><b>$cfgServers[n]['connect_type']</b> string</dt>
 410     <dd>
 411         What type connection to use with the MySQL server. Your options are
 412         'socket' &amp; 'tcp'. It defaults to 'tcp' as that is nearly guarenteed
 413         to be available on all MySQL servers, while sockets are not supported
 414         on some platforms.
 415         <br /><br />
 416     </dd>
 417
 418     <dt>
 419         <b>$cfgServers[n]['stduser']</b> string<br />
 420         <b>$cfgServers[n]['stdpass']</b> string
 421     </dt>
 422     <dd>
 423         When using http or cookie authentication modes (or 'config'
 424         authentication mode since phpMyAdmin 2.2.1), you need to supply the
 425         details of a MySQL account that has <tt>SELECT</tt> privilege on the
 426         <i>mysql.user (all columns except &quot;Password&quot;)</i>,
 427         <i>mysql.db (all columns)</i> &amp; <i>mysql.tables_priv (all columns
 428         except &quot;Grantor&quot; &amp; &quot;Timestamp&quot;) </i>tables.
 429         This account is used to check what databases the user will see at
 430         login.<br />
 431         Please see the <a class="navigation" href="#setup">install section</a>
 432         on &quot;Using http authentication&quot; for more information.
 433         <br /><br />
 434         Note that if you try login to phpMyAdmin with this &quot;stduser&quot;,
 435         you could get some errors, depending the exact privileges you gave to
 436         the &quot;stduser&quot;. phpMyAdmin does not support a direct login
 437         with the &quot;stduser&quot;.
 438         <br /><br />
 439     </dd>
 440
 441     <dt><b>$cfgServers[n]['auth_type']</b> string <tt>['http'|'cookie'|'config']</tt> </dt>
 442     <dd>
 443         Whether config or cookie or http authentication should be used for this
 444         server.
 445
 446         <ul>
 447             <li>
 448                 'config' authentication
 449                 (<tt>$auth_type&nbsp;=&nbsp;'config'</tt>) is the plain old
 450                 way: username and password are stored in
 451                 <i>config.inc.php3</i>.
 452             </li>
 453             <li>
 454                 'cookie' authentication mode
 455                 (<tt>$auth_type&nbsp;=&nbsp;'cookie'</tt>) as introduced in
 456                 2.2.3 allows you to log in as any valid MySQL user with the
 457                 help of... cookies. Log name and password are stored in
 458                 cookies during the session and password is deleted when it
 459                 ends.
 460             </li>
 461             <li>
 462                 'http' authentication (was called 'advanced' in older versions)
 463                 (<tt>$auth_type&nbsp;=&nbsp;'http'</tt>) as introduced in 1.3.0
 464                 allows you to log in as any valid MySQL user via HTTP-Auth.
 465             </li>
 466         </ul><br />
 467
 468         Please see the install section on &quot;Using authentication modes&quot;
 469         for more information.
 470         <br /><br />
 471     </dd>
 472
 473     <dt>
 474         <b>$cfgServers[n]['user']</b> string<br />
 475         <b>$cfgServers[n]['password']</b> string
 476     </dt>
 477     <dd>
 478         The user/password-pair which phpMyAdmin will use to connect to this
 479         MySQL-server. The password is not needed when http or cookie
 480         authentication is used, and should be empty.<br /><br />
 481     </dd>
 482
 483     <dt><b>$cfgServers[n]['only_db']</b> string or array</dt>
 484     <dd>
 485         If set to a(an array of) database name(s), only this(these) database(s)
 486         will be shown to the user. Since phpMyAdmin 2.2.1, this/these
 487         database(s) name(s) may contain MySQL wilcards characters
 488         (&quot;_&quot; and &quot;%&quot;): if you want to use literal instances
 489         of these characters, escape them (ie use <tt>'my\_db'</tt> and not
 490         <tt>'my_db'</tt>).<br />
 491         This setting is an efficient way to lower the server charge since the
 492         latter does not need to send MySQL requests to build the available
 493         database list. But <font color="#bb0000">it does not replace the
 494         privileges rules of the MySQL database server</font>. If set, it just
 495         means only these databases will be displayed but
 496         <font color="#bb0000">not at all other databases can't be used.</font>
 497         <br /><br />
 498     </dd>
 499
 500     <dt><b>$cfgServers[n]['verbose']</b> string</dt>
 501     <dd>
 502         Only useful when using phpMyAdmin with multiple server entries. If set,
 503         this string will be displayed instead of the hostname in the pulldown
 504         menu on the main page. This can be useful if you want to show only
 505         certain databases on your system, for example.
 506         <br /><br />
 507     </dd>
 508
 509     <dt>
 510         <b>$cfgServers[n]['bookmarkdb']</b> string<br />
 511         <b>$cfgServers[n]['bookmarktable']</b> string
 512     </dt>
 513     <dd>
 514         Since release 2.2.0 phpMyAdmin allows to bookmark queries. This can be
 515         useful for queries you often run.<br /><br />
 516
 517         To use this functionality you have to:
 518         <ul>
 519             <li>
 520                 create a table following this scheme:<br />
 521                 <tt>
 522                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CREATE TABLE bookmark (<br />
 523                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id int(11) DEFAULT '0' NOT NULL auto_increment,<br />
 524                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbase varchar(255) NOT NULL,<br />
 525                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;user varchar(255) NOT NULL,<br />
 526                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;label varchar(255) NOT NULL,<br />
 527                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;query text NOT NULL,<br />
 528                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PRIMARY KEY (id)<br />
 529                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);
 530                 </tt>
 531             </li>
 532             <li>
 533                 then complete the two variables
 534                 <tt>$cfgServers[n]['bookmarkdb']</tt> and
 535                 <tt>$cfgServers[n]['bookmarktable']</tt> with the database and
 536                 table names you've choosen so phpMyAdmin will be able to find
 537                 the bookmarks.
 538             </li>
 539         </ul><br />
 540
 541         Note that <tt>stduser</tt> must have <tt>SELECT</tt>, <tt>INSERT</tt>
 542         and <tt>DELETE</tt> privileges on the bookmark table.
 543         Here is a query to set up those privileges:<br />
 544         <tt>GRANT SELECT,INSERT,DELETE ON &lt;bookmarkdb&gt;.&lt;bookmarktable&gt; to 'stduser'@localhost;</tt>
 545         <br /><br />
 546     </dd>
 547
 548     <dt>
 549         <b>$cfgServers[n]['relation']</b> string
 550     </dt>
 551     <dd>
 552         Since release 2.2.4 you can describe in a relation table which field
 553         is a key in another table. phpMyAdmin currently uses this to make
 554         clickable the data values that point to another table.
 555         <br /><br />
 556
 557         Currently, the keys must be numeric, and you must be running PHP 4.
 558         <br /><br />
 559
 560         To use this functionality you have to:
 561         <ul>
 562             <li>
 563                 create in the same database a table (for example 'relation')
 564                 following this scheme:<br />
 565                 <tt>
 566                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CREATE TABLE `relation` (<br />
 567                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`src_table` varchar(32) NOT NULL default '',<br />
 568                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`src_column` varchar(32) NOT NULL default '',<br />
 569                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`dest_table` varchar(32) NOT NULL default '',<br />
 570                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`dest_column` varchar(32) NOT NULL default '',<br />
 571                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PRIMARY KEY  (`src_table`,`src_column`)<br />
 572                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;) TYPE=MyISAM COMMENT='Table Relation';<br />
 573                 </tt>
 574             </li>
 575             <li>
 576                 put the relation table name in
 577                 <tt>$cfgServers[n]['relation']</tt>
 578             </li>
 579             <li>
 580                 then manually fill the relation table with information about
 581                 the keys.
 582             </li>
 583         </ul><br />
 584     </dd>
 585
 586     <dt><b>$cfgServerDefault</b> integer</dt>
 587     <dd>
 588         If you have more than one server configured, you can set
 589         <tt>$cfgServerDefault</tt> to any one of them to autoconnect to that
 590         server when phpMyAdmin is started, or set it to 0 to be given a list of
 591         servers without logging in.<br />
 592         If you have only one server configured, <tt>$cfgServerDefault</tt> MUST
 593         be set to that server.
 594         <br /><br />
 595     </dd>
 596
 597     <dt><b>$cfgOBGzip </b>boolean</dt>
 598     <dd>
 599         Defines whether to use gzip output buffering for increased
 600         speed in HTTP transfers.
 601         <br /><br />
 602     </dd>
 603
 604     <dt><b>$cfgPersistentConnections </b>boolean</dt>
 605     <dd>
 606         Whether persistent connections should be used or not (mysql_connect or
 607         mysql_pconnect).
 608         <br /><br />
 609     </dd>
 610
 611     <dt><b>$cfgExecTimeLimit </b>integer [number of seconds]</dt>
 612     <dd>
 613         Set the number of seconds a script is allowed to run. If seconds is set
 614         to zero, no time limit is imposed.<br />
 615         This setting is used while importing/exporting dump files but has no
 616         effect when PHP is running in safe mode.
 617         <br /><br />
 618     </dd>
 619
 620     <dt><b>$cfgSkipLockedTables </b>boolean</dt>
 621     <dd>
 622         Mark used tables and make it possible to show databases with locked
 623         tables (since 3.23.30).
 624         <br /><br />
 625     </dd>
 626
 627     <dt><b>$cfgShowSQL </b>boolean</dt>
 628     <dd>
 629         Defines whether sql-queries generated by phpMyAdmin should be displayed
 630         or not.
 631         <br /><br />
 632     </dd>
 633
 634     <dt><b>$cfgAllowUserDropDatabase </b>boolean</dt>
 635     <dd>
 636         Defines whether standard users (non administrator) are allowed to
 637         delete their own database or not. If set as FALSE, the link &quot;Drop
 638         Database&quot; will not be shown, and even a &quot;DROP DATABASE
 639         mydatabase&quot; will be rejected. Quite practical for ISP's with many
 640         customers.
 641         <br /><br />
 642      </dd>
 643
 644     <dt><b>$cfgConfirm </b>boolean</dt>
 645     <dd>
 646         Whether a warning (&quot;Are your really sure..&quot;) should be
 647         displayed when you're about to loose data.
 648         <br /><br />
 649     </dd>
 650
 651     <dt><b>$cfgShowTooltip </b>boolean</dt>
 652     <dd>
 653         Defines whether to display table comment as tooltip in left frame or
 654         not.
 655         <br /><br />
 656     </dd>
 657
 658     <dt><b>$cfgLeftFrameLight</b> boolean</dt>
 659     <dd>
 660         Defines whether to use select-based menu and display only the current
 661         tables in the left frame (smaller page).
 662         <br /><br />
 663     </dd>
 664
 665     <dt>
 666         <b>$cfgShowMysqlInfo </b>boolean<br />
 667         <b>$cfgShowMysqlVars </b>boolean<br />
 668         <b>$cfgShowPhpInfo </b>boolean
 669     </dt>
 670     <dd>
 671         Defines whether to display the &quot;MySQL runtime information&quot;,
 672         &quot;MySQL system variables&quot; and &quot;PHP information&quot;
 673         links or not for simple users at the starting main (right) frame.
 674         This setting does not check MySQL commands entered directly.
 675         <br /><br />
 676
 677         Please note that to block the usage of phpinfo() in scripts, you
 678         have to put this in your php.ini:<br />
 679         <tt>disable_functions = phpinfo()</tt>
 680         <br /><br />
 681     </dd>
 682
 683     <dt><b>$cfgLoginCookieRecall </b>boolean</dt>
 684     <dd>
 685         Define whether the previous login should be recalled or not in cookie
 686         authentication mode.
 687         <br /><br />
 688     </dd>
 689
 690     <dt><b>$cfgShowStats </b>boolean</dt>
 691     <dd>
 692         Defines whether to display space usage and statistics about databases
 693         and tables or not.<br />
 694         Note that statistics requires at least MySQL 3.23.3 and that, at this
 695         date, MySQL doesn't return such information for Berkeley DB tables.
 696         <br /><br />
 697     </dd>
 698
 699     <dt><b>$cfgShowBlob </b>boolean</dt>
 700     <dd>
 701         Defines whether <tt>BLOB</tt> fields are shown when browsing a table's
 702         content or not.
 703         <br /><br />
 704     </dd>
 705
 706     <dt><b>$cfgNavigationBarIconic </b>boolean</dt>
 707     <dd>
 708         Defines whether navigation bar buttons contain text or symbols only.
 709         <br /><br />
 710     </dd>
 711
 712     <dt><b>$cfgShowAll </b>boolean</dt>
 713     <dd>
 714         Defines whether an user should be displayed a
 715         &quot;show all (records)&quot; button in browse mode or not.
 716         <br /><br />
 717     </dd>
 718
 719     <dt><b>$cfgMaxRows </b>integer</dt>
 720     <dd>
 721         Number of rows displayed when browsing a resultset. If the resultset
 722         contains more rows, Previous/Next links will be shown.
 723         <br /><br />
 724     </dd>
 725
 726     <dt><b>$cfgOrder </b>string [<tt>DESC</tt>|<tt>ASC</tt>|<tt>SMART</tt>]</dt>
 727     <dd>
 728         Defines whether fields are displayed in ascending (<tt>ASC</tt>) order,
 729         in descending (<tt>DESC</tt>) order or in a &quot;smart&quot;
 730         (<tt>SMART</tt>) order -ie descending order for fields of type TIME,
 731         DATE, DATETIME &amp; TIMESTAMP, ascending order else- by default.
 732         <br /><br />
 733     </dd>
 734
 735     <dt><b>$cfgProtectBinary </b>boolean or string</dt>
 736     <dd>
 737         Defines whether <tt>BLOB</tt> or <tt>BINARY</tt> fields are protected
 738         from edition when browsing a table's content or not.
 739         Valid values are:<br />
 740         - <tt>FALSE</tt> to allow edition of all fields;<br />
 741         - <tt>blob</tt> to allow edition of all fields except <tt>BLOBS</tt>;<br />
 742         - <tt>all</tt> to disallow edition of all <tt>BINARY</tt> or <tt>BLOB</tt> fields.
 743         <br /><br />
 744     </dd>
 745
 746     <dt><b>$cfgShowFunctionFields </b>boolean</dt>
 747     <dd>
 748         Defines whether MySQL functions fields should be displayed or not in edit/insert
 749         mode.
 750         <br /><br />
 751     </dd>
 752
 753     <dt>
 754         <b>$cfgZipDump </b>boolean<br />
 755         <b>$cfgGZipDump </b>boolean<br />
 756         <b>$cfgBZipDump </b>boolean
 757     </dt>
 758     <dd>
 759         Defines whether to allow the use of zip/gzip/bzip compression when
 760         creating a dump file or not.
 761         <br /><br />
 762     </dd>
 763
 764     <dt><b>$cfgManualBaseShort</b> string</dt>
 765     <dd>
 766         If set to an URL which points to the MySQL documentation (on short
 767         pages), appropriate help links are generated.
 768         <br /><br />
 769     </dd>
 770
 771     <dt><b>$cfgDefaultLang </b>string</dt>
 772     <dd>
 773         Defines the default language to use, if not browser-defined or
 774         user-defined.<br />
 775         See the <i>select_lang.inc.php3</i> script to know the valid values for
 776         this setting.
 777         <br /><br />
 778     </dd>
 779
 780     <dt><b>$cfgLang </b>string</dt>
 781     <dd>
 782         Force: always use this language (must be defined in the
 783         <i>select_lang.inc.php3</i> script).
 784         <br /><br />
 785     </dd>
 786
 787     <dt><b>$cfgLeftWidth </b>integer</dt>
 788     <dd>
 789         Left frame width in pixel.
 790         <br /><br />
 791     </dd>
 792
 793     <dt>
 794         <b>$cfgLeftBgColor </b>string [HTML color]<br />
 795         <b>$cfgRightBgColor </b>string [HTML color]
 796     </dt>
 797     <dd>
 798         The background colors (HTML) used for both the frames.
 799         <br /><br />
 800     </dd>
 801
 802     <dt><b>$cfgLeftPointerColor </b>string [HTML color]</dt>
 803     <dd>
 804         The color (HTML) used for the pointer in the left frame (does not work
 805         with NS4).
 806         <br /><br />
 807     </dd>
 808
 809     <dt><b>$cfgBorder </b>integer</dt>
 810     <dd>
 811         The size of a table's border.
 812         <br /><br />
 813     </dd>
 814
 815     <dt><b>$cfgThBgcolor </b>string [HTML color]</dt>
 816     <dd>
 817         The color (HTML) used for table headers.
 818         <br /><br />
 819     </dd>
 820
 821     <dt><b>$cfgBgcolorOne </b>string [HTML color]</dt>
 822     <dd>
 823         The color (HTML) #1 for table rows.
 824         <br /><br />
 825     </dd>
 826
 827     <dt><b>$cfgBgcolorTwo </b>string [HTML color]</dt>
 828     <dd>
 829         The color (HTML) #2 for table rows.
 830         <br /><br />
 831     </dd>
 832
 833     <dt><b>$cfgBrowsePointerColor </b>string [HTML color]</dt>
 834     <dd>
 835         The color (HTML) used for the pointer in browse mode (does not work
 836         with NS4).
 837         <br /><br />
 838     </dd>
 839
 840     <dt><b>$cfgBrowseMarkRow </b>boolean</dt>
 841     <dd>
 842         If the value is 1, you can visually mark rows with the color in
 843         <tt>$cfgBrowsePointerColor</tt>, by clicking on them. Works on browsers
 844         that support 'onmousedown'.
 845         <br /><br />
 846     </dd>
 847
 848     <dt>
 849         <b>$cfgTextareaCols </b>integer<br />
 850         <b>$cfgTextareaRows </b>integer
 851     </dt>
 852     <dd>
 853         Number of columns and rows for the textareas.
 854         <br /><br />
 855     </dd>
 856
 857     <dt><b>$cfgLimitChars </b>integer</dt>
 858     <dd>
 859         Maximal number of Chars showed in a <tt>TEXT</tt> OR a <tt>BLOB</tt>
 860         field on browse view. Can be turned off by a toggle button on the
 861         browse page.
 862         <br /><br />
 863     </dd>
 864
 865     <dt>
 866         <b>$cfgModifyDeleteAtLeft </b>boolean<br />
 867         <b>$cfgModifyDeleteAtRight </b>boolean
 868     </dt>
 869     <dd>
 870         Defines the place where modify and delete links would be put when
 871         tables contents are displayed (you may have them displayed both at the
 872         left and at the right).
 873         &quot;Left&quot; and &quot;right&quot; are parsed as &quot;top&quot;
 874         and &quot;bottom&quot; with vertical display mode.
 875         <br /><br />
 876     </dd>
 877
 878     <dt><b>$cfgDefaultDisplay </b>string</dt>
 879     <dd>
 880         There are 2 display modes: horizontal and vertical. Define which one is
 881         displayed by default.
 882         <br /><br />
 883     </dd>
 884
 885     <dt><b>$cfgRepeatCells </b>integer</dt>
 886     <dd>
 887         Repeat the headers every X cells, or 0 to deactivate.
 888         <br /><br />
 889     </dd>
 890
 891     <dt><b>$cfgColumnTypes </b>array</dt>
 892     <dd>
 893         All possible types of a MySQL column. In most cases you don't need to
 894         edit this.
 895         <br /><br />
 896     </dd>
 897
 898     <dt><b>$cfgAttributeTypes </b>array</dt>
 899     <dd>
 900         Possible attributes for fields. In most cases you don't need to edit
 901         this.
 902     </dd>
 903
 904     <dt><b>$cfgFunctions </b>array</dt>
 905     <dd>
 906         A list of functions MySQL supports. In most cases you don't need to
 907         edit this.
 908         <br /><br />
 909     </dd>
 910 </dl>
 911
 912
 913 <!-- FAQ -->
 914 <a name="faq"></a><br />
 915 <hr noshade="noshade" width="100%" />
 916 <font size="+1">
 917     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
 918     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
 919     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
 920     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
 921     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
 922     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
 923     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
 924     <a class="navigation2" href="#credits">Credits</a>
 925 </font>
 926 <hr noshade="noshade" width="100%" />
 927
 928 <h2>FAQ - Frequently Asked Questions</h2>
 929
 930 <h3>[Server]</h3>
 931 <p>
 932     <b>I'm running php 4+ and my server is crashing each time a specific action
 933     is required or phpMyAdmin sends a blank page or a page full of cryptic
 934     characters to my browser, what can I do?</b>
 935     <br />
 936     There are some known php bugs with output buffering and compression.<br />
 937     Try to set the <tt>$cfgOBGzip</tt> directive to <tt>FALSE</tt> in your
 938     <i>config.inc.php or .php3</i> file and the
 939     <tt>zlib.output_compression</tt> directive to <tt>Off</tt> in your php
 940     configuration file.
 941 </p>
 942
 943 <p>
 944     <b>My Apache server crashes when using phpMyAdmin.</b>
 945     <br />
 946     You should first try the latest versions of Apache (and possibly MySQL).
 947     <br />
 948     See also the other FAQ entry about php bugs with output buffering.
 949     <br />
 950     If your server keeps crashing, please ask for help in the various
 951     Apache support groups.
 952 </p>
 953
 954 <p>
 955     <b>Using phpMyAdmin on IIS, I'm displayed the error message: &quot;The
 956        specified CGI application misbehaved by not returning a complete set of
 957        HTTP headers....&quot;</b>
 958     <br />
 959     You just forgot to read the <i>install.txt</i> file from the php
 960     distribution. Have a look at the last message in this
 961     <a href="http://bugs.php.net/bug.php?id=12061">bug report</a> from the
 962     official php bug database.
 963 </p>
 964
 965 <p>
 966     <b>Using phpMyAdmin on IIS, I'm facing crashes and/or many error messages
 967        with the http or advanced authentication mode.</b>
 968     <br />
 969     This is a known problem with the php ISAPI filter: it's not so stable. For
 970     some more information and complete testings see the messages posted by
 971     André B. aka &quot;djdeluxe76&quot; in
 972     <a href="http://www.phpwizard.net/phorum/read.php?f=1&amp;i=6624&amp;t=6300">this&nbsp;thread</a>
 973     from the phpWizard forum.<br />
 974     Please use instead the cookie authentication mode.
 975 </p>
 976
 977 <p>
 978     <b>I can't use phpMyAdmin on PWS: nothing is displayed!</b>
 979     <br />
 980     This seems to be a PWS bug. Filippo Simoncini found a workaroud (at this
 981     time there is no better fix): remove or comment the <tt>DOCTYPE</tt>
 982     declarations (3 lines) from the scripts <i>header.inc.php3</i>,
 983     <i>index.php3</i>, <i>left.php3</i> and <i>libraries/common.lib.php3</i>.
 984 </p>
 985
 986 <p>
 987     <b>How can I GZip or Bzip a dump or a CSV export. It seems to not work?</b>
 988     <br />
 989     These features are based on the <tt>gzencode()</tt> and
 990     <tt>bzcompress()</tt> php functions to be more independent of the platform
 991     (Unix/Windows, Safe Mode or not, and so on).
 992     So, you must have PHP4&nbsp;>=&nbsp;4.0.4 and Zlib/Bzip2 support
 993     (<tt>--with-zlib</tt> and <tt>--with-bz2</tt>).
 994 </p>
 995
 996 <p>
 997     <b>I cannot insert a text file in a table, and I get an error about safe
 998        mode being in effect.</b>
 999     <br />
1000     Your uploaded file is saved by PHP in the &quot;upload dir&quot;, as
1001     defined in <i>php.ini</i> by the variable <tt>upload_tmp_dir</tt> (usually
1002     the system default is <i>/tmp</i>).
1003     <br />
1004     We recommend the following setup for Apache servers running in safe mode,
1005     to enable uploads of files while being reasonably secure:
1006 </p>
1007 <ul>
1008    <li>create a separate directory for uploads:
1009            <tt>mkdir /tmp/php</tt></li>
1010    <li>give ownership to the Apache server's user.group:
1011            <tt>chown apache.apache /tmp/php</tt></li>
1012    <li>give proper permission: <tt>chmod 600 /tmp/php</tt></li>
1013    <li>put <tt>upload_tmp_dir = /tmp/php</tt> in php.ini</li>
1014    <li>restart Apache</li>
1015 </ul>
1016
1017 <p>
1018     <b>I'm having troubles when uploading files. In general file uploads don't
1019     work on my system and uploaded files have a <tt>Content-Type:</tt> header
1020     in the first line.</b>
1021     <br />
1022     It's not really phpMyAdmin related but RedHat 7.0. You have a RedHat 7.0
1023     and you updated your php rpm to php-4.0.4pl1-3.i386.rpm, didn't you?
1024     <br />
1025     So the problem is that this package has a serious bug that was corrected
1026     ages ago in php (2001-01-28: see
1027     <a href="http://www.php.net/bugs.php?id=8966">php's bug tracking system</a>
1028     for more details). The problem is that the bugged package is still
1029     available though it was corrected (see
1030     <a href="http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=24933">redhat's bugzilla</a>
1031     for more details).
1032     <br />
1033     So please download
1034     <a href="http://www.redhat.com/swr/i386/php-4.0.4pl1-9.i386.html">the fixed package (4.0.4pl1-9)</a>
1035     and the problem should go away.
1036     <br />
1037     And that fixes the \r\n problem with file uploads!
1038 </p>
1039
1040 <p>
1041     <b>I'm having troubles when uploading files with phpMyAdmin running on a
1042        secure server. My browser is Internet Explorer and I'm using the Apache
1043        server.</b>
1044     <br />
1045     As suggested by &quot;Rob M&quot; in the phpWizard forum, add this line to
1046     your <i>httpd.conf</i>:<br />
1047     &nbsp;&nbsp;&nbsp;&nbsp;<tt>SetEnvIf User-Agent ".*MSIE.*" nokeepalive ssl-unclean-shutdown</tt><br />
1048     It seems to clear up many problems between IE and SSL.
1049 </p>
1050
1051 <p>
1052     <b>I get an 'open_basedir restriction' while uploading a file from the
1053        query box.</b>
1054     <br />
1055     Since version 2.2.4, phpMyAdmin supports servers with open_basedir
1056     restrictions. Assuming that the restriction allows you to open files in the
1057     current directory ('.'), all you have to do is create a 'tmp' directory
1058     under the phpMyAdmin install directory, with permissions 777 and the same
1059     owner as the owner of your phpMyAdmin directory. The  uploaded files will
1060     be moved there, and after execution of your SQL commands, removed.
1061 </p>
1062
1063 <p>
1064     <b>I have lost my MySQL root password, what can I do?</b>
1065     <br />
1066     The MySql manual explains how to
1067     <a href="http://www.mysql.com/doc/R/e/Resetting_permissions.html">
1068     reset the permissions</a>.
1069 </p>
1070
1071 <p>
1072     <b>I get an error 'No SQL query' when trying to execute a bookmark.</b>
1073     <br />
1074     If PHP does not have read/write access to its <i>upload_tmp_dir</i>, it
1075     cannot access the uploaded query.
1076 </p>
1077
1078 <h3>[Configuration]</h3>
1079
1080 <p>
1081     <b>The error message &quot;Warning: Cannot add header information - headers
1082     already sent by ...&quot; is displayed, what's the problem?</b>
1083     <br />
1084     Edit your <i>config.inc.php or .php3</i> file and ensure there is nothing
1085     (ie no blank lines, no spaces, no characters...) neither before the
1086     <tt>&lt;?php</tt> tag at the beginning, neither after the <tt>?&gt;</tt>
1087     tag at the end.
1088 </p>
1089
1090 <p>
1091     <b>phpMyAdmin can't connect to MySQL. What's wrong?</b>
1092     <br />
1093     Either there is an error with your PHP setup or your username/password is
1094     wrong. Try to make a small script which uses mysql_connect and see if it
1095     works. If it doesn't, it may be you haven't even compiled MySQL support
1096     into PHP.
1097 </p>
1098
1099 <p>
1100     <b>The error message &quot;Warning: MySQL Connection Failed: Can't connect
1101     to local MySQL server through socket '/tmp/mysql.sock' (111)...&quot;) is
1102     displayed. What can I do?</b>
1103     <br />
1104     Here is a fix suggested by Brad Ummer in the
1105     <a class="navigation" href="http://www.phpwizard.net/phorum/list.php?f=1" target="_blank">
1106          phpwizard forum</a>:
1107 </p>
1108 <ul>
1109     <li>
1110         First, you need to determine what socket is being used by MySQL.
1111         <br />
1112         To do this, telnet to your server and go to the MySQL bin directory. In
1113         this directory there should be a file named <i>mysqladmin</i>. Type
1114         <tt>./mysqladmin variables</tt>, and this should give you a bunch of
1115         info about your MySQL server, including the socket
1116         (<i>/tmp/mysql.sock</i>, for example).
1117     </li>
1118     <li>
1119         Then, you need to tell PHP to use this socket.<br />Assuming you are
1120         using PHP 3.0.10 or better, you can specify the socket to use when you
1121         open the connection. To do this in phpMyAdmin, you need to complete the
1122         socket information in the config.inc.php3.<br />
1123         For example:
1124         <tt>$cfgServers[n]['socket']&nbsp;=&nbsp;'/tmp/mysql.sock';</tt>
1125     </li>
1126 </ul>
1127 <p>
1128     Have also a look at the
1129     <a class="navigation" href="http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html" target="_blank">
1130          corresponding section of the MySQL documentation</a>.
1131 </p>
1132
1133 <p>
1134     <b>Nothing is displayed by my browser when I try to run phpMyAdmin, what
1135        can I do?</b>
1136     <br />
1137     Try to set the <tt>$cfgOBGZip</tt> directive to <tt>FALSE</tt> in the
1138     phpMyAdmin configuration file. It helps sometime.<br />
1139     Also have a look at your php version number: if it contains
1140     &quot;4.0b...&quot; it means you're running a beta version of PHP. That's
1141     not a so good idea, please upgrade to a plain revision.
1142 </p>
1143
1144 <p>
1145     <b>Each time I want to insert or change a record or drop a database or a
1146        table, an error 404 (page not found) is displayed or, with http or
1147        cookie authentication, I'm asked to login again. What's wrong?</b>
1148     <br />
1149     Check the value you set for the <tt>$cfgPmaAbsoluteUri</tt> directive in
1150     the phpMyAdmin configuration file.
1151 </p>
1152
1153 <h3>[Known limitations]</h3>
1154 <a name="login_bug"></a>
1155 <p>
1156     <b>When using http authentication, an user who logged out can not relog
1157        in with the same nick.</b>
1158     <br />
1159     This is related to the authentication mechanism (protocol) used by
1160     phpMyAdmin. We plan to change it as soon as we may find enough free time
1161     to do it, but you can bypass this problem: just close all the opened
1162     browser windows and then go back to phpMyAdmin. You should be able to
1163     logs in again.
1164 </p>
1165
1166 <p>
1167     <b>When dumping a large table in compressed mode, I get a memory limit
1168        error or a time limit error.</b>
1169     <br />
1170     As of version 2.2.4, we build the compressed dump in memory, so large
1171     tables dumps may hang. The only alternative we can think about (using
1172     system calls to mysqldump then gzip or bzip2) would not be applicable in
1173     environments where PHP is in safe mode: access to system programs is
1174     is limited by the system administrator, and time limit is enforced.
1175 </p>
1176
1177 <h3>[ISPs]</h3>
1178 <p>
1179     <b>I'm an ISP. Can I setup one central copy of phpMyAdmin or do I need to
1180     install it for each customer?</b>
1181     <br />
1182     Since version 2.0.3, you can setup a central copy of phpMyAdmin for all
1183     your users. The development of this feature was kindly sponsored by
1184     NetCologne GmbH.
1185     This requires a properly setup MySQL user management and phpMyAdmin
1186     http authentication. See the install section on
1187     &quot;Using http authentication&quot;.
1188 </p>
1189
1190 <p>
1191     <b>What's the preferred way of making phpMyAdmin secure against evil
1192     access?</b>
1193     <br />
1194     This depends on your system.<br />
1195     If you're running a server which cannot be accessed by other people, it's
1196     sufficient to use the directory protection bundled with your webserver
1197     (with Apache you can use <i>.htaccess</i> files, for example).<br />
1198     If other people have telnet access to your server, you should use
1199     phpMyAdmin's http authentication feature.
1200     <br /><br />
1201     Suggestions:
1202 </p>
1203 <ul>
1204     <li>
1205         Your <i>config.inc.php3</i> file should be <tt>chmod 660</tt>.
1206     </li>
1207     <li>
1208         All your phpMyAdmin files should be chown phpmy.apache, where phpmy
1209         is a user whose password is only known to you, and apache is the
1210         group under which Apache runs.
1211     </li>
1212     <li>
1213         You should use PHP safe mode, to protect from other users that try
1214         to include your <i>config.inc.php3</i> in their scripts.
1215     </li>
1216 </ul>
1217
1218 <p>
1219     <b>I get errors about not being able to include a file in <i>/lang</i></b>
1220     <br />
1221     Check <i>php.ini</i>, or ask your sysadmin to check it. The
1222     <tt>include_path</tt> must contain &quot;.&quot; somewhere in it, and
1223     <tt>open_basedir</tt>, if used, must contain &quot;.&quot; and
1224     &quot;./lang&quot; to allow normal operation of phpMyAdmin.
1225 </p>
1226 <p>
1227     <b>phpMyAdmin always gives &quot;Access denied&quot; when using http
1228     authentication.</b><br />
1229     This could happen for several reasons:
1230 </p>
1231 <ul>
1232     <li>
1233         <tt>$cfgServers[n]['stduser']</tt> and/or
1234         <tt>$cfgServers[n]['stdpass']</tt> are wrong.
1235     </li>
1236     <li>
1237         The username/password you specify in the login-dialog are invalid.
1238     </li>
1239     <li>
1240         You have already setup a security mechanism for the
1241         phpMyAdmin-directory, eg. a .htaccess file. This would interfere with
1242         phpMyAdmin's authentication, so remove it.
1243     </li>
1244 </ul>
1245
1246
1247 <h3>[Browsers or client OS]</h3>
1248 <p>
1249     <b>I get an out of memory error, and my controls are non-functional, when
1250     trying to create a table with more than 14 fields.</b>
1251     <br />
1252     We could reproduce this problem only under Win98/98SE. Testing under
1253     WinNT4 or Win2K, we could easily create more than 60 fields.
1254     <br />
1255     A workaround is to create a smaller number of fields, then come back to
1256     your table properties and add the other fields.
1257 </p>
1258
1259 <p>
1260     <b>With Xitami 2.5b4, phpMyAdmin won't process form fields.</b>
1261     <br />
1262     This is not a phpMyAdmin problem but a Xitami known bug: you'll face it
1263     with each script/website that use forms.<br />
1264     Upgrade or downgrade your Xitami server.
1265 </p>
1266
1267 <p>
1268     <b>I have problems dumping tables with Konqueror (phpMyAdmin 2.2.2)</b>
1269     <br />
1270     With Konqueror 2.1.1: plain dumps, zip and gzip dumps work ok, except that
1271     the proposed file name for the dump is always 'tbl_dump.php'. Bzip2 dumps
1272     don't seem to work.<br />
1273
1274     With Konqueror 2.2.1: plain dumps work; zip dumps are placed into
1275     the user's temporary directory, so they must be moved before closing
1276     Konqueror, or else they disappear. Gzip dumps give an error message.<br />
1277
1278     Testing needs to be done for Konqueror 2.2.2.<br />
1279 </p>
1280
1281 <p>
1282     <b>In Internet Explorer 5.0, I get Javascript errors when browsing my
1283        rows.</b>
1284     <br />
1285     Upgrade to at least Internet Explorer 5.5SP2.<br />
1286 </p>
1287
1288 <p>
1289     <b>In Internet Explorer 5.0, 5.5 or 6.0, I get an error when trying to
1290        modify a row in a table with many fields, or with a text field.</b>
1291     <br />
1292     Your table neither have a primary key nor an unique one, so we must use a
1293     long URL to identify this row. There is a limit on the lenght of the URL in
1294     those browsers, and this not happen in Netscape, for example. The
1295     workaround is to create a primary or unique key, or use another browser.
1296     <br />
1297 </p>
1298
1299 <p>
1300     <b>I refresh (reload) my browser, and come back to the welcome page.</b>
1301     <br />
1302     Some browsers support right-clicking into the frame you want to refresh,
1303     just do this in the right frame.<br />
1304 </p>
1305
1306 <p>
1307     <b>With Mozilla 0.9.7 I have problems sending a query modified in the query
1308        box.</b>
1309     <br />
1310     Looks like a Mozilla bug: 0.9.6 was ok. We will keep an eye on future
1311     Mozilla versions.<br />
1312 </p>
1313
1314
1315 <h3>[Using phpMyAdmin]</h3>
1316 <p>
1317     <b>I can't insert new rows into a table - MySQL brings up a SQL-error.</b>
1318     <br />
1319     Examine the SQL error with care. I've found that many programmers
1320     specifying a wrong field-type.<br />
1321     Common errors include:
1322 </p>
1323 <ul>
1324     <li>Using <tt>VARCHAR</tt> without a size argument</li>
1325     <li>Using <tt>TEXT or</tt> BLOB with a size argument</li>
1326 </ul>
1327 <p>
1328     Also, look at the syntax chapter in the MySQL manual to confirm that your
1329     syntax is correct.
1330 </p>
1331 <p>
1332     <b>When I create a table, I click the Index checkbox for 2 fields and
1333        phpMyAdmin generates only one index with those 2 fields.</b>
1334     <br />
1335     In phpMyAdmin 2.2.0 and 2.2.1, this is the way to create a multi-fields
1336     index. If you want two indexes, create the first one when creating the
1337     table, save, then display the table properties and click the Index link to
1338     create the other index.
1339 </p>
1340
1341 <p>
1342     <b>How can I insert a null value into my table?</b>
1343     <br />
1344     Since version 2.2.3, you have a checkbox for each field that can be null.
1345     Before 2.2.3, you had to enter &quot;null&quot;, without the quotes, as the
1346     field's value.
1347 </p>
1348
1349 <h3>[phpMyAdmin project]</h3>
1350 <p>
1351     <b>I have found a bug. How do I inform developers?</b>
1352     <br />
1353     Our Bug Tracker is located at <a href="http://sourceforge.net/projects/phpmyadmin/">
1354         http://sourceforge.net/projects/phpmyadmin/</a> under the Bugs section.
1355     <br /><br />
1356     But please first discuss your bug with other users:
1357     <br />
1358     <a href="http://sourceforge.net/projects/phpmyadmin/">
1359         http://sourceforge.net/projects/phpmyadmin/</a> (and choose Forums)
1360     <br />
1361     <a href="http://www.phpwizard.net/projects/phpMyAdmin/">
1362         http://www.phpwizard.net/projects/phpMyAdmin/</a> (and choose Support
1363     Forum)
1364 </p>
1365
1366 <p>
1367     <b>I want to translate the messages to a new language or upgrade an
1368        existing language, where do I start?</b>
1369     <br />
1370     Always use the current cvs version of your language file.
1371     For a new language, start from english.inc.php3. If you don't know
1372     how to get the cvs version, please ask one of the developers. It would be a
1373     good idea to subscribe to the phpmyadmin-translators discussion list,
1374     because this is where we ask for translations of new messages. You can
1375     then send your translations to the sourceforge.net translation tracker.
1376 </p>
1377
1378 <p>
1379     <b>I would like to help out with the development of phpMyAdmin. How should
1380     I proceed?</b>
1381     <br />
1382     The following method is preferred for new developers:
1383 </p>
1384 <ul>
1385     <li>
1386         fetch the current CVS tree over anonymous CVS:<br />
1387         <tt>cvs -d:pserver:anonymous@cvs.phpmyadmin.sourceforge.net:/cvsroot/phpmyadmin login</tt><br />
1388         [Password: simply press the Enter key]<br />
1389         <tt>cvs -z3 -d:pserver:anonymous@cvs.phpmyadmin.sourceforge.net:/cvsroot/phpmyadmin checkout phpMyAdmin</tt><br />
1390         [This will create a new sub-directory named phpMyAdmin]
1391     </li>
1392     <li>
1393         add your stuff
1394     </li>
1395     <li>
1396         put the modified files (tar'ed and gzip'ed) inside the patch tracker of
1397         the
1398         <a class="navigation" href="https://sourceforge.net/projects/phpmyadmin/" target="_blank">phpMyAdmin SourceForge account</a>.
1399     </li>
1400 </ul>
1401 <p>
1402     Write access to the CVS tree is granted only to experienced developers who
1403     have already contributed something useful to phpMyAdmin.<br />
1404     Also, have a look at the <a class="navigation" href="#developers">Developers section</a>.
1405 </p>
1406
1407
1408
1409 <!-- DEVELOPERS -->
1410 <a name="developers"></a><br />
1411 <hr noshade="noshade" width="100%" />
1412 <font size="+1">
1413     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
1414     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
1415     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
1416     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
1417     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
1418     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
1419     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
1420     <a class="navigation2" href="#credits">Credits</a>
1421 </font>
1422 <hr noshade="noshade" width="100%" />
1423
1424 <h2>Developers Information</h2>
1425
1426 <p>
1427     phpMyAdmin is Open Source, so you're invited to contribute to it. Many
1428     great features have been written by other people and you too can help to
1429     make phpMyAdmin a useful tool.
1430 </p>
1431
1432 <p>
1433     If you're planning to contribute source, please read the following
1434     information:
1435 </p>
1436 <ul>
1437     <li>
1438         All files include <i>header.inc.php3</i> (layout),
1439         <i>libraries/common.lib.php3</i> (common functions) and
1440         <i>config.inc.php3</i>.
1441         <br />
1442         All configuration data belongs in <i>config.inc.php3</i>. Please keep
1443         it free from other code.
1444         <br />
1445         Commonly used functions should be added to
1446         <i>libraries/lib.inc.php3</i> and more specific ones may be added
1447         within a library stored into the <i>libraries</i> sub-directory.
1448     </li>
1449     <li>
1450         Obviously, you're free to use whatever coding style you want. But
1451         please try to keep your code as simple as possible: beginners are
1452         using phpMyAdmin as an example application.<br />
1453         By the way, we're currently updating all the scripts so they will be
1454         XHTML1.0 and CSS2 compliant on one hand, they will fit
1455         <a class="navigation" href="http://pear.php.net/" target="_blank">PEAR coding standards</a>
1456         on the other hand. Please pay attention to this.
1457     </li>
1458     <li>
1459         Please try to keep up the file-naming conventions. Table-related stuff
1460         goes to <i>tbl_*.php3</i>, db-related code to <i>db_*.php3</i> and so
1461         on.
1462     </li>
1463     <li>
1464         Please don't use verbose strings in your code, instead add the string
1465         (at least) to <i>english.inc.php3</i> and print() it out.
1466     </li>
1467     <li>
1468         If you want to be really helpful, write an entry for the ChangeLog.
1469     </li>
1470 </ul>
1471
1472 <p>
1473     IMPORTANT: With 1.4.1, development has switched to CVS. The following
1474     method is preferred for new developers:
1475 </p>
1476 <ul>
1477     <li>
1478         fetch the current CVS tree over anonymous CVS:<br />
1479         <tt>cvs -d:pserver:anonymous@cvs.phpmyadmin.sourceforge.net:/cvsroot/phpmyadmin login</tt><br />
1480         [Password: simply press the Enter key]<br />
1481         <tt>cvs -z3 -d:pserver:anonymous@cvs.phpmyadmin.sourceforge.net:/cvsroot/phpmyadmin checkout phpMyAdmin</tt><br />
1482         [This will create a new sub-directory named phpMyAdmin]
1483     </li>
1484     <li>
1485         add your stuff
1486     </li>
1487     <li>
1488         put the modified files (tar'ed and gzip'ed) inside the patch tracker
1489         of the phpMyAdmin SourceForge account
1490         (<a class="navigation" href="http://sourceforge.net/projects/phpmyadmin/" target="_blank">http://sourceforge.net/projects/phpmyadmin/</a>)
1491     </li>
1492 </ul>
1493 <p>
1494     Write access to the CVS tree is granted only to developers who have already
1495     contributed something useful to phpMyAdmin.  If you're interested in that,
1496     please contact us using the phpmyadmin-devel mailing list.
1497 </p>
1498
1499
1500 <!-- CREDITS -->
1501 <a name="credits"></a><br />
1502 <hr noshade="noshade" width="100%" />
1503 <font size="+1">
1504     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
1505     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
1506     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
1507     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
1508     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
1509     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
1510     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
1511     <a class="navigation2" href="#credits">Credits</a>
1512 </font>
1513 <hr noshade="noshade" width="100%" />
1514
1515 <h2>Credits</h2>
1516
1517 <pre>
1518
1519 phpMyAdmin - Credits
1520 ====================
1521
1522 CREDITS, in chronological order
1523 -------------------------------
1524
1525 [tr] - Tobias Ratschiller &lt;tobias_at_phpwizard.net&gt;
1526         * creator of the phpmyadmin project
1527         * maintainer from 1998 to summer 2000
1528
1529 [md] - Marc Delisle &lt;DelislMa_at_CollegeSherbrooke.qc.ca&gt;
1530         * multi-language version
1531         * various fixes and improvements
1532
1533 [om] - Olivier Müller &lt;om_at_omnis.ch&gt;
1534         * started SourceForge phpMyAdmin project in March 2001
1535         * sync'ed different existing CVS trees with new features and bugfixes
1536         * multi-language improvements, dynamic language selection
1537         * current project maintainer, with Marc and Loic
1538
1539 [lc] - Loïc Chapeaux &lt;lolo_at_phpheaven.net&gt;
1540         * rewrote and optimized javascript, DHTML and DOM stuff
1541         * started to rewrite the scripts so they fit the PEAR coding standards
1542           and generate XHTML1.0 and CSS2 compliant codes
1543         * improved the language detection system
1544         * many bugfixes and improvements
1545
1546 [rj] - Robin Johnson &lt;robbat2_at_users.sourceforge.net&gt;
1547         * database maintence controls
1548         * table type code
1549
1550 [af] - Armel Fauveau &lt;armel.fauveau_at_globalis-ms.com&gt;
1551         * bookmarks feature
1552         * multiple dump feature
1553         * gzip dump feature
1554         * zip dump feature
1555
1556 [gl] - Geert Lund &lt;glund_at_silversoft.dk&gt;
1557         * various fixes
1558         * moderator of the phpMyAdmin users forum at phpwizard.net
1559
1560 [kc] - Korakot Chaovavanich &lt;korakot_at_iname.com&gt;
1561         * &quot;insert as new row&quot; feature
1562
1563 [pk] - Pete Kelly &lt;webmaster_at_trafficg.com&gt;
1564         * rewrote and fix dump code
1565         * bugfixes
1566
1567 [sa] - Steve Alberty &lt;alberty_at_neptunlabs.de&gt;
1568         * rewrote dump code for PHP4
1569         * mySQL table statistics
1570         * bugfixes
1571
1572 [bg] - Benjamin Gandon &lt;gandon_at_isia.cma.fr&gt;
1573         * main author of the version 2.1.0.1
1574         * bugfixes
1575
1576
1577 Thanks to those guy who send us some major improvements to merge into the
1578 code since version 2.1.0:
1579 - Michal Cihar &lt;nijel at users.sourceforge.net&gt; who implemented the
1580   enhanced index creation/display feature.
1581 - Christophe Gesché from the "MySQL Form Generator for PHPMyAdmin"
1582   (http://sourceforge.net/projects/phpmysqlformgen/) who suggested the patch
1583   for multiple table printviews.
1584 - Garvin Hicking &lt;hicking at faktor-e.de&gt; who builds the patch for
1585   vertical display of table rows.
1586 - Piotr Roszatycki &lt;d3xter at users.sourceforge.net&gt; and Dan Wilson, for
1587   the Cookie authentication mode.
1588 - Axel Sander &lt;n8falke at users.sourceforge.net&gt; for the table
1589   relation-links feature.
1590
1591 And also to the following people who have contributed minor changes,
1592 enhancements, bugfixes or support for a new language since version 2.1.0:
1593 Bora Alioglu, Ricardo ?, Sven-Erik Andersen, Alessandro Astarita,
1594 Péter Bakondy, Borges Botelho, Olivier Bussier, Neil Darlow,
1595 Kristof Hamann, Thomas Kläger, Lubos Klokner, Martin Marconcini,
1596 Girish Nair, David Nordenberg, Bernard M. Piller, Laurent Haas,
1597 &quot;Sakamoto&quot;, Yuval Sarna, www.securereality.com.au,
1598 Peter Svec, Michael Tacelosky,
1599 Daniel Villanueva, Vinay, Ignacio Vazquez-Abrams, Chee Wai, Jakub Wilk,
1600 Thomas Michael Winningham.
1601
1602
1603 Original Credits of Version 2.1.0
1604 ---------------------------------
1605
1606     This work is based on Peter Kuppelwieser's MySQL-Webadmin. It was his idea
1607     to create a web-based interface to MySQL using PHP3. Although I have not
1608     used any of his source-code, there are some concepts I've borrowed from
1609     him. phpMyAdmin was created because Peter told me he wasn't going to
1610     further develop his (great) tool.
1611     Thanks go to
1612     - Amalesh Kempf &lt;ak-lsml_at_living-source.com&gt; who contributed the
1613       code for the check when dropping a table or database. He also suggested
1614       that you should be able to specify the primary key on tbl_create.php3. To
1615       version 1.1.1 he contributed the ldi_*.php3-set (Import text-files) as
1616       well as a bug-report. Plus many smaller improvements.
1617     - Jan Legenhausen &lt;jan_at_nrw.net&gt;: He made many of the changes that
1618       were introduced in 1.3.0 (including quite significant ones like the
1619       authentication). For 1.4.1 he enhanced the table-dump feature. Plus
1620       bug-fixes and help.
1621     - Marc Delisle &lt;DelislMa_at_CollegeSherbrooke.qc.ca&gt; made phpMyAdmin
1622       language-independent by outsourcing the strings to a separate file. He
1623       also contributed the French translation.
1624     - Alexandr Bravo &lt;abravo_at_hq.admiral.ru&gt; who contributed
1625       tbl_select.php3, a feature to display only some fields from a table.
1626     - Chris Jackson &lt;chrisj_at_ctel.net&gt; added support for MySQL
1627       functions in tbl_change.php3. He also added the
1628       &quot;Query by Example&quot; feature in 2.0.
1629     - Dave Walton &lt;walton_at_nordicdms.com&gt; added support for multiple
1630       servers and is a regular contributor for bug-fixes.
1631     - Gabriel Ash &lt;ga244_at_is8.nyu.edu&gt; contributed the random access
1632       features for 2.0.6.
1633     The following people have contributed minor changes, enhancements, bugfixes
1634     or support for a new language:
1635     Jim Kraai, Jordi Bruguera, Miquel Obrador, Geert Lund, Thomas Kleemann,
1636     Alexander Leidinger, Kiko Albiol, Daniel C. Chao, Pavel Piankov,
1637     Sascha Kettler, Joe Pruett, Renato Lins, Mark Kronsbein, Jannis Hermanns,
1638     G. Wieggers.
1639
1640     And thanks to everyone else who sent me email with suggestions, bug-reports
1641     and or just some feedback.
1642 </pre>
1643
1644
1645
1646 <a name="bottom"></a><br />
1647 <hr noshade="noshade" width="100%" />
1648 <font size="+1">
1649     <a class="navigation2" href="#top">Top</a> &nbsp;-&nbsp;
1650     <a class="navigation2" href="#require">Requirements</a> &nbsp;-&nbsp;
1651     <a class="navigation2" href="#intro">Introduction</a> &nbsp;-&nbsp;
1652     <a class="navigation2" href="#setup">Installation</a> &nbsp;-&nbsp;
1653     <a class="navigation2" href="#config">Configuration</a> &nbsp;-&nbsp;
1654     <a class="navigation2" href="#faq">FAQ</a> &nbsp;-&nbsp;
1655     <a class="navigation2" href="#developers">Developers</a> &nbsp;-&nbsp;
1656     <a class="navigation2" href="#credits">Credits</a>
1657 </font>
1658 <hr noshade="noshade" width="100%" />
1659
1660 <p align="right">
1661     <a href="http://validator.w3.org/check/referer" target="w3c">
1662         <img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" border="0" height="31" width="88" /></a>
1663     &nbsp;&nbsp;&nbsp;&nbsp;
1664     <a href="http://jigsaw.w3.org/css-validator/" target="w3c">
1665         <img src="http://www.w3.org/Icons/valid-css" alt="Valid CSS!" border="0" width="88" height="31" /></a>
1666 </p>
1667
1668 </body>
1669 </html>