Your Localhost is very nearly complete, we’ve installed Apache, PHP 5 and MySQL 5. I breifly talked about the ability to modify and change MySQL databases. Well phpMyAdmin can do just that, this tool allows you to do this, it helps you manage your MySQL database in a nicely presented admin panel which you can easily change tables, prefixes and much more. This tool is a must if you plan on creating databases on your localhost
In part two, we installed almightly PHP language onto our localhost, with that you can now run php scripts and code offline on your localhost, but for example what if you want to test a script that needs a database your basically stuck aren’t you? Well to handle databases there’s something called MySQL, this is simple a relation database management system and is present on most web-servers avaliable today. MySQL allows you to create and modify (To a certain extent) databases on a server, and lucky you, it can be installed on a localhost! We will be installing the MySQL service and getting it to run with your localhost.
In part one we setup a Apache server and configured the localhost ready for you to use, we also set up the directory where you are going to save your local files. But so far in part one we only essentially setup the localhost, so all of the goodness of being able to view server side documents/scripts etc won’t work yet as you will need to install them, one of the most popular if not the popular server side code is PHP. It is used mostly to create dynamic webpages. Lets install PHP!
A localhost is a developers best friend when it comes to testing out server side scripts etc. Much like a web-server, a localhost is a space which is offline but allows you to view/test server side code as if it was a real online server, but infact you will be creating a server which can only be accessed by you. There are many ways to create an localhost but there is one easy newbie friendly way to go about it, and that is by installing Apache web server on your computer. This method is very simple and easy to follow.