Installing PHPMyAdmin on Windows XP Pro 5

 

What do we have in this session 5?

  1. Establishing the Database Connection

  2. Testing Logging to PHPMyAdmin

 

 

Establishing the Database Connection

 

The following section demonstrate the config.inc.php file that you need to edit in order to establish a database connection. Replace port number, username, and password as shown below with the port number for your account and the username/password that you've granted privileges to when setting up your database.

 

$cfg['Servers'][$i]['host'] = 'mysql.iu.edu'; // MySQL hostname

$cfg['Servers'][$i]['port'] = 'port number'; // MySQL port

$cfg['Servers'][$i]['extension'] = 'mysql';

$cfg['Servers'][$i]['connect_type']= 'tcp';

$cfg['Servers'][$i]['compress'] = false;

$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['user'] = 'username'; // MySQL user

$cfg['Servers'][$i]['password'] = 'password'; // MySQL password

 

 

After having imported the ./scripts/create_tables.sql file, you should specify the table names in your ./config.inc.php file. The directives used for that can be found in the Configuration section. You will also need to have a controluser with the proper rights to those tables (see section Using authentication modes).

 

<?php

/* vim: set expandtab sw=4 ts=4 sts=4: */

/**

 * phpMyAdmin sample configuration, you can use it as base for

 * manual configuration. For easier setup you can use setup/

 *

 * All directives are explained in Documentation.html and on phpMyAdmin

 * wiki <http://wiki.phpmyadmin.net>.

 *

 * @version $Id$

 * @package phpMyAdmin

 */

 

/*

 * This is needed for cookie based authentication to encrypt password in

 * cookie

 */

$cfg['blowfish_secret'] = 'ajrkt4l6fv92j800'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

 

/*

 * Servers configuration

 */

$i = 0;

$i++;

 

/*

 * First server

 */

$i++;

/* Authentication type */

$cfg['Servers'][$i]['auth_type'] = 'cookie';

/* Server parameters */

$cfg['Servers'][$i]['host'] = 'localhost'; /* port should be default to 3306 */

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = false;

/* Select mysqli if your server has it */

$cfg['Servers'][$i]['extension'] = 'mysql';

$cfg['Servers'][$i]['AllowNoPassword'] = false;

 

/* rajk - for blobstreaming */

$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;

$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';

$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;

$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';

 

/* User for advanced features */

$cfg['Servers'][$i]['controluser'] = 'pma';

$cfg['Servers'][$i]['controlpass'] = 'pmapass';

/* Advanced phpMyAdmin features */

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';

$cfg['Servers'][$i]['relation'] = 'pma_relation';

$cfg['Servers'][$i]['table_info'] = 'pma_table_info';

$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';

$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';

$cfg['Servers'][$i]['column_info'] = 'pma_column_info';

$cfg['Servers'][$i]['history'] = 'pma_history';

$cfg['Servers'][$i]['tracking'] = 'pma_tracking';

$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

/* Contrib / Swekey authentication */

// $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';

 

/*

 * End of servers configuration

 */

 

/*

 * Directories for saving/loading files from server

 */

$cfg['UploadDir'] = '';

$cfg['SaveDir'] = '';

 

?>

 

 

 

 

 

 

 

Testing Logging to PHPMyAdmin

 

Now, launch your browser and point to http://localhost/phpmyadmin/ or http://127.0.0.1/phpmyadmin/ of any other path that you have chosen for phpmyadmin installation done previously. Automatically, you will be brought to phpmyadmin main control manager page with automatic login.

 

phpmyadmin in action with mbstring PHP extension warning message

 

 

 

 

< PHPMyAdmin 4 | Java and Opensource Friends | PHPMyAdmin 6 >

 

 

 

 


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