Bright Java Tutorial

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.

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.

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.

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

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.

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.