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.
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.
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".
Tip: 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 the Section called PHPMyadmin, administering MySQL via web in Chapter 11.
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"; $dbuname = "root"; $dbpass = ""; $dbname = "nuke"; $system = "1"; $prefix = "nuke"; $user_prefix = "nuke"; $dbtype = "MySQL";
Let's do an example:
Host DB: 22.214.171.1247
User DB: Pippo
Password DB: Topolino
Database Name: Orazio
Operating System Used: Linux (what else!!! :-) )
The file config.php should then look like:
$dbhost = "126.96.36.1997"; $dbuname = "Pippo"; $dbpass = "Topolino"; $dbname = "Orazio"; $system = 0; $prefix = "nuke";
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.