How To Install MySQL On Windows 11 – Guide #2023

Byadmin

One of the most flexible and popular options for working with databases is MySQL. MySQL will function wonderfully for any purpose whether you’re a crew of database professionals. Or building a data-driver B2B business or an undergrad looking to install it for a semester project. So, today, in this article we will learn how to install My SQL on Windows 11 pc.

MySQL is among the best database systems to use if you’ve been working on a project that calls for you to collect and process data.

Nevertheless, you would also have to install the Microsoft Visual C++ 2019 Redistributable Package.. So let’s start with the Microsoft Visual Redistributable Package before moving on to MySQL.

Microsoft Visual Redistributable Package: Download and Install

  • To achieve this, use your favorite browser to navigate to docs.microsoft.com/latest-supported-vc-redist. Next, identify the download links by scrolling down the page and selecting the one that corresponds to the configuration of your machine.
  • Once obtained, locate the .EXE file in your normal downloads location and double-click it to launch the installation.
  • Once you have checked the box next to “I agree to terms and conditions” in the Visual Installer window, press the “Install” key.
  • A UAC (User Account Control) windowpane will then make an appearance. Insert the login information for an administrator account if you don’t have one already. Or else, press the “Yes” button to start the installation.
  • The installation process on your PC can take a little longer. You will be informed on the Visual installer window when the program has been successfully installed. To turn off the computer, hit the “Close” button to apply the configuration.

Let’s go on installing MySQL on your PC now since you have the Visual C++ Redistributable module.

The procedure to Install MySQL on your PC by downloading it

Utilizing the official MySQL installer is the quickest and most straightforward option to access and install MySQL on your Windows 11 computer. You will nonetheless need to download it first.

  • Use your favorite browser to get to the official MySQL download page at mysql.com/downloads. Then, to continue, scroll to the bottom and choose the “MySQL Community(GPL) Downloads” box.
  • Now, to proceed, you need to select “MySQL Community Server” from the “Community Downloads” tab.
  • After this, select the “Go to Page” link Download found on the webpage’s “Recommended Download:” column.
  • Afterward, press the “Download” button that is located on the tile with the greater file size to start the installation download.
  • Use the “No thanks, just start my download” link on the following page to proceed.
  • Once downloaded, locate the .MSI file in your default downloads location and double-click it.
  • Keep waiting as Windows configures the installation; this process will take a few minutes.
  • Your device will then display a UAC (User Account Control) screen. Input login information for an admin account if you are not already logged in with one. If not, you need to use the “Yes” button to proceed.
  • You must now choose an installation setup from the MySQL installer window.

For your use, we’ve included a brief summary of each of them below:

Developer Default: This installation type includes the MySQL server and numerous development tools. The installation consists of MySQL Server, MySQL Connectors, MySQL Shell, MySQL Router, MySQL Workbench, and MySQL for Visual Studio.

Server Only: If you select this setup type, MySQL Server will be the only thing installed. The ideal scenario for this is when you want to deploy a MySQL server but not MySQL applications.

Client Only: With the exception of MySQL Server, the “Client Only” configuration type installs all the tools included in the “Developer Default” configuration type. If you want to create an application for a server that already exists, you can select this option.

Full: As its name implies, this class comprises every MySQL product as well as utility samples, examples, and manuals.

Custom: By implementing this plan, you may choose each tool, their particular versions, and even the layout by yourself (depending on OS).

Furthermore,

  • By selecting the radio button next to the choice, choose the setup type. Afterward, to continue, click the “Next” button located in the window’s bottom right corner.
  • The installation of all indicated tools will then begin when you hit the “Execute” button on the next screen.
  • After all the tools have been installed successfully perfectly, choose the ‘Next’ button to continue.

The server type on your PC will then need to be configured. You can select from three different server configuration types:

  • Select your desired choice from the drop-down menu that appears after the “Config type” alternative. In order to connect with SQL, you may also customize the TCP/IP ports as desired. It is preferable to leave it at its default settings if you are unsure. To continue, you have to click the “Next” tab.
  • If you are building a new server from zero, select the “Use Strong Password Encryption for Authentication” box. Instead, you can select “Utilize Legacy Authentication Method” by selecting on the radio box.
  • After that, you must establish a password for the root account in the corresponding sections on the “Account and Roles” window.
  • If you decide to create user accounts, type the user’s name in the text box and then, choose the user’s status that is next to the “Role:” option.
  • Consequently, default parameters will already be selected to conduct the SQL Server as a Windows Service on the “Windows Service” screen.
  • Select the option next to “Start the MySQL Server at System Startup” to initiate the SQL Server when the system starts.
  • To apply the configuration settings, select the “Execute” button on the next screen.

Moreover,

In the next step, you will be asked for a router configuration to direct traffic between MySQL apps and an InnoDB cluster using. Hit the “Finish” button to proceed if you don’t want to utilize the MySQL Router on your machine.

  • If not, choose the option next to “Bootstrap MySQL Router for use with InnoDB cluster” and customize it to your needs.
  • The password must be entered in the text box on the “Connect to Server” page in order to verify the connection.
  • Select the “Next” button to continue when the server connection is successful and then pick the “Execute” button on the “Apply Configuration” page.
  • Choose the “Finish” button to continue after the setting has been applied.

Now that MySQL has been installed, you may use the on-screen hyperlinks to access the documentation and MySQL Shell sample files.