Database like MySQL and MariaDB perform significant roles of any websites. All user are not comfortable to administering the database from command line.To make database administering easily phpMyAdmin was created. It is web-base management tool.I will explain in this guide how to install and configure phpMyAdmin.
Before going ahead we need some requirements.
- Make sure you have good build Linux system and OS installed properly.
- Before starting phpMyAdmin make sure LAMP ( Linux,Apache,MySQL and PHP ) stack is properly installed in your system
If everything is properly functioning than we can start installation. To install phpMyAdmin we need to install EPEL repo. It contain many packages including phpMyAdmin. There are no phpMyAdmin package available in Centos 6 default repository. That’s why we need to install EPEL repository.
EPEL repository installation:-
#yum install epel-release
After installing epel repo we will install phpMyAdmin package
#yum install phpmyadmin
phpMyAdmin.conf file automatically create in /etc/httpd/conf.d location after installation complete. We will need to modify a bit to get it work.
# vim /etc/httpd/conf.d/phpMyAdmin.conf Alias /phpMyAdmin /usr/share/phpMyAdmin Alias /phpmyadmin /usr/share/phpMyAdmin <Directory /usr/share/phpMyAdmin> AddDefaultCharset UTF-8 <IfModule mod_authz_core.c> Apache 2.4 <RequireAny> Require ip 127.0.0.1 Require ip ::1 </RequireAny> </IfModule> <IfModule !mod_authz_core.c> Apache 2.2 Order Deny,Allow Deny from All Allow from All Allow from ::1 </IfModule> <Files ~ "^\.ht"> Deny from all </Files> #Restricted AuthUserFile /etc/httpd/htpasswd AuthName "Restricted" AuthType Basic require valid-user </Directory>
Save and exit.
There are two directives are define for Apache version >2.4 AND <2.2. In Apache 2.4 and its upper version Require ip work. In Apache 2.2 and its lower version Order Deny,Allow work.
Now you can edit it according to your Apache version. I am using Apache 2.2 that’s why I have allowed from all and secure it with user and password. You can configure it IP base restriction like ‘ Allow from your_ip ‘ .
Than restart Apache service.
#service httpd restart Stopping httpd: [ OK ] Starting httpd: [ OK ]
phpMyAdmin is ready to work. You can type http://server_ip_or_domain/phpMyAdmin/ in you browser to access it.
It will prompt you to type user name and password if it is restricted. If it is configured with IP base restriction it will not prompt for any username and password.
To login use your valid database username/password .
You can see your all databases.
Create Password for Authentication
#htpasswd –c /etc/httpd/htpasswd username New password: #Type your password here Re-type new password: #Retype password Adding password for user username Password created succssfully .
Type http://www.example.com/phpMyAdmin/ it will prompt you for authentication.