|Guide for beginners and administrators|
phpMyAdmin: Introduction, Installation, Configuration
Currently phpMyAdmin can:
create and drop databases
create, copy, drop, rename and alter tables
delete, edit and add fields
execute any SQL-statement, even batch-queries
manage keys on fields
load text files into tables
create and read dumps of tables
export data to CSV, XML and Latex formats
administer multiple servers
manage MySQL users and privileges
check referential integrity in MyISAM tables
support InnoDB tables and foreign keys (see FAQ 3.6)
support mysqli, the improved MySQL extension (see FAQ 1.17)
communicate in 50 different languages
using Query-by-example (QBE), create complex queries automatically connecting required tables
create PDF graphics of your Database layout
search globally in a database or a subset of it
transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link or ...
You need PHP 4.1.0 or newer, with session support (*)
MySQL 3.23.32 or newer (the best is 5.x.x)
If you want to display inline thumbnails of JPEGs with the original aspect ratio, you also need GD2 support in PHP
* Starting with phpMyAdmin 2.6.1, MIME-based transformations that use an external program need PHP 4.3.0 or newer
* Not really a requirement but a strong suggestion: if you are using the "cookie"
authentication method, having the mcrypt PHP extension on your web server accelerates not only the login phase but every other
action that you do in phpMyAdmin.
* a web-browser (doh!).
Installation of phpmyadmin to a local computer
For testing: in the browser, enter http://localhost/padmin
Altering the configuration file config.inc.php
(Source: www.phpmyadmin.net/documentation and records in the file config.default.php)
Example of a config.inc.php file
$cfg['PmaAbsoluteUri'] = '';
The most important configuration data:
$cfg['PmaAbsoluteUri'] = '';
// Configuring the absolute path to the folder containing phpmyadmin. Usually the auto-detection is used which detects the path, and then there is no need to configure it.
$cfg['PmaAbsoluteUri'] = 'http://localhost/padmin/'; (change made by us)
// Your phpMyAdmin URL. Complete the variable below
with the full url ie http://www.your_web.net/path_to_your_phpMyAdmin_directory/
$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
// Disabling the warning about the
"PmaAbsoluteUri" value not being set up. If it seems that everything works fine, you can change
the value to "TRUE" or to add the previous "PmaAbsoluteUri" value.
$cfg['Servers']['host'] = 'localhost';
$cfg['Servers']['port'] = ''; // MySQL port - leave blank for
//Values specifying detailed setup of the server. We used the default settings without any changes made.
// Defining the extension - whether the older mysql or the newer mysqli (in PHP 5+) should be used.
//The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['PmaNoRelation_DisableWarning'] = FALSE;
//Disable the default warning that is displayed on the DB Details Structure page if any of the required Tables for the relationfeatures could not be found.
$cfg['Servers'][$i]['auth_type'] = 'config';
//Authentication method for access to mysql. You can choose config, http or cookie. Config represents the less safe, but the fastest and the easiest method (with password in the value $cfg['Servers'][$i]['password']). It is much safer to use http or cookie (the password is not saved in the configuration file). If you are sure you do not need to secure the access to the database and the phpMyAdmin application, you can use the "config" method with clear conscience
// Authentication method (config, http or cookie based)?
// User account used for logging in the database.
// MySQL user
//Password for the access to MySQL (required upon using the "config" authentication method).
// MySQL password (only needed with 'config' auth_type)
$cfg['LeftDisplayLogo'] = TRUE;
//Hiding the logo at the top of the left frame linking to www.phpmyadmin.net
$cfg['blowfish_secret'] = '';
// Defining the secret password for encoding the password to cookie on your client server. It is entered only once and you are not required to enter that anymore.
//The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If at least one server configuration uses 'cookie' auth_type, enter here a passphrase that will be used by blowfish.
$cfg['Servers'] vs. $cfg['Servers'][$i] - // [$i] or  have the same importance for identifying the values for the server. The $i value can be replaced by numbers 1,2,3.. and you can define to which configuration of the server this value should be affiliated. Detailed explanation of the configuration of the administration of mysql servers would be a topic for a new larger article. You can also read the documentation.
Frequent error messages:
The version 2.8.0 probably changes some features
Print Print article | Recommend Send link
FAQ (Frequently Asked Questions)