Install MySQL5.5.19 graphics and text tutorials under Windows _mysql

This article introduces the whole process of installing MySQL5.5.19 under Windows, hoping to be helpful to beginners.

Download Mysql-5.5.19-win32.msi installation file, double-click to run, the following interface appears.

　　

The MySQL Setup Wizard starts, press "Next" to continue

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

Select the installation type, there are "typical (default)", "Custom", "Complete (Full)" Three options, we choose "Custom", as shown:

In Custom installation, we can choose the installation path, where we install MySQL to D:\WAMP\MySQL and press "Next" to continue.

Click "Install" to continue, the following graphic interface appears:

Click on "Next" to continue, the following image appears:

On the "Launch the MySQL Instance Configuration Wizard (Enable MySQL configuration Wizard)" Before the Tick, then press "Finish" to complete the installation.

MYSQLL Configuration Wizard to start the interface, press "Next" to continue

Select the configuration mode, "Detailed Configuration (Manual precise configuration)", "Standard Configuration (Standard configuration)", we choose "Detailed Configuration" to facilitate familiarity with the configuration process.

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

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

InnoDB tablespace configuration, is to InnoDB database files to choose a storage space, if modified, to remember the location, when reloading to choose the same place, otherwise it may cause database damage, of course, to do a backup of the database is no problem, here is not detailed. Use the default location and click "Next" to continue.

Select the general MySQL traffic for your site, the number of simultaneous connections, "Decision Support (DSS)/olap (20 or so)", "Online Transaction Processing (OLTP) (500 or so)", " Manual Setting (manually set, lose a number) ", as we are mainly on our own machine to do development testing, here Select" Manual Setting ", and then fill in the number of 10 connections, click" Next "to continue.

Whether to enable TCP/IP connections, set the port, if not enabled, you can only access the MySQL database on their own machine, if enabled, the front of the tick, port number (port numbers): 3306, "ADD firewall exception for this Port "is a firewall setting that adds a listening port to Windows Firewall exception to prevent firewall blocking. There is also a "Enable Strict mode", which does not allow for minor grammatical errors if MySQL is selected. If you are still a novice, I recommend that you cancel the standard mode to reduce the hassle. But after familiarity with MySQL, use standard mode as much as possible, because it reduces the likelihood that harmful data will enter the database. When all is configured, click "Next" to continue.

Set the MySQL default database encoding. The first is the western code, the second is multibyte universal UTF8 encoding, the third one you can Character Set dropdown box in a variety of coding 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, versatility is worse than UTF8, but UTF8 occupy a database than GBK, here according to suit your own choice is good, I chose is utf8, but it is necessary to note that if you want to use the original database data, it is best to determine the original database with what code, If the encoding set here and the original database data encoding inconsistent, in the use of the time may appear garbled, click "Next" to continue.

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

Whether you want to modify the default root (super Admin) password (default is null), "New root password" If you want to modify, then fill in the password, "Confirm (again)" to fill in again, to prevent the wrong loss. "Enable root access from remotemachines (whether or not to allow root users to log on to other machines, if you want to be safe, do not hook, if it is convenient, hook it up)". The last item "Create an Anonymous account (new anonymous user, anonymous user can connect to the database, cannot manipulate data, including query)", generally do not have to tick, when finished, click "Next" to continue.

Make sure you have the above set up correctly, click Execute to make the settings effective, and if it is wrong, press back to check. This MySQL5 installation is complete.

Common error Handling:

1. Install MySQL last step tip "There are no more endpoints available in the endpoint mapper"

This is because you selected the "Add firewall exception for this port" in one of the steps to install MySQL (add an exception for the firewall), but your Windows Firewall or Firewall service has been optimized for your shutdown (for example, I has not opened Windows Firewall), so there will be this prompt. Generally click "OK" is good, will not cause any impact on the system.

2. Install MySQL 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 the Add or Remove Programs in Control Panel, remove all MySQL installation paths from the original MySQL setup path. If you have important data previously, you can make a backup first. The
deletes the C:\Documents and settings\administrator\application Data\mysql folder. The
deletes the C:\Documents and Settings\All Users\Application Data\mysql folder.
Note that application data is a hidden directory.