How To Install Mysql Community Server

Install Mysql on Windows 10 Step by Step

In this tutorials, I am going to evidence how to install Mysql on Windows x operating system.

Install Mysql on Windows 10:

I hope this step by stride process to install Mysql on Windows ten will aid yous improve.

Version Data:

Windows 10 Pro
Mysql Community Server eight.0.12

Step 1:

Download the latest Mysql Community server from MySQL official website. For me, it is 8.0.12, if the version differs y'all no problem the installation steps volition be the aforementioned.

By clicking on the above URL, you will see the below options. Select your operating system (Microsoft Windows) and click on Go to Download Page. Information technology volition redirect you the actual download page for windows Mysql server.

Step 2:

It will show yous Mostly Available (GA) Releases. Where nosotros can see ii different installers, i is a web community installer which comes as a footling file and another one is MySQL installer community. Click the Download button on the second one (mysql-installer-community).

Footstep 3:

Information technology will ask your MySQL credentials to download the .msi file. If y'all have your credentials, yous tin log in or else if you wish to sign upward now you can click on the greenish coloured signup button.

If you are non interested in login or sign upwardly for now, you can directly go and click onNo thanks, just outset my download option. It will download selected MySQL for you on your local motorcar.

Stride 4:

Become to your downloads folder where yous can see the mysql-installer-community file, correct click on that file and click Install option.

Footstep 5:

This window configures the installer, in the middle, it may ask you for permissions to change your computer settings or firewall confirmation, you tin have and and so it will take a few seconds to configure the installer.

Step 6:

Read the license agreement and accept the license terms.

Step 7:

This window provides yous to set upwards different types of MySQL installations. Y'all tin prepare Mysql in 5 dissimilar types equally provided below. Now I am selecting the Developer Default equally I am a developer so that I need all the products which assist my development purposes. Click on Next.

Footstep 8:

Based on your Windows configuration, information technology may prompt you like "Ane or more product requirements take not been satisfied". You tin can just click on Yeah.

Step 9:

Click on Execute.

Step 10:

Upon execution of the previous pace, the installer grasps all recommended products in place and asking for our blessing to execute the product installation procedure. Click on Execute.

Step eleven:

Upon successful execution of all required products, now the MySQL allows u.s. to configure the server settings. Click on Nextto configure the server.

Step 12:

This step allows you to configure the server. Nosotros tin set up the server in two different modes. One is a standalone mode, and some other 1 is cluster manner. I don't want to go far every bit a cluster considering I am installing MySQL for development purpose so that I am selecting Standalone MySQL server and click on Side by side.

Step fourteen:

Choose the Development Figurer option from Config Type drop-downward. You can find the following controls like TCP/IP, Port and X Protocol Port. If y'all wish to configure your port, y'all can change here itself and click on Next. For at present, I am leaving every bit its default configuration.

Stride 15:

Information technology is prompting you lot to select the authentication method, leave it equally the default recommended method and click on Adjacent.

Stride 16:

Here you can set up your MySQL root user password. If yous wish to create a new user, you can click on Add User button under MySQL user accounts department.

Step 17:

Upon clicking on Add User button, you will get the user details popup which allows you to create a new user account. After creating the user click on Next.

Step xviii:

Leave the service details as default and click on Next.

Step 19:

Press Execute to apply the configurations on the previous pace.

Step 20:

Upon execution, yous can encounter the below green coloured ticks on every configuration choice and finally you will getFinish push.

Click on Cease you got your MySQL on your Windows 10 operating organisation.

Testing:

Search for MySQL in your taskbar search item. At that place you can see all MySQL products which we installed and click on MySQL client; it volition ask your MySQL password to login, after successful login yous could see the MySQL prompt like beneath.