2 phpMyAdmin 2.3.2 Documentation
4 * Sourceforge phpMyAdmin project page [ http://www.phpmyadmin.net/
7 + Version history: ChangeLog
8 + General notes: README
10 * Documentation version: $Id: Documentation.html,v 1.351 2002/10/08
12 ______________________________________________________________________
14 Top - Requirements - Introduction - Installation -
15 Configuration - FAQ - Developers - Credits
16 ______________________________________________________________________
20 * PHP3 or PHP4: phpMyAdmin widely uses the 'str_replace()' php
21 function that was added in PHP 3.0.6, but was buggy up until
22 PHP 3.0.8. Then you should not run this script with PHP3 < 3.0.8.
23 PHP also needs to be compiled with MySQL support;
24 * MySQL (tested with 3.21.x, 3.22.x, 3.23.x and 4.0.x);
25 * a web-browser (doh!).
26 ______________________________________________________________________
28 Top - Requirements - Introduction - Installation -
29 Configuration - FAQ - Developers - Credits
30 ______________________________________________________________________
34 phpMyAdmin can manage a whole MySQL-server (needs a super-user) but
35 also a single database. To accomplish the latter you'll need a
36 properly set up MySQL-user who can read/write only the desired
37 database. It's up to you to look up the appropriate part in the MySQL
38 manual. Currently phpMyAdmin can:
39 * create and drop databases
40 * create, copy, drop and alter tables
41 * delete, edit and add fields
42 * execute any SQL-statement, even batch-queries
43 * manage keys on fields
44 * load text files into tables
45 * create (*) and read dumps of tables
46 * export (*) and import data to CSV values
47 * administer multiple servers and single databases
48 * check referential integrity
49 * create complex queries automatically connecting required tables
50 * create PDF graphics of your Database layout
51 * communicate in more than 41 different languages
53 (*) phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2 formats)
54 dumps and CSV exports if you use PHP4 >= 4.0.4 with Zlib support
55 (--with-zlib) and/or Bzip2 support (--with-bz2).
56 ______________________________________________________________________
58 Top - Requirements - Introduction - Installation -
59 Configuration - FAQ - Developers - Credits
60 ______________________________________________________________________
64 NOTE: phpMyAdmin does not apply any special security methods to the
65 MySQL database server. It is still the sysadmin's job to grant
66 permissions on the MySQL databases properly. phpMyAdmin's "Users" page
69 Warning for Mac users:if you are on a MacOS version before OS X,
70 Stuffit unstuffs with Mac formats.
71 So you'll have to resave as in Bbedit to unix style ALL phpMyAdmin
72 scripts before uploading them to your server, as PHP seems not to like
73 Mac-style end of lines character ("\r").
75 Documentation warning: when you see in this document a .php3 file
76 extension, please transpose to .php if you are using a kit with files
77 having this extension.
80 1. Choose and download a distribution kit with the files having the
81 extension (.php3 or .php) depending on the way your web/PHP server
82 interprets those extensions.
83 2. Untar or unzip the distribution (be sure to unzip the
84 subdirectories): tar xzvf phpMyAdmin_x.x.x.tar.gz in your
85 webserver's document root. If you don't have direct access to your
86 document root, put the files in a directory on your local machine,
87 and, after step 3, transfer the directory on your web server
88 using, for example, ftp.
89 3. Open the file config.inc.php3 in your favourite editor and change
90 the values for host, user, password and authentication mode to fit
91 your environment. Also insert the correct value for
92 $cfg['PmaAbsoluteUri']. Have a look at Configuration section for
93 an explanation of all values.
94 4. It is recommended that you protect the directory in which you
95 installed phpMyAdmin (unless it's on a closed intranet, or you
96 wish to use http or cookie authentication), for example with
97 HTTP-AUTH (in a .htaccess file). See the FAQ section for
98 additional information.
99 5. Open the file <www.your-host.com>/<your-install-dir>/index.php3 in
100 your browser. phpMyAdmin should now display a welcome screen and
101 your databases, or a login dialog if using http or cookie
104 Upgrading from an older version:
105 * Please do not copy your older config.inc.php3 over the new one: it
106 may offer new configuration variables, and the new version may
107 depend on these for normal behavior. It is suggested instead to
108 insert your site values in the new one.
110 Using authentication modes:
111 * Http and cookie authentication modes are recommended in a
112 multi-user environment where you want to give users access to
113 their own database and don't want them to play around with others.
114 Nevertheless be aware that MS Internet Explorer seems to be really
115 buggy about cookies, at least till version 6. And php 4.1.1 is
116 also a bit buggy in this area!
117 * Http and cookie authentication modes are more secure: the MySQL
118 password does not need to be set in the phpMyAdmin configuration
119 file (except for the "controluser" -see the Configuration
121 However, keep in mind that the password travels in plain text,
122 unless you are using the https protocol.
123 In cookie mode, we send the password in a temporary cookie, so
124 most browsers should not store the password in their cookie file.
125 * For 'http' and 'cookie' modes, phpMyAdmin needs a controluser that
126 has only the SELECT privilege on the mysql.user (all columns
127 except "Password"), mysql.db (all columns) & mysql.tables_priv
128 (all columns except "Grantor" & "Timestamp") tables.
129 You must specify the details for the controluser in the
130 config.inc.php3 file under the $cfg['Servers'][$i]['controluser']&
131 $cfg['Servers'][$i]['controlpass'] settings.
132 This example assumes you want to use pma as the controluser and
133 pmapass as the controlpass, but this is only an example: use
134 something else in your file:
136 GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY
138 GRANT SELECT (Host, User, Select_priv, Insert_priv, Update_priv,
139 Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv,
140 Process_priv, File_priv, Grant_priv, References_priv, Index_priv,
141 Alter_priv) ON mysql.user TO 'pma'@'localhost';
142 GRANT SELECT ON mysql.db TO 'pma'@'localhost';
143 GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON
144 mysql.tables_priv TO 'pma'@'localhost';
145 ... and if you want to use the many new relation and bookmark
147 GRANT SELECT, INSERT, UPDATE, DELETE ON <pma_db> TO
148 'pma'@'localhost'; (this of course requires you to have a special DB
149 for phpMyAdmin, the contents will be explained later)
150 * Then each of the true users should be granted of a set of
151 privileges on a set of particular databases but shouldn't have any
152 global privileges. For example, to grant the user real_user with
153 all privileges on the database user_base:
154 GRANT ALL PRIVILEGES ON user_base.* TO 'real_user'@localhost
155 IDENTIFIED BY 'real_password';
156 What the user may now do is controlled entirely by the MySQL user
158 With http or cookie auth mode, you don't need to fill the
159 user/password fields inside the $cfg['Servers'] array.
161 'http' authentication mode:
162 * Was called 'advanced' in versions before 2.2.3.
163 * Introduced in 1.3.0, it uses Basic HTTP authentication method and
164 allows you to login as any valid MySQL user.
165 * Is only supported with PHP running as an Apache module, not with
168 'cookie' authentication mode:
169 * You can use this method as a replacement for the http
170 authentication (for example, if you're running IIS).
171 * Obviously, the user must enable cookies in the browser.
172 * With this mode, the use can truly logout of phpMyAdmin and login
173 back with the same username.
175 'config' authentication mode:
176 * This mode is the less secure one because it requires you to fill
177 the $cfg['Servers'][$i]['user'] and
178 $cfg['Servers'][$i]['password'] fields.
179 But you don't need to setup a "controluser" here: using the
180 $cfg['Servers'][$i]['only_db'] might be enough.
181 * In the ISP FAQ section, there is an entry explaining how to
182 protect your configuration file.
183 * For additional security in this mode, you may wish to consider the
184 Host authentication $cfg['Servers'][$i]['AllowDeny']['order'] and
185 $cfg['Servers'][$i]['AllowDeny']['rules'] configuration
187 ______________________________________________________________________
189 Top - Requirements - Introduction - Installation -
190 Configuration - FAQ - Developers - Credits
191 ______________________________________________________________________
195 Warning for Mac users: php seems not to like Mac end of lines
196 character ("\r"). So ensure you choose the option that allows to use
197 the *nix end of line character ("\n") in your text editor before
198 registering a script you have modified.
200 All configurable data is placed in config.inc.php3.
202 $cfg['PmaAbsoluteUri'] string
203 Sets here the complete url (with full path) to your phpMyAdmin
205 http://www.your_web.net/path_to_your_phpMyAdmin_directory/.
206 phpMyAdmin needs this setting, because of requirements of the
207 HTTP protocol, explained in RFC2616, section 14.30.
208 Don't forget the slash at the end of your url. The url must
209 contain characters that are valid for a url, and on some
210 servers, the path is case-sensitive.
211 Starting with version 2.3.0, you can try to leave this
212 parameter empty, because the program tries to auto-detect its
213 proper value. Additional details are in the configuration file.
214 Alternatively, this setting can be dynamically completed. For
215 example, you can try to use such a kind of code:
217 $cfg['PmaAbsoluteUri'] = (!empty($_SERVER['HTTPS']) ? 'https' : 'http') . '://'
218 . $_SERVER['HTTP_HOST']
219 . (!empty($_SERVER['SERVER_PORT']) ? ':' . $_SERVER['SER
221 . substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_
226 $cfg['PmaAbsoluteUri'] = (!empty($_SERVER['HTTPS']) ? 'https' : 'http') . '://'
227 . $_SERVER['SERVER_NAME']
228 . (!empty($_SERVER['SERVER_PORT']) ? ':' . $_SERVER['SER
230 . substr($_SERVER['SCRIPT_NAME'], 0, strrpos($_SERVER['S
231 CRIPT_NAME'], '/')+1);
234 Please note that the $_SERVER array doesn't exist in
235 PHP < 4.1.0. Try to replace $_SERVER by $HTTP_SERVER_VARS or
236 $GLOBALS in this case.
238 $cfg['PmaAbsoluteUri_DisableWarning'] boolean
239 By default, when you leave $cfg['PmaAbsoluteUri'] empty, and
240 the system detects your absolute URI automatically, we display
241 a warning to remind you. If you have tested the automatic
242 detection, and it works perfectly for your setup, then you can
243 set this variable to squelch the warning.
245 $cfg['PmaNoRelation_DisableWarning'] boolean
246 Starting with version 2.3.0 phpMyAdmin offers a lot of features
247 to work with master / foreign - tables. These features require
248 the PMA administrator to set up a special database for PMA (see
249 $cfg['Servers'][$i]['pmadb']). Its contents and use will be
250 explained further down.
251 If you tried to set this up and it does not work for you have a
252 look on the "Structure" page of one database where you would
253 like to use it. You will find a link that will analyze why
254 those features have been disabled.
255 If you do not want to use those features set this variable to
256 TRUE to stop this message from appearing.
258 $cfg['Servers'] array
259 Since version 1.4.2, phpMyAdmin supports the administration of
260 multiple MySQL servers. Therefore, a $cfg['Servers']-array has
261 been added which contains the login information for the
262 different servers. The first $cfg['Servers'][$i]['host']
263 contains the hostname of the first server, the second
264 $cfg['Servers'][$i]['host'] the hostname of the second server,
265 etc. If you have only one server to administer, simply leave
266 free the hostname of the other $cfg['Server']-entries.
268 $cfg['Servers'][$i]['host'] string
269 The hostname of your $i-th MySQL-server. E.g. localhost.
271 $cfg['Servers'][$i]['port'] string
272 The port-number of your $i-th MySQL-server. Default is 3306
275 $cfg['Servers'][$i]['socket'] string
276 The path to the socket to use. Leave blank for default.
277 To use the socket feature you must run php 3.0.10 or more.
279 $cfg['Servers'][$i]['connect_type'] string
280 What type connection to use with the MySQL server. Your options
281 are 'socket' & 'tcp'. It defaults to 'tcp' as that is nearly
282 guarenteed to be available on all MySQL servers, while sockets
283 are not supported on some platforms.
285 $cfg['Servers'][$i]['controluser'] string
286 $cfg['Servers'][$i]['controlpass'] string
287 When using http or cookie authentication modes (or 'config'
288 authentication mode since phpMyAdmin 2.2.1), you need to supply
289 the details of a MySQL account that has SELECT privilege on the
290 mysql.user (all columns except "Password"), mysql.db (all
291 columns) & mysql.tables_priv (all columns except "Grantor" &
292 "Timestamp") tables. This account is used to check what
293 databases the user will see at login.
294 Please see the install section on "Using http authentication"
295 for more information.
296 Note that if you try login to phpMyAdmin with this
297 "controluser", you could get some errors, depending the exact
298 privileges you gave to the "controluser". phpMyAdmin does not
299 support a direct login with the "controluser".
300 In versions before 2.2.5, those were called "stduser/stdpass".
302 $cfg['Servers'][$i]['auth_type'] string ['http'|'cookie'|'config']
303 Whether config or cookie or http authentication should be used
306 + 'config' authentication ($auth_type = 'config') is the plain
307 old way: username and password are stored in config.inc.php3.
308 + 'cookie' authentication mode ($auth_type = 'cookie') as
309 introduced in 2.2.3 allows you to log in as any valid MySQL
310 user with the help of... cookies. Log name and password are
311 stored in cookies during the session and password is deleted
313 + 'http' authentication (was called 'advanced' in older
314 versions) ($auth_type = 'http') as introduced in 1.3.0 allows
315 you to log in as any valid MySQL user via HTTP-Auth.
317 Please see the install section on "Using authentication modes"
318 for more information.
320 $cfg['Servers'][$i]['user'] string
321 $cfg['Servers'][$i]['password'] string
322 The user/password-pair which phpMyAdmin will use to connect to
323 this MySQL-server. This user/password pair is not needed when
324 http or cookie authentication is used, and should be empty.
326 $cfg['Servers'][$i]['only_db'] string or array
327 If set to a(an array of) database name(s), only this(these)
328 database(s) will be shown to the user. Since phpMyAdmin 2.2.1,
329 this/these database(s) name(s) may contain MySQL wilcards
330 characters ("_" and "%"): if you want to use literal instances
331 of these characters, escape them (ie use 'my\_db' and not
333 This setting is an efficient way to lower the server charge
334 since the latter does not need to send MySQL requests to build
335 the available database list. But it does not replace the
336 privileges rules of the MySQL database server. If set, it just
337 means only these databases will be displayed but not at all
338 other databases can't be used.
340 $cfg['Servers'][$i]['verbose'] string
341 Only useful when using phpMyAdmin with multiple server entries.
342 If set, this string will be displayed instead of the hostname
343 in the pulldown menu on the main page. This can be useful if
344 you want to show only certain databases on your system, for
347 $cfg['Servers'][$i]['pmadb'] string
348 Starting with version 2.3.0 phpMyAdmin offers a lot of features
349 to work with master / foreign - tables. To use those as well as
350 the bookmark feature you will need to create a new db.
351 To use this functionality as superuser create a new database:
353 + create a new database for phpmyadmin:
354 CREATE DATABASE phpmyadmin;
355 Note that "controluser" must have SELECT, INSERT, UPDATE and
356 DELETE privileges on this database. Here is a query to set up
357 those privileges (using "phpmyadmin" as the database name,
358 and "pma" as the controluser):
359 GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to
361 do not give any other user rights on this database.
362 + enter the databasename in $cfg['Servers'][$i]['pmadb']
364 $cfg['Servers'][$i]['bookmarktable'] string
365 Since release 2.2.0 phpMyAdmin allows to bookmark queries. This
366 can be useful for queries you often run.
367 To allow the usage of this functionality the superuser has to:
369 + set up a PMA database as described above
370 + within this database create a table following this scheme:
371 CREATE TABLE `PMA_bookmark` (
372 id int(11) DEFAULT '0' NOT NULL auto_increment,
373 dbase varchar(255) NOT NULL,
374 user varchar(255) NOT NULL,
375 label varchar(255) NOT NULL,
378 ) TYPE=MyISAM COMMENT='Bookmarks';
379 + enter the tablename in $cfg['Servers'][$i]['bookmarktable']
381 $cfg['Servers'][$i]['relation'] string
382 Since release 2.2.4 you can describe, in a special 'relation'
383 table, which field is a key in another table (a foreign key).
384 phpMyAdmin currently uses this to
386 + make clickable, when you browse the master table, the data
387 values that point to the foreign table;
388 + display in an optional tooltip the "display field" when
389 browsing the master table, if you move the mouse to a column
390 containing a foreign key (use also the 'table_info' table);
391 + display links on the table properties page, to check
392 referential integrity (display missing foreign keys) for each
394 + in query-by-example, create automatic joins (see an example
395 in the FAQ, section "Using phpMyAdmin");
396 + enable you to get a PDF schema of your database (also uses
397 the table_coords table).
399 The keys can be numeric or character.
400 To allow the usage of this functionality the superuser has to:
402 + set up a PMA database as described above
403 + within this database create a table following this scheme:
404 CREATE TABLE `PMA_relation` (
405 `master_db` varchar(64) NOT NULL default '',
406 `master_table` varchar(64) NOT NULL default '',
407 `master_field` varchar(64) NOT NULL default '',
408 `foreign_db` varchar(64) NOT NULL default '',
409 `foreign_table` varchar(64) NOT NULL default '',
410 `foreign_field` varchar(64) NOT NULL default '',
411 PRIMARY KEY (`master_db`, `master_table`,
413 KEY foreign_field (foreign_db, foreign_table)
414 ) TYPE=MyISAM COMMENT='Relation table';
415 + put the relation table name in
416 $cfg['Servers'][$i]['relation']
417 + now as normal user open phpMyAdmin and for each one of your
418 tables where you want to use this feature, click
419 "Structure/Relation view/" and choose foreign fields.
421 Please note that in the current (2.3.0) version, master_db must
422 be the same as foreign_db. Those fields have been put in future
423 development of the cross-db relations.
425 $cfg['Servers'][$i]['table_info'] string
426 Since release 2.3.0 you can describe, in a special 'table_info'
427 table, which field is to be displayed as a tooltip when moving
428 the cursor over the corresponding key.
429 This configuration variable will hold the name of this special
430 table. To allow the usage of this functionality the superuser
433 + set up a PMA database as described above
434 + within this database create a table following this scheme:
435 CREATE TABLE `PMA_table_info` (
436 `db_name` varchar(64) NOT NULL default '',
437 `table_name` varchar(64) NOT NULL default '',
438 `display_field` varchar(64) NOT NULL default '',
439 PRIMARY KEY (`db_name`, `table_name`)
440 ) TYPE=MyISAM COMMENT='Table information for
442 + put the table name in $cfg['Servers'][$i]['table_info']
443 + then for each table where you want to use this feature, click
444 "Structure/Relation view/Choose field to display" to choose
447 Usage tip: Display field.
449 $cfg['Servers'][$i]['table_coords'] string
450 $cfg['Servers'][$i]['pdf_pages'] string
451 Since release 2.3.0 you can have phpMyAdmin create PDF pages
452 showing the relations between your tables. To do this it needs
453 two tables "pdf_pages" (storing information about the available
454 pdf pages) and "table_coords" (storing coordinates where each
455 table will be placed on a PDF schema output).
456 You must be using the "relation" feature and have a table of
457 PDF pages (see $cfg['Servers'][$i]['pdf_pages']) to create PDF
459 To allow the usage of this functionality the superuser has to:
461 + set up a PMA database as described above
462 + within this database create a table following this scheme:
463 CREATE TABLE `PMA_table_coords` (
464 `db_name` varchar(64) NOT NULL default '',
465 `table_name` varchar(64) NOT NULL default '',
466 `pdf_page_number` int NOT NULL default '0',
467 `x` float unsigned NOT NULL default '0',
468 `y` float unsigned NOT NULL default '0',
469 PRIMARY KEY (`db_name`, `table_name`,
471 ) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin
473 + also within this database create:
474 CREATE TABLE `PMA_pdf_pages` (
475 `db_name` varchar(64) NOT NULL default '',
476 `page_nr` int(10) unsigned NOT NULL auto_increment,
477 `page_descr` varchar(50) NOT NULL default '',
478 PRIMARY KEY (page_nr),
480 ) TYPE=MyISAM COMMENT='PDF Relationpages for PMA';
481 + put the first table name in
482 $cfg['Servers'][$i]['table_coords'] and the second table name
483 in $cfg['Servers'][$i]['pdf_pages']
485 Usage tips: PDF output.
487 $cfg['Servers'][$i]['column_comments'] string
488 Since release 2.3.0 you can store comments to describe each
489 column for each table. These will then be shown on the
491 To allow the usage of this functionality the superuser has to:
493 + set up a PMA database as described above
494 + within this database create a table following this scheme:
495 CREATE TABLE `PMA_column_comments` (
496 id int(5) unsigned NOT NULL auto_increment,
497 db_name varchar(64) NOT NULL default '',
498 table_name varchar(64) NOT NULL default '',
499 column_name varchar(64) NOT NULL default '',
500 comment varchar(255) NOT NULL default '',
502 UNIQUE KEY db_name (db_name, table_name, column_name)
503 ) TYPE=MyISAM COMMENT='Comments for Columns';
504 + put the table name in $cfg['Servers'][$i]['column_comments']
506 $cfg['Servers'][$i]['AllowDeny']['order'] string
507 If your rule order is empty, then IP authentication is
509 If your rule order is set to 'deny,allow' then the system
510 applies all deny rules followed by allow rules. Access is
511 allowed by default. Any client which does not match a Deny
512 command or does match an Allow command will be allowed access
514 If your rule order is set to 'allow,deny' then the system
515 applies all allow rules followed by deny rules. Access is
516 denied by default. Any client which does not match an Allow
517 directive or does match a Deny directive will be denied access
519 If your rule order is set to 'explicit', the authentication is
520 performed in a similar fashion to rule order 'deny,allow', with
521 the added restriction that your host/username combination must
522 be listed in the allow rules, and not listed in the deny rules.
523 This is the most secure means of using Allow/Deny rules, and
524 was available in Apache by specifying allow and deny rules
525 without setting any order.
527 $cfg['Servers'][$i]['AllowDeny']['rules'] array of strings
528 The general format for the rules is as such:
529 <'allow' | 'deny'> <username> [from] <ipmask>
530 If you wish to match all users, it is possible to use a '%' as
531 a wildcard in the username field.
532 There are a few shortcuts you can use in the ipmask field as
535 'localhost' -> 127.0.0.1/8
536 Having an empty rule list is equivalent to either using 'allow
537 % from all' if your rule order is set to 'deny,allow' or 'deny
538 % from all' if your rule order is set to 'allow,deny' or
540 For the IP matching system, the following work:
541 xxx.xxx.xxx.xxx (an exact IP address)
542 xxx.xxx.xxx.[yyy-zzz] (an IP address range)
543 xxx.xxx.xxx.xxx/nn (CIDR, Classless Inter-Domain Routing type
545 But the following does not work:
546 xxx.xxx.xxx.xx[yyy-zzz] (partial IP address range)
548 $cfg['ServerDefault'] integer
549 If you have more than one server configured, you can set
550 $cfg['ServerDefault'] to any one of them to autoconnect to that
551 server when phpMyAdmin is started, or set it to 0 to be given a
552 list of servers without logging in.
553 If you have only one server configured, $cfg['ServerDefault']
554 MUST be set to that server.
556 $cfg['OBGzip'] boolean
557 Defines whether to use gzip output buffering for increased
558 speed in HTTP transfers.
560 $cfg['PersistentConnections'] boolean
561 Whether persistent connections should be used or not
562 (mysql_connect or mysql_pconnect).
564 $cfg['ExecTimeLimit'] integer [number of seconds]
565 Set the number of seconds a script is allowed to run. If
566 seconds is set to zero, no time limit is imposed.
567 This setting is used while importing/exporting dump files but
568 has no effect when PHP is running in safe mode.
570 $cfg['SkipLockedTables'] boolean
571 Mark used tables and make it possible to show databases with
572 locked tables (since 3.23.30).
574 $cfg['ShowSQL'] boolean
575 Defines whether sql-queries generated by phpMyAdmin should be
578 $cfg['AllowUserDropDatabase'] boolean
579 Defines whether normal users (non-administrator) are allowed to
580 delete their own database or not. If set as FALSE, the link
581 "Drop Database" will not be shown, and even a "DROP DATABASE
582 mydatabase" will be rejected. Quite practical for ISP's with
585 $cfg['Confirm'] boolean
586 Whether a warning ("Are your really sure..") should be
587 displayed when you're about to loose data.
589 $cfg['LoginCookieRecall'] boolean
590 Define whether the previous login should be recalled or not in
591 cookie authentication mode.
593 $cfg['UseDbSearch'] boolean
594 Define whether the "search string inside database" is enabled
597 $cfg['LeftFrameLight'] boolean
598 Defines whether to use select-based menu and display only the
599 current tables in the left frame (smaller page).
601 $cfg['ShowTooltip'] boolean
602 Defines whether to display table comment as tooltip in left
605 $cfg['ShowStats'] boolean
606 Defines whether to display space usage and statistics about
607 databases and tables or not.
608 Note that statistics requires at least MySQL 3.23.3 and that,
609 at this date, MySQL doesn't return such information for
612 $cfg['ShowMysqlInfo'] boolean
613 $cfg['ShowMysqlVars'] boolean
614 $cfg['ShowPhpInfo'] boolean
615 $cfg['ShowChgPassword'] boolean
616 Defines whether to display the "MySQL runtime information",
617 "MySQL system variables", "PHP information" and "Change
618 password " links or not for simple users at the starting main
619 (right) frame. This setting does not check MySQL commands
621 Please note that to block the usage of phpinfo() in scripts,
622 you have to put this in your php.ini:
623 disable_functions = phpinfo()
624 Also note that enabling the "Change password " link has no
625 effect with "config" authentication mode: because of the hard
626 coded password value in the configuration file, end users can't
627 be allowed to change their passwords.
629 $cfg['SuggestDBName'] boolean
630 Defines whether to suggest a database name on the "Create
631 Database" form or to keep the textfield empty.
633 $cfg['ShowBlob'] boolean
634 Defines whether BLOB fields are shown when browsing a table's
637 $cfg['NavigationBarIconic'] boolean
638 Defines whether navigation bar buttons contain text or symbols
641 $cfg['ShowAll'] boolean
642 Defines whether an user should be displayed a "show all
643 (records)" button in browse mode or not.
645 $cfg['MaxRows'] integer
646 Number of rows displayed when browsing a resultset. If the
647 resultset contains more rows, Previous/Next links will be
650 $cfg['Order'] string [DESC|ASC|SMART]
651 Defines whether fields are displayed in ascending (ASC) order,
652 in descending (DESC) order or in a "smart" (SMART) order -ie
653 descending order for fields of type TIME, DATE, DATETIME &
654 TIMESTAMP, ascending order else- by default.
656 $cfg['ProtectBinary'] boolean or string
657 Defines whether BLOB or BINARY fields are protected from
658 edition when browsing a table's content or not. Valid values
660 - FALSE to allow edition of all fields;
661 - blob to allow edition of all fields except BLOBS;
662 - all to disallow edition of all BINARY or BLOB fields.
664 $cfg['ShowFunctionFields'] boolean
665 Defines whether MySQL functions fields should be displayed or
666 not in edit/insert mode.
668 $cfg['CharEditing'] string
669 Defines which type of editing controls should be used for CHAR
670 and VARCHAR fields. Possible values are:
672 + input - this allows to limit size of text to size of field in
673 MySQL, but has problems with newlines in fields
674 + textarea - no problems with newlines in fields, but also no
677 Default is old behavior so input.
679 $cfg['ZipDump'] boolean
680 $cfg['GZipDump'] boolean
681 $cfg['BZipDump'] boolean
682 Defines whether to allow the use of zip/gzip/bzip compression
683 when creating a dump file or not.
685 $cfg['DefaultTabDatabase'] string
686 Defines the tab displayed by default on database view. Possible
687 values: "db_details_structure.php3", "db_details.php3" or
690 $cfg['DefaultTabTable'] string
691 Defines the tab displayed by default on table view. Possible
692 values: "tbl_properties_structure.php3", "tbl_properties.php3",
693 "tbl_select.php3" or "tbl_change.php3".
695 $cfg['MySQLManualBase'] string
696 If set to an URL which points to the MySQL documentation (type
697 depends on $cfg['MySQLManualType']), appropriate help links are
699 See MySQL Documentation page for more information about MySQL
700 manuals and their types.
702 $cfg['MySQLManualType'] string
703 Type of MySQL documentation:
705 + old - old style used in phpMyAdmin 2.3.0 and sooner
706 + searchable - "Searchable, with user comments"
707 + chapters - "HTML, one page per chapter"
708 + big - "HTML, all on one page"
709 + none - do not show documentation links
711 $cfg['DefaultLang'] string
712 Defines the default language to use, if not browser-defined or
714 See the select_lang.inc.php3 script to know the valid values
718 Force: always use this language (must be defined in the
719 select_lang.inc.php3 script).
721 $cfg['DefaultCharset'] string
722 Default charset to use for recoding of MySQL queries. This must
723 be enabled and it's described by $cfg['AllowAnywhereRecoding']
725 You can give here any charset which is in
726 $cfg['AvailableCharsets'] array and this is just default
727 choice, user can select any of them.
729 $cfg['AllowAnywhereRecoding'] boolean
730 Allow charset recoding of MySQL queries. You need recode or
731 iconv support (compiled in or module) in php to allow MySQL
732 queries recoding and used language file must have it enabled
733 (by default only these which are in unicode, just to avoid
734 losing some characters).
736 $cfg['RecodingEngine'] string
737 You can select here which functions will be used for charset
738 conversion. Possible values are:
740 + auto - automatically use available one (first is tested
742 + iconv - use iconv or libiconv functions
743 + recode - use recode_string function
747 $cfg['AvailableCharsets'] array
748 Available charsets for MySQL conversion. You can add your own
749 (any of supported by recode/iconv) or remove these which you
750 don't use. Charsets will be shown in same order as here listed,
751 so if you frequently use some of these move them to the top.
753 $cfg['LeftWidth'] integer
754 Left frame width in pixel.
756 $cfg['LeftBgColor'] string [HTML color]
757 $cfg['RightBgColor'] string [HTML color]
758 The background colors (HTML) used for both the frames.
760 $cfg['RightBgImage'] string
761 The URI of the background image used for the right frame. It
762 can be absolute as well as relative from your phpMyAdmin
765 $cfg['LeftPointerColor'] string [HTML color]
766 The color (HTML) used for the pointer in the left frame (does
769 $cfg['Border'] integer
770 The size of a table's border.
772 $cfg['ThBgcolor'] string [HTML color]
773 The color (HTML) used for table headers.
775 $cfg['BgcolorOne'] string [HTML color]
776 The color (HTML) #1 for table rows.
778 $cfg['BgcolorTwo'] string [HTML color]
779 The color (HTML) #2 for table rows.
781 $cfg['BrowsePointerColor'] string [HTML color]
782 $cfg['BrowseMarkerColor'] string [HTML color]
783 The colors (HTML) uses for the pointer and the marker in browse
784 mode (does not work with NS4).
785 The former feature highlights the row over which your mouse is
786 passing and the latter lets you visually mark/unmark rows by
788 You can disable both of these features by emptying the
789 respective directive.
791 $cfg['TextareaCols'] integer
792 $cfg['TextareaRows'] integer
793 $cfg['CharTextareaCols'] integer
794 $cfg['CharTextareaRows'] integer
795 Number of columns and rows for the textareas.
796 This value will be emphasized (*2) for sql query textareas.
797 The Char* values are used for CHAR and VARCHAR editing (if
798 configured via $cfg['CharEditing']).
800 $cfg['TextareaAutoSelect'] boolean
801 Defines if the whole textarea of the query box will be selected
804 $cfg['LimitChars'] integer
805 Maximal number of Chars showed in a TEXT OR a BLOB field on
806 browse view. Can be turned off by a toggle button on the browse
809 $cfg['ModifyDeleteAtLeft'] boolean
810 $cfg['ModifyDeleteAtRight'] boolean
811 Defines the place where modify and delete links would be put
812 when tables contents are displayed (you may have them displayed
813 both at the left and at the right). "Left" and "right" are
814 parsed as "top" and "bottom" with vertical display mode.
816 $cfg['DefaultDisplay'] string
817 There are 2 display modes: horizontal and vertical. Define
818 which one is displayed by default.
820 $cfg['UploadDir'] string
821 The name of the directory, ending with a slash, where SQL files
822 have been uploaded by other means than phpMyAdmin (for example,
823 ftp). Those files are available under a drop-down box when you
824 click the database name, then the SQL tab.
825 Please note that the file names must have the suffix ".sql".
826 This feature is useful when your file is too big to be uploaded
827 via HTTP, or when file uploads are disabled in PHP.
828 Please note that if PHP is running in safe mode, this directory
829 must be owned by the same user as the owner of the phpMyAdmin
832 $cfg['RepeatCells'] integer
833 Repeat the headers every X cells, or 0 to deactivate.
835 $cfg['SQP']['enable'] boolean
836 As of phpMyAdmin 2.3.0, we now have a fully functional SQL
837 Parser system. It is enabled by default, as it is used to
838 format the SQL queries.
839 As of 2.3.1, it will become an integral part of phpMyAdmin, as
840 it will analyze certain queries to improve the behavior of
841 phpMyAdmin. But as it is very new, and not yet heavily used, we
842 offer you an option to turn it off.
844 $cfg['SQP']['fmtType'] string [html|none]
845 The main use of the new SQL Parser is to pretty-print SQL
846 queries. By default we use HTML to format the query, but you
847 can disable this by setting this varible to 'none'
849 $cfg['SQP']['fmtInd'] float
850 $cfg['SQP']['fmtIndUnit'] string [em|px|pt|ex]
851 For the pretty-printing of SQL queries, under some cases the
852 part of a query inside a bracket is indented. By changing
853 $cfg['SQP']['fmtInd'] you can change the amount of this indent.
854 Related in purpose is $cfg['SQP']['fmtIndUnit'] which specifies
855 the units of the indent amount that you specified. This is used
858 $cfg['SQP']['fmtColor'] array of string tuples
859 This array is used to define the colours for each type of
860 element of the pretty-printed SQL queries. The tuple format is
861 class => [HTML colour code | empty string]
862 If you specify an empty string for the color of a class, it is
863 ignored in creating the stylesheet. You should not alter the
864 class names, only the colour strings.
867 + comment Applies to all comment sub-classes
868 + comment_mysql Comments as "#...\n"
869 + comment_ansi Comments as "-- ...\n"
870 + comment_c Comments as "/*...*/"
871 + digit Applies to all digit sub-classes
872 + digit_hex Hexadecimal numbers
873 + digit_integer Integer numbers
874 + digit_float Floating point numbers
875 + punct Applies to all punctuation sub-classes
876 + punct_bracket_open_round Opening brackets"("
877 + punct_bracket_close_round Closing brackets ")"
878 + punct_listsep List item seperator ","
879 + punct_qualifier Table/Column Qualifer "."
880 + punct_queryend End of query marker ";"
881 + alpha Applies to all alphabetic classes
882 + alpha_columnType Identifers matching a column type
883 + alpha_columnAttrib Identifers matching a
884 database/table/column attribute
885 + alpha_functionName Identifiers matching a MySQL function name
886 + alpha_reservedWord Identifiers matching any other reserved
888 + alpha_variable Identifers matching a SQL variable "@foo"
889 + alpha_identifier All other identifiers
890 + quote Applies to all quotation mark classes
891 + quote_double Double quotes "
892 + quote_single Single quotes '
893 + quote_backtick Backtick quotes `
895 $cfg['SQLValidator']['use'] boolean
896 phpMyAdmin now supports use of the Mimer SQL Validator service,
897 as originally published on Slashdot.
898 For help in setting up your system to use the service, see the
901 $cfg['SQLValidator']['username'] string
902 $cfg['SQLValidator']['password'] string
903 The SOAP service allows you to login with anonymous and any
904 password, so we use those by default.. Instead, if you have an
905 account with them, you can put your login details here, and it
906 will be used in place of the anonymous login.
908 $cfg['ColumnTypes'] array
909 All possible types of a MySQL column. In most cases you don't
912 $cfg['AttributeTypes'] array
913 Possible attributes for fields. In most cases you don't need to
916 $cfg['Functions'] array
917 A list of functions MySQL supports. In most cases you don't
919 ______________________________________________________________________
921 Top - Requirements - Introduction - Installation -
922 Configuration - FAQ - Developers - Credits
923 ______________________________________________________________________
925 FAQ - Frequently Asked Questions
927 Server - Configuration - Limitations - Multi-user - Browsers
928 - Usage tips - Project
932 [1.1] I'm running php 4+ and my server is crashing each time a
933 specific action is required or phpMyAdmin sends a blank page or a page
934 full of cryptic characters to my browser, what can I do?
935 There are some known php bugs with output buffering and compression.
936 Try to set the $cfg['OBGzip'] directive to FALSE in your
937 config.inc.php or .php3 file and the zlib.output_compression directive
938 to Off in your php configuration file.
939 Furthermore, we know about such problems connected to the release
940 candidates of php 4.2.0 (tested with php 4.2.0 RC1 to RC4) together
941 with MS Internet Explorer. Please upgrade to the release version php
944 [1.2] My Apache server crashes when using phpMyAdmin.
945 You should first try the latest versions of Apache (and possibly
947 See also the other FAQ entry about php bugs with output buffering.
948 If your server keeps crashing, please ask for help in the various
949 Apache support groups.
951 [1.3] I'm running phpMyAdmin with "cookie" authentication mode under
952 PHP 4.2.0 or 4.2.1 loaded as an Apache 2+ module but can't enter the
953 script: I'm always displayed the login screen.
954 This is a known PHP bug (see this bug report) from the official php
955 bug database. It means there is and won't be any phpMyAdmin fix
956 against it because there is no way to code a fix.
958 [1.4] Using phpMyAdmin on IIS, I'm displayed the error message: "The
959 specified CGI application misbehaved by not returning a complete set
961 You just forgot to read the install.txt file from the php
962 distribution. Have a look at the last message in this bug report from
963 the official php bug database.
965 [1.5] Using phpMyAdmin on IIS, I'm facing crashes and/or many error
966 messages with the http or advanced authentication mode.
967 This is a known problem with the php ISAPI filter: it's not so stable.
968 For some more information and complete testings see the messages
969 posted by André B. aka "djdeluxe76" in this thread from the phpWizard
971 Please use instead the cookie authentication mode.
973 [1.6] I can't use phpMyAdmin on PWS: nothing is displayed!
974 This seems to be a PWS bug. Filippo Simoncini found a workaroud (at
975 this time there is no better fix): remove or comment the DOCTYPE
976 declarations (2 lines) from the scripts header.inc.php3,
977 header_printview.inc.php3, index.php3, left.php3 and
978 libraries/common.lib.php3.
980 [1.7] How can I GZip or Bzip a dump or a CSV export. It seems to not
982 These features are based on the gzencode() and bzcompress() php
983 functions to be more independent of the platform (Unix/Windows, Safe
984 Mode or not, and so on). So, you must have PHP4 >= 4.0.4 and
985 Zlib/Bzip2 support (--with-zlib and --with-bz2).
986 We faced php crashes when trying to download a dump with MS Internet
987 Explorer when phpMyAdmin is run with a release candidate of php 4.2.0.
988 In this case you should switch to the release version of php 4.2.0.
990 [1.8] I cannot insert a text file in a table, and I get an error about
991 safe mode being in effect.
992 Your uploaded file is saved by PHP in the "upload dir", as defined in
993 php.ini by the variable upload_tmp_dir (usually the system default is
995 We recommend the following setup for Apache servers running in safe
996 mode, to enable uploads of files while being reasonably secure:
997 * create a separate directory for uploads: mkdir /tmp/php
998 * give ownership to the Apache server's user.group: chown
999 apache.apache /tmp/php
1000 * give proper permission: chmod 600 /tmp/php
1001 * put upload_tmp_dir = /tmp/php in php.ini
1004 [1.9] I'm having troubles when uploading files. In general file
1005 uploads don't work on my system and uploaded files have a
1006 Content-Type: header in the first line.
1007 It's not really phpMyAdmin related but RedHat 7.0. You have a RedHat
1008 7.0 and you updated your php rpm to php-4.0.4pl1-3.i386.rpm, didn't
1010 So the problem is that this package has a serious bug that was
1011 corrected ages ago in php (2001-01-28: see php's bug tracking system
1012 for more details). The problem is that the bugged package is still
1013 available though it was corrected (see redhat's bugzilla for more
1015 So please download the fixed package (4.0.4pl1-9) and the problem
1017 And that fixes the \r\n problem with file uploads!
1019 [1.10] I'm having troubles when uploading files with phpMyAdmin
1020 running on a secure server. My browser is Internet Explorer and I'm
1021 using the Apache server.
1022 As suggested by "Rob M" in the phpWizard forum, add this line to your
1024 SetEnvIf User-Agent ".*MSIE.*" nokeepalive ssl-unclean-shutdown
1025 It seems to clear up many problems between IE and SSL.
1027 [1.11] I get an 'open_basedir restriction' while uploading a file from
1029 Since version 2.2.4, phpMyAdmin supports servers with open_basedir
1030 restrictions. Assuming that the restriction allows you to open files
1031 in the current directory ('.'), all you have to do is create a 'tmp'
1032 directory under the phpMyAdmin install directory, with permissions 777
1033 and the same owner as the owner of your phpMyAdmin directory. The
1034 uploaded files will be moved there, and after execution of your SQL
1037 [1.12] I have lost my MySQL root password, what can I do?
1038 The MySql manual explains how to reset the permissions.
1040 [1.13] I get an error 'No SQL query' when trying to execute a
1042 If PHP does not have read/write access to its upload_tmp_dir, it
1043 cannot access the uploaded query.
1045 [1.14] I get an error 'No SQL query' when trying to submit a query
1046 from the convenient text area.
1047 Check the post_max_size directive from your php configuration file and
1050 [1.15] I have problems with mysql.user field names.
1051 In older MySQL versions, the User and Password fields were named user
1052 and password. Please modify your field names to align with current
1055 [1.16] I cannot upload big dump files.
1056 The first things to check (or ask your host provider to check) are the
1057 values of upload_max_filesize, memory_limit and post_max_size in the
1058 php.ini configuration file.
1059 All of these three settings limit the maximum size of data that can be
1060 submitted and handled by php. One user also said that post_max_size
1061 and memory_limit need to be larger than upload_max_filesize.
1063 [1.17] Does phpMyAdmin support MySQL 4?
1064 MySQL 4 is not yet fully supported by phpMyAdmin.
1065 Because of MySQL 4's backwards compatibility you can use phpMyAdmin
1066 for administering MySQL 4 servers, but phpMyAdmin does not yet support
1067 its new features. Please notice that in this case it is recommended to
1068 use php >= 4.1 since older versions of php are not compatible to
1070 Furthermore, several users reported problems with phpMyAdmin related
1071 to bugs in MySQL 4. MySQL 4 is still an alpha release and should be
1072 used for test purposes only!
1074 [1.18] I'm running MySQL <= 4.0.1 having lower_case_table_names set to
1075 1. If I create a new table with a capital letter in its name it is
1076 changed to lowercase as it should. But if I try to DROP this table
1077 MySQL is unable to find the corresponding file.
1078 This is a bug of MySQL <= 4.0.1. Please upgrade to at least
1079 MySQL 4.0.2 or turn off your lower_case_table_names directive.
1081 [1.19] I can't run the "display relations" feature because the script
1082 seems not to know the font face I'm using!
1083 The "FPDF" library we're using for this feature requires some special
1084 files to use font faces.
1085 Please refers to the FPDF manual to build these files.
1087 [1.20] I receive the error "cannot load MySQL extension, please check
1089 To connect to a MySQL server, PHP needs a set of MySQL functions
1090 called "MySQL extension". This extension may be part of the PHP server
1091 (compiled-in), otherwise it needs to be loaded dynamically. Its name
1092 is probably mysql.so or mysql.dll. phpMyAdmin tried to load the
1093 extension but failed.
1094 Usually, the problem is solved by installing a software package called
1095 "PHP-MySQL" or something similar.
1097 [1.21] I am running the CGI version of PHP under Unix, and I cannot
1098 login using cookie auth.
1099 In php.ini, set mysql.max_links higher than 1.
1101 [1.22] I don't see the "Location of text file" field, so I cannot
1103 This is most likely because in php.ini, your file_uploads parameter is
1106 [1.23] I'm running MySQL on a Win32 machine. Each time I create a new
1107 table the table and field names are changed to lowercase!
1108 This happens because the MySQL directive lower_case_table_names
1109 defaults to 1 (ON) in the Win32 version of MySQL. You can change this
1110 behavior by simply changing the directive to 0 (OFF):
1111 Just edit you my.ini file that should be located in your Windows
1112 directory and add the following line:
1113 lower-case-table-names=0
1114 Next, save the file and restart the MySQL service. You can always
1115 check the value of this directive using the query
1116 SHOW VARIABLES LIKE 'lower_case_table_names';
1118 [1.24] Some characters are being truncated in my queries, or I get
1119 characters randomly added. I am running PHP 4.2.3.
1120 This is a PHP 4.2.3 bug.
1124 [2.1] The error message "Warning: Cannot add header information -
1125 headers already sent by ..." is displayed, what's the problem?
1126 Edit your config.inc.php or .php3 file and ensure there is nothing (ie
1127 no blank lines, no spaces, no characters...) neither before the <?php
1128 tag at the beginning, neither after the ?> tag at the end.
1130 [2.2] phpMyAdmin can't connect to MySQL. What's wrong?
1131 Either there is an error with your PHP setup or your username/password
1132 is wrong. Try to make a small script which uses mysql_connect and see
1133 if it works. If it doesn't, it may be you haven't even compiled MySQL
1136 [2.3] The error message "Warning: MySQL Connection Failed: Can't
1137 connect to local MySQL server through socket '/tmp/mysql.sock'
1138 (111)..." is displayed. What can I do?
1139 For RedHat users, Harald Legner suggests this on the mailing list:
1140 On my RedHat-Box the socket of mysql is /var/lib/mysql/mysql.sock. In
1141 your php.ini you will find a line
1142 mysql.default_socket = /tmp/mysql.sock
1144 mysql.default_socket = /var/lib/mysql/mysql.sock
1145 Then restart apache and it will work.
1146 Here is a fix suggested by Brad Ummer in the phpwizard forum:
1147 * First, you need to determine what socket is being used by MySQL.
1148 To do this, telnet to your server and go to the MySQL bin
1149 directory. In this directory there should be a file named
1150 mysqladmin. Type ./mysqladmin variables, and this should give you
1151 a bunch of info about your MySQL server, including the socket
1152 (/tmp/mysql.sock, for example).
1153 * Then, you need to tell PHP to use this socket.
1154 Assuming you are using PHP 3.0.10 or better, you can specify the
1155 socket to use when you open the connection. To do this in
1156 phpMyAdmin, you need to complete the socket information in the
1158 For example: $cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock';
1160 Have also a look at the corresponding section of the MySQL
1163 [2.4] Nothing is displayed by my browser when I try to run phpMyAdmin,
1165 Try to set the $cfg['OBGZip'] directive to FALSE in the phpMyAdmin
1166 configuration file. It helps sometime.
1167 Also have a look at your php version number: if it contains "4.0b..."
1168 it means you're running a beta version of PHP. That's not a so good
1169 idea, please upgrade to a plain revision.
1171 [2.5] Each time I want to insert or change a record or drop a database
1172 or a table, an error 404 (page not found) is displayed or, with http
1173 or cookie authentication, I'm asked to login again. What's wrong?
1174 Check the value you set for the $cfg['PmaAbsoluteUri'] directive in
1175 the phpMyAdmin configuration file.
1177 [3. Known limitations]
1179 [3.1] When using http authentication, an user who logged out can not
1180 relog in with the same nick.
1181 This is related to the authentication mechanism (protocol) used by
1182 phpMyAdmin. We plan to change it as soon as we may find enough free
1183 time to do it, but you can bypass this problem: just close all the
1184 opened browser windows and then go back to phpMyAdmin. You should be
1185 able to logs in again.
1187 [3.2] When dumping a large table in compressed mode, I get a memory
1188 limit error or a time limit error.
1189 As of version 2.2.4, we build the compressed dump in memory, so large
1190 tables dumps may hang. The only alternative we can think about (using
1191 system calls to mysqldump then gzip or bzip2) would not be applicable
1192 in environments where PHP is in safe mode: access to system programs
1193 is is limited by the system administrator, and time limit is enforced.
1195 [3.3] With InnoDB tables, I lose foreign key relationships when I
1196 rename or alter a table.
1197 This seems to be a InnoDB bug (fixed in MySQL 3.23.50?). However, keep
1198 in mind that phpMyAdmin as of version 2.3.0 does not support InnoDB.
1200 [4. ISPs, multi-user installations ]
1202 [4.1] I'm an ISP. Can I setup one central copy of phpMyAdmin or do I
1203 need to install it for each customer?
1204 Since version 2.0.3, you can setup a central copy of phpMyAdmin for
1205 all your users. The development of this feature was kindly sponsored
1206 by NetCologne GmbH. This requires a properly setup MySQL user
1207 management and phpMyAdmin http or cookie authentication. See the
1208 install section on "Using http authentication".
1210 [4.2] What's the preferred way of making phpMyAdmin secure against
1212 This depends on your system.
1213 If you're running a server which cannot be accessed by other people,
1214 it's sufficient to use the directory protection bundled with your
1215 webserver (with Apache you can use .htaccess files, for example).
1216 If other people have telnet access to your server, you should use
1217 phpMyAdmin's http authentication feature.
1219 * Your config.inc.php3 file should be chmod 660.
1220 * All your phpMyAdmin files should be chown phpmy.apache, where
1221 phpmy is a user whose password is only known to you, and apache is
1222 the group under which Apache runs.
1223 * You should use PHP safe mode, to protect from other users that try
1224 to include your config.inc.php3 in their scripts.
1226 [4.3] I get errors about not being able to include a file in /lang or
1228 Check php.ini, or ask your sysadmin to check it. The include_path must
1229 contain "." somewhere in it, and open_basedir, if used, must contain
1230 "." and "./lang" to allow normal operation of phpMyAdmin.
1232 [4.4] phpMyAdmin always gives "Access denied" when using http
1234 This could happen for several reasons:
1235 * $cfg['Servers'][$i]['controluser'] and/or
1236 $cfg['Servers'][$i]['controlpass'] are wrong.
1237 * The username/password you specify in the login-dialog are invalid.
1238 * You have already setup a security mechanism for the
1239 phpMyAdmin-directory, eg. a .htaccess file. This would interfere
1240 with phpMyAdmin's authentication, so remove it.
1242 [4.5] Is it possible to let users create their own databases?
1243 Starting with 2.2.5, in the user management page, you can enter a
1244 wildcard database name for a user, and put the privileges you want.
1245 For example, adding SELECT, INSERT, UPDATE, DELETE, CREATE, DROP,
1246 INDEX, ALTER would let a user create/manage his/her database(s).
1248 [4.6] How can I use the Host-based authentication additions?
1249 If you have existing rules from an old .htaccess file, you can take
1250 them and add a username between the 'deny'/'allow' and 'from' strings.
1251 Using the username wildcard of '%' would be a major benefit here if
1252 your installation is suited to using it. Then you can just add those
1253 updated lines into the $cfg['Servers'][$i]['AllowDeny']['rules']
1255 If you want a pre-made sample, you can try this fragment. It stops the
1256 'root' user from logging in from any networks other than the private
1258 //block root from logging in except from the private networks
1259 $cfg['Servers'][$i]['AllowDeny']['order'] = 'deny,allow';
1260 $cfg['Servers'][$i]['AllowDeny']['rules'] = array(
1261 'deny root from all',
1262 'allow root from localhost',
1263 'allow root from 10.0.0.0/8',
1264 'allow root from 192.168.0.0/16',
1265 'allow root from 172.16.0.0/12',
1268 [5. Browsers or client OS]
1270 [5.1] I get an out of memory error, and my controls are
1271 non-functional, when trying to create a table with more than 14
1273 We could reproduce this problem only under Win98/98SE. Testing under
1274 WinNT4 or Win2K, we could easily create more than 60 fields.
1275 A workaround is to create a smaller number of fields, then come back
1276 to your table properties and add the other fields.
1278 [5.2] With Xitami 2.5b4, phpMyAdmin won't process form fields.
1279 This is not a phpMyAdmin problem but a Xitami known bug: you'll face
1280 it with each script/website that use forms.
1281 Upgrade or downgrade your Xitami server.
1283 [5.3] I have problems dumping tables with Konqueror (phpMyAdmin 2.2.2)
1284 With Konqueror 2.1.1: plain dumps, zip and gzip dumps work ok, except
1285 that the proposed file name for the dump is always 'tbl_dump.php'.
1286 Bzip2 dumps don't seem to work.
1287 With Konqueror 2.2.1: plain dumps work; zip dumps are placed into the
1288 user's temporary directory, so they must be moved before closing
1289 Konqueror, or else they disappear. Gzip dumps give an error message.
1290 Testing needs to be done for Konqueror 2.2.2.
1292 [5.4] I can't use the cookie authentication mode because Internet
1293 Explorer never stores the cookies.
1294 MS Internet Explorer seems to be really buggy about cookies, at least
1295 till version 6. And thanks to Andrew Zivolup we've traced also a php
1296 4.1.1 bug in this area!
1297 Then, if you're running php 4.1.1, try to upgrade or downgrade... it
1300 [5.5] In Internet Explorer 5.0, I get Javascript errors when browsing
1302 Upgrade to at least Internet Explorer 5.5SP2.
1304 [5.6] In Internet Explorer 5.0, 5.5 or 6.0, I get an error when trying
1305 to modify a row in a table with many fields, or with a text field.
1306 Your table neither have a primary key nor an unique one, so we must
1307 use a long URL to identify this row. There is a limit on the lenght of
1308 the URL in those browsers, and this not happen in Netscape, for
1309 example. The workaround is to create a primary or unique key, or use
1312 [5.7] I refresh (reload) my browser, and come back to the welcome
1314 Some browsers support right-clicking into the frame you want to
1315 refresh, just do this in the right frame.
1317 [5.8] With Mozilla 0.9.7 I have problems sending a query modified in
1319 Looks like a Mozilla bug: 0.9.6 was ok. We will keep an eye on future
1322 [5.9] With Mozilla 0.9.? to 1.0 and Netscape 7.0-PR1 I can't type a
1323 whitespace in the SQL-Query edit area: the page scrolls down.
1324 This is a Mozilla bug (see bug #26882 at Bugzilla).
1326 [5.10] With Netscape 4.75 I get empty rows between each row of data in
1327 a CSV exported file.
1328 This is a known Netscape 4.75 bug: it adds some line feeds when
1329 exporting data in octet-stream mode. Since we can't detect the
1330 specific Netscape version, we cannot workaround this bug.
1332 [6. Using phpMyAdmin]
1334 [6.1] I can't insert new rows into a table / I can't create a table -
1335 MySQL brings up a SQL-error.
1336 Examine the SQL error with care. Often the problem is caused by
1337 specifying a wrong field-type.
1338 Common errors include:
1339 * Using VARCHAR without a size argument
1340 * Using TEXT or BLOB with a size argument
1342 Also, look at the syntax chapter in the MySQL manual to confirm that
1343 your syntax is correct.
1345 [6.2] When I create a table, I click the Index checkbox for 2 fields
1346 and phpMyAdmin generates only one index with those 2 fields.
1347 In phpMyAdmin 2.2.0 and 2.2.1, this is the way to create a
1348 multi-fields index. If you want two indexes, create the first one when
1349 creating the table, save, then display the table properties and click
1350 the Index link to create the other index.
1352 [6.3] How can I insert a null value into my table?
1353 Since version 2.2.3, you have a checkbox for each field that can be
1354 null. Before 2.2.3, you had to enter "null", without the quotes, as
1357 [6.4] How can I backup my database or table?
1358 Click on a database or table name in the left frame, the properties
1359 will be displayed. Then on the menu, click "Export", you can dump the
1360 structure, the data, or both. This will generate standard SQL
1361 statements that can be used to recreate your database/table.
1362 You will need to choose "Save as file", so that phpMyAdmin can
1363 transmit the resulting dump to your station. Depending on your PHP
1364 configuration, you will see options to compress the dump. See also the
1365 $cfg['ExecTimeLimit'] configuration variable.
1366 For additional help on this subject, look for the word "dump" in this
1369 [6.5] How can I restore (upload) my database or table using a dump?
1370 How can I run a ".sql" file?
1371 Click on a database name in the left frame, the properties will be
1372 local displayed. Then in the "Run SQL query" section, type in your
1373 dump filename, or use the Browse button. Then click Go.
1374 For additional help on this subject, look for the word "upload" in
1377 [6.6] How can I use the relation table in Query-by-example?
1378 Here is an example with the tables persons, towns and countries, all
1379 located in the database mydb. If you don't have a PMA_relation table,
1380 create it as explained in the configuration section. Then create the
1382 CREATE TABLE REL_countries (
1383 country_code char(1) NOT NULL default '',
1384 description varchar(10) NOT NULL default '',
1385 PRIMARY KEY (country_code)
1387 INSERT INTO REL_countries VALUES ('C', 'Canada');
1388 CREATE TABLE REL_persons (
1389 id tinyint(4) NOT NULL auto_increment,
1390 person_name varchar(32) NOT NULL default '',
1391 town_code varchar(5) default '0',
1392 country_code char(1) NOT NULL default '',
1395 INSERT INTO REL_persons VALUES (11, 'Marc', 'S', '');
1396 INSERT INTO REL_persons VALUES (15, 'Paul', 'S', 'C');
1397 CREATE TABLE REL_towns (
1398 town_code varchar(5) NOT NULL default '0',
1399 description varchar(30) NOT NULL default '',
1400 PRIMARY KEY (town_code)
1402 INSERT INTO REL_towns VALUES ('S', 'Sherbrooke');
1403 INSERT INTO REL_towns VALUES ('M', 'Montréal');
1404 INSERT INTO `PMA_relation` VALUES ('mydb', 'REL_persons',
1405 'town_code', 'mydb', 'REL_towns', 'town_code');
1406 INSERT INTO `PMA_relation` VALUES ('mydb', 'REL_persons',
1407 'country_code', 'mydb', 'REL_countries', 'country_code');
1408 INSERT INTO `PMA_table_info` VALUES ('mydb', 'REL_towns',
1410 INSERT INTO `PMA_table_info` VALUES ('mydb', 'REL_countries',
1412 Then test like this:
1413 * Click on your db name in the left frame
1415 * Use tables: persons, towns, countries
1416 * Click "Update query"
1417 * In the fields row, choose persons.person_name and click the "Show"
1419 * Do the same for towns.description and countries.descriptions in
1421 * Click "Update query" and you will see in the query box that the
1422 correct joins have been generated
1423 * Click "Submit query"
1425 [6.7] How can I use the "display field" feature?
1426 Starting from the previous example, create the PMA_table_info as
1427 explained in the configuration section, then browse your persons
1428 table, and move the mouse over a town code or country code.
1430 [6.8] How can I produce a PDF schema of my database?
1431 First you have to fill the "relation", "table_coords" and "pdf_pages"
1432 configuration variables.
1433 Then, think about your schema layout: which tables will go on which
1435 * Click on your db name in the left frame
1436 * Choose "Structure" in the navigation on top
1437 * Choose "Edit PDF Pages" which should be somewhere at the bottom of
1439 * Enter the name for a first pdf page and submit
1440 * Choose this page to edit
1441 * Now add a table you want to show on this page and it's coordinates
1443 First you will have to guess this coordinates of course, so just
1444 expect to have an area of about 297 * 210 and put the tables
1445 coordinates somewhere in there, you will be able to have a look at
1446 what happened and change them later.
1447 For example, x=100 and y=200 means that the table will be at 200
1448 mm down and 100 mm right from the upper left corner.
1449 Actually if you have a width of more than 300 or a height of more
1450 than 200 than it will automatically be scaled but 300*100 is a
1451 good start to have an idea of what coordinates to use.
1452 * After every table you submitted you will have the possibility to
1454 * When you have entered enough tables Click on your db name in the
1456 * Now, again at the bottom of the page you should be able to choose
1457 "Display PDF schema"
1458 For testing it might be useful to show the grid as well, so you
1459 can see the coordinates used.
1460 Maybe also choose color and submit.
1461 * Save the file he will offer you to something like Schema.pdf
1462 (Internet Explorer has some bug there which might make it offer it
1463 without an extension. Under Windows it is important to have the
1464 extension ".pdf", under other OSes you should be fine just saving
1465 the file under the name it offers).
1467 [6.9] phpMyAdmin is changing the type of one of my columns!
1468 No, it's MySQL that is doing silent column type changing.
1470 [6.10] My database has an underscore in it's name, and when I grant
1471 privileges to a user for this database, a backslash is added before
1473 This is normal and means that the grant is done only for this
1474 database. If there was no backslash, this would be a wildcard grant,
1475 and the underscore would mean "any character". So, if the database
1476 name is "john_db", the user would get rights to john1db, john2db...
1477 instead of just john_db.
1478 If you really want to grant using a wildcard, there is a dialog box "
1479 Database (wildcards allowed)" for this.
1481 [6.11] What is the curious symbol ø in the table statistics?
1484 [6.12] I want to understand some Export options.
1485 "Complete inserts" adds the column names on every INSERT command, for
1486 better documentation (but resulting file is bigger).
1487 "Extended inserts" provides a shorter dump file by using only once the
1488 INSERT verb and the table name.
1489 "Enclose table and field names with backquotes" ensures that field and
1490 table names formed with special characters are protected.
1492 [6.13] I would like to create a database with a dot in its name.
1493 This is a bad idea, because in MySQL the syntax "database.table" is
1494 the normal way to reference a database and table name. Worse, MySQL
1495 will usually let you create a database with a dot, but then you cannot
1496 work with it, nor delete it.
1498 [6.14] How do I set up the SQL validator?
1499 To use it, you need a very recent version of PHP, built with Overload,
1500 XML and PEAR support. On your system command line, run "pear install
1501 Mail_Mime Net_DIME SOAP" to get the nessecary PEAR modules for usage.
1502 If you use it, you should be aware that any SQL statement you submit
1503 will be stored anonymously (database/table/column names, strings,
1504 numbers replaced with generic values). The Mimer SQL Validator itself,
1505 is © 2001 Upright Database Technology. We utilize it as free XML-SOAP
1507 The overload module is crucial to the functionality of the validator
1510 [6.15] I want to add a BLOB field and put an index on it, but MySQL
1511 says "BLOB column '...' used in key specification without a key
1513 The right way to do this, is to create the field without any indexes,
1514 then display the table structure and use the "Create an index" dialog.
1515 On this page, you will be able to choose your BLOB field, and set a
1516 size to the index, which is the condition to create an index on a BLOB
1519 [7. phpMyAdmin project]
1521 [7.1] I have found a bug. How do I inform developers?
1522 Our Bug Tracker is located at
1523 http://sourceforge.net/projects/phpmyadmin/ under the Bugs section.
1524 But please first discuss your bug with other users:
1525 http://sourceforge.net/projects/phpmyadmin/ (and choose Forums)
1527 [7.2] I want to translate the messages to a new language or upgrade an
1528 existing language, where do I start?
1529 Always use the current cvs version of your language file. For a new
1530 language, start from english-iso-8859-1.inc.php3. If you don't know
1531 how to get the cvs version, please ask one of the developers.
1532 Please note that we try not to use html entities like é in the
1533 translations, since we define the right character set in the file.
1534 With html entities, the text on buttons would not display correctly.
1535 You can then put your translations, as a zip file to avoid losing
1536 special characters, on the sourceforge.net translation tracker.
1537 It would be a good idea to subscribe to the phpmyadmin-translators
1538 mailing list, because this is where we ask for translations of new
1541 [7.3] I would like to help out with the development of phpMyAdmin. How
1543 The following method is preferred for new developers:
1544 * fetch the current CVS tree over anonymous CVS:
1546 -d:pserver:anonymous@cvs.phpmyadmin.sourceforge.net:/cvsroot/phpmy
1548 [Password: simply press the Enter key]
1550 -d:pserver:anonymous@cvs.phpmyadmin.sourceforge.net:/cvsroot/phpmy
1551 admin checkout phpMyAdmin
1552 [This will create a new sub-directory named phpMyAdmin]
1554 * put the modified files (tar'ed and gzip'ed) inside the patch
1555 tracker of the phpMyAdmin SourceForge account.
1557 Write access to the CVS tree is granted only to experienced developers
1558 who have already contributed something useful to phpMyAdmin.
1559 Also, have a look at the Developers section.
1560 ______________________________________________________________________
1562 Top - Requirements - Introduction - Installation -
1563 Configuration - FAQ - Developers - Credits
1564 ______________________________________________________________________
1566 Developers Information
1568 phpMyAdmin is Open Source, so you're invited to contribute to it. Many
1569 great features have been written by other people and you too can help
1570 to make phpMyAdmin a useful tool.
1572 If you're planning to contribute source, please read the following
1574 * All files include header.inc.php3 (layout),
1575 libraries/common.lib.php3 (common functions) and config.inc.php3.
1576 All configuration data belongs in config.inc.php3. Please keep it
1577 free from other code.
1578 Commonly used functions should be added to
1579 libraries/common.lib.php3 and more specific ones may be added
1580 within a library stored into the libraries sub-directory.
1581 * Obviously, you're free to use whatever coding style you want. But
1582 please try to keep your code as simple as possible: beginners are
1583 using phpMyAdmin as an example application.
1584 As far as possible, we want the scripts to be XHTML1.0 and CSS2
1585 compliant on one hand, they fit PEAR coding standards on the other
1586 hand. Please pay attention to this.
1587 * Please try to keep up the file-naming conventions. Table-related
1588 stuff goes to tbl_*.php3, db-related code to db_*.php3 and so on.
1589 * Please don't use verbose strings in your code, instead add the
1590 string (at least) to english-iso-8859-1.inc.php3 and print() it
1592 * If you want to be really helpful, write an entry for the
1595 IMPORTANT: With 1.4.1, development has switched to CVS. The following
1596 method is preferred for new developers:
1597 * fetch the current CVS tree over anonymous CVS:
1599 -d:pserver:anonymous@cvs.phpmyadmin.sourceforge.net:/cvsroot/phpmy
1601 [Password: simply press the Enter key]
1603 -d:pserver:anonymous@cvs.phpmyadmin.sourceforge.net:/cvsroot/phpmy
1604 admin checkout phpMyAdmin
1605 [This will create a new sub-directory named phpMyAdmin]
1607 * put the modified files (tar'ed and gzip'ed) inside the patch
1608 tracker of the phpMyAdmin SourceForge account
1609 (http://sourceforge.net/projects/phpmyadmin/)
1611 Write access to the CVS tree is granted only to developers who have
1612 already contributed something useful to phpMyAdmin. If you're
1613 interested in that, please contact us using the phpmyadmin-devel
1615 ______________________________________________________________________
1617 Top - Requirements - Introduction - Installation -
1618 Configuration - FAQ - Developers - Credits
1619 ______________________________________________________________________
1624 phpMyAdmin - Credits
1625 ====================
1627 CREDITS, in chronological order
1628 -------------------------------
1630 - Tobias Ratschiller <tobias.ratschiller_at_maguma.com>
1631 * creator of the phpmyadmin project
1632 * maintainer from 1998 to summer 2000
1634 - Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca>
1635 * multi-language version
1636 * various fixes and improvements
1637 * project co-administrator
1639 - Olivier Müller <om_at_omnis.ch>
1640 * started SourceForge phpMyAdmin project in March 2001
1641 * sync'ed different existing CVS trees with new features and bugfixes
1642 * multi-language improvements, dynamic language selection
1643 * current project maintainer
1644 * many bugfixes and improvements
1646 - Loïc Chapeaux <lolo_at_phpheaven.net>
1647 * rewrote and optimized javascript, DHTML and DOM stuff
1648 * rewrote the scripts so they fit the PEAR coding standards and
1649 generate XHTML1.0 and CSS2 compliant codes
1650 * improved the language detection system
1651 * many bugfixes and improvements
1653 - Robin Johnson <robbat2_at_users.sourceforge.net>
1654 * database maintence controls
1656 * Host authentication IP Allow/Deny
1657 * DB-based configuration (Not completed)
1660 * many bugfixes and improvements
1662 - Armel Fauveau <armel.fauveau_at_globalis-ms.com>
1664 * multiple dump feature
1668 - Geert Lund <glund_at_silversoft.dk>
1670 * moderator of the phpMyAdmin users forum at phpwizard.net
1672 - Korakot Chaovavanich <korakot_at_iname.com>
1673 * "insert as new row" feature
1675 - Pete Kelly <webmaster_at_trafficg.com>
1676 * rewrote and fix dump code
1679 - Steve Alberty <alberty_at_neptunlabs.de>
1680 * rewrote dump code for PHP4
1681 * mySQL table statistics
1684 - Benjamin Gandon <gandon_at_isia.cma.fr>
1685 * main author of the version 2.1.0.1
1688 - Alexander M. Turek <rabus_at_bugfixes.info>
1690 * MySQL 4 related features
1691 * various small features and fixes
1692 * German language file updates
1694 - Mike Beck <mike.beck_at_ibmiller.de>
1695 * automatic joins in QBE
1696 * links column in printview
1699 - Michal Cihar <nijel_at_users.sourceforge.net>
1700 * enhanced index creation/display feature
1701 * feature to use a different charset for HTML than for MySQL
1702 * Czech language file updates
1704 - Christophe Gesché from the "MySQL Form Generator for PHPMyAdmin"
1705 (http://sourceforge.net/projects/phpmysqlformgen/)
1706 * suggested the patch for multiple table printviews
1708 - Garvin Hicking <hicking_at_faktor-e.de>
1709 * built the patch for vertical display of table rows
1711 - Yukihiro Kawada <kawada_at_den.fujifilm.co.jp>
1712 * japanese kanji encoding conversion feature
1714 - Piotr Roszatycki <d3xter_at_users.sourceforge.net> and Dan Wilson
1715 * the Cookie authentication mode
1717 - Axel Sander <n8falke_at_users.sourceforge.net>
1718 * table relation-links feature
1720 - Maxime Delorme <delorme.maxime_at_free.fr>
1721 * PDF schema output, thanks also to Olivier Plathey for the
1722 "FPDF" library (see http://www.fpdf.org/).
1724 - Olof Edlund <olof.edlund_at_upright.se>
1725 * SQL validator server
1727 - Ivan R. Lanin <ivanlanin_at_users.sourceforfe.net>
1730 And also to the following people who have contributed minor changes,
1731 enhancements, bugfixes or support for a new language since version 2.1.0:
1733 Bora Alioglu, Ricardo ?, Sven-Erik Andersen, Alessandro Astarita,
1734 Péter Bakondy, Borges Botelho, Olivier Bussier, Neil Darlow,
1735 Laurent Dhima, Kristof Hamann, Thomas Kläger, Lubos Klokner,
1736 Martin Marconcini, Girish Nair, David Nordenberg, Andreas Pauley,
1737 Bernard M. Piller, Laurent Haas, "Sakamoto", Yuval Sarna,
1738 www.securereality.com.au, Alvar Soome, Siu Sun, Peter Svec, Michael Tacelosky,
1739 Rachim Tamsjadi, Kositer Uros, Luís V., Martijn W. van der Lee,
1740 Algis Vainauskas, Daniel Villanueva, Vinay, Ignacio Vazquez-Abrams, Chee Wai,
1741 Jakub Wilk, Thomas Michael Winningham, Vilius Zigmantas.
1744 Original Credits of Version 2.1.0
1745 ---------------------------------
1747 This work is based on Peter Kuppelwieser's MySQL-Webadmin. It was his idea
1748 to create a web-based interface to MySQL using PHP3. Although I have not
1749 used any of his source-code, there are some concepts I've borrowed from
1750 him. phpMyAdmin was created because Peter told me he wasn't going to
1751 further develop his (great) tool.
1753 - Amalesh Kempf <ak-lsml_at_living-source.com> who contributed the
1754 code for the check when dropping a table or database. He also suggested
1755 that you should be able to specify the primary key on tbl_create.php3. To
1756 version 1.1.1 he contributed the ldi_*.php3-set (Import text-files) as
1757 well as a bug-report. Plus many smaller improvements.
1758 - Jan Legenhausen <jan_at_nrw.net>: He made many of the changes that
1759 were introduced in 1.3.0 (including quite significant ones like the
1760 authentication). For 1.4.1 he enhanced the table-dump feature. Plus
1762 - Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca> made phpMyAdmin
1763 language-independent by outsourcing the strings to a separate file. He
1764 also contributed the French translation.
1765 - Alexandr Bravo <abravo_at_hq.admiral.ru> who contributed
1766 tbl_select.php3, a feature to display only some fields from a table.
1767 - Chris Jackson <chrisj_at_ctel.net> added support for MySQL
1768 functions in tbl_change.php3. He also added the
1769 "Query by Example" feature in 2.0.
1770 - Dave Walton <walton_at_nordicdms.com> added support for multiple
1771 servers and is a regular contributor for bug-fixes.
1772 - Gabriel Ash <ga244_at_is8.nyu.edu> contributed the random access
1774 The following people have contributed minor changes, enhancements, bugfixes
1775 or support for a new language:
1776 Jim Kraai, Jordi Bruguera, Miquel Obrador, Geert Lund, Thomas Kleemann,
1777 Alexander Leidinger, Kiko Albiol, Daniel C. Chao, Pavel Piankov,
1778 Sascha Kettler, Joe Pruett, Renato Lins, Mark Kronsbein, Jannis Hermanns,
1781 And thanks to everyone else who sent me email with suggestions, bug-reports
1782 and or just some feedback.
1783 ______________________________________________________________________
1785 Top - Requirements - Introduction - Installation -
1786 Configuration - FAQ - Developers - Credits
1787 ______________________________________________________________________
1789 Valid XHTML 1.0! Valid CSS!