3.3. How to install PHP-Nuke through phpMyAdmin

3.3.1. What Is PHPMyadmin

PHPMyAdmin is a visual system for the management of a MySQL database (see Figure 3-6). It is written in PHP and serves to display the contents of the databases on the server (or client) on which MySQL is installed. Through this interface you can create new databases, modify existing ones and modify the contents of single fields.

3.3.2. How to install phpMyAdmin

Local installation under Windows is very simple: you only need to extract the files from the archive you downloaded from the official phpBB site and point your browser to the address http://localhost/phpmyadmin. You will then see a screen as in Figure 3-6.

If you are working locally, don't worry about any warnings you might get. In case you have to install phpMyAdmin on your server, e.g. when your ISP does not offer a preinstalled administration panel for the database, you must configure the config.inc.php file that comes with it:

Supposing that your data are:

• IP of the database server: 156.123.22.34

• User: Pippo

• Password: Topolino

• Database name: Minnie

then the necessary entries in config.inc.php look like this:

$cfgServers[1]["host"] = "156.123.22.34"; // MySQL hostname
$cfgServers[1]["port"] = ""; // MySQL port - leave blank for default port
$cfgServers[1]["adv_auth"] = false; // Use advanced authentication?
$cfgServers[1]["stduser"] = ""; // MySQL standard user (only needed with advanced auth)
$cfgServers[1]["stdpass"] = ""; // MySQL standard password (only needed with advanced auth)
$cfgServers[1]["user"] = "Pippo"; // MySQL user (only needed with basic auth)
$cfgServers[1]["password"] = "Topolino"; // MySQL password (only needed with basic auth)
$cfgServers[1]["only_db"] = "Minnie"; // If set to a db-name, only this db is accessible
$cfgServers[1]["verbose"] = ""; // Verbose name for this host - leave blank to show the hostname
$cfgServers[1]["bookmarkdb"] = ""; // Bookmark db - leave blank for no bookmark support
$cfgServers[1]["bookmarktable"] = ""; // Bookmark table - leave blank for no bookmark support

In the config.inc.php you will find more configuration parameters that are repeated. They serve to manage DBs in various hosts with the same interface.