Windows XP system Installation MySQL5.5.28 Illustrated tutorial _mysql

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

The installation of MySQL database

1, double-click the download of the MySQL installation file, as shown in the picture:

2, the Pop-up MySQL5.5 Installation Wizard dialog box, click the Next button, as shown in the picture:

3, open the End-User License Agreement dialog box, select the I accept the terms in the License check box, click the Next button, as shown in the picture:

4. Open the Choose Setup Type dialog box, which lists the installation types in 3, namely typical, custom, and complete. If you choose either typical or complete, you will enter the confirmation dialog box to confirm your selection and start the installation. If you choose Custom, you will enter the custom dialog box. Select Custom here, click the Custom button, as shown in the picture:

The 3 types of installation have the following meanings:

Typical: install MySQL server, MySQL command line client and command line use program, command line client and utilities include mysqldump, Myisamchk and several other tools to help manage MySQL server.

Complete: Installs all components contained within the package. The full installation package includes components that have embedded server libraries, benchmark suites, support scripts, and documentation.

Custom: The installation allows full control over the package and installation path that you want to install.

5. Open the Custom Setup dialog box, all available components are included in the tree view on the left side of the Custom Setup dialog box, components that are not installed are indicated by a red icon, and the installed components have a gray icon, as shown in the figure:

6, by default, select all installation, to change the component, click the component's icon and select the new option from the Drop-down list, and set the installation path, click the Next button, as shown in the picture:

Four of these options mean:

'll is installed on the local had drive: indicates that this add-on is installed to the native hard drive.

Entire feature will is installed on the local hard driver: represents the feature of this component and its subcomponents to the native hard disk.

Feature will is installed when required: indicates that the add-on is installed when needed.

Entire feature would be unavailable: indicates that this component is not installed.

The default installation path for MySQL is "C:\Program files\mysql\mysql Server 5.5\", and if you want to change the path to the installation, you can change the default installation path by clicking the Browse button to the right of the installation path.

7, next will go into the Installation confirmation dialog box, click the Install button, as shown in the picture:

8, the installation of the MySQL file, installation Wizard will be done after the installation is completed, the user can see through the progress bar of the current installation progress, as shown:

9, after the installation is completed, will pop up about the MySQL Enterprise version of the introduction of the Description dialog box, click the "More" button, as shown in the picture:

10, open a page in the browser, and then click the Next button to enter the second Introduction dialog box, as shown in the figure:

11, click the Next button to enter the installation completion interface, as shown in the picture:

In the Setup Completion dialog box There is an option "Launch the MySQL Instance Configuration Wizard", and the MySQL setup file will launch the MySQL configuration Wizard with this option selected. Here, select the option and click the Finish button to enter the MySQL Configuration Wizard dialog box to begin configuring MySQL. If this option is unchecked here, you can also configure MySQL by starting the MySQL InstanceConfig.exe file directly into the MySQL installation bin directory.

Second, the MySQL database configuration

After MySQL is installed, the server needs to be configured and the graphical configuration tool can be used to MySQLInstanceConfig.exe. Start the MySQL Instance Configuration Wizard, or double-click the MySQLInstanceConfig.exe Launch Configuration Wizard directly in the Bin directory under the MySQL installation directory. The specific configuration steps are as follows:

1. The Launch Configuration Wizard will enter the configuration dialog, as shown in the following illustration:

2, click the Next button, enter the selection Configuration Type dialog box, in the Configuration Type dialog box can choose two types of configuration: Detailed Configutaion (detailed configuration) and standard Configuration (standard configuration), as shown in the figure:

The meanings of each of these options are as follows:

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

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

3, in order to learn the MySQL configuration process, select the detailed configuration options, click the Next button, enter the Server Type dialog box, you can select 3 types of servers, choose which server will affect the MySQL Configuration Wizard memory, hard disk and process or use of the decision , as shown in the figure:

As a beginner, the choice of developer machine is enough, so that the resources to occupy the system will not be much.

The meanings of each option are as follows:

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

Server Machine: This option represents the server, and the MySQL server can run with other applications, such as FTP, email, and Web servers. The MySQL server is configured to use the appropriate proportional system resources.

dedicated MySQL server Machine: This option represents a server running only the MySQL service. Assuming that no other applications are running, the MySQL server is configured to use the available system resources used.

4, click the Next button, go to the Select Database Purpose dialog box, in which there are 3 options, generally choose the default first radio button, that is, multi-function database, as shown in the figure:

The meanings of the options are as follows:

