Installation illustration of MySQL
Mysql http://www.jb51.net/softs/2193.html
The following is an example of MySQL installation. It is installed using an executable file! Open the mysqlinstallation file mysql-5.0.27-win32.zip, decompress the file, and run “setup.exe. The following interface is displayed:
Mysql installation tutorial 1
Start the mysql Installation Wizard and press "Next" to continue
Mysql graphic installation tutorial 2
Select the installation type, which has three options: "Typical (default)", "Complete (Complete)", and "Custom (Custom)". Select "Custom ", there are more options to familiarize yourself with the installation process:
Mysql graphic installation tutorial 3
Click "Developer Components (Developer part)" and select "This feature, and allsubfeatures, will be installed on local harddrive. ", that is," This part and its sub-parts are all installed on the local hard disk ". This is also true for "MySQLServer (mysql Server)", "ClientPrograms (mysql client program)", and "Documentation (document)" above to ensure that all files are installed. Click "Change..." to manually specify the installation directory.
In mysql graphic installation tutorial 4, fill in the installation directory. My name is "F: \ Server \ MySQL Server5.0". We recommend that you do not place it in the same partition as the operating system, this prevents data from being cleared during system backup and restoration. Press "OK" to continue.
Mysql graphic installation tutorial 5: return to the previous page and press "Next" to continue
Mysql text and text installation tutorial 6 confirm the previous settings, if the error, press "Back" to return redo. Click "Install" to start installation.
Mysql graphic installation tutorial 7 is being installed. Please wait until the following interface appears
Mysql text and text installation tutorial 8 here is to ask if you want to register an account for mysql.com, or use an existing account to log on to mysql.com. Generally, this is not required. Click "SkipSign-Up ", click "Next" to skip this step.
Mysql text installation tutorial 9 now software installation is complete, the above interface appears, there is a good function, mysql Configuration Wizard, do not use the same as before, manually mess up my. ini. Check the "Configure the Mysql Servernow" and click "Finish" to Finish the software installation and start the mysql Configuration Wizard.
Mysql graphic installation tutorial 10
Mysql Configuration Wizard start interface, press "Next" to continue
Mysql graphic installation tutorial 10 select the Configuration method, "Detailed Configuration (manual precise Configuration)", and "StandardConfiguration (standard Configuration)". We select "Detailed Configuration" to familiarize ourselves with the Configuration process.
Mysql text and text installation tutorial 11 select the server type, "Developer Machine (development and testing class, mysql occupies a small amount of resources)", "ServerMachine (server type, mysql occupies a large amount of resources) "," Dedicated MySQL ServerMachine (Dedicated database server, mysql occupies all available resources) ", you choose according to your own type, generally select" ServerMachine ", not too little, it will not be full.
Mysql graphic installation tutorial 12 select the general purpose of the mysql Database, "Multifunctional Database (general multi-function type, good)", "TransactionalDatabase Only (server type, focus on transaction processing, General) "," Non-Transactional DatabaseOnly (non-transaction processing type, relatively simple, mainly used for monitoring and recording, the support for MyISAM data types is limited to Non-transactional ), I chose it with my own purpose. Here I select "TransactionalDatabase Only" and press "Next" to continue.
Mysql graphic installation tutorial 13
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. I have not modified it here. Use the default position and press "Next" to continue.
Mysql graphic installation tutorial 14
Select the average mysql access volume of your website and the number of connections at the same time, such as "DecisionSupport (DSS)/OLAP (about 20)" and "Online TransactionProcessing (OLTP) (about 500) "," Manual Setting (Manual Setting, input a number) ", I select" OnlineTransaction Processing (OLTP) "here, my server should be enough, and press" Next "to continue
Mysql graphic installation tutorial 15
Whether to enable the TCP/IP connection and set the port. If the port is not enabled, you can only access the mysql database on your own machine. I enable it here and tick the previous one, PortNumber: 3306, on this page, you can also select Enable StrictMode, so that MySQL will not allow small syntax errors. 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. Press "Next" to continue
Mysql graphic installation tutorial 16
The second is multi-byte universal utf8 encoding, which is not our general encoding. Here we select the third encoding, and then select or enter "gbk" in CharacterSet ", of course, you can also use "gb2312", the difference is that the gbk font size is large, including all the Chinese characters of gb2312, and added traditional Chinese characters, and other messy words-when using mysql, run the "SETNAMESGBK;" command before running the data operation command (only once. The GBK can be replaced with other values, depending on the settings here ), you can use Chinese characters (or other texts) normally. Otherwise, Chinese characters cannot be displayed normally. Press "Next" to continue.
Mysql graphic installation tutorial 17 -uusername-ppassword##", which indicates the complete address of mysql.exe, which is very convenient). I have checked all of them here and the ServiceName remains unchanged. Press "Next" to continue. -Uusername-ppassword##then, the complete address of mysql.exe is displayed, which is very convenient). I have checked all of them here and the ServiceName remains unchanged. Press "Next" to continue.
Mysql graphic installation tutorial 18
This step asks if you want to change the default root user (Super Management) password (which is blank by default). If you want to change "New rootpassword", enter the New password here (if it is reinstalled, you have already set a password. Changing the password may cause errors. leave it blank and remove the check box before "ModifySecuritySettings". After the installation and configuration are complete, change the password separately ), "Confirm (re-enter)" is entered again to prevent errors. "Enableroot access from remotemachines (whether to allow the root user to log on to another machine. If you want security, do not check it. If you want convenience, check it )". At last, "CreateAn AnonymousAccount (create an anonymous user, and the anonymous user can connect to the database, and cannot operate data, including queries)" is skipped. After the settings are complete, press "Next" to continue.
Mysql graphic installation tutorial 19
Confirm that the settings are correct. If any error occurs, press "Back" to return for the check. Press Execute to make the settings take effect.
Mysql graphic installation tutorial 20
After the configuration is complete, press "Finish" to end mysql installation and configuration. A common error is that mysql cannot be "Startservice", which usually occurs on a server where mysql was previously installed, to solve this problem, first ensure that the previously installed mysql server is completely uninstalled. If not, check whether the previous password has been modified as mentioned above; if not, back up the data folder under the mysql installation directory and delete it. After the installation is complete, delete the data folder generated by the installation and remove the backed up data folder, restart the mysql service. In this case, you may need to check the database and fix it once to prevent data errors.
