[CentOS] PHPMYADMIN on Centos 6.3

Fri Oct 5 09:30:19 UTC 2012
John R Pierce <pierce at hogranch.com>

On 10/05/12 1:53 AM, adekoya adekunle wrote:
> how to install phpmyadmin on centos 6.3 ?

assuming you want to use postgresql 9.1 on a 64bit CentOS 6.x system 
with phpPgAdmin...

# rpm -Uvh 
# yum install postgresql91-server postgresql91-contrib phpPgAdmin
# chkconfig postgresql-9.1 on
# service postgresql-9.1 initdb
## (tweak /var/lib/pgsql/9.1/postgresql.conf and pg_hba.conf to suit [*])
# service postgresql-9.1 start
# su - postgres
$ createuser --superuser -P username
(enter a password for this new sql user at the prompt)
$ createdb -O username username
$ ^D
# service httpd start   ## or reload if its already running

now, on that server, http://localhost/phpPgAdmin   should get you 
phpPgAdmin.... initially connect to localhost:5432 as user username to 
database username with the password you gave above.   you'll need to 
tweak /etc/httpd/conf.d/phpPgAdmin.conf  to enable access from other 
hosts and reload httpd.

[*] in particular, change pg_hba.conf to read like...


# "local" is for Unix domain socket connections only
local   all             postgres                                peer
local   all             all                                     md5
# IPv4 local connections:
host    all             all               md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# host  all             all               x.y.z.w/24         md5 # 
uncomment this line and change to your subnet if you want LAN 
connections to postgres

john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast