How To Setup A Mysql Server On Windows

Summary: in this tutorial, y'all volition learn stride by pace how to install MySQL on the Windows platform using the MySQL Installer. After the tutorial, you volition take a MySQL server and its tools up and running on your system for learning and practicing.

Annotation that if you use other operating organisation platforms such as Linux and macOS, you use the post-obit tutorial:

• Install MySQL 8 on CentOS vii
• Install MySQL viii on Ubuntu

Download MySQL Installer

If you lot want to install MySQL on the Windows environment, using MySQL installer is the easiest mode. MySQL installer provides you with an piece of cake-to-use wizard that helps you to install MySQL with the following components:

• MySQL Server
• All Bachelor Connectors
• MySQL Workbench with Sample Information Models
• MySQL Notifier
• Tools for Excel and Microsoft Visual Studio
• MySQL Sample Databases
• MySQL Documentation

To download MySQL installer, go to the following link http://dev.mysql.com/downloads/installer/.  There are two installer files:

• If you are connecting to the net while installing MySQL, you lot tin can choose the online installation version mysql-installer-web-community-<version>.exe .
• In case you want to install MySQL offline, you lot can download the mysql-installer-customs-<version>.exe file.

Install MySQL via MySQL Installer

To install MySQL using the MySQL installer, double-click on the MySQL installer file and follow the steps below:

Install MySQL Step 1: Windows configures MySQL Installer

Install MySQL Step 2 – Welcome Screen: A welcome screen provides several options. Choose the offset pick: Install MySQL Products

Install MySQL Step 3 – Download the latest MySQL products: MySQL installer checks and downloads the latest MySQL products including MySQL server, MySQL Workbench, etc.

Install MySQL Step 4: Click the Adjacent button to continue

Install MySQL Pace 5 – Choosing a Setup Type: there are several setup types bachelor. Cull the Total choice to install all MySQL products and features.

Install MySQL Step six – Checking Requirements

Install MySQL Footstep 7 – Installation Progress: MySQL Installer downloads all selected products. Information technology will take a while, depending on which products y'all selected and the speed of your internet connectedness.

Install MySQL Pace 7 – Installation Progress: downloading Products in progress.

Install MySQL Step 7 – Installation Progress: Consummate Downloading. Click the Next button to continue…

Install MySQL Stride 8 – Configuration Overview. Click the Next button to configure MySQL Database Server

Install MySQL Footstep eight.1 – MySQL Server Configuration: choose Config Type and MySQL port (3006 by default) and click Next button to proceed.

Install MySQL Step 8.1 – MySQL Server Configuration: choose a countersign for the root account. Please annotation the password download and continue it securely if you lot are installing MySQL database server on a production server. If you want to add a more MySQL user, you tin can do it in this pace.

Install MySQL Step 8.i – MySQL Server Configuration: cull Windows service details including Windows Service Name and account type, then click Next push button to continue.

Install MySQL Step 8.1 – MySQL Server Configuration – In Progress: MySQL Installer is configuring MySQL database server. Wait until it is done and click the Next push to continue.

Install MySQL Footstep 8.1 – MySQL Server Configuration – Done. Click the Adjacent push to continue.

Install MySQL Step eight.2 – Configuration Overview: MySQL Installer installs sample databases and sample models.

Install MySQL Step nine – Installation Completes: the installation completes. Click the Finish push to close the installation wizard and launch the MySQL Workbench.

In this tutorial, you lot have learned how to install MySQL on your Windows system using the MySQL installer.

Was this tutorial helpful?

Source: https://www.mysqltutorial.org/install-mysql/

Posted by: walstonlond1985.blogspot.com

Share this post