How To Install phpMyAdmin 3.4 On CentOS 6

Tuesday, August 16, 2011

In my previous post, you knew how to set up your own website with Apache, MySQL and PHP on CentOS 6. Today, I’ll show you how to use phpMyAdmin 3.4 to manage your MySQL server. This software provides a user interface that greatly simplifies your interactions with MySQL.

1. Install phpMyAdmin

# cd /var/www/html

# wget -c http://downloads.sourceforge.net/project/phpmyadmin/
phpMyAdmin/3.4.3.2/phpMyAdmin-3.4.3.2-english.tar.gz

# tar xvfz phpMyAdmin-3.4.3.2-english.tar.gz

# mv phpMyAdmin-3.4.3.2-english phpmyadmin

# cd phpmyadmin

# cp config.sample.inc.php config.inc.php

# vi config.inc.php

$cfg['Servers'][$i]['auth_type'] = ‘http‘; # default is cookie

# service httpd restart

2. Manage MySQL Database With phpMyAdmin

To open the main phpMyAdmin page, type http://ipaddress/phpmyadmin into the address field in your browser.

You can use phpMyAdmin to administer your databases in one of two ways:

Write SQL queries

Click links and buttons in the phpMyAdmin interface

3. Quicker Way To The MySQL Server

When MySQL is installed, a simple, text-based program called mysql is also install. To send SQL queries to MySQL by using the mysql client, follow these steps: