MySQL installation diagram

First, installation of MySQL

1. Open the downloaded MySQL installation file mysql-5.5.27-win32.zip, double-click Unzip, run "Setup.exe".

2, choose the installation type, there are "typical (default)", "Complete", "Custom (User Defined)" Three options, select "Custom", press "Next" key to continue.

3. Click "Browse" to specify the installation directory manually.

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 system backup restore, the data is emptied. Press "OK" to continue.

Confirm the previous settings and, if wrong, press "back" to return to redo. Press "Install" to start the installation.

5, in the installation, please wait until the following interface appears, complete the installation of MySQL

Second, Configuration of MySQL

1, the installation is complete, the following interface will enter the MySQL Configuration Wizard.

2, choose the configuration Square ,"Detailed configuration", "Standard Configuration", we select "Detailed Configuration", Easy to familiarize with the configuration process.

3, select the server type, "Developer Machine (Development test class, MySQL occupies very little resources)", "Server machine (server type, MySQL occupies more resources)", "dedicated MySQL server Machine (dedicated database server, MySQL occupies all available resources) "

4, choose the general purpose of MySQL database, "Multifunctional database (Universal multifunction, good)", "Transactional database only (server type, focus on transaction processing, general)", " Non-transactional Database only (non-transactional, simpler, mainly to do some monitoring, counting, MyISAM data type support is limited to non-transactional), press "Next" to continue.

5. Select the number of concurrent connections, decision Support (DSS)/olap (20 or so), Online Transaction Processing (OLTP) (500 or so), Manual Setting (manually set, lose a number yourself) ".

6, whether to enable the TCP/IP connection, set the port, if not enabled, you can only access the MySQL database on their own machine, on this page, you can also select "Enable Standard mode" (Enable Strict mode), This way, MySQL will not allow small grammatical errors. If you are a novice, it is recommended that you remove the standard mode to reduce hassle. However, when you are familiar with MySQL, try to use standard mode as it can reduce the possibility of harmful data entering the database. Press "Next" to continue

7, is the MySQL default database language encoding to set ( important), general election UTF-8, press "Next" to continue.

8, choose whether to install MySQL as a Windows service, you can also specify the service name (the Services identity name), whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under the bin, instead of indicating the directory name, such as connection, "Mysql.exe-uusername-ppassword;" You can, do not point out the full address of the Mysql.exe, very convenient), I have all ticked here, Service name unchanged. Press "Next" to continue.

9. Ask if you want to modify the password for the default root user (super Admin). "Enable root access from remote machines (whether to allow root users to log on to other machines, if it is safe, do not tick, if it is convenient, tick it)". Finally "Create an Anonymous account (create a new anonymous user, anonymous users can connect to the database, unable to manipulate data, including queries)", generally do not check, set up, press "Next" to continue.

10, confirm the settings are correct, press "Execute" to make the setting effective, that is, complete the installation and configuration of MySQL.

Note: SetEndBi, press"Finish"afterThere is a ratiomoreoftenSeeof theError, just can't"Start service", usually out ofnowprior to installationMySQL's serviceServiceson the device to resolve theOfficeLaw, pre-insuredCertificatethe previously installedMySQL CostumeServicesDeviceBeecherBottom UnloadingDownloadout of the way;words,Checkwhether to press the above oneStepthesay, before the secretCodewhether there is any modification, according to the above operation, if still not, willMySQL installation targetRecordunder theData FileClamping Deviceshare, and thenDeleteafter the installation is complete, the generatedData FileClip Deletein addition,preparedpart ofData FileClampmove back, restart again.MySQL CostumeServicesIt's ready,thiscase, you may need to set the dataLibrary Check, and then fixComplexonce to prevent data fromwrong.

Workaround:

1, Uninstall MySQL

2, Windows XP System removal Directory C:\Documents and Settings\All Users\Application Data\

Windows 7\8\10 operating system removal directory C:\ProgramData\MySQL

3, re-install it can be

MySQL installation diagram