How do I install MySQL on Windows 10 64

This video tutorial teaches you to install MySQL latest sever on Windows 10 64 Bit computer. This installer of MySQL server add the service in Windows services that starts the MySQL server at boot time.

First MySQL Server was developed by a company called MySQL AB, this company was founded in 1995. MySQL AB was acquired by by Sun Microsystems in 2008. Later on Sun Microsystems was acquired by Oracle and currently MySQL Server is with Oracle.

MySQL Server is most used open source database relational database server, source code of this project is  available under the terms of the GNU General Public License.

In this video tutorial we are going to learn how to install world's most popular database server on Windows 10 64 Bit computer. The same process applies to the 32Bit System.

I the video you will see the complete installation process, here I am going to write about the important steps of the installation process.

Here is video tutorial "Downloading and installing MySQL on Windows 10":

Here are the steps to download and install MySQL Server on Windows 10:

Step 1: Downloading MySQL Server

To download MySQL Server visit http://dev.mysql.com/downloads/ and then select the "MySQL Community Server (GPL)". The follow the screen to download MySQL installer.

How do I install MySQL on Windows 10 64

Step 2: Select the MySQL Community server

Now click on the download link as shown below:

How do I install MySQL on Windows 10 64

Step 3: Select the version

Now select 64BIT or 32BIT installer as shown below:

How do I install MySQL on Windows 10 64

Step 4: Continue download

If you have username and password of MySQL server you can login other wise click on the "No thanks, just start my download." to continue the download as shown below:

Download the latest Mysql Community server from MySQL official website. For me, it is 8.0.12, if the version differs you no problem the installation steps will be the same.

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. It will redirect you the actual download page for windows Mysql server.

How do I install MySQL on Windows 10 64

Step 2: 

It will show you Generally Available (GA) Releases. Where we can see two different installers, one is a web community installer which comes as a little file and another one is MySQL installer community. Click the Download button on the second one (mysql-installer-community).

How do I install MySQL on Windows 10 64

Step 3:

It will ask your MySQL credentials to download the .msi file. If you have your credentials, you can log in or else if you wish to sign up now you can click on the green coloured signup button.

If you are not interested in login or sign up for now, you can directly go and click on No thanks, just start my download option. It will download selected MySQL for you on your local machine.

How do I install MySQL on Windows 10 64

Step 4:

Go to your downloads folder where you can see the mysql-installer-community file, right click on that file and click Install option.

How do I install MySQL on Windows 10 64

Step 5:

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

How do I install MySQL on Windows 10 64

Step 6:

Read the license agreement and accept the license terms.

How do I install MySQL on Windows 10 64

Step 7:

This window provides you to set up different types of MySQL installations. You can set up Mysql in 5 different types as provided below. Now I am selecting the Developer Default as I am a developer so that I need all the products which help my development purposes. Click on Next.

How do I install MySQL on Windows 10 64

Step 8:

Based on your Windows configuration, it may prompt you like “One or more product requirements have not been satisfied”. You can just click on YES.

How do I install MySQL on Windows 10 64

Step 9:

Click on Execute.

How do I install MySQL on Windows 10 64

Step 10:

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

How do I install MySQL on Windows 10 64

Step 11:

Upon successful execution of all required products, now the MySQL allows us to configure the server settings. Click on Next to configure the server.

How do I install MySQL on Windows 10 64

Step 12:

This step allows you to configure the server. We can set the server in two different modes. One is a standalone mode, and another one is cluster mode. I don’t want to make it as a cluster because I am installing MySQL for development purpose so that I am selecting Standalone MySQL server and click on Next.

How do I install MySQL on Windows 10 64

Step 14:

Choose the Development Computer option from Config Type drop-down. You can find the following controls like TCP/IP, Port and X Protocol Port. If you wish to configure your port, you can change here itself and click on Next. For now, I am leaving as its default configuration.

How do I install MySQL on Windows 10 64

Step 15:

It is prompting you to select the authentication method, leave it as the default recommended method and click on Next.

How do I install MySQL on Windows 10 64

Step 16:

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

How do I install MySQL on Windows 10 64

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.

How do I install MySQL on Windows 10 64

Step 18:

Leave the service details as default and click on Next.

How do I install MySQL on Windows 10 64

Step 19:

Press Execute to apply the configurations on the previous step.

How do I install MySQL on Windows 10 64

Step 20:

Upon execution, you can see the below green coloured ticks on every configuration option and finally you will get Finish button.

How do I install MySQL on Windows 10 64

Click on Finish you got your MySQL on your Windows 10 operating system.

Testing:

Search for MySQL in your taskbar search item. There you can see all MySQL products which we installed and click on MySQL client; it will ask your MySQL password to login, after successful login you could see the MySQL prompt like below.

How do I install MySQL on Windows 10 64

MySQL comes along with some default databases. We can see the databases by using show databases command.

Is MySQL available for 64

MySQL is available for Microsoft Windows, for both 32-bit and 64-bit versions.

How to install MySQL X64?

How to Download MySQL's Free Community Edition.
Go to the MySQL website and select Downloads..
Select MySQL Community (GPL) Downloads. ... .
On the following page, select MySQL Community Server..
Scroll down to the bottom of the page and select the Go to Download Page next to Windows (x86, 32 & 64-bit), MySQL Installer MSI..

How do I install and run MySQL on Windows 10?

The simplest and recommended method is to download MySQL Installer for Windows from https://dev.mysql.com/downloads/installer/ and execute it. Select mysql-installer-web-community-8.0. 23. msi if you have good internet connection, otherwise choose mysql-installer-community-8.0.

Is MySQL 32 or 64

Although MySQL Installer is a 32-bit application, it can install both 32-bit and 64-bit binaries.