Let's install the MySQL 8 DB server on a windows system and do the configuration as a development server.
Install MySQL 8 DB on Windows systemsStep-1 Download the MySQL installer
Download the latest stable version of MySQL installer from here. There will be two download links one will be mysql-installer-web-community-x.x.x.x.msi which will be less in size and is an online installer. The other one is mysql-installer-ommunity-x.x.x.msi which is an offilne installer and large in size.
You can download and install with any of the links but the first one requires internet to download the required files through out the installation process. In this tutorial offline installer is downloaded and installed.Step-2 Start Installtion
When the installation begins it first asks for "setup type" as shown below. For developers select default option otherwise select as per your requirement.
In some systems if any system requirements are not met the following screens appear, which require to be resolved manually. Otherwise also you can ignore the below screens and move forward.
Now the actual installation begins after pressing "Execute" and progress can be seen product wise as below and success screen appears after all products are installed.
Read Also: Install PHP on Windows System.
Read Also: Install Apache2.4 on Windows System.
Read Also: Install Composer on Windows System.Step-3 Product Configuration
After installation it asks for configuration of its products as shown below. Click on "Next"
Under High Availability default option will be "Standard MySQL Server" which is sufficient for developers. Select "InnoDB Cluster" option if you want your DB to be installed as a part of Cluster. Select default option and click "Next"
Under Type and Networking just check for the default options here click "Next" for developers. If you want to change the access port of your DB you can change here.
From MySQL 8 onwards authentication has been improved based on strong SHA-256 based methods, this is the default option. Here if you are configuring DB for new application development then go for the default option. Otherwise if you are configuring DB for existing application Use Legacy Authentication Method based on your application compatibility.
Now cretae the Root password for your DB. You can aslo add users for DB access now itself or you can do it after logging in as root user.
Under Windows Service click "Next" with default options unless otherwise you want to restrict access to a particular User.
Now click on "Execute" to apply all our selected configurations to MySQL Server. After Configuration is done click "Finish".
In the next step "MySQL Router" configuration will be done. But as we have not installed our DB as InnoDB cluster we will simply click "Next" and then "Finish".
Next step will install Samples and Examples for our reference. Click on "Next". In the next screen provide your created credentials and click "Check". If your connection is succeeded click "Next".
Now Apply the configuration by clicking "Execute". Once executed click on "Finish".
Now you you can see the all products configuration status here. Click on "Next"
Now you can see the Installation Complete screen. You have successfully installed MySQL 8 DB on your windows system. Click on "Finish" will launch the MySQL Work Bench.Step-4 Login to MySQL Workbench and create Database.
Now you can login to your MySQL server and can create DB. Thanks for reading this post.