Freeware: Manage Your MySQL Database with Web-Based PhpMyAdmin
September 12, 2007 – 12:50 amPhpMyAdmin 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.
Love this post? You may want to subscribe to my RSS feed. Thanks for visiting!
8 Responses to “Freeware: Manage Your MySQL Database with Web-Based PhpMyAdmin”
I installed phpmyAdmin in my laptop and its work well, Thank You. But there are some error message in phpmyAdmin Home page:
“The mbstring PHP extension was not found …” and
“Cannot load mcrypt extension….”
could you please explain me what those extension are and how to setup them?
once again, Thank You for your nice tutorial.
By bamby on Apr 17, 2008
By Syahid A. on Apr 17, 2008
Syahid,
I have a problem. I installed phpmyadmin and when i try to open it the list of files are showing. and when i click index.php this error comes
#1045 - Access denied for user ‘root’@'localhost’ (using password: NO)
Please help
By KK on Sep 14, 2008
By Syahid A. on Sep 14, 2008
I had setup apache with kkwebserver.com and has created a directory kkwebserver under htdocs. phpmyadmin is also placed in this. Also made an entry for kkwebserver in etc/hosts. When i ping kkwebserver.com it works. But when i view in browser http://www.kkwebserver.com - The index file in the directory want display. If there is an index file in its parent directory then it is ok. And secondly http://www.kkwebserver.com/phpmyadmin shows a file list. Can you help it out
By KK on Sep 14, 2008
By Syahid A. on Sep 14, 2008
I don’t understand the description of phpMy Admin as web-based freeware (isn’t all freeware web-based, unless you get a free CD with a magazine). I have php as part of a WAMPserver download. Is its functioning in any way web-based?
I have seen comments saying that it being web-based is a disadvantage compared with MySQL GUI or Navicat. Is this correct?
By ColinG on Sep 29, 2008
By Syahid A. on Oct 6, 2008