5.2. How to install PHP-Nuke through PHPMyadmin

5.2.1. What Is PHPMyadmin

PHPMyAdmin is an visual system for the management of a MySQL database (see Figure 5-2). 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.

Figure 5-2. PHPMyAdmin start screen

PHPMyAdmin start screen

5.2.2. How to install the DB of PHP-Nuke with PHPMyadmin

Clicking on the left bar, depending on the database you selected, you will see a list menu coming up, showing the structure of the database (and, on the same time, the central page will show the enlarged structure of the database), with a series of options, all of them in the bottom of the page (see Figure 5-3). It is these options we are interested in when installing PHP-Nuke.

Figure 5-3. PHPMyAdmin table selection

PHPMyAdmin table selection

What you have to do now, is to click on "browse" and go search for the .sql file that contains the instructions that build the structure of the PHP-Nuke database (see Figure 5-4). Once found, it suffices to click on "Go" and the database will be installed. Of course, if there are errors, they will be reported at the end of the installation procedure. And of course, the same holds for the message "operation succeeded".

Figure 5-4. PHPMyAdmin: SQL query

PHPMyAdmin: SQL query

TipTip
 

Other options of PHPMyAdmin that are not relative to the installation of PHP-Nuke can be found in the tutorial published on www.spaghettibrain.com and in Section 11.3.

Figure 5-5. PHPMyAdmin: table data

PHPMyAdmin: table data

Figure 5-6. PHPMyAdmin: database dump

PHPMyAdmin: database dump

5.2.3. The config.php file

Ok, the last thing that remains to do before starting with the management of your site, is to configure the file config.php This is important because it sets up a connection between the PHP files of PHP-Nuke and the MySQL database that manages it.

There is only a few parameters to configure. When you open the file "config.php" you will see the following near the top:

$dbhost = "localhost"; (1)
$dbuname = "root"; (2)
$dbpass = ""; (3)
$dbname = "nuke"; (4)
$system = "1"; (5)
$prefix = "nuke"; (6)
$user_prefix = "nuke"; 
$dbtype = "MySQL"; 
(1)
In place of "localhost" you will have to put the host/server that the database is installed on.
(2)
In place of "root" you must put your username.
(3)
You will have to insert your password here.
(4)
In place of "nuke" you will have to insert the name of your database here.
(5)
Leave it to 0 if on Linux/Unix systems, put 1 if on a Windows server)
(6)
I recommend this to be left to its default value, "nuke", is the prefix that goes in front of the name of every database table.

Let's do an example:

The file config.php should then look like:

$dbhost = "212.110.12.297";
$dbuname = "Pippo";
$dbpass = "Topolino";
$dbname = "Orazio";
$system = 0;
$prefix = "nuke"; 

CautionAttention!
 

This is case sensitive! Remember to use The Capital Letters!!! On Linux systems, if you write a user name or a password without taking care of letter case, the system will not allow you to log in.

Ok, we are done, the only thing that remains to do is to enter the administration section (www.yoursite.com/admin.php). The very first time you will log in using “God” as username and “Password” as password. I recommend you to change these as soon as possible.

5.2.4. Resources

If you are looking for PHP-Nuke hosting, Spaghettibrain.com has custom offers for you... give us a visit! Spaghettibrain.com is the italian support site for PHP-Nuke, there you will find modules, security patches, support forums and a lot more. Come for a tour soon.