This will be a quick article for those wishing to install MySQL a Windows Operating System, not just Windows 8 (although that is what this tutorial will be using). A good description of MySQL for those new to programming is a free open source alternative to Microsoft SQL & SQL Server. MySQL is preferred in situations where you will be using Java as your programming language and need a quick database to store your data. Without further waste of an introduction to MySQL and onto installing it on our Windows machine.
The first thing we want to do is download the installer from the MySQL website. To do this we need to navigate to http://www.mysql.com/downloads/installer/ and select the download button. After it has been clicked the next page will ask for your registration but this can be bypassed by clicking “» No thanks, just take me to the downloads!” button below the register or login section. We then will have to choose the site closest to us to download from and we will want to choose the HTTP option over the FTP. After the installer has downloaded we can proceed to find it on our desktop and double click it.
Once the installer started we will see the above screen asking us what we want to do. We are going to choose the middle option – Add/Modify Products and Features – to add a new MySQL install to Windows 8. After clicking the button we will progress to the license agreement where you will have to check the “I Agree” button to move onto the next screen. The next screen will be the most important, this one being the feature selection screen.
In the feature selection screen, the first thing we will want to do is change the architecture to “Any” and not “32-bit” or “64-bit” to encompass all installation methods. We then want to click all of the options below in order to install all documentation, connectors and a MySQL server. You will only be able to install a 64-bit or 32-bit version of MySQL server but not both. After clicking on MySQL Servers and choosing which you would like we can proceed. After this is done we can click next to progress to the next part of the installation. The next screen will check the requirements needed for MySQL to install on your computer and notify you which products are already installed and which will be installed with the MySQL install. We can proceed to press the Execute button to begin the install of the required programs before MySQL is installed. After all requirements are met the next button will appear.
Next we will be shown the list of items to be installed and at the bottom will be the Execute button to proceed to the install. Make sure everything is in order before proceeding to the next step. After everything is installed we can press next button and be shown the Configuration screen where it will prompt us to configure any installed servers. When we press the next button it will prompt us to choose one of three configuration styles. The three styles are Developer Machine, Server Machine, and Dedicated Machine and out of the three we will want to choose the Development Machine. After we press next we will be prompted to set up the TCP/IP, create a Windows Service and create a password for the Root account of MySQL Sever. After pressing the next button it will apply these changes and allow you to press the next button to the final screen.
The last screen will give you the option of viewing the installation log as well as start the MySQL Workbench after pressing the Finish button. We want to open the workbench and make a database so leave the check box for opening the workbench still checked. After we press Finish the MySQL Workbench will run and you will see the following screen.
Once the MySQL Workbench is open we can proceed to making a Database within it. To do this we will need to go to the middle right of the screen and choose Open Connection to Start Querying and double click on our MySQL instance. Once clicked, it will ask you for the password of the Root user of the MySQL server. Enter it, choose whether you want added security of having to enter it all the time, or check the checkbox to add the password to the vault to auto log you in next time and then click OK. We will then be brought to the SQL Editor as shown below.
Once the SQL Editor is up we can start to create our Database. To do this we need to create a new Schema which is under the Overview table and looks like the Database symbol with a plus sign next to it. If you are still unable to locate it, hovering over items will bring up the tooltip and you are looking for “Create a New Schema“. Once you press the icon we will be directed to enter a name for the schema, we chose javadatatest. After we click Apply the next screen will show us what SQL Statement will be run to complete what we needed done. Go ahead and click apply and you will be directed to the next screen which will give you any errors that occurred or if it completed successfully. If it was successful you should see something like the image below.
You can then proceed to press Finish and then will be directed to our previous dialog box to create a schema which we can now close. With this done you are now able to see that we have created a new database and are ready to start adding in Tables, Stored Procedures amongst other things. Now that we are at the end of the tutorial on how to make a database, you should know how to install, configure and setup a new database in MySQL Workbench. Until the next tutorial, Happy Hacking!