Using phpMyAdmin for Effective MySQL Management in Windows XP

Introduction to phpMyAdmin

phpMyAdmin is a open source, web-based client that can manage a whole MySQL server (needs a super-user) as well as a single database. It supports PHP5 and MySQL 4.1.

Requirements

• PHP 4.1.0 or newer
• MySQL 3.23.32 or newer
• Optional: if you are using the “cookie” authentication method, having the mcrypt PHP extension on your web server accelerates not only the login phase but every other action that you do in phpMyAdmin.
• A web-browser
• Web Server

Note: Refer to this post for steps to setup the above required ocmponents.

Download phpMyAdmin

Download latest version of phpMyAdmin. For Windows web server, the zip package should downloaded.

Install phpMyAdmin

1. Extract the distribution into a folder (phpmyadmin is fine) in your webserver’s document root (../apache group/apache2/htdocs). If you don’t have direct access to your document root, put the files in a directory on your local machine, and, after step 3, transfer the directory on your web server using, for example, ftp.
2. Locate the folder, edit the config.inc.php file with any text editor.
3. Search for $cfg['Servers'][$i]['auth_type'], modify the value from ‘config’ to either ‘http’ or ‘cookie’, for security purpose. ‘http’ will prompt you for user id and password for each login, while ‘cookie’ will prompt you for user id and password for one time only until the cookie is deleted or expired.

Testing and Accessing phpMyAdmin

Launch your browser and access http://localhost/phpmyadmin/index.php (or http://[www.your-host.com]/[your-install-dir]/index.php by replacing [www.your-host.com] with your own domain, and [your-install-dir] with path of your phpMyAdmin.

phpMyAdmin should display a welcome screen and your databases, or a login dialog if using HTTP or cookie authentication mode.

Share and contribute or get technical support and help at My Digital Life Forums.

Related Articles

• How to Delete Existing WordPress Post Revisions Stored/Saved
• Easily Set Up Web Server with XAMPP
• Change and Reset MySQL root Password
• Install Web Server in Windows XP with Apache2, PHP5 and MySQL4 - Part 4
• How to Backup and Restore (Export and Import) MySQL Databases Tutorial
• Remove or Trim First or Last Few Characters in MySQL Database with SQL
• Installing Web Server in FreeBSD 6.0 with Apache 2.2, MySQL 5.0 and PHP 5 - Part 3
• Install Web Server in Windows XP with Apache2, PHP5 and MySQL4 - Part 1
• Check and Optimize MySQL Database Automatically with Crontab/Cron
• MySQL Database Performance Tuning Best Practices Video Tutorial

This entry was posted on Wednesday, October 19th, 2005 at 10:56 am and is filed under Databases. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.