HomeWindowsHow to Download & Install MySQL On Windows 11

How to Download & Install MySQL On Windows 11

-

Key Takeaways
  • MySQL is a top database management system for working with databases
  • Download and install Microsoft Visual C++ 2019 Redistributable Package before installing MySQL on Windows 11
  • Follow step-by-step instructions to download MySQL installer, select installation type, configure server type, and complete the installation on your Windows 11 PC.

When it comes to dealing with databases, MySQL is one of the best options. MySQL is a database management system that can be used to work with databases. To use MySQL, youโ€™ll need to download and install the Microsoft Visual C++ 2019 Redistributable Package. If you want to install MySQL on Windows 11 but donโ€™t know-how, this article will guide you through the process. Weโ€™ll talk about how to install MySQL on Windows 11 in this article.

Download And Install Microsoft Visual C++ Redistributable Package

Firstly, you will have to download and install the Microsoft Visual C++ Redistributable Package. To download and install Microsoft Visual C++ Redistributable package on your PC, follow the steps given below-

How To Download & Install MySQL On Windows 11

Download And Install MySQLย 

Once you have installed the Microsoft Visual C++ Redistributable Package on your PC, you can get ahead with installing MySQL on your PC with Windows 11. Given below is the step-by-step process to download and install MySQL on your PC-

  • Head to the officialย download pageย of MySQL. From here, download the MySQL installer.
  • Now open the File Explorer by pressing theย Windows + Eย key combo and head to the location where you saved the MySQL installer. Double-click on the file to run it.
  • You will see the installer app window open up on your PC. If you are given UAC, then click on theย Yesย button to continue.
  • You will be asked to select the setup type of installation. You will be given these options-
    • Developer Defaultโ€“ In this type of installation setup, tools requirements for MySQL application development will be installed. The tools will include MySQL Shell, MySQL Router, MySQL for Visual Studio, MySQL Workbench, MySQL Server, and MySQL Connectors.
    • Client Only-ย This type of installation setup installs all the tools that are there in the Developer Default setup type, except for the MySQL Server.
    • Server Only-ย This setup type of installation will only install MySQL Server on your PC.
    • Fullโ€“ย This type of installation setup installs all the MySQL products including samples, examples, as well as documents of the tools.
    • Custom-ย Choosing this option allows you to select custom products of MySQL.
  • Once you have selected the installation type, click on theย Nextย button.
  • Next, you will see all the products that will be installed on your PC. Click onย Executeย button to install the tools.
  • After the installation is completed, click on theย Nextย button to continue ahead.
  • Next, you will be asked to configure the server type on your PC. To do so, click on the drop-down menu next to theย Config typeย on theย Type and Networking.ย You will be given three server configurations that you can choose.
    • Development Computer-ย This type of server configuration is best if you run several servers and applications on your PC.
    • Server Computer-ย If you run MySQL along with a few other server applications, then you can go for this type of server configuration. The memory usage for this configuration will be moderate.
    • Dedicated Computer-ย If you donโ€™t plan on running any other servers on the machine, then you can go for this type of server configuration.
  • If you want to you can also select theย TCP/IP ports.ย If you do not want to select them, then leave them to the default settings. Once done, click on theย Nextย button.
  • You will be headed to theย Authentication Methodย tab. You will have to select the authentication method, which can beย Use Strong Password Encryption for Authenticationย orย Use Legacy Authentication Method. Once done, click on theย Nextย button.
  • Next, you will be headed to theย Accounts and Rolesย tab. You will be asked to create a password for the root account. To do so, you will have to enter the password in the given field.

If you want you can also make aย User Account; all you have to do is click onย Add Userย option, and you will be able to create a user account.ย 

  • You will have to enter theย Username,ย Roleย and enter theย Passwordย for the account. Once done, click onย OK.ย After doing so, click on theย Nextย button.
  • You will now be headed to theย Windows Serviceย tab. Here, you will see theย Configure MySQL Server as a Windows Serviceย option. In case, if you want to run it as a Windows Service, then check this option, and if you donโ€™t want to run it as a Windows Service, then let this option be unchecked.
  • If you want to go for aย Windows Service Name,ย then enter the name. If you want to start MySQL Server when your system starts, simply check the checkbox sayingย Start the MySQL Server At System Startup. Once done, click onย Next.ย 
  • You will now be headed to theย Apply Configurationย tab. Click on theย Executeย button to get ahead.
  • After this, you will have to go for router configuration to bootstrap the MySQL router that is already installed. This will help direct traffic between MySQL apps as well as the InnoDB cluster. Once done, the MySQL Router will run as the Windows Service. If you do not want to go for router configuration, then simply click on theย Finishย button, and then on theย Product Configurationย screen, click on theย Nextย button.
  • You will now be headed toย Connect to serverย tab. Here enter theย Passwordย in given. Once done, click on theย Checkย button. Once you see the status asย Connection succeeded, click on theย Nextย button.
  • You will be headed to theย Apply Configurationย window. Here, click on theย Executeย button.
  • Once all the configuration has been applied, click onย Finish.ย Now, click on theย Nextย button on theย Product Configurationย screen to continue.
  • After doing so, the installation process for MySQL will be completed. You will be shown some documentation for the use of the tool. If you want to get ahead with it, then click on the document you want to open. If you donโ€™t want to get ahead with it, then click onย Finish.ย 

RELATED:ย 

Final Words

This is how you can install MySQL on Windows 11 PC. Given above is the step-by-step process to install MySQL on Windows 11 PC. Following the above steps, you will be able to easily install MySQL on your PC.

Anurag Jain
Anurag Jainhttps://itechhacks.com
Anurag is a Senior content analyst with 4 years of experience in the industry. Based in India, He is extremely skilled at Windows related to How to Troubleshooting matters. His favorite topics are Windows 11, Android, and How To's.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

LATEST