Shulou(Shulou.com)06/01 Report--

Xiaobian to share with you how to download version 5.5 of mysql, I believe most people still do not know how, so share this article for everyone's reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

Download version 5.5 mysql method: first open mysql official website; then find MySQL 5.5 and click download; then install MySQL 5.5; finally MySQL configuration can be.

Download MySQL 5.5 from the website.

Download address: dev.mysql.com/downloads/mysql/5.5.html#downloads

Install MySQL 5.5

Note: Please turn off antivirus software before installing.

(1) Open downloaded mysql-5.5.59-winx64.msi

(2) Click Next

(3) Check the box and select Next.

(4) Select custom installation. Select the installation type, there are three options: "Typical","Complete" and "Custom". Select "Custom" and press "next" to continue.

(5) Change of installation path.

(6) Click to install

(7) Click Next

8) Click Finish

(9) Click Next

3. MySQL configuration:

(1) After installation, the following interface will appear to enter the mysql configuration wizard.

(2) Select the configuration mode,"Detailed Configuration" and "Standard Configuration". We select "Detailed Configuration" to familiarize ourselves with the configuration process.

(3) Select the server type,"Developer Machine","Server Machine","Dedicated MySQL Server Machine"

(4) Select the general purpose of mysql database,"Multifunctional Database","Transaction Database Only","Non-Transaction Database Only", press "Next" to continue.

(5) Select the number of concurrent connections to the website, the number of simultaneous connections,"Decision Support (DSS)/OLAP (about 20),""Online Transaction Processing(OLTP)(about 500),""Manual Setting (manual setting, enter a number yourself)."

(6) Whether to enable TCP/IP connection, set the port, if not enabled, you can only access mysql database on your own machine, on this page, you can also select "Enable Strict Mode"(Enable Strict Mode), so MySQL will not allow minor syntax errors. If you are new, it is recommended that you cancel the standard mode to reduce trouble. However, after you become familiar with MySQL, try to use standard schema because it reduces the likelihood of harmful data entering the database. Press "Next" to continue.

(7) is to set the mysql default database language encoding (important), generally choose UTF-8, press "Next" to continue.

(8) Choose whether to install mysql as a Windows service, you can also specify ServiceName (service identification name), whether to add mysql bin directory to Windows PATH (after adding, you can directly use the files under bin without pointing out the directory name, such as connection,"mysql.exe-uusername -ppassword;", do not point out the complete address of mysql.exe, very convenient), I have checked all here, ServiceName unchanged. Press "Next" to continue.

(9) Ask if you want to change the password of the default root user (super admin). "Enable root access from remote machines (untick if safe, tick if convenient)." Finally,"Create An Anonymous Account"(create an anonymous user, anonymous users can connect to the database, can not operate data, including queries), generally do not check, after setting, press "Next" to continue.

(10) Confirm that the settings are correct, press "Execute" to make the settings effective, that is, complete the installation and configuration of MYSQL.

Note: After setting, press "Finish" and there is a common error, that is,"Startservice" cannot be "Startservice," which generally appears on servers that have previously installed mysql. The solution is to ensure that the previously installed mysql server is completely uninstalled; if not, check whether the previous password has been modified according to the above step. Follow the above operation; If it still doesn't work, backup the data folder under the mysql installation directory, and then delete it. After the installation is completed, delete the data folder generated by the installation, move the backup data folder back, and restart the mysql service. In this case, you may need to check the database and repair it once to prevent data errors.

Solution:

1, uninstall MySQL

2, Windows XP system delete directory C:\Documents and Settings\All Users\Application Data\

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

3, re-installation can be done

Above is how to download version 5.5 of mysql all the content, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.