Phpmyadmin - CORE MANAGED

From Cheatsheet
Revision as of 00:36, 31 May 2010 by Admin (talk | contribs)
Jump to navigation Jump to search

How to install PHPMYADMIN on COREMANAGED box

First download the phpmyadmin

cd /var/www/html/
wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.3.2/phpMyAdmin-3.3.2-english.tar.gz?use_mirror=iweb
tar zxvf phpMyAdmin-3.3.2-english.tar.gz
rm -rf phpMyAdmin-3.3.2-english.tar.gz
mv phpMyAdmin-3.3.2-english/ phpmyadmin

Visit servers main ip/phpMyAdmin to see if the install needs further components.

Install rpmforge repo for yum installation based on the OS architecture.

 uname -a

From this command get the system bit.

32bit OS
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.1-1.el5.rf.i386.rpm
rpm -ivh rpmforge-release-0.5.1-1.el5.rf.i386.rpm

64bit OS
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm
rpm -ivh rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm

Add the development repositories

First thing we need to do is add the development repositories to yum. When we add the development repository we're going to configure it so it only pulls PHP packages. To start we'll need create a new yum repository configuration file (use your favorite editor):

 # /etc/yum.repos.d/CentOS-Testing.repo

Copy/paste the following into this file:

# CentOS-Testing:
# !!!! CAUTION !!!!
# This repository is a proving grounds for packages on their way to CentOSPlus and CentOS Extras.
# They may or may not replace core CentOS packages, and are not guaranteed to function properly.
# These packages build and install, but are waiting for feedback from testers as to
# functionality and stability. Packages in this repository will come and go during the
# development period, so it should not be left enabled or used on production systems without due
# consideration.
[c5-testing]
name=CentOS-5 Testing
baseurl=http://dev.centos.org/centos/$releasever/testing/$basearch/
enabled=1
gpgcheck=1
gpgkey=http://dev.centos.org/centos/RPM-GPG-KEY-CentOS-testing
includepkgs=php*
      • Make sure to remove any spaces at the start of each line, then save and close the file and you're done.***


Now install mysql

yum install mysql
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-bcmath-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-cli-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-common-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-dba-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-devel-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-eaccelerator-5.2.13_0.9.5.3-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-gd-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-imap-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-ldap-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-mbstring-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-mcrypt-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-mhash-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-mssql-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-mysql-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-ncurses-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-odbc-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-pdo-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-pgsql-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-readline-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-snmp-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-soap-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-tidy-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-xml-5.2.13-1.x86_64.rpm'
wget 'http://www.atoomnet.net/./php/php-5.2.13/php-xmlrpc-5.2.13-1.x86_64.rpm'


Now install PHP 5.2.10

yum install php

Now install php-pdo-5.2.10-1.el5.centos.x86_64.rpm

yum install php-pdo

Now install php devolpment tools

yum install php-devel-5.2.10-1.el5.centos.x86_64

Now install pecl

yum install php-pear-1.4.9-6.el5.noarch

Now install mbstring and mcrypt

yum install php-mcrypt
yum install php-mbstring


Run to set the phpmyadmin password

mysqladmin -u root password 'PASSWORD'

To enable the cookies do the following.

cd /var/www/html/phpmyadmin
cp config.sample.inc.php config.inc.php
vim config.inc.php

change the following

$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE

where th is put a randompassword in there.