Bright Java Tutorial

is brought to you by DoITBright LLC

MySQL

Get Started On MySQL

MySQL is a very popular relational database management system. It is backed by Oracle and it is free to use. A lot of web hosting companies support MySQL. This means, it wont be a problem to find a web hosting company to host your application.

The first thing you need to do is download MySQL Community Server which is available at the MySQL website. You may click here to download the installer. My operating system is Windows 8. At the time I am writing this, the latest MySQL version is 5.7. Execute the installer once download is finished. Choose 'Full' as the setup type. Here is a screen capture.

MySQL Installation - Setup Type

Click the 'Next' button. It will also require to run a system check for the installation requirements. Go through the flow of the installation steps. On the screen that requires connectivity type and port numbers, here is what I have.

MySQL Installation - Type and Networking

I believe that those are the default values. Do not change those things. Click 'Next' button. Another step that you should pay attention to is when it asks for the root password. You have to remember what you provide. This is what the screen would look like.

MySQL Installation - Provide Root Password

On the Windows Service screen, it is safe not to change the defaults. Here is a screen capture to give you an idea.

MySQL Installation - Windows Service

The rest of the steps should be straight forward. When it asks for the root password, provide the password you have provided in the previous steps. Then, it will launch the MySQL Workbench automatically. The workbench will look something like this.

MySQL Workbench

Here are few things you need to take note of on your workbench. The large part of the screen shot is an empty space that looks like a text area. This is where you will key in your commands which is for the most part is Structured Query Language or SQL. The lightning symbol is to execute whatever command you have entered on the provided text area.


Next