MySQL is an SQL-based Relational Database Management System (RDBMS) applied widely in e-commerce, data warehousing, and logging applications. It’s a freely available and industry-leading, open-source (under the GPL License) database that leverages the power of SQL (Structured Query Language) for proven reliability, ease of use, flexibility, and quick processing. The database provides great features and is fully supported in the Windows environment. For this reason, users may want to taste its advantages either in the cloud or physically.
To take advantage of MySQL on your Windows platform, you need to get past one hurdle; Installing the application properly. Although the installation is extremely quick and simple, multiple components should be handled cautiously for MySQL to run smoothly. This tutorial will give you a step-by-step guide on how to successfully install MySQL on your Windows platform via the MySQL installer.
Let’s get started!
- For this process to work flawlessly, you must be logged into your PC as the administrator.
STEP 1: Downloading the MySQL Installer
The first and the most important step is downloading and installing the MySQL Installer. The Installer provides a user friendly wizard with key components for expediting installation and running MySQL with ease. The components include the most recent version of: MySQL for Excel, MySQL connectors, MySQL server, Documentation, Sample Databases, MySQL for visual studio, MySQL workbench, MySQL sample models, MySQL Notifier.
MySQL Installer is a 32-bit application capable of installing both the 64-bit and 32-bit binaries faultlessly. You need to pick the right file from the two options; follow this link: http://dev.mysql.com/downloads/installer/
- If you have internet connection while executing the installer, follow this link
- On the other hand, if you don’t have an internet connection, then the is the best option.
Make sure you download the right option:
Now we have the right MySQL installer downloaded; we can proceed to the next step.
STEP 2: Installing and configuring MySQL
Note: MySQL file is a zip file, you must have an unzipping software installed on your PC to access the archive folder. Once you unzip the installation file, double-click on the Installer file (Setup.exe) to initialize the installation process.
Welcome screen (Installation wizard)
The Windows will configure and install the MySQL Installer and take you to the welcome screen.
Click on “Install MySQL Products,” read and accept all the license terms. The Installer will check the latest versions of MySQL products such as MySQL Workbench, MySQL server, and more. If any of the product you are about to install is not available, the Installer will automatically download it. Tick the following boxes:
Select setup option
Click next to continue to select the setup type. The Installer avails multiple setup options, including developer default, server only, client only, full, and custom. The “custom” setup option allows you manually select the exact product you want to install and specify where to install it. This is an ideal setup type if you want Apache and MySQL installed in the same directory.
You can pick the “Full” setup option if you want to install all MySQL products available in the catalog including MySQL server, MySQL for Excel, MySQL connectors, MySQL workbench and sample models, Documentation, MySQL for visual studio, MySQL Notifier, and Sample Databases. On the other hand, the “developer default” option lets you install MySQL on your Dedicated Server (cloud or physical server) where you plan to develop other applications.
By now you know the setup type that suits your need. Before, you click next, ensure the data and installation paths are correct. It’s advisable to leave these paths to their default setting, but take note of the installation path to know where the MySQL is installed.
Checking the requirements
The Installer will highlight all the requirements that must be downloaded before you install the selected products. If there is a requirement that you cannot meet, go back to the product list and deselect the product that calls for it. All installed requirements will be marked in green whereas the boxes of those that are not installed will not be marked.
When all the requirements are met, you can click next to prompt the Installer to download the products you selected.
This may take time depending on how fast your internet connection is and the products selected.
Once the download is complete, click next to proceed to product configuration. This is a crucial step, fortunately, it’s a snap with the MySQL Installer. Here you ought to choose your ideal MySQL configuration type. By default, the configuration type is development machine, but it can also be set to the server machine or dedicated machine option. Leave it as “development by machine” and enable TCP/IP networking. Select MySQL port as 3306 and click next to continue.
Choosing a password for MySQL root account
The administrative account is root which means you have no option to change it. However, you must set an intricate password for the root account. The Installer will authenticate the complexity of your password, and notify you if it’s strong or weak.
Finish the configuration.
After setting the password for your root account and adding your DB Admin user, click next to move to the last step of MySQL server configuration. The next window allows you to edit the Windows service name and configure your Windows server details. Select your ideal Windows server name and click next. You will proceed to configure samples and examples, click next to finish the configuration process.
Click the “finish” button to end the process and close the MySQL installation wizard. The MySQL Workbench will launch and be ready for use.
This tutorial has taken a straightforward approach to MySQL installation on Windows platform using the MySQL installer. It’s important to note that unlike the customary MySQL installer, the web-community version doesn’t bundle MySQL applications but is capable of downloading all the products selected for installation. Having installed your MySQL successfully, you can now download MySQL sample database, load it into your MySQL server, and start learning and practicing MySQL.