Mysql is divided into Enterprise edition and Community edition. The Community Office is an open source software licensed under the GPL and can be used for free, while the Enterprise edition is a commercial software that requires a fee.

  • Mysql websitewww.mysql.com/Go to Download

  • Scroll down to the end and seeMySQL Community Edition (GPL), click on the

  • Go in and click Download

  • Scroll to the bottom of the page. The latest version is 8.0.17. Usually download version 5.5,5.6, click on the **Looking for Previous GA versions? ** To find the previous version





    Generally, the corresponding digit is selected



At the end, there will be a popup that requires registered users to download. You can click the picture below without registering



ZIP ArchiveThe installation package is installed by downloading the installation source package whileMSI InstallerDownload the installer, either of which is recommended to install the mysql5.5 versionMSI InstallerThe installation

MSI Installer installation procedure:

Install MYSQL

1. Open the downloaded mysql installation file mysql-5.5.27-win32.zip, double-click to decompress the file, and run setup.exe.





2. Select a Typical, Complete, and Custom installation type. Select Custom and press Next to continue.

3. Click Browse to manually specify the installation directory.



F:\Server\MySQL\MySQL Server 5.0. It is recommended that you do not place it in the same partition as the operating system. This will prevent the data from being cleaned up during system backup and restoration. Press “OK” to continue.



Verify your previous Settings and press “Back” to go Back and redo if you were wrong. Press Install to start the installation.





5. The MYSQL installation is in progress. Please wait until the following interface is displayed

1. After the installation is complete, the following interface is displayed to enter the MYSQL configuration wizard.





2. Select the Configuration mode. “Detailed Configuration” and “Standard Configuration” are selected to help you get familiar with the Configuration process.



3, Select the Server type, “Developer Machine”, “Server Machine”, Mysql is a Dedicated mysql Server that uses all available resources.

Transactional Database Only (a server type, Transactional, Transactional, Transactional) Non-transactional Database Only press “Next” to continue.



5. Select the number of concurrent connections and the number of simultaneous connections. Decision Support(DSS)/OLAP (about 20), Online Transaction Processing(OLTP) (about 500), and Manual Setting (manually set and input a number by yourself).





6, whether to Enable TCP/IP connection, set the port, if not enabled, you can only access the mysql database on your own machine, on this page, you can also select “Enable Strict Mode”, mysql does not allow minor syntax errors. If you are new to the game, you are advised to cancel the standard mode to save trouble. However, once you are familiar with MySQL, try to use standard mode because it reduces the possibility of harmful data entering the database. Click “Next” to continue



Mysql > select UTF-8 and press Next. Mysql > select UTF-8 and press Next.



Mysql > install mysql as a Windows Service; mysql > install mysql as a Windows Service; mysql > install mysql as a Windows Service; “Mysql. Exe – uusername – ppassword;” Mysql > select mysql.exe from mysql.exe. Mysql > select mysql.exe from mysql.exe. Press “Next” to continue.



9. Ask whether you want to change the password of the default root user. Enable root access from remote machines Enable root access from remote machines Finally, “Create An Anonymous Account (Create An Anonymous Account, Anonymous user can connect to the database, can not operate data, including query)”, generally do not check box, after setting, press “Next” to continue.

10. Confirm the Settings and press Execute to make the Settings take effect. The MYSQL installation and configuration are complete.





Note: A common error occurs when you press “Finish” to Start the mysql server. This error occurs when you install mysql on the server where it was installed. If not, check whether according to the above step, the previous password has been changed, according to the above operation; If still not, will the mysql installation directory data backup folder, and then deleted, after the installation is complete, will be installed to generate the data folder to delete, backup the data folder, and then restart the mysql service is ok, in this case, may need to check the database, and then repair time, prevent data error.



Solutions:

1, uninstall MySQL

Windows Xp delete directory C:\Documents and Settings\All Users\Application Data\

Windows 7\8\10 delete directory C:\ProgramData\MySQL

3. Reinstall

Attach downloaded mysql5.5 64 – bit version of the installer link: pan.baidu.com/s/10Rm9lTC5… Extraction code: PNIZ