Freeware: Manage Your MySQL Database with Web-Based PhpMyAdmin

September 12, 2007 – 12:50 am

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.

 

phpmyadmin-mysql-management-home-page

 

 

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.

phpmyadmin-working-when-mysql-extension-enabled-on-php

 

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.

Share!

Related Posts:


  1. 13 Responses to “Freeware: Manage Your MySQL Database with Web-Based PhpMyAdmin”

  2. 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

  3. @bamby: You need to install / reinstall your PHP and enable the mbstring and mcrypt extension from the setup wizard.

    By Syahid A. on Apr 17, 2008

  4. 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

  5. @KK: Looks like that you need to insert your MySQL database access password to PhpMyAdmin configuration file. Please re-check again.

    By Syahid A. on Sep 14, 2008

  6. 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

  7. @KK: Inside httpd.conf, there is a line called “DirectoryIndex”. Try adding index.php at the end of the line and restart your web server.

    By Syahid A. on Sep 14, 2008

  8. 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

  9. @ColinG: Web based means that you can use this tool with your web browser over the Internet without sitting in front of the same machine that host the database server. About the comments, I don’t think so.

    By Syahid A. on Oct 6, 2008

  10. your missing something in the description above mate, this only brings up a list of files…

    By marc on Dec 7, 2008

  11. everything else you have said upto now has been terrific, so help us go the next step and clean this up so it works mate

    By marc on Dec 7, 2008

  12. HI, I have tried reinstalling 3 times now and here is the latest.
    when I run http://www.mydomain.com/phpmyadmin
    a list of files appear…
    when I click on index.php from the list dialog box appears to logon however cam not load mcrupt extension error…

    went through everything as I said 3 times and unable to get to the bottom, the above responses which are simular can you help be a little more specific please? thanks.

    By marc on Dec 7, 2008

  13. maybe you don’t insert index.php at the DirectoryIndex line inside httpd.conf. Try it again!

    By Syahid A. on Dec 11, 2008

  14. Cannot load mcrypt extension. Please check your PHP configuration.

    please help me..

    By zeeshan on Oct 22, 2009

Post a Comment