Schematic MySQL5.5 detailed installation and configuration process

Originating From: http://www.dbhom.com/show.aspx?id=77&cid=9

MySQL is an open source relational database management system originally developed by the Swedish MySQL AB company, currently owned by Oracle Corporation. MySQL is currently one of the most popular open source databases in the world and is the most widely used open source database. MySQL is the m in lamp.

This article discusses in detail the latest version of MySQL MySQL5.5 detailed installation and configuration process. MySQL5.5 installation program can be downloaded from MySQL website, download address: http://dev.mysql.com/downloads/mysql/. MySQL5.5 is divided into Enterprise (Corporate Edition) and Community (Community Edition), where the Community edition is open source, free version. This article uses the MySQL5.5 Community Edition.

1. Run the Setup program, open the interface. This is a welcome interface, click "Next" to proceed to the next step.

2. Here "end-user License agreement" is the end user Agreement, please read carefully, only accept this agreement to continue to install.

3. This step selects the setup type, and there are three options: typical (typical) will install the most commonly used program features, recommended for most use, custom (customized) allows the selection of installer features, recommended for advanced users Complete (full installation) installs all program features and requires the most disk space. It is recommended that you choose "typical".

4. After selecting the installation type, Setup begins installation as shown in.

5. Before the installation is finished, an interface will pop up, which is an advertisement for the MySQL Enterprise Edition. If you do not need to, click "Next".

6. Seeing this interface means that the installation is complete. If you tick "Launch the MySQL intance Configuration Wizard" and click "Finish", the MySQL instance Configuration guide will be launched. We recommend that you check it here. (Of course, there is a MySQLInstanceConfig.exe under the bin file in the MySQL installer directory, and running it can also start this configuration wizard at any time.) ）

7. The 1th screen of the Configuration Wizard is a welcome interface, click "Next" to continue. (Here is an example, instance is the instance, referring to the MySQL server process)

8. Open the following interface, which allows the user to select the configuration type (config-type), there are two options: detailed configuration (detailed configuration) represents the creation of an optimal server configuration; Configuration (Standard). It is recommended that you choose a detailed configuration.

9. In this step, let's choose a server type, there are three options: the developer Machine (Developer machines), the MySQL server uses only the least amount of memory; servers (server machine), As a Web or application server, MySQL will use a medium amount of storage space, and a dedicated MySQL server (dedicated MySQL servers machine), MySQL will utilize as much available storage space as possible. Here, if you install MySQL on your PC for learning purposes only, we recommend that you choose DeveloperMachine.

10. The next step is to select the database usage. There are also three options: the Multipurpose database (multifunctional database), which is the general data base, which is recommended for everyone; transactional database (transactional), using InnoDB as the primary storage engine The non-transactional database (non-transactional), the MyISAM storage engine will be activated.

11. This step is the InnoDB table space setting. As a general rule, click "Next" to proceed to the next step.

12. This step is to set the number of server concurrent connections. There are three options: Decision Support or online analytical processing (decision SUPPORT/OLAP), approximately 20 connections are assumed; online transaction processing (line Transaction processing, or OLTP), up to 500 active connections, Suitable for highly concurrent applications, manual setup (Manual Setting), which manually specifies the number of concurrent. If it is a personal learning use, the number of concurrent connections will not be many, you can manually specify 5-10.

13. This step is to set the Network option (Networking options). Enable TCP/IP, tick "Enable TCP/IP Networking", and specify the port number, 3306 is the default installation program, if it has been occupied, can be modified to other. Tick "Add firewall exception for this port" to add this to the firewall exception. "Enable Strict mode" means that strict modes are enabled, and if unchecked, MySQL ignores some minor grammatical errors, which are recommended here.

14. The next step is to select the default character set. There are three options: Standard Character set, using Latin1 as the default character set, suitable for English and other Western European languages, and multi-language support (best supports for multilingualism), Using UTF-8 as the default character set, Manual selection (Manual Selected default Character set/collation), if the database is to handle Chinese and other language text, it is recommended to set GBK, gb2312 or UTF8. For more questions about character sets, refer to the MySQL character set GBK, GB2312, UTF8 differences.

15. Here is the option to set Windows. Tick "Install as Windows Service" to indicate that MySQL is installed as a server for Windows, and check "Launch the MySQL Server automatically" to indicate that the MySQL service will start with Windows. It is recommended that you check these options. "Include bin directory in Windows path" means that the bin directory of MySQL is included in the path variable of Windows so that running the MySQL program at the command line does not require a path, which is recommended here.

16. This step sets the security options. Check "Modify Security Settings" will set the root user password, root is the default administrator account in MySQL. Tick "Enable root access from remote machines" to allow access from the remote machine using the root user. "Create an Anonymous account" means creating an anonymous accounts, which can affect system security and is not recommended.

17. The following interface indicates that all configurations have been set up, and clicking "Execute" will apply all configurations.

18. See the following interface, indicating that all configurations have been applied, everything OK! Click Finish to complete the configuration.

Schematic MySQL5.5 detailed installation and configuration process