Mysql Installation Detailed graphics version (V5.5 for Windows) _mysql

Recently, in a larger concurrent project, I tried the InnoDB mysql5.5,30m installation files, performing in the slightest inferior to the huge Oracle or MSSQLSERVER. Open source, not superstitious Linux, I believe that MySQL in Windows will be more and more widely used. Sorted out a previous article, hoping to help beginners.

Installation environment: Windows Server 2003 [32bit NTFS]
Version information: MySQL 5.5.15 [download address: http://dev.mysql.com/downloads/]
References: http://dev.mysql.com/doc/refman/5.1/zh/installing.html

Step 1: Choose the installation Type
There are 3 types of installation: Typical (typical installation), Complete (full installation) and custom (custom installation).
Typical (Typical installation) installation installs only MySQL server, MySQL command line client, and command-line utility. command line clients and utilities include mysqldump, Myisamchk, and several other tools to help you manage your MySQL server.
Complete (fully installed) installation installs all the components contained within the package. The full installation package includes components such as an embedded server library, a base suite, support scripts, and documentation.
Custom installation allows you to fully control the package and installation path you want to install.

Step 2: Customize the Installation dialog box
All available components are included in the tree view on the left side of the Custom Installation dialog box. Components that are not installed are represented by a red X icon, and the installed components have a gray icon. To change the component, tap the component's icon and select a new option from the Drop-down list.
You can click the change on the right side of the installation path ... button to change the default installation path.
Once you have selected the installation components and installation path, click the Next button to enter the confirmation dialog box.

Step 3: Select a configuration type
You can choose between two types of configuration: Detailed Configuration (verbose configuration) and standard Configuration (standard configuration). The Standard Configuration (standard configuration) option is suitable for new users who want to quickly start MySQL without having to consider the server configuration. The detailed configuration options are appropriate for advanced users who want finer granularity of control over the server configuration.
If you are new to MySQL and need to be configured as a single user developer server, Standard Configuration (standard configuration) should fit your needs. Select the standard Configuration (standard configuration) option, the MySQL Configuration Wizard (Configuration Wizard) automatically sets all configuration options, but does not include service options and security options.
The Standard Configuration (standard configuration) setup option may not be compatible with the system where MySQL is installed. If you have MySQL installed on your system and you want to configure the installation, it is recommended that you select a detailed configuration.

Step 4: Select the server type
You can select 3 server types and choose which server will affect the MySQL Configuration Wizard (Configuration Wizard) decision on memory, hard disk, and process or use.
· Developer Machine (Development 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 (dedicated MySQL servers): This option represents a server running only the MySQL service. Assume that the run does not run another application. The MySQL server is configured to use all available system resources.

Step 5: Select the storage engine
You can point out the table processor used when creating the MySQL table. With this option, you can choose whether to use the InnoDB storage engine, and how much of the server resources InnoDB occupy.
· 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 (transaction processing databases only): This option uses both the INNODB and MyISAM storage engines, but assigns most server resources to the InnoDB storage engine. It is recommended that you select this option primarily using InnoDB only occasionally using MyISAM.
· Non-transactional database only (Transactions only): This option completely disables the InnoDB storage engine and assigns all server resources to the MyISAM storage engine. It is recommended that users who do not use InnoDB Select this option.
Here is a brief introduction, InnoDB and MyISAM are using MySQL most commonly used two table types, each has advantages and disadvantages, depending on the specific application. The basic difference is that the MyISAM type does not support advanced processing, such as transaction processing, but InnoDB type support. MyISAM type tables emphasize performance, which is performed more than InnoDB types faster, but does not provide transactional support, while InnoDB provides transactional support and advanced database functionality such as foreign keys.

Step 6: Select the InnoDB data file storage directory

Step 7: Set the number of concurrent connections
It is important to limit the number of concurrent connections that are created with the MySQL server in order to prevent the server from running out of resources.
· Decision Support (decision Support) (DSS)/olap: This option can be selected if the server does not require a large number of parallel connections. Suppose the average number of parallel connections is 20.
· Online Transaction processing (on-line transaction processing) (OLTP): Select this option if your 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 concurrent connections from the previous Drop-down box, and if the number you expect is not in the list, enter the maximum number of connections in the Drop-down box.

Step 8: Networking options
In the Networking Options dialog box, you can enable or disable TCP/IP networking and configure the port number used to connect to the MySQL server. TCP/IP networking is enabled by default. To disable the TCP/IP network, deselect the check box next to the Enable TCP/IP networking option.
The 3306 port is used by default. To access the port used by MySQL more, select a new port number from the Drop-down box or enter the new port number directly down the box. If you select a port number that is already occupied, you will be prompted to confirm the selected port number.

Step 9: Select the character set
The MySQL server supports a variety of character sets, and you can set the default server character set that applies to all tables, columns, and databases. Use the character set (character Set dialog box) to change the default character set for the MySQL server.
· 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 (multiple languages supported): Select this option if you want to use UTF8 as the default server character set. UTF8 can store characters in different languages as a single character set.
· Manual Selected default Character set/collation (manually selected default character set/proofing rules): Select this option if you want to manually select the default character set for the server. Select the desired character set from the Drop-down list.

Step 10: Set up the service
On a Windows NT-based platform, you can install a MySQL server into a service. Installed into the service, the system can start automatically when the MySQL server, or even a service failure can be automatically started with Windows.
By default, the MySQL Configuration Wizard (Configuration Wizard) installs the MySQL server as a service, and the service name is MySQL. If you do not want to install the service, remove the Install as Windows service option next to the selection box. You can change the service name by selecting a new service name from the Drop-down box or by entering a new service name in the Drop-down box.
To install the MySQL server as a service, but does not start automatically, check box next to launch the MySQL server automatically option is not selected.

Step 11: Security options
It is strongly recommended that you set a root password for your MySQL server, and by default the MySQL Configuration Wizard (Configuration Wizard) requires you to set a root password. If you do not want to set the root password, do not select the checkbox next to the Modify security settings (Modify safety settings) option.
To set the root password, enter the desired password in the new root password (enter a newer password) and confirm (confirm) two boxes. If you reconfigure an existing server, you will also need to enter the existing root password in the current root password box.
To prevent log on over the network, uncheck the box next to the Enable root access from remote machines (do not allow remote connections) option. This can improve security.
To create an anonymous user account, select the box next to the Create Anonymous account option. Creating an anonymous account lowers the security of the server and makes it difficult to login and license. therefore not recommended.

OK, finally finish.