The MySQL5.0 version of the installation diagram tutorial is for beginners, and the current mysql5.0.96 is the latest stable version.
MySQL Download address http://www.jb51.net/softs/2193.html
The following is the MySQL installation diagram, with the executable file installed, detailed description of a bit! Open the download MySQL installation file mysql-5.0.27-win32.zip, double-click Decompression, run "Setup.exe", the following interface appears
MySQL Installation graphics Tutorial 1
The MySQL Setup Wizard starts, press "Next" to continue
MySQL graphics and text installation tutorial 2
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:
MySQL graphics and text installation Tutorial 3
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.
MySQL graphics and text installation tutorial 4
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.
MySQL graphics and text installation tutorial 5
Return to the interface just now, press "Next" to continue
MySQL graphics and text installation tutorial 6
Confirm the previous settings and, if wrong, press "back" to redo. Press "Install" to start the installation.
MySQL graphics and text installation tutorial 7
is in the installation, please wait until the following interface appears
MySQL graphics and text installation tutorial 8
Here is to ask if 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.
MySQL graphics and text installation tutorial 9
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 graphics and text installation tutorial 10
MySQL Configuration Wizard start interface, press "Next" to continue
MySQL graphics and text installation tutorial 10
Select the configuration mode, "Detailed Configuration (Manual precise configuration)", "Standard Configuration (Standard configuration)", we choose "Detailed Configuration" to facilitate familiarity with the configuration process.
MySQL graphics and text installation tutorial 11
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.
MySQL graphics and text installation tutorial 12
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.
MySQL graphics and text installation tutorial 13
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
MySQL graphics and text installation tutorial 14
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
MySQL graphics and text installation tutorial 15
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
MySQL graphics and text installation tutorial 16
Latin code, the second is multibyte universal UTF8 encoding, is not our common code, here is the third choice, and then in the character set to select or fill in the "GBK", of course, can also use "gb2312", the difference is that the GBK font size, It includes all the characters of gb2312, plus traditional characters, and other messy words--run "SET NAMES GBK before executing the data manipulation commands when using MySQL". (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.
MySQL graphics and text installation tutorial 17
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. 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.
MySQL graphics and text installation tutorial 18
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.
MySQL graphics and text installation tutorial 19
Verify that the settings are correct, and if so, press "back" to return to check. Press ' Execute ' to make the settings effective.
MySQL graphics and text installation tutorial 20
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.
