Windows7-32bit system Installation Mysql-5.5.39-win32.msi service diagram

Download the Mysql-5.5.39-win32.msi installation file, double-click Run, the following interface appears.

MySQL Setup Wizard starts, press "Next" to continue

Tick the terms in the License agreement (I accept the terms of the license agreement). Press "Next" to continue.

Choose the installation type, with "typical (default)", "Custom", "complete" three options, we choose "Custom",

In custom customized installation, we can choose the installation path, here we will install MySQL to D:\WAMP\MySQL, press "Next" to continue.

Click "Install" to continue, the interface appears:

Click "Next" to continue and appear:

Check the "Launch the MySQL Instance Configuration Wizard (enable MySQL)" button in front of it and press "finish" to complete the installation.

MYSQLL Configuration Wizard Start interface, press "Next" to continue

Choose the configuration method, "Detailed configuration (manual precise configuration)", "Standard Configuration", we select "Detailed Configuration", easy to familiarize with the configuration process.

Select the server type, "Developer Machine (Development test class, MySQL occupies very little resources)", "Server machine (server type, MySQL takes up more resources)", "dedicated MySQL server Machine (dedicated database server, MySQL occupies all available resources) ", depending on your type selection, we choose the first one here, click" Next "to continue.

The purpose of MySQL database, "Multifunctional database (General purpose)", "Transactional database only (server type, focus on transaction Processing)", "non-transactional Database only (non-transactional, simpler, mainly to do some monitoring, counting, support for MyISAM data types is limited to non-transactional), according to your own use choice is good, I choose "Multifunctional Database ", press" Next "to continue.

To InnoDB tablespace configuration, is to select a storage space for InnoDB database files, if modified, to remember the location, re-install the time to choose the same place, otherwise it may cause database corruption, of course, do a backup of the database is no problem, here is not detailed. Use the default location and click "Next" to continue.

Select your site's general MySQL traffic, number of simultaneous connections, "decision Support (DSS)/olap (20 or so)", "Online Transaction Processing (OLTP) (500)", " Manual Setting (manually set, you lose a number) ", because we mainly on their own machine to do development testing, here to choose" Manual Setting ", and then select the number of 10 connections, click" Next "to continue.

Whether to enable TCP/IP connection, set the port, if not enabled, you can only access the MySQL database on your own machine, if enabled, put the front tick, port number (port): 3306, "ADD firewall exception for this Port is a firewall setting that adds a listening port to the Windows Firewall exception and avoids firewall blocking. There is also an "Enable Strict mode", which will not allow for minor syntax errors if MySQL is checked. If you're still a novice, I recommend canceling the standard mode to reduce the hassle. However, when you are familiar with MySQL, try to use standard mode as it can reduce the possibility of harmful data entering the database. Once configured, click "Next" to continue.

Set the MySQL default database encoding. The first one is the Latin code, the second is a multi-byte universal UTF8 encoding, the third you can be in the Character Set dropdown box in a variety of code to choose freely, we often use is GBK, gb2312 and Utf8,utf8 is the international code, its versatility is better, GBK is the country code, the generality is worse than the UTF8, but UTF8 occupies the database bigger than the GBK, here according to your own choice is good, I choose is utf8, but need to notice is if want to use the original database data, the best can determine the original database uses what code, If the code set here and the original database data encoding inconsistent, in use may appear garbled, click "Next" to continue.

If you are installing MySQL as a Windows service, you can also specify the service name (the identity name) and whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under Bin without indicating the directory name, such as the connection, " Mysql.exe-uusername-ppassword; " On it, do not point out the full address of the Mysql.exe, very convenient), I here all ticked, Service name unchanged, press "Next" to continue.

If you want to modify the default root user (super Admin) password (default is empty), "New root password" If you want to modify, fill in the new password here, "Confirm (Lose Again)" fill in again, to prevent the wrong. "Enable root access from remotemachines (whether to allow root users to log on to other machines, if it is safe, do not tick, if it is convenient, tick it)". The last item "Create an Anonymous account (create a new anonymous user, anonymous users can connect to the database, cannot manipulate data, including queries)", generally do not tick, after completion, click "Next" to continue.

If you want to modify the default root user (super Admin) password (default is empty), "New root password" If you want to modify, fill in the new password here, "Confirm (Lose Again)" fill in again, to prevent the wrong. "Enable root access from remotemachines (whether to allow root users to log on to other machines, if it is safe, do not tick, if it is convenient, tick it)". The last item "Create an Anonymous account (create a new anonymous user, anonymous users can connect to the database, cannot manipulate data, including queries)", generally do not tick, after completion, click "Next" to continue.

After making sure that your settings above are correct, click Execute to make the settings effective and, if wrong, press back to return to the check. This MySQL5 installation is complete.

Common error Handling:

　1. Install MySQL last hint "no more endpoints available in the endpoint mapper"

This is because you checked the "Add firewall exception for this port" in one step of installing MySQL (adding an exception to the firewall), but your Windows Firewall or Firewall service was optimized to shut down (for example, I Has not been opened by Windows Firewall), so there will be this hint. In general, click "OK" is good, will not have any impact on the system.

　2. Install MySQL The last step appears "MySQL Apply security settings 1045 Error"

This error usually occurs when you reload MySQL, and the previous MySQL is not uninstalled cleanly.
In addition to uninstalling MySQL in Add or Remove Programs in Control Panel, remove all MySQL installation paths from the original MySQL install path. If you have important data previously, you can make a backup first.
Delete the C:\Documents and Settings\administrator\application Data\mysql folder.
Delete the C:\Documents and Settings\All Users\Application Data\mysql folder.
Note that application data is a hidden directory.

Windows7-32bit system Installation Mysql-5.5.39-win32.msi service diagram