Pages

Tuesday, August 12, 2014

Update php mysql mysql-server version and Install phpmyadmin



=============================================
Upgrade mysql and mysql-sever version 5.1 to 5.5 at centos
=============================================
If server is centOS-6 then
### rpm -Uvh https://mirror.webtatic.com/yum/el6/latest.rpm
IF server is CentOS-5 then
### rpm -Uvh http://mirror.webtatic.com/yum/el5/latest.rpm


If you already have MySql client or server installed, then

### yum install mysql.`uname -i` yum-plugin-replace
### yum replace mysql --replace-with mysql55w


if fressh installation, then

### yum install mysql55w mysql55w-server

Then start Mysql service

### service mysqld start

########################################################
 PhpMyAdmin (phpmyadmin) Installation
==================================================


wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
rpm -ivh epel-release-6-8.noarch.rpm
rpm -ivh remi-release-6.rpm


vim /etc/yum.repos.d/remi.repo
[remi-php55]
enabled=0
[remi-php56]
enabled=1


 yum install ntp httpd mysql-server php php-mysql php-mbstring php-mcrypt phpmyadmin

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

Order Deny,Allow
Deny from 1.2.3.1
Allow from 127.0.0.1 ALL

Save and
service httpd restrart

mysqladmin -u root password newpass

http://ipaddress/phpmyadmin
root
newpass

########################################################