Installing MySQL5.5.19 in Windows _ MySQL

This document describes how to install MySQL5.5.19 in Windows. it is helpful for beginners.

Download the mysql-5.5.19-win32.msi installation file, double-click Run, the following page appears.

　　

Start the mysql installation wizard and press "Next" to continue

Check I accept the terms in the License Agreement (I accept the terms in the License Agreement. Press "Next" to continue.

Select the installation type, which has three options: "Typical (default)", "Custom (Custom)", and "Complete (Complete)". select "Custom ",

In Custom installation of Custom, we can select the installation path. here we install MySQL to D:/WAMP/MySQL and press "Next" to continue.

Click "install" to continue. the page is displayed:

Click "Next" to continue:

Check "Launch the Mysql Instance Configuration Wizard (enable MySQL Configuration Wizard)" and then press "Finish" to complete the installation.

On the MySQLl configuration wizard startup page, press "Next" to continue

Select the Configuration method, "Detailed Configuration (manual precise Configuration)", and "Standard Configuration". select "Detailed Configuration" to familiarize yourself with the Configuration process.

Select the Server type, "Developer Machine (development and testing class, MySQL occupies a small amount of resources)", "Server Machine (Server type, MySQL occupies a large amount of resources) "," Dedicated MySQL Server Machine (Dedicated Database Server, MySQL occupies all available resources) ", select the first one based on your type, and click" Next "to continue.

MySQL Database usage, "Multifunctional Database (universal multi-function type)", "Transactional Database Only (server type, dedicated to transaction processing) "," Non-Transactional Database Only (non-transaction processing type, relatively simple, mainly used for monitoring and recording, the support for MyISAM data types is limited to Non-transactional ), you can choose according to your own purpose. here I will select "Multifunctional Database" and press "Next" to continue.

Configure InnoDB Tablespace to select a bucket for the InnoDB database file. if you modify the bucket, remember the location and select the same place for the reinstallation. Otherwise, the database may be damaged, of course, it is okay to back up the database. we will not detail it here. Click "Next" to continue.

Select the average MySQL access volume of your website and the number of connections at the same time. for example, "demo-support (DSS)/OLAP (about 20 connections)" and "Online Transaction Processing (OLTP) (about 500) "and" Manual Setting (manually set, input a number by yourself) ". because we are mainly used for development and testing on our own machine, choose" Manual Setting "here ", select 10 connections and click "Next" to continue.

Whether to enable TCP/IP connection and set the Port. if it is not enabled, you can only access the mysql database on your own machine. if it is enabled, check the preceding Port Number ): 3306, "Add firewall exception for this port" is a firewall setting. Add the listening port as an exception for windows firewall to avoid firewall blocking. There is also an "Enable Strict Mode (Enable Standard Mode)". if MySQL is selected, minor syntax errors are not allowed. If you are a newbie, I suggest you cancel the standard mode to reduce the trouble. However, if you are familiar with MySQL, try to use the standard mode because it can reduce the possibility of harmful data entering the database. After the configuration is complete, click "Next" to continue.

Set the default MySQL database encoding. The first is Spanish encoding, the second is multi-byte universal utf8 encoding, and the third is free to choose from multiple encodings in the Character Set drop-down box, we often use gbk, gb2312, and utf8. UTF8 is international encoding, which has better universality. GBK is a national encoding and has worse universality than UTF8, however, the database occupied by UTF8 is larger than that occupied by GBK. I chose utf8, but note that if you want to use the data of the original database, it is best to determine the encoding used by the original database. if the encoding set here is inconsistent with the encoding of the original database data, garbled characters may occur during usage. click "Next" to continue.

Whether to install MySQL as a Windows Service, you can also specify the Service Name (Service ID Name), and whether to add the Bin directory of MySQL to Windows kernel-uusername-ppassword##, which indicates the complete address of mysql.exe, which is very convenient ), I checked all the items here. the Service Name remains unchanged. press "Next" to continue.

Whether to change the password of the default root user (Super management) (blank by default). If you want to change the "New root password", enter the New password here, "Confirm (re-enter). "Enable root access from remotemachines (whether to allow root users to log on to other machines. if you want security, do not check it. if you want convenience, check it )". The last item "Create An Anonymous Account (Create An Anonymous user, Anonymous user can connect to the database, and cannot operate data, including queries)" generally does not need to be checked, click "Next" to continue.

After making sure that your settings are correct, click Execute to make the settings take effect. if the settings are incorrect, press Back to return for check. So far, MySQL5 has been installed.

Common Error Handling:

1. the last step of installing MySQL prompts "no more endpoints are available in the endpoint er"

This is because you checked "Add firewall exception for this port" in a step of installing MySQL (adding exceptions to the firewall ), but your Windows Firewall or firewall service has been optimized and disabled by you (for example, I have not opened the windows firewall), so this prompt will appear. Generally, you can click "OK" without affecting the system.

2. "MySQL apply security settings 1045 error" appears in the last step of mysql installation"

This error usually occurs when you reinstall MySQL. The previous MySQL was not uninstalled.
In addition to detaching MySQL from the "add or delete programs" on the control panel, you must also delete all MySql information from the original MySql installation path. If important data exists previously, you can back up the data first.
Delete the C:/Documents and Settings/Administrator/Application Data/MySql folder.
Delete the C:/Documents Ents and Settings/All Users/Application Data/MySql folder.
Note that Application Data is a hidden directory.