How to install Apache , mysql and PHP on centos 6
Update yum repositories and packages by typing the below command
[root@localhost ~]# yum update
After updating repositories , we can start installing packages one by one.
1. Apache2 installation and configuration
2. Mysql installation
3. PHP installation
4. Testing all together
Apache2 installation :
Apache2 package installation and configuration is very simple .
Step 1 » just type the command
[root@localhost ~]# yum install httpd
This command will install httpd package along with dependencies
After installing the package .
Step 2 » Open the file /etc/httpd/conf/httpd.conf .
Find “#ServerName http://www.example.com:80″ (line no : 276 ) .
and add this line below . “ServerName youripaddress:80″
Step 3 » Now start apache service
[root@localhost ~]# service httpd start
and type this below command to start apache service automatically while booting.
[root@localhost ~]# chkconfig --levels 235 httpd on
Step 4 » Now you have successfully configured apache web server . open your browser and type the ip address in the address bar and hit enter . you can see the test page of your web server .
Testing your page:
Goto the default apache root path /var/www/html . create a new file index.html and paste the below code and save it.
Welcome to my webserver
Again open the webserver ip address in the browser . you can see the index page created by you.
Mysql installation :
Step 1 » just type the command to install mysql server and client packages along with dependencies .
[root@localhost ~]# yum install mysql-server
After installation packages and dependencies .
Step 2 » Start mysql service
[root@localhost ~]# service mysqld start
and type this below command to start mysql server automatically while booting.
[root@localhost ~]# chkconfig --levels 235 mysqld on
Step 3 » Create a new root password for mysqlserver
[root@localhost ~]# mysqladmin -u root password '********'
Step 4 » Test your mysql server by login as root
[root@localhost ~]# mysql -u root -p ( press enter )
Enter password:(Type your mysql root password and press enter)
Now you can see the mysql prompt.
[root@localhost ~]# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.61 Source distribution
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
PHP installation :
Step 1 » Install php package along with php-mysql .
[root@localhost ~]# yum install php php-mysql
After installing php , create a php info file to test your php configuration .
Step 2 » Goto the default apache root path /var/www/html . create a new filephpinfo.php and paste the below code and save it.
Step 3 » Restart apache service
[root@localhost ~]# service httpd restart
Step 4 » open the filepath in the browser ( http://192.168.141.22/phpinfo.php ). you can see the php information page as below.
and make sure you can see the mysql details in the php information page .
Finally apache2 , php and mysql has been configured perfectly . few more steps need to be performed to check the database connectivity.
Testing All together :
We need to test mysql database connectivity in php .
Step 1 » create a new file dbtest.php in the apache root path (/var/www/html) and paste the below code .Replace “password” with your mysql root password.
$con = mysql_connect(“localhost”,”root”,”password”);
die(‘Could not connect: ‘ . mysql_error());
echo “Congrats! connection established successfully”;
Step 2 » open the filepath in the browser ( http://192.168.141.22/dbtest.php ). you can see the page as below.
Congrats , you just made it
If you are getting some errors like
» Could not connect: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
( This means your mysql server service is stopped , you must start the service “service mysql start”)
» Could not connect: Access denied for user ‘root’@’localhost’ (using password: YES)
(Something wrong with username and password )
if you are getting a blank page , then must be a problem with the code .