How to Install and Configure phpMyAdmin on Linux

04:25    1 comment



PhpMyAdmin Installation on Linux

Note:First you have to install Apache or Httpd
Step #1: activate EPEL repo

  1. phpMyAdmin isn't enclosed in default RHEL / CentOS repo. thus activate EPEL repo as represented here:
  2. $ cd /tmp
  3. $ wget http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm
  4. # revolutions per minute -ivh epel-release-6-5.noarch.rpm


Step #2: Install phpMyAdmin

  1. Type the subsequent command:
  2. # yum search phpmyadmin
  3. # yum -y install phpmyadmin

Sample outputs:

Loaded plugins: rhnplugin
Setting up Install method
Resolving Dependencies
There ar unfinished transactions remaining. you may contemplate running yum-complete-transaction initial to end them.
--> Running group action check
---> Package phpMyAdmin.noarch 0:3.5.1-1.el6 are put in
--> Finished Dependency Resolution
Dependencies Resolved
==================================================================================================
 Package                  Arch                 Version                   Repository          Size
==================================================================================================
Installing:
 phpMyAdmin               noarch three.5.1-1.el6               epel four.2 M
Transaction outline
==================================================================================================
Install one Package(s)
Total transfer size: four.2 M
Installed size: seventeen M
Downloading Packages:
phpMyAdmin-3.5.1-1.el6.noarch.rpm                                          | four.2 MB     00:00
Running rpm_check_debug
Running group action take a look at
Transaction take a look at Succeeded
Running group action
 putting in : phpMyAdmin-3.5.1-1.el6.noarch                                                  1/1
 corroborative  : phpMyAdmin-3.5.1-1.el6.noarch                                                  1/1
Installed:
  phpMyAdmin.noarch 0:3.5.1-1.el6
================================================================

Step #3: put together phpMyAdmin

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

  1. # vi /etc/httpd/conf.d/phpMyAdmin.conf

It permits solely localhost by default. you'll be able to setup HTTPD SSL as represented here (mod_ssl) and permit LAN / WAN users or DBA user to manage the information over World Wide Web. realize line that browse follows

  • Require information science 127.0.0.1
  • Replace along with your digital computer information science address:
  • Require information science ten.1.3.53
  • Again realize the subsequent line:
  • Allow from 127.0.0.1
  • Replace as follows:
  • Allow from ten.1.3.53

Update phpMyAdmin config.inc from Wizard


You need to setup the config.inc file properly for phpMyAdmin to figure. you'll be able to either produce and edit this file manually, or use the config phpMyAdmin installer setup wizard. i like to recommend that you simply use the setup wizard, because it is incredibly uncomplicated. To do that, you ought to produce the subsequent dummy config.inc with correct permission.

  1. # cd /usr/local/apache2/htdocs/phpmyadmin/
  2. # mkdir config
  3. # chmod o+rw config
  4. # cp config.sample.inc.php config/config.inc.php
  5. # chmod o+w config/config.inc.php
Save and shut the file. Restart Apache / httpd server:

  1. # service httpd restart

Open an online browser and sort the subsequent url:
https://your-server-ip/phpMyAdmin/

OR
http://your-server-ip/phpMyAdmin/


1 comments: