Graphic tutorial on installing MySQL5.5.28 on Windows XP

MySQL database installation is divided into two parts: database installation and database configuration.

I. Installation of MySQL database

1. Double-click the downloaded MySQL Installation File ,:

2. The MySQL5.5 Installation Wizard dialog box is displayed. click Next ,:

3. Open the End-User License Agreement dialog box, select the I accept the terms in the License Agreement check box, and click the Next button ,:

4. Open the Choose Setup Type dialog box. The installation types listed in 3 are Typical, Custom, and Complete. If you select the Typical or Complete installation method, the confirmation dialog box is displayed. Confirm the selection and start installation. If Custom is selected, the Custom (Custom) dialog box is displayed. Select Custom and click Custom ,:

The meanings of the three installation types are as follows:

Typical:Install the MySQL server, the MySQL command line client and the command line user program. The command line client and utility include mysqldump, myisamchk, and several other tools to help manage the MySQL server.

Complete: Install all components included in the package. Fully installed software packages include Embedded Server libraries, benchmarking kits, supporting scripts, and documents.

Custom:Installation allows full control of the software package to be installed and the installation path.

5. Open the Custom Setup dialog box. All available components are listed in the Tree View on the left side of the Custom Setup dialog box. uninstalled components are marked with red icons. installed components have gray icons ,:

6. By default, select "Install all". To change the component, click the component icon, select a new option from the drop-down list, set the installation path, and click "Next ,:

The four options mean:

Will be installed on local had drive:This additional component is installed on the local hard disk.

Entire feature will be installed on local hard driver:This component feature and its sub-components are sent to the local hard disk.

Feature will be installed when required:Indicates that this additional component is installed only when necessary.

Entire feature will be unavailable:This component is not installed.

The default installation path for MySQL is "C: \ Program Files \ MySQL Server 5.5 \". To change the installation path, you can click the Browse button on the right of the installation path to change the default installation path.

7. The installation confirmation dialog box is displayed. Click the Install button ,:

8. Start to install the MySQL file. The settings made during the installation wizard take effect after the installation is complete. You can view the current installation progress through the progress bar ,:

9. After the installation is complete, a dialog box about the MySQL Enterprise version is displayed. Click More ,:

10. Open a page in the browser and click Next to enter the second introduction dialog box ,:

11. Click Next To Go To The installation completion page ,:

In the installation completion dialog box, select Launch the MySQL Instance Configuration Wizard. Select this option. the MySQL installation file starts the MySQL Configuration Wizard. Select the option and click Finish. The MySQL Configuration Wizard dialog box is displayed. If this option is deselected, you can directly start the MySQL InstanceConfig.exe file in the MySQL installation bin directory to configure MySQL ..

Ii. MySQL Database Configuration

After mysqlinstallation is complete, you can configure the server and use the graphical Configuration tool mysqlinstanceconfig.exe. Start MySQL Instance Configuration wizardand directly double-click mysqlinstanceconfig.exe in the bindirectory of the mysqlinstallation directory to start the Configuration Wizard. The specific configuration steps are as follows:

1. Start the Configuration Wizard and enter the configuration dialog box ,:

2. Click Next To Go To The select Configuration Type dialog box. In the Configuration type dialog box, you can select two Configuration types: Detailed Configutaion (Detailed Configuration) and Standard Configuration (Standard Configuration ),:

The meanings of each option are as follows:

Standard Configuration:This option is suitable for new users who want to quickly start MySQL without considering server configuration.

Detailed Configuration:This option is suitable for advanced users who want to control server configurations in more detail.

3. To learn how to configure MySQL, select the detailed configuration option and click Next to enter the server type dialog box. You can select three server types, which server will affect MySQL Configuration Wizard's decision on memory, hard disk, and process or usage ,:

As a beginner, it is enough to select Developer Machine, which will not occupy a lot of system resources.

The meanings of each option are as follows:

Developer Machine:This option represents a typical personal desktop workstation. Assume that multiple desktop applications are running on the machine. Configure the MySQL server to use the least amount of system resources.

Server Machine:This option indicates the server. The MySQL server can run with other applications, such as FTP, Email, and Web servers. Configure the MySQL server to use the appropriate proportion of system resources.

Dedicated MySQL Server Machine:This option indicates the server that only runs the MySQL service. If no other application is running, the MySQL server is configured to use the available system resources.

4. Click the Next button to go to the select database usage dialog box. There are three options in this dialog box. Generally, select the default first single-choice button, that is, multi-function database ,:

The meanings of the options are as follows:

Multifunctional Database:If this option is selected, the InnoDB and MyISAM storage engines are used at the same time, and resources are evenly allocated between the two engines. We recommend that you select this option when using two storage engines.

Transactional Database Only:This option uses both the InnoDB and MyISAM storage engines, but assigns most server resources to the InnoDB Storage engine. We recommend that you use InnoDB and select this option occasionally when using MyISAM.

Non-Transactional Database Only:This option completely disables the InnoDB Storage engine and assigns all server resources to the MyISAM engine. However, MyISAM data types that do not support transactions are supported.

5. Click the Next button to enter the InnoDB tablespace configuration dialog box. You can select a storage location for the InnoDB data file. Generally, you can select the default location directly. Drive info displays the partition information of the storage location ,:

6. Click the Next button to go to the set maximum number of concurrent connections dialog box, which provides three different connection options. I think it is better to manually set the options, here I change the number of connections to 500 ,:

The meanings of each option are as follows:

Demo-support (DSS)/OLAP:Select this option if the server does not require a large number of parallel connections. Assume that the maximum number of connections is set to 100, and the average number of parallel connections is 20.

Online Transaction Processing (OLTP ):Online transaction processing. Select this option if the server requires a large number of parallel connections. The maximum number of connections is 500.

Manual Setting:Manual settings. Select this option to manually set the maximum number of concurrent connections to the server. Select the number of parallel links from the drop-down list. If the expected number is not in the list, enter the maximum number of connections in the drop-down list.

7. Click the Next button to enter the Network Setting Dialog Box. In the Networking Options dialog box, you can enable or disable the TCP/IP network and configure the port number used to connect to the MySQL server, the TCP/IP network is enabled by default. The default port is 3306. To change the port used to access MySQL, select a new port from the drop-down list or enter a new port directly to the drop-down list box, but make sure that the selected port number is not occupied. If you select the Add firewall exception for this port check box, the firewall will allow access through this port and select this option here. If the Enable Strict Mode option is selected, MySQL will strictly check the input data. I personally think it is a good choice, so that you can strictly abide by the MySQL rules, you can develop a good habit ,:

8. Click Next to open the dialog box for setting the default MySQL language encoding character set. This dialog box provides three types of character sets. If you want to support Chinese characters, commonly used options include latin1, gb2312, gbk, or UTF-8. If they are all English characters, you can select latin1. If you want to support Chinese characters, you can select the National Standard gb2312 or gbk, if you want to support multiple languages, you can select UTF-8. Here, you can select UTF-8 from the drop-down list of the third option. There is another reason to choose this option, it is to use java to connect to the database to avoid Garbled text. If Garbled text occurs, add "? UseUnicode = true & characterEncoding = UTF-8 ":

The meanings of each option are as follows:

Standard Character Set:Standard character set. If you want to use Latin1 as the default server Character Set, select this option. Latin1 is used in English and many western European languages.

Best Support For Multilingualism:Supports multiple languages. Select this option if you want to use the UTF-8 as the default character set. The UTF-8 can store characters in different languages as a single character set.

Manual Selected Default Character Set/Collation:Default Character Set/collation manually selected. If you want to manually select the default Character Set of the server, select this option. Select the expected character set from the drop-down list.

9. Click Next to enter the dialog box for setting Windows options. Here, you can select to install MySQL as a Windows Service, specify the service name, and allow the command line, after the command line is enabled, you can use the command line to operate MySQL ,:

The meanings of each option are as follows:

Select the Install As Windows Service check box to Install MySQL As a Windows Service.

In the drop-down list box on the right of the Service Name, you can select the Service Name or enter the Service Name on your own.

When the Launch the MySQL Server automatically option is selected, MySQL will be automatically started after Windows is started. I think the automatic start is not very good, but it can be started only when necessary. Here we select automatic first, after the installation is complete, change it to manual.

Select the Include Bin Directory in Windows PATH option. The bin Directory of MySQL will be added to the PATH environment variable. in cmd mode, you can directly use the files in the bin Directory, instead of entering the complete address every time.

10. Click Next to enter the dialog box for setting security options ,:

The meanings of each option are as follows:

To set the root password, enter the password to be set in the New root password and Confirm text boxes.

To disable root login over the network, you do not need to select the Enable root access from remote machines (only allow local login and connection) check box. This improves the security of the root account. Here I select this option.

To Create An Anonymous user Account, select the Create An Anonymous Account check box. Creating an anonymous account reduces server security. Therefore, we do not recommend that you select this option.

If you do not want to set the root password, do not select the Modify Security Settings check box.

11. Click the Next button to go to the "prepare for configuration execution" dialog box ,:

12. If the settings are correct, click the Execute button. The MySQL Server Configuration Wizard executes a series of tasks and displays the task progress in the dialog box: click Finish to complete the configuration.

In this way, the installation and configuration of the MySQL database are complete.