Multifunctional Database: Select this option to use both the InnoDB and MyISAM storage engines and distribute resources evenly between two engines. It is recommended that users who frequently use two storage engines Select this option.

transactional Database only: This option uses both the INNODB and MyISAM storage engines but assigns most server resources to the InnoDB storage engine, and recommends the main use of InnoDB, Users who occasionally use MyISAM Select this option.

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, into the InnoDB table Space Configuration dialog box, where you can select the InnoDB data file storage location, the general can directly select the default, Drive info shows the location of the partition information, as shown in the figure:

6, click the Next button, into the set up the maximum number of concurrent connections to the Server dialog box, the dialog box provides 3 different connection options, I think the manual settings are better, where I will be the number of connections to 500, as shown in the figure:

The meanings of each of these options are as follows:

Decision Support (DSS)/olap: This option can be selected if the server does not require a large number of parallel connections. Suppose the maximum number of connections is set to 100, and the average number of parallel connections is 20.

Online Transaction Processing (OLTP): on-line transaction processing, select this option if the server requires a large number of parallel connections. The maximum number of connections is set to 500.

Manual Setting: manual setting. Select this option to manually set the maximum number of concurrent server connections. Select the number of parallel links from the Drop-down list, and if the expected number is not in the list, enter the maximum number of connections in the Drop-down list box.

7, click the Next button, enter the Set Up Network Options dialog box, in the Networking Options dialog box can enable or disable TCP/IP network, and configure the port number to connect to the MySQL server, by default, TCP/IP network, the default port is 3306, To change access to the port used by MySQL, select a new port from the Drop-down list or enter a new port in the Direct 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 that port, where this option is selected. If the Enable Strict mode option is selected, MySQL will strictly verify the data entered, I personally think that selection is a good choice, so you can strictly abide by the rules of MySQL, you can develop a good habit, as shown in the picture:

8, click the Next button, open to set the MySQL default language code character Set dialog box, which provides 3 types of character sets, if you want to support Chinese, the common options are latin1, gb2312, GBK or Utf-8, if all are English characters, you can choose Latin1, If you want to support Chinese, you can choose GB gb2312 or GBK, if you want to support a multinational language can choose Utf-8, choose Utf-8 here, from the third option Drop-down list to choose Utf-8, there is another reason to choose this, is to use Java to connect the database when the problem of avoiding garbled, if there are garbled words, after the connection URL plus "Useunicode=true&characterencoding=utf-8" as shown in the picture:

The meanings of each of these options are as follows:

Standard Character set: standard character Set. Select this option if you want to use Latin1 as the default server character set. 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 UTF-8 as the default character set. UTF-8 can store characters in different languages as a single character set.

Manual Selected default Character set/collation: A manually selected set of defaults/proofing rules. Select this option if you want to manually select the default character set for your server. Select the desired character set from the Drop-down list.

9. Click the Next button to enter the dialog box for setting up Windows options, where you can choose to install MySQL as a Windows service and set the service name, and allow the command line, set the Allow command line, you can use the command line to operate MySQL, as shown in the figure:

The meanings of each of these options are as follows:

Select the Install as Windows Service check box to install MySQL as Windows services.

You can select a service name in the Drop-down list box to the right of service name, or you can enter it yourself.

Select launch the MySQL Server automatically option, then the MySQL will start automatically after Windows starts, I feel that the automatic start is not very good, or need to start on the line, here first selected as automatic, after the installation is completed, and then changed to Manual.

Select the Include bin directory in Windows path option, and the MySQL bin directory will be added to the environment variable path, so that later in CMD mode, you can directly use the files in the Bin directory without having to enter the full address each time.

10. Click the Next button to enter the dialog box for setting security options, as shown in the figure:

The meanings of each of these options are as follows:

To set the root password, enter the password you want to set in the new root password and confirm two text boxes.

To disable root logging over the network, do not select the Enable root access from remote machines (only allow connections from this computer) check box. This will improve the security of the root account, where I choose this option.

To create an anonymous user account, select the Create a Anonymous account (creating anonymous accounts) check box. Creating an anonymous account can reduce the security of the server, so it is not recommended to select this option.

If you do not want to set the root password, uncheck the Modify security settings (Modify safe setting) check box.

11, click the Next button to enter the ready to execute the Configuration dialog box, as shown in the picture:

12, if the correct settings, click the Execute button, the MySQL Server Configuration Wizard to perform a series of tasks, and in the dialog box to display the progress of the task, after the completion of the display as shown: Click the Finish button to complete the configuration process.

So the MySQL database installation and configuration is completed.