Install and configure MySQL winx64 and mysqlwinx64 the next day

Install and configure MySQL winx64 and mysqlwinx64 the next day

I. Installation Method

There are two types of MySQL installation files:MSI format, One isZIP Format. Let's take a look at these two methods:

If the file is in MSI format, you can click Install and install it as prompted. In Windows, MySQL is usually installed in the C: \ Program Files \ MySQL directory.

The ZIP format is self-decompressed. After decompression, MySQL can be used, but configuration is required. You can find this on the internet and provide detailed steps for custom installation and configuration. Recommended link: Detailed mysql image and text installation tutorial

Ii. Install MySQL (Windows 64-bit operating system)

(1) double-click to run the downloaded MySQL installation files mysql-5.5.20-winx64.msi.

(2) Start the mysql Installation Wizard and press "Next" to continue.

(3) You must agree to the End User License Agreement and press "Next" to continue.

(4) Select the installation type,The MySQL Installation Wizard provides three installation types:Typical (Typical installation), Custom (Custom installation), Complete (full installation ),I chose the Typical installation method. Therefore, in Windows, the installation Files are generally stored in the C drive's Program Files directory file, that is, the installation directory is: C: \ Program Files \ MySQL Server 5.5 \ bin, and press "Next" to continue.

(5) Prepare for installation and press "Install" to continue.

(6) The installation progress is displayed. After the installation is complete, press "Next" to continue.

(7) MySQL product advertisement, press "Next" to continue.

(8) MySQL product advertisement, press "Next" to continue.

(9) check whether the configuration is performed. I have not configured the configuration here. We will set the configuration later and press "Finish" to complete the installation.

3. Configure MySQL

(1) run the MySQL Configuration Wizard file. Because I chose the Typical installation method, the installation Files are generally stored in the Program Files directory file of drive C in Windows, the installation directory is: C: \ Program Files \ MySQL Server 5.5 \ bin. Find a file namedMySQLInstanceConfig.exeIn the Configuration Wizard file, double-click to run.

(2) Click "Next" to continue.

(3) Select the Configuration type. Here we are prompted for two Configuration Methods: Detailed Configuration (Detailed Configuration) and Standard Configuration (Standard Configuration). I chose Standard Configuration, press "Next" to continue.

(4) check whether the Window service is installed and whether the Path environment variable is configured. For future use convenience, I have selected it and press "Next" to continue.

(5) set the root user password. The two output passwords must be consistent. Otherwise, the password will not pass. Press "Next" to continue.

(6) ask if we want to execute the setting options. If you still need to set the options, press "Back" to modify and configure them. Otherwise, press "Excute" to configure the options.

7) Complete the configuration and press "Finish.

At this point, the installation and configuration of MYSQL are basically complete, and I will verify whether the MySQL service is successfully installed later.

This is the second tutorial on MySQL. I hope it will be helpful for you to install and configure MySQL.