MySQL 5.5 installation configuration method graphics and text tutorial _mysql

Recall MySQL 5.5 installation configuration method, organize the MySQL 5.5 installation configuration tutorial notes, share to everyone.

MySQL Download address: http://dev.mysql.com/downloads/installer/

1, the first entry is the installation of the boot interface

2, then enter the type selection interface, there are 3 types: typical (typical), Complete (full), custom (custom). It is recommended that you choose Custom installation, which allows you to customize the installation directory of MySQL, then click Next Next, a custom installation interface, for data security, do not recommend MySQL installation system disk C directory.

3. Ready to install

4, the installation is completed after the MySQL configuration will appear the boot interface

5, here is a guide to configure the MySQL option (luanch the MySQL Instance Configuration Wizard), suggest that you immediately configure your MySQL

6, here is the MySQL configuration to configure the type of MySQL configuration, you can choose two types of configuration: Detailed Configuration (detailed 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.

Here I choose is detailed Configuration, want to better complete personalized customization.

7, here is the MySQL configuration MySQL server type, you can choose 3 types of servers, choose which server will affect the MySQL Configuration Wizard (Configuration Wizard) on memory, hard disk and process or use decisions.

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.

Here I choose the developer Machine, mainly for the development of peacetime needs.

8, here is the configuration of MySQL database usage, you can point out the creation of the MySQL table using the table processor. 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.

I chose the multifunctional Database.

9, here is the configuration of MySQL InnoDB table space, some users may want to InnoDB table space files to a different location, but not to the MySQL server data directory. If your system has larger space or a higher performance storage device (such as a RAID storage system), it is a good idea to place the tablespace files in one location alone. To change the default location for InnoDB tablespace files, select a new drive from the drive Drop-down list and select a new path from the path Drop-down list. To create a path, click ... Button. If you want to change the configuration of an existing server, you must click the Modify button before changing the path. Before you start the server, you must move the existing tablespace files to a new location. I choose the default configuration.

10. This is a concurrent connection that configures MySQL, and it is important to limit the number of concurrent connections that are created to the MySQL server to prevent the server from running out of resources. You can select how the server is used and limit the number of concurrent connections depending on the situation. You can also manually set limits for parallel connections.

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 maximum number of connections is set to 100, and 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.

Here according to the individual needs, I choose is manual Setting.

11, here is the configuration of MySQL network options, you can enable or disable TCP/IP network, and configure to connect the MySQL server port number. 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 in use, you will be prompted to confirm the selected port number, and if other machines need access to the database, it is recommended to check the Add firewall exception for this port (added to the firewall exception).

12, here is the configuration of MySQL character set, MySQL server supports a variety of character sets, you can set for all tables, columns and database default server character set. You can change the default character set for the MySQL server by using the character set (character Set dialog box).

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.

13, here is the configuration of MySQL service options, you can install the 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.

14, here is the security option to configure MySQL, we strongly recommend that you set a root password for your MySQL server, 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 logging on through the network with root, select the box next to the root can only connect from localhost (which only allows you to log on from the local connection root) option. This will increase the security of the root account. 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.

15, confirm, click Excute Complete Installation

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.