How to install MySQL for Microsoft Windows
Summary: In this post, We will show you how to install MySQL on Microsoft Windows via the MySQL Installer package. After this short tutorial, you will have a MySQL server setup and the extra tools up and running on your operating system and to also help you learn in a lab enviroment.
Your going to need to download the MySQL installer.
The installer package can be found here http://dev.mysql.com/downloads/installer/.
- If you are connecting to the internet while installing MySQL, you can choose the online installation version
mysql-installer-web-community-<version>.exe. - In case you want to install MySQL offline, you can download the
mysql-installer-community-<version>.exefile.
Install MySQL using the MySQL Installer
To install MySQL via the MySQL installer package first double-click on the MySQL installer file and then follow the steps shown below.
Install MySQL.
Step 1: Windows configures MySQL Installer
Install MySQL.
Step 2 – The Welcome Screen: The welcome screen give you several different options. Choose the first option: Install MySQL Products
Install MySQL.
Step 3 – Download the latest updated MySQL products: MySQL installer will check and download the latest MySQL product updates including MySQL server, MySQL Workbench and other required components.
Install MySQL
Step 4: Click the Next button to continue to the next step.
Install MySQL
Step 5 – Choose your Setup Type: there are 5 setup types available on the next screen. Choose the Full option to install all of the MySQL products and features.
Install MySQL.
Step 6 – Checking the Requirements.
Install MySQL.
Step 7 – The Installation Progress Bar: The MySQL Installer will now download all the products you selected. It will take time so be patient. The amount of time it takes to install depends on which products you checked and the speed of the internet connection you are using.
Install MySQL.
Step 7 Continued – The Installation Progress: downloading Products in progress.
Install MySQL
Step 7 Continued – After the Installation Progress: Completed Download. Now click the Next button to continue…
Install MySQL
Step 8 – The Configuration Overview Details. Next, click the Next button to configure the MySQL Database Server component.
Install MySQL
Step 8.1 – The MySQL Server Configuration: Now choose the Config Type and the MySQL port. 3006 is the default port which you may also need to configure in your routers NAT settings. Now click Next the button to continue with the installation.
Install MySQL
Step 8.1 – The MySQL Server Configuration: Now choose a new password for the root account. Note the password download and keep it secure place if you are going to install the MySQL database server in a production enironment. If you need to add a extra MySQL users it can be done it in this step.
Install MySQL.
Step 8.1 – The MySQL Server Configuration. You can now choose the Windows service details which includes the Windows Service Name and account type. Now then click Next button to continue.
Install MySQL.
Step 8.1 – The MySQL Server Configuration – In Progress bar: The MySQL Installer is now configuring the MySQL database server. Please wait until it is completed and then click the Next button to continue.
Install MySQL
Step 8.1 – The MySQL Server Configuration – Done. Click the Next button to continue.
Install MySQL.
Step 8.2 – The Configuration Overview: MySQL Installer will now install the sample databases and sample models.
Install MySQL.
Step 9 – The will Installation will now Complete.
Now click the Finish button to close the installation wizard and launch the MySQL Workbench.
In this post on how to install MySQL you will have learned how to install MySQL on your Microsoft Windows operating system via the MySQL installer.
