http://www.htmlwizard.net/phpMyAdmin/
Tobias Ratschiller
Main documentation: Documentation.php3
Version history: ChangeLog
Installation instructions: INSTALL
General notes: README
All configurable data is placed in config.inc.php3. This file is included in header.inc.php3 (which means in every file).
$hostname string
The hostname of your MySQL-server. E.g. localhost.
$adv_auth boolean
Whether basic or advanced authentification should be used. Basic authentification
($adv_auth = false) is the plain old way: username and password are stored in
config.inc.php3. Advanced authentification $adv_auth = true) as introduced in
1.3.0 allows you to log in as any valid MySQL user via HTTP-Auth. All you have
to provide in config.inc is a standard user which can connect to MySQL and read
the mysql user table.
Using advanced authentification is recommended:
$user string
$password string
The user/password-pair which phpMyAdmin will use to connect to the MySQL-server
specified with $hostname when using basic authentification. Not needed when
using advanced authentification.
$stduser string
$stdpass string
A user/pasword pair used to verify the real user/password pair when using advanced
authentification. This user must be able to connect to MySQL and read the mysql
user table. Not needed when using basic authentification.
$only_db string
If set to a database name, only this database will be shown to the user.
$manual_base string
If set to an URL which points to the MySQL documentation, appropriate help links
are generated.
$persistent_connections boolean
Whether persistent connections should be used or not (mysql_connect or mysql_pconnect).
$mysqladmin string
Path to mysqladmin. Only used to reload MySQL.
$column_types array
All possible types of a MySQL column. In most cases you don't need to edit this.
$confirm boolean
Whether a warning ("Are your really sure..") should be displayed when
you're about to loose data.
$max_rows integer
Number of rows displayed when browsing a resultset. If the resultset contains
more rows, Previous/Next links will be shown.
$max_inputsize integer
Size of the edit-field when adding a new record to a table.
$border integer
The size of a table's border.
$th_bgcolor string [HTML color]
The color (HTML) used for table headers.
$bgcolor_one string [HTML color]
The color (HTML) #1 for table rows.
$bgcolor_two string [HTML color]
The color (HTML) #2 for table rows.
$order string ["DESC"|"ASC"]
Defines whether fields are displayed in ascending ("ASC") order or in descending
("DESC") order when you click on the field-name.
$show_blob boolean
Defines whether BLOB fields are shown when browsing a table's content or not.
I can't insert new rows into a table - MySQL brings up a SQL-error.
Most of the time it just that - a SQL error. Probably you're specifying
a wrong field-type. Common errors include:
At least I made this errors often when I started using MySQL :-)
Have a look at the MySQL manual (syntax chapter) when in doubt.
phpMyAdmin can't connect to MySQL. What's wrong?
Either there is an error with your PHP setup or your username/password is
wrong. Try to make a small script which uses mysql_connect and see if it works.
If it doesn't, it may be you haven't even compiled MySQL support into PHP.
I cannot edit the content of a table, even if the README says this is a
feature of phpMyAdmin.
phpMyAdmin allows only editing of a table's content if the table contains
a primary or unique key.
phpMyAdmin always gives "Access denied" when using advanced authentification.
This could happen for some reasons: