Handcrafting a MySQL Database

The natural progression for a developer of web applications is for them to eventually be able to create a solid persistent web application. Solid in that is is robust to scalability and persistent in that the data you create while using it gets stored on the cloud, as it were. Cloud computing is a new way of imagining how data will be handled online. Instead of your data residing on a single hard-drive on your home computer or on a web server somewhere your data will be shifting through the cloud as resources are negotiated automatically to handle the breath of demand for your content.

In this example I’m going to show you how to download, install, create and query a MySQL database. In a future post I’ll show how to connect a JSP page to a database and display some content onto a page. This will be the first steps to creating a Content Management System of sorts, but I’ll leave that for now.

So, First step should be to download MySQL server. if you’ve got a Microsoft computer then choose the download that corresponds to your country. After you’ve downloaded and installed everyting agreeing to everything along the way, you should get to the MySQL Server Instance Configuration Wizard:

1

Read More