How To Setup Mysql Server On Windows

Summary: in this tutorial, you will larn step by step how to install MySQL on the Windows platform using the MySQL Installer. After the tutorial, you volition have a MySQL server and its tools upward and running on your system for learning and practicing.

Note that if you lot use other operating system platforms such as Linux and macOS, you utilise the post-obit tutorial:

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

Download MySQL Installer

If you want to install MySQL on the Windows surroundings, using MySQL installer is the easiest way. MySQL installer provides you with an easy-to-use wizard that helps yous to install MySQL with the following components:

• MySQL Server
• All Bachelor Connectors
• MySQL Workbench with Sample Data 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 yous are connecting to the internet while installing MySQL, you tin choose the online installation version mysql-installer-web-community-<version>.exe .
• In instance you want to install MySQL offline, y'all tin 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 two – Welcome Screen: A welcome screen provides several options. Choose the starting time choice: Install MySQL Products

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

Install MySQL Step four: Click the Next button to continue

Install MySQL Step v – Choosing a Setup Type: there are several setup types available. Cull the Full choice to install all MySQL products and features.

Install MySQL Step half dozen – Checking Requirements

Install MySQL Stride seven – Installation Progress: MySQL Installer downloads all selected products. It will take a while, depending on which products you selected and the speed of your internet connection.

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

Install MySQL Stride vii – Installation Progress: Complete Downloading. Click the Next button to continue…

Install MySQL Step 8 – Configuration Overview. Click the Adjacent button to configure MySQL Database Server

Install MySQL Stride eight.i – MySQL Server Configuration: choose Config Type and MySQL port (3006 by default) and click Side by side button to continue.

Install MySQL Step 8.i – MySQL Server Configuration: cull a password for the root account. Delight note the countersign download and go along it securely if you are installing MySQL database server on a production server. If y'all desire to add a more MySQL user, you can do information technology in this pace.

Install MySQL Footstep 8.1 – MySQL Server Configuration: cull Windows service details including Windows Service Proper name and account type, then click Next button to go along.

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

Install MySQL Step viii.ane – MySQL Server Configuration – Washed. Click the Adjacent button to continue.

Install MySQL Footstep 8.ii – Configuration Overview: MySQL Installer installs sample databases and sample models.

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

In this tutorial, yous 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: fullerseethe79.blogspot.com

Share this post