Mysql 6.0 installation Diagram

Because of its free, MySQL database is used more and more extensively in the project, and its security can be particularly high, no less than large database software such as Oracle. To put it simply, in some small and medium-sized projects, using MySQL, PostgreSQL is the best choice. Today, let's take a look at the MySQL installation process.

http://dev.mysql.com/downloads/

Since it is free, I am here to download the Mysql-essential-6.0.10-alpha-win32.msi. Of course there are many types, according to the requirements of their own system to download it.

Note: Win7 , Win8 the system runs as administrator as possible.

Click Mysql-essential-6.0.10-alpha-win32.msi and the Installation Wizard will appear, such as.

Installation Wizard Start Page, press "Next" to continue

Choose the type of installation, generally divided into "typical" "complete" "Custom". The general novice chooses "typical" or "complete", in order to look at the installation details, we select "Custom", and then press "Next" to continue.

On the C Include files/lib Files, on the left, select the first item to install this attribute to the local hard disk. These features are installed to better support some other development. So if the hard disk space, see how not strange. Then press "Next" to continue.

Select the installation path. Depending on the size of the hard disk, choose. Then press "OK".

Here I have chosen D drive. If changes are needed, press "change" to re-select it and make sure that "Next" continues.

Current installation settings information, if you need to change these installation settings, you can press "back" to re-select the installation settings, OK and then press "Install" the MySQL installed on the local hard drive.

Please be patient while the installation wizard is installing MySQL, which will take a few minutes.

Here only select "Configure the MySQL Serve now", if you want to register MySQL also can choose. After confirming, press "Finish" to complete the installation, then configure the server. The link is very important oh.

The MySQL server instance configuration, of course, can also press "Cancel", later configuration can also. Press "Next" to continue.

Select the configuration type, which is divided into "detialed configuration" (detailed config), "standard configuration". To understand the entire detailed configuration process, we select "Detialed Configuration" and press "Next" to continue.

Here is the type of server to select. Three types: "Developer machine" (developer type), using only good resources, consumes the least memory resources. It is recommended that the general user choose this. "Server machine" (server type), takes up a little more available resources and consumes more memory resources, of course. "Dedicate MySQL server Machine" (dedicated database server) consumes all available resources, consuming the largest amount of memory. To synthesize these three, we select "Server machine" and press "Next" to continue.

Select the purpose of the database. "Multifunctional database" can be understood as a universal row of databases, supporting all database operations, "Transaction database Only" transactional, dedicated service type. "Non-transactional Database only" non-transactional processing, generally only monitoring, application data analysis, MyISAM data type support is limited to non-transactional. Main one use, here Select the first "Multifunctional Database", and then press "Next" to continue.

To set the InnoDB tablespace, select the location space where the MySQL data is stored. In particular, it is important to choose this location because the data files are stored here to ensure that the data files are not corrupted. Here, select the space under the installation path as the data table space, and press "next" to continue.

Set the number of servers currently connected, "decision Support Dss/olap", this does not require a lot of connections, generally around 20, "Online Transaction Processing (OLTP)", the number of connections 500 or so, General own development test with the choice of this is enough, "Manual Setting" can manually set the number of connections. Select "Onine Transaction processing (OLTP)" Here and press "Next" to continue.

"Enable TCP/IP Networking" enables TCP/IP connection, generally choose the default is OK, do not change the port number, lest later forget; "Enable Strict mode" enables strict mode, enabling its benefits to control the security of MySQL data. Here, select the default, and press "Next" to continue.

This step is also key, set the character set, the "standard Character set" default character set, the number of other characters supported is very few; "Best supported for Multilingualism" supports most language-based characters, mainly stored in UTF-8 form. , so the general choice of this item;

"Manual Selected default Character set/collation", manually set the character set, relatively single, can only select a character set, in order not to appear garbled problem, here for the moment choose GBK Character set, support Chinese simplified, including traditional, So it's enough for us. Select "Manual Selected Default Character set/collation" Press "Next" to continue.

Set the Windows operation, "Install as Windows Service", set the service name, and the general default is OK, this name will appear in the Windows service. "Include Bin directory in Windows path", put the bin directory in the Windows path path, it is recommended to select it, so that in the DOS window directly access to MySQL, do not need to go to the MySQL bin directory, convenient, fast. Press "Next" to continue.

Set the password for the root account. If it is the first time to install MySQL directly enter a new password is OK, such as, but previously installed MySQL, the following situation will appear:

You need to enter the current password, and then enter a new password, so be sure to remember the root account password, it is the key to the database operation of the door.

Press "Execute" to complete the configuration operation. It is worth noting that when the configuration is prone to a problem, "Start service" operation failed, the reason is that there are other MySQL database in the computer, of course, it is very simple, the system was not used before the MySQL service, or delete it, and then reconfigure.

OK, the installation operation is complete.

Mysql 6.0 installation Diagram