Install phpMyAdmin on CentOS


Install phpMyAdmin:
phpMyAdmin is a very handy tool, for developers, Database administrator, and system integrator of various open source platform. Although in most distribution Phpmyadmin is already installed and comes automatically with the distribution. It is  written in PHP and allows you to handle the administration of MySQL over the Web.

Version
CentOS 5.x
phpMyAdmin 3.1.x
Requirements:
Install and Configure the Remi Repository
Install phpMyAdmin 3.1.x
Run the following yum install command

yum install phpmyadmin

Restart the Apache Server

service httpd restart

Test

  • Visit http://localhost/phpmyadmin in your local web browser. You should be prompted for authentication
  • Enter the system root username and password and click OK
  • You should now be presented with the phpMyAdmin home page
In Some cases you will not be able to sign in or even can’t see the login prompt. To enable your system to give you the login prompt please do the following:
  1. Please login to your system using putty(or anyof your favourite ssh client)
  2. go to :
    [root@yourserver]# vi /etc/httpd/conf.d/phpMyAdmin.conf
  3. Put a # and space on Line 3 :  (As shown in the picture)
    Allowing PhpMyAdmin Access from your browser

    Allowing PhpMyAdmin Access from your browser

    usr/share/phpMyAdmin/>

    Order Deny,Allow

    # Deny from All

    Allow from 127.0.0.1

    Allow from ::1

    </Directory>

  4. You have just commented out “deny from all”
  5. Point your browser to your system;  such as: 10.250.10.1/phpmyadmin (Remember to put you server IP address).
  6. If you face any problem please email me at ” shisdew@gmail.com ” ; I will be happy to help you out.  And yes of course it is FREE as long as it’s about Open Source.

Visit the phpMyAdmin website for more information.

Ref: http://dev.antoinesolutions.com/phpmyadmin 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s