mysql phpmyadmin install


Step #1: Turn on EPEL repo

phpMyAdmin is not included in default RHEL / CentOS repo. So turn on EPEL repo as described here:
$ cd /tmp
$ wget
# rpm -ivh epel-release-6-8.noarch.rpm

Step #2: Install phpMyAdmin on a CentOS / RHEL Linux

Type the following yum command to download and install phpMyAdmin:
# yum search phpmyadmin
# yum -y install phpmyadmin

Install MySQL server on a CentOS/RHEL

You need download and install MySQL server on CentOS/RHEL using the following yum command:
# yum install mysql-server mysql

Turn on and start the mysql service, type:
# chkconfig mysqld on
# service mysqld start

Set root password and secure mysql installation by running the following command:
# mysql_secure_installation

Step #3: Configure phpMyAdmin

You need to edit /etc/httpd/conf.d/phpMyAdmin.conf file, enter:
# vi /etc/httpd/conf.d/phpMyAdmin.conf

It allows only localhost by default. You can setup HTTPD SSL as described here (mod_ssl) and allow LAN / WAN users or DBA user to manage the database over www. Find line that read follows

Require ip
Replace with your workstation IP address:

Require ip
Again find the following line:

Allow from
Replace as follows:

Allow from
Save and close the file. Restart Apache / httpd server:
# service httpd restart

Open a web browser and type the following url:

This entry was posted in Uncategorized. Bookmark the permalink.

Comments are closed.