How to Create a MySQL Database Web Site

Set up an awesome web app with a MySQL backend

MySQL is a common and practical solution for using a database. It's fast, and fairly easy to learn. It's also free. This makes it the database of choice for many webmasters and web developers, as licensing is a non-issue and allows them to operate at reasonable scales with low overhead. As such, learning to construct web applications with a MySQL database back end is a useful and desirable skill.

Things You'll Need

• Web server

Instructions

1. Install MySQL on your web server. The procedure for this will differ from server to server. If you use Apache, which serves some 90% of the web and run Apache on Linux, which additionally serves some 90% of the web, you'll install MySQL by running the command "sudo apt-get install mysql".

2. Install PHP, or the Personal HomePage Hypertext PreProcessor. If your setup is as above, run the command "sudo apt-get install php(version number here)". Put the number of the version of PHP you would like in the parentheses. At the time of writing, PHP is in it's fifth iteration.

3. At the home directory of your server, which will be "www" if you are set up as above, place PHP scripts that interface with the database as you need it to.

References

• Official PHP documentation
• How to set up Ubuntu/Debian LAMP