Way How to Install MySQL on Windows 10 without Harming your Data

One of the world’s popular open-source databases is MySQL. It has also become one of the best choices for web-based applications due to its performance, ease-of-use and reliability.

If you want to process, add or access the data stored in the computer’s database, you’ll need a database management system. MySQL helps you performing those activities.

Because computers can store a large amount of data, database management systems like MySQL play a significant role in computing so know how to Install MySQL on Windows.

Go through this post to learn how to download and install MySQL server in Windows 10 computers.

How to download MySQL on Windows 10

You can download the latest MySQL community server from their official website.

When you’re on the site, choose your operating system and then click on Go to Download Page.

Now, click on Download on mysql-installer-community under Generally Available (GA) Releases.

In case you’re not interested to sign up, you can click on No thanks, just start my download to download MySQL.

How to install MySQL on Windows 10

Locate the folder where mysql-installer-community is download and then run the file.

The installer window will open, accept the license terms after reading the License Agreement.

Now, you will get five different types of MySQL installations. Choose your preferred one and then click on Next.

Click on Yes, if you’re prompted with a window.

After that, click on Execute for Install MySQL on Windows.

Now, the installer will present you with recommended products and will ask for approval to execute them in the installation. Select the products and then click on Execute.

After the successful execution of the products, click on Next to configure the server.

You can set the server in two different modes, standalone and cluster mode. Select one configuration and then click on Next.

Now, from the Config Type drop-down menu, select the Development Computer and then click on Next. You can also configure the port here if you want to.

You will now be prompted to select the authentication method. Click on Next by keep the method as the default recommendation.

Now, you need to create a user. Click on Add User that is under MySQL user accounts.

After you create the user, click on Next.

Make sure you leave the services and information details as it is and then click on Next.

To apply the configuration, click on Execute.

After the successful execution of the above process, you get to see Finish.

Lastly, click on Finish and you have successfully installed MySQL on your Windows 10 OS.

Open MySQL

This is to test out whether you’ve correctly Install MySQL on Windows 10 computer. First, search for MySQL on the Windows search bar and then open it.

When the MySQL window opens, you would see all the installed products, click on MySQL client. You may be asked for your MySQL password, enter it and log in.

After logging, you will see MySQL’s window. It comes with default databases, to see the databases, use the command show databases.