Installing PHPMyAdmin on Windows XP Pro 6

 

 

What do we have in this session 6?

  1. Configuration for PHP v5

  2. More Advanced Settings

 

Configuration for PHP v5

 

Note that this step is only required for PHP v5. Under PHP v4, PHP extension php_mysql.dll is build in and extension php_mysqli is not supported. Edit file php.ini, under the [Dynamic Extensions] Section by un-commenting the following lines (if not done yet).

 

;extension=php_mbstring.dll

...

;extension=php_pdo_mysql.dll

 

The following is the shortcut.

 

Activating the mbstring and php_pdo_mysql PHP module extensions

 

You need to make sure the DLL is available under the ./ext folder. If those DLLs not available, you need to download them.

 

The PHP extension modules DLL php_mbstring.dll file

 

Next, clear the Browser’s cookies and reload the http://localhost/myphpadmin/ (or the URL that you have chosen during the setup).

 

 

 

 

 

 

 

 

 

 

 

 

 

-----------------------------------------------------------------

phpmyadmin in action without mbstring error

 

More Advanced Settings

 

Well, the access works. However this is not what we want. The sample config.inc.php given is very basic that provide limited use. Let use the default given config.inc.php. Find the config.default.php file under C:\Inetpub\wwwroot\phpmyadmin\libraries folder. Firstly you need to rename the original config.inc.php file to other name.

 

The phpmyadmin default config file

 

Then, copy config.default.php file to %your_phpmyadmin_root%\phpmyadmin folder. Rename the config.default.php to config.inc.php. Open the file in WordPad.

Fill in the following line of script.

 

$cfg['blowfish_secret'] = 'dddhg6867877hgghg8908989';

 

With alphanumeric characters as done previously and save the file. Then, reload the phpmyadmin URL.

 

Setting the blowfish_secret for phpmyadmin

 

The phpmyadmin login page

 

Fill-in MySQL root username and its password (as used in MySQL installation). We cannot use pma user because all the configuration are set to defaults. However, by referring the documentation, the defaults value should be fine. (If the parameters are not provided, then the values will be set to defaults);

 

Login phpmyadmin using MySQl root username and its password

 

Well, if it takes so long to login and then the page just blank re-open config.inc.php file and change the host parameter from 'localhost' to '127.0.0.1', save the file.

 

Changing phpmyadmin config file setting from localhost to 127.0.0.1

 

Make sure you clean-up the Browser’s cookies and reload the URL.

 

Another phpmyadmin login page using root username and its password

 

 

phpmyadmin main page in action

 

Now, all the system go!

 

Exploring phpmyadmin

 

 

 

 

 

< PHPMyAdmin 5 | Java and Opensource Friends | PHPMyAdmin 7 >


PHPMyAdmin 1 | PHPMyAdmin 2 | PHPMyAdmin 3 | PHPMyAdmin 4 | PHPMyAdmin 5 | PHPMyAdmin 6 | PHPMyAdmin 7 | Java and Opensource Friends