The key steps to install MySQL on Windows 11 are as follows: 1. Download the correct version, select the MSI installation package for Windows and ensure that the system is 64-bit; 2. Select "Custom" mode during installation, add MySQL Server and set the appropriate installation path; 3. Run the configuration wizard, select the "Server Computer" configuration type, set the root password, and select the automatic startup method; 4. After the test installation is successful, if the prompt command is unavailable, add the MySQL bin directory to the system PATH environment variable. Follow these steps to complete the installation and configuration smoothly.

Installing MySQL is not difficult on Windows 11. As long as the steps are clear, there will basically be no problems. The key is to choose the right version, configure the environment, and remember to set the password and start the service.

Download the appropriate version of MySQL

First, you have to go to the official website to download the correct installation package. Visit the MySQL official website and select the MSI installation package for Windows. It is recommended to select the option "Windows (x86, 64-bit), MSI Installer".

• Register or log in to an Oracle account is optional. Click "No thanks, just start my download." to download it directly.
• Make sure the system is 64 bit, otherwise it may not be installed

After the download is completed, double-click to run the installer. Don’t rush to click the next step. Let’s take a look at the following key steps.

Run the installation process correctly

After the installation wizard is opened, select "Custom" to customize the installation mode, so that components can be controlled more clearly.

• Add MySQL Server to the installation list (usually checked by default)
• Try not to place the installation path in the root directory of the C disk to avoid permission problems
• After installation, you will prompt whether to run the configuration wizard. Remember to select "Yes"

After this step is completed, we will enter the most important configuration step.

Configure MySQL Server

There are several key points that must be paid attention to in the configuration stage:

• Select configuration type : Selecting "Server Computer" is more suitable, suitable for most development purposes
• Set root password : Remember! This is the highest permission account for the database
• Name service name : Generally, default is MySQL80, no need to change it
• Startup method : It is recommended to choose automatic startup, which is convenient for direct use every time you start the machine

After these are done, click Execute to start applying the configuration. If there is no error, the configuration is successful.

Test whether the installation is successful

Open a command prompt (CMD) and enter:

 mysql -u root -p

Then enter the root password you just set. If you enter the mysql> prompt, the installation is successful.

If the prompt不是內(nèi)部或外部命令, it may be that the MySQL bin directory is not added to the system environment variable. The solution is as follows:

• Find the bin folder in the installation directory (for example, C:\Program Files\MySQL\MySQL Server 8.0\bin)
• Add this path to the system's PATH environment variable
• Restart CMD and try again

Basically that's it. The whole process is not complicated, but some details are easy to ignore, such as environment variables, root password settings, and the wrong version selected during installation. Just take it step by step and it will be done smoothly.

The above is the detailed content of How to install MySQL on Windows 11. For more information, please follow other related articles on the PHP Chinese website!