PhpMyAdmin is one of the most popular web based freeware to manage MySQL database. This program is also open source, meaning that the code is available for the public to tweak and further enhance its capability, thus it is open to improvement. Recently, this freeware was awarded “2007 SourceForge.net Community Choice Awards” for its contribution to the open source community.
Some of PhpMyAdmin features:
- Create and drop MySQL databases
- Create, drop and alter tables
- Add, delete or edit any fields
- SQL statement execution
- Manage keys on fields
- Manage user and database privileges
- Data export / import features
- Support for over 54 plus languages
Installation can be done with a wizard or just by copying a preinstalled sample configuration file. Recently, I have installed PhpMyAdmin to manage my local MySQL database. Here are the software requirements before you can run PhpMyAdmin from a web browser:
- Apache server that can run PHP 4.1.0 or newer (mine is PHP version 5.x.x)
- MySQL 3.23.32 or newer (mine is version 5.x.x)
- MySQL, mbstring (Multi byte string in PHP 5), mcrypt and GD2 PHP extensions installed.
How To Install PhpMyAdmin on Apache 2.2
1- Download PhpMyAdmin here. The file name is english.zip.
2- Unzip english.zip to your Apache web server root directory (htdocs folder). If you follow my Apache 2.2 Installation Guide , the location is at C:\Program Files\Apache Software Foundation\Apache2.2\htdocs.
3- You will get a folder named “phpMyAdmin-2.11.0-english “. Rename this folder to “phpmyadmin” or any easy to remember name.
4- Open the phpmyadmin folder. Copy the sample configuration file, config.sample.inc.php to another file name, config.inc.php.
5- Edit these two lines in config.inc.php . Save this file.
- $cfg['blowfish_secret'] = ‘add anything that you want here‘;
- $cfg['Servers'][$i]['auth_type'] = ‘cookie‘;
6- Open your web browser, type your web server name followed by the PhpMyAdmin folder, e.g http://www.syahid.com/phpmyadmin . You will see a login page.
7- Enter your MySQL administrator name and password. Click the “Login” button. Installation of PhpMyAdmin is successful.
Easy right? If you have your Apache, PHP and MySQL properly installed, you will have no problem in installing PhpMyAdmin. Check out the PhpMyAdmin documentation page for a complete guide in using this freeware.
Bonus tips: Doing more with PhpMyAdmin by DevShed.