Install MySQL 6.0 in Windows

Reprinted from: http://fengyongfa2006.blog.163.com/blog/static/36654659200942401542800/

Here we will not talk about the specific download of MySQL 6.0. Since it is free, it is certainly very easy to download. You can go to the official website or go to the software website, but in order to get the latest, it is best to go to the official website. I downloaded mysql-essential-6.0.10-alpha-win32.msi here. Of course there are many other types. You can download them according to your system requirements.

Click the mysql-essential-6.0.10-alpha-win32.msi to see the Installation Wizard, as shown in.

On the Installation Wizard start page, click Next to continue

Select the installation type, which is generally divided into [typical] [complete] [custom ]. Generally, you can select "typical" or "complete" as a beginner. To view the installation details, choose "Custom" and click "Next" to continue.

Click c Include files/lib files and select the first option to install this feature on the local disk. These features are installed to better support some other development. Therefore, it is not surprising that the disk space is plentiful. Then press [next] to continue.

Select the installation path. Select the disk size. Then press OK ].

Here I chose disk D. If you want to change the value, click Change to reselect it. If you do not want to change the value, click Next to continue.

If you need to change the current installation settings, you can click back to re-select the installation settings, and then click Install to install MySQL on the local hard disk.

Please be patient. It may take several minutes to install MySql in the installation wizard.

Select "configure the MySQL serve now" here. If you want to register MySQL, you can also choose. Click Finish to complete the installation and configure the server. The next step is very important.

You can also click Cancel to configure the MySQL server instance. Click Next to continue.

 

Select the configuration type, which is divided into detialed configuration (detailed configuration) and standard configuration (standard configuration ). To understand the detailed configuration process, we select detialed configuration and press next to continue.

Select the server type. Three types: [developer machine] (developer machine), which only occupies good resources and consumes the least memory resources. We recommend that you select this option. [Server machine] (server type), which consumes a little more available resources and consumes more memory resources. [Dedicate MySQL server machine] (dedicated database server), which occupies all available resources and consumes the maximum memory. In combination, we select server machine and press next to continue.

Select the purpose of the database. [Multifunctional database], can be understood as a general row database, supports all database operations, [transaction database only] only for transaction processing, dedicated service type. [Non-transactional database only] non-transactional processing, generally only monitoring, application data analysis, support for the MyISAM data type is limited to non-transaction. It is mainly used for the first purpose. Here, select the first [multifunctional database] and click [next] to continue.

Set InnoDB tablespace and select the MySQL data storage location. Note that it is important to select this location because the data file is stored here to ensure that the data file is not damaged. Select the space in the installation path as the data table space and click Next to continue.

Set the number of current connections to the server, [demo-support DSS/OLAP]. This does not require many connections, generally around 20 connections. [online transaction processing (OLTP )], the number of connections is about 500. Generally, this option is enough for your own development and testing. You can set the number of connections manually in manual setting. Select onine Transaction Processing (OLTP) and click Next to continue.

[Enable TCP/IP networking] Enable TCP/IP connection. Generally, you can select the default one. Do not change the port number to avoid forgetting it. [enable strict mode] enable strict mode, the benefits of enabling MySQL can control the data security of MySQL. Here, select the default option and click Next to continue.

This step is also critical. Set the character set. The default Character Set of [standard character set] supports very few other characters. [best support for multilingualism] supports most characters in the language family, mainly in the form of UTF-8 storage, so the general choice of this item;

[Manual selected default Character Set/collation]. You can only select one character set for a single character set. To avoid garbled characters, select the GBK character set for the moment. simplified Chinese characters are supported, including traditional Chinese, so it is enough for us. Select manual selected default Character Set/Collation and press next to continue.

Set windows operations, install as Windows service, and set the service name. Generally, this name will appear in Windows Services by default. [Include bin directory in Windows path]: place the bin directory in the Windows path. We recommend that you select this directory so that you can directly access MySql in the DOS window, it is convenient and fast to enter the MySQL bin directory. Click Next to continue.

Set the password for the root account. If it is the first time MySQL is installed, enter a new password and it will be OK. For example, if MySQL has been installed before, the following situation will occur:

You need to enter the current password, and then enter the new password, so be sure to remember the password of this root account, which is the key to subsequent database operations.

 

Click execute to complete the configuration. It is worth noting that during configuration, the [start service] operation may fail because other MySQL databases are on the computer, of course, the solution is also very simple. The MySQL service is not used in the past, or you can delete it and reconfigure it.

OK. Now the installation is complete.