How to install LAMP server with Apache 2.2, MySQL 5.5.37, PHP 5.5.11 on Centos Linux

Backup your data, remove old Apache/httpd, MySQL, PHP packages

You don’t have to do this step if you on a fresh installed Centos or Fedora system. Note: if you are using some sort of virtualization environment like openvz, kvm, or xen, most of the time your hosting/vps providers use openvz/kvm/xen precreated templates. Those templates may have apache/http and/or php/mysql pre-installed. You want to remove old Apache/http, MySQL, and PHP packages from your system to prevent any error or conflict later, trust me removing old packages and install newer one is better doing upgrading packages. I spent hours to troubleshoot errors when I upgrade from PHP 5.3.3 and MySQL 5.1.73 to PHP 5.5.11 and MySQL 5.5.37. At the end I removed all old php/mysql and install newer versions, the process went smoothly without any error.

To backup Apache config file

# cp /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.conf.bk

To backup PHP config file

# cp /etc/php.ini /etc/php.ini.bk

To backup MySQL config file

# cp /etc/my.cnf /etc/my.cnf.bk

Your Apache/PHP/MySQL configure files will be at the same directory as the original file with .bk file extension at the end.

Remove old Apache/PHP/MySQL packages

# yum remove httpd* php* mysql* -y

Install Apache 2.2 server

Centos 5.10 / Centos 6.5

# yum --enablerepo=remi,remi-php55 install httpd

Fedora 20 Heisenbug / 19 Schrödinger’s Cat

# yum --enablerepo=remi install httpd

Fedora 18 Spherical Cow / 17 Beefy Miracle

# yum --enablerepo=remi,remi-test install httpd

To start Apache

# service httpd start

To start Apache at Startup

# chkconfig httpd on

or

# chkconfig --level 235 httpd on

Install MySQL 5.5 server

MySQL 5.5 support multi-core CPUs better than older versions. Instead of waiting for CPUs get faster, you can take advantages today multi’cores CPU technology. There are many new features from Diagnostic improvements, Unicode, IPv6, and MySQL Cluster. The biggest change in MySQL 5.5 is default storage engine, older MySQL use MyISAM but 5.5 version use InnoDB as default storage engine.

Centos 5.10 / Centos 6.5

# yum --enablerepo=remi,remi-php55 install mysql-server

Fedora 20 Heisenbug / 19 Schrödinger’s Cat

# yum --enablerepo=remi install mysql-server

Fedora 18 Spherical Cow / 17 Beefy Miracle

# yum --enablerepo=remi,remi-test install mysql-server

To start MySQL database server

# service mysqld start

To start MySQL server at Startup

# chkconfig mysqld on

or

# chkconfig --level 235 mysqld on

Hardening MySQL with mysql_secure_installation command

Default MySQL installation isn’t safe since there is no default root password nor any user’s privilege. By using mysql_secure_installation the command will help to improve MySQL server more secure. With mysql_secure_installation, you can:

• Set MySQL’s root password
• Remove root’s remote access
• Remove anonymous users
• Disallow root login remotely
• Reload privilege tables

# mysql_secure_installation

# yum --enablerepo=remi,remi-php55 install php php-common

# yum --enablerepo=remi install php php-common

# yum --enablerepo=remi,remi-test install php php-common

# service httpd restart

# yum --enablerepo=remi,remi-php55 install php-mysql php-cli php-pear php-xml php-tidy php-pecl-apc php-pdo php-mysqlnd php-gd php-mbstring php-mcrypt

# yum --enablerepo=remi install php-mysql php-cli php-pear php-xml php-tidy php-pecl-apc php-pdo php-mysqlnd php-gd php-mbstring php-mcrypt

# yum --enablerepo=remi,remi-test install php-mysql php-cli php-pear php-xml php-tidy php-pecl-apc php-pdo php-mysqlnd php-gd php-mbstring php-mcrypt

# service httpd restart

# yum --enablerepo=remi search php-

# nano /var/www/html/info.php

 <?php
phpinfo();
?>

# service httpd start
# service httpd restart
# service httpd stop

# service mysqld start
# service mysqld restart
# service mysqld stop

# yum --enablerepo=remi

# yum --enablerepo=remi,remi-php65 install httpd mysql-server php php-common php-cli php-mysql