This article discusses the installation of MySQL5 under WINDOWS2003, please note
Download MySQL installation files, download the address:
Click here to download MySQL5.5.0Open the downloaded MySQL installation file mysql-5.0.27-win32.zip, double-click Decompression, run "Setup.exe", the following interface appears, the MySQL Installation Wizard starts, press "Next" to continue
Choose the installation type, there are "typical (default)", "Complete (Full)", "Custom (user-defined)" Three options, we choose "Custom", there are more options, but also easy to familiarize yourself with the installation process
Left-click on the "Developer components (developer part)", select "This feature, and all subfeatures, will is installed on the local hard drive.", that is, "this part, and the next Sub-part content, all installed on local hard drive. This is done on the MySQL server (MySQL servers), client Programs (MySQL client), and documentation (documentation) to ensure that all files are installed. Click Change ... to manually specify the installation directory.
Fill in the installation directory, my is "F:\Server\MySQL\MySQL Server 5.0", also recommended not to be placed in the same partition as the operating system, so as to prevent the system backup restore time, the data is emptied. Press "OK" to continue.
Return to the interface just now, press "Next" to continue
Confirm the previous settings and, if wrong, press "back" to redo. Press "Install" to start the installation.
Please wait while the installation is in progress
appear below the interface, here is asked whether you want to register a mysql.com account, or use the existing account login mysql.com, generally do not need, click "Skip Sign-up", press "Next" skip this step.
Now the software installation is complete, the above interface, there is a good function, the Mysql Configuration Wizard, not to the same as before, their own manual mess configuration My.ini, will "Configure the Mysql Server now" in front of the tick, point "Finish "End the installation of the software and start the MySQL Configuration Wizard."
MySQL Configuration Wizard start 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) ", we choose according to their own type, the general election of" server Machine ", not too little, will not fill.
Choose the approximate use of MySQL database, "Multifunctional db (Universal multi-function, good)", "Transactional database only (server type, focus on transaction, General)", " Non-transactional Database only (non-transactional processing type, simpler, mainly do some monitoring, counting, MyISAM data types of support limited to non-transactional), with their own use and chose, I choose here " Transactional Database only, 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. I have not modified here, use the default location, press "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) ", I choose" Online Transaction Processing (OLTP), your own server, should be enough, press "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, I am enabled here, the front of the tick, Port number:3306, on this page, you can also choose "Enable Standard mode" (Enabling Strict Mode) so that MySQL does not allow for minor grammatical errors. 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. Press "Next" to continue
The following are more important, is the MySQL default database language encoding settings, the first is the western code, the second is multibyte universal UTF8 encoding, is not our common coding, here Select the third, and then in character set there select or fill in "GBK", of course, can also use " gb2312 ", the difference is that GBK's font size, including the gb2312 of all Chinese characters, and add traditional characters, and other messy words-when using MySQL, run the data Operation command before the" SET NAMES GBK; " (Run once on the line, GBK can be replaced by other values, depending on the settings here), you can normally use Chinese characters (or other text), otherwise can not display Chinese characters normally. Press "Next" to continue.
Choose whether to install MySQL as a Windows service, or you can specify the service name (Services identity name) 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.
This step asks if you want to modify the default root user (super Admin) password (default is null). New root Password "If you want to modify it, fill in this password (if it's a reload, and you've already set a password, you may have an error changing the password here, leave it blank, and" Modify Security Settings "in front of the check out, the installation configuration is completed after a separate change password)," Confirm (again) "to fill in again, to prevent the wrong.
"Enable root access from remote machines (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 to hook it up)".
Finally "Create a Anonymous account (a new anonymous user, anonymous users can connect to the database, cannot manipulate data, including queries)", generally do not have to tick, set up, press "Next" to continue. Verify that the settings are correct, and if so, press "back" to return to check. Press ' Execute ' to make the settings effective.
Set up, press "Finish" to end the installation and configuration of MySQL--here is a more common mistake, is not "Start service", generally appear in the previous installation of MySQL server, the solution, first of all, to ensure that the MySQL server installed before the total uninstall off the , if not, check to see if the previous password has been modified according to the above, the operation above; if still not, the MySQL installation directory of the Data folder backup, and then deleted, after the installation is completed, will install the generated Data folder deleted, the backup of the data folder to move back, Restart the MySQL service, in which case you may need to check the database and fix it once to prevent data errors.
This MySQL5 installation is complete.
