If you want to host a database driven website on your computer, LAMP (Linux Apache MySql Php) or WAMP (Windows Apache MySql Php, use XAMPP to make your life easier) is the way to go. In addition you would need to install phpmyadmin as well to manage the database. Going for linux based web-server is recommended just for the sake of convenience and security, giver you are comfortable with it.

Step 1: Install mysql client and server in the first step. Become root by typing “su -” at a terminal

yum install mysql mysql-server

After the installation you can restart the mysql-server by doing this

/etc/init.d/mysqld restart

Next you need to setup the root password for the server, start the setup process by doing this

mysql_secure_installation

You would be asked for the current root password which is blank to begin with, next you would be asked to set the new root password for the mysql server, after which you would be asked a few Y/n questions, answers to which are not difficult to guess. I chose Y for all of them.

Step 2: Install apache2 its called httpd inside Fedora after the installation start the server

yum install httpd
/etc/init.d/httpd start

Now you can test if your web-server is up and running by opening the http://localhost in your web browser. You should see a page like this.

Step 3: Time to install and test php support. Install it by doing

yum install php mod_suphp

Before we test for php support, you need to restart http server by doing this

/etc/init.d/httpd restart

Now create a test.php file using your favorite text editor, say gedit

gedit /var/www/html

and paste the following content in it and save the file.

<?php
phpinfo();
?>

Remember: the /var/www/html is your root web folder, whatever you put in there would become visible to the rest of the world via your web server. Now open the file you created above by pointing your browser to http://localhost/test.php, if you have followed the steps so far correctly you should see something like this

Step 4: Install additional php related packages, especially the one necessary to communicate with mysql and other webserver modules etc.

yum install php-mysql php-magickwand  php-devel php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc php-eaccelerator php-magpierss php-mapserver php-mbstring php-mcrypt php-mhash php-mssql php-shout php-snmp php-soap php-tidy curl curl-devel perl-libwww-perl ImageMagick libxml2 libxml2-devel

Restart the http server  by doing

/etc/init.d/httpd restart

Now to ensure that the web server as well as mysql server starts on its own at every boot, do the following (while being root with su - and not su alone)

chkconfig --levels 235 httpd on
chkconfig --levels 235 mysqld on

Step 5: Finally install phpmyadmin

yum install phpmyadmin

Restart apache (httpd) again. If you want to allow phpmyadmin connection from other locations other than localhost, then modify the following file

gedit /etc/httpd/conf.d/phpMyAdmin.conf

by commenting out the following lines

<Directory /usr/share/phpMyAdmin/>
order deny,allow
deny from all
allow from 127.0.0.1
allow from ::1
</Directory>

basically replacing the lines above with

#<Directory /usr/share/phpMyAdmin/>
#   order deny,allow
#   deny from all
#   allow from 127.0.0.1
#   allow from ::1
#</Directory>

Now you are all set just restart the httpd again by doing

/etc/init.d/httpd restart

And you should have a perfect web server running. You can access the phpmyadmin from http://your_server_address/phpmyadmin