Phpmyadmin - CORE MANAGED: Difference between revisions

From Cheatsheet
Jump to navigation Jump to search
No edit summary
m 31 revisions
 
(One intermediate revision by the same user not shown)
Line 3: Line 3:
First download the phpmyadmin
First download the phpmyadmin
<pre>cd /var/www/html/
<pre>cd /var/www/html/
wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.5.1/phpMyAdmin-3.5.1-all-languages.tar.gz?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fphpmyadmin%2Ffiles%2FphpMyAdmin%2F3.5.1%2F&ts=1338052727&use_mirror=iweb
wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.5.1/phpMyAdmin-3.5.1-all-languages.tar.gz?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fphpmyadmin%2Ffiles%2FphpMyAdmin%2F3.5.1%2FphpMyAdmin-3.5.1-all-languages.tar.gz%2Fdownload&ts=1338052850&use_mirror=softlayer
tar -zxvf phpMyAdmin-3.5.1-all-languages.tar.gz
tar -zxvf phpMyAdmin-3.5.1-all-languages.tar.gz
rm -rf phpMyAdmin-3.5.1-all-languages.tar.gz
rm -rf phpMyAdmin-3.5.1-all-languages.tar.gz

Latest revision as of 23:49, 23 October 2014

How to install PHPMYADMIN on COREMANAGED box, also switching to php 5.2.13

First download the phpmyadmin

cd /var/www/html/
wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.5.1/phpMyAdmin-3.5.1-all-languages.tar.gz?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fphpmyadmin%2Ffiles%2FphpMyAdmin%2F3.5.1%2FphpMyAdmin-3.5.1-all-languages.tar.gz%2Fdownload&ts=1338052850&use_mirror=softlayer
tar -zxvf phpMyAdmin-3.5.1-all-languages.tar.gz
rm -rf phpMyAdmin-3.5.1-all-languages.tar.gz
mv phpMyAdmin-3.5.1-all-languages phpmyadmin

Visit servers main ip/phpMyAdmin to see if the install needs further components.
If this does not resolve you will have to check with the customer and have them configure their apache server, unless the wish to provide explicit instructions as to how the would like their server setup.

If you need to install apache please go to the following wiki: Coremanaged HTTPD

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
yum install mysql-server-5.0.77-4.el5_5.3.x86_64

Now onto customizing php to work with our installation. Download the files.

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-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-devel-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-mysql-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-gd-5.2.13-1.x86_64.rpm'


now onto installing them

yum install libmcrypt-2.5.8-4.el5.centos.x86_64

After installing this dependency, install the rest.

rpm -ivh php-common-5.2.13-1.x86_64.rpm
rpm -ivh php-cli-5.2.13-1.x86_64.rpm
rpm -ivh php-5.2.13-1.x86_64.rpm
rpm -ivh php-pdo-5.2.13-1.x86_64.rpm
rpm -ivh php-mysql-5.2.13-1.x86_64.rpm
rpm -ivh php-mbstring-5.2.13-1.x86_64.rpm
rpm -ivh php-devel-5.2.13-1.x86_64.rpm
rpm -ivh php-mcrypt-5.2.13-1.x86_64.rpm
rpm -ivh php-gd-5.2.13-1.x86_64.rpm

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 the ' ' is put a randompassword in there.