Mysql 5.7.20 unzip version installation steps (two methods), mysql5.7.20

Mysql 5.7.20 unzip version installation steps (two methods), mysql5.7.20

I will explain how to install MySQL in Windows 64-Bit mode. MySQL only has 32-bit download services when it is installed in MySQL 5.7. Here I will explain how to install MySQL in the decompressed version, when installing the MySQL decompress version, it is also a headache for beginners. Various problems are easy to solve without installing the version with one click. During installation, you must pay attention to three points: 1. Path configuration, 2. When the MySQL port is occupied during installation, You need to disable the occupied port. 3. cmd must set MySQL information in the administrator environment.

MySQL Official Website:

Https://www.mysql.com/downloads/

Http://www.bkjia.com/softs/451120.html

Method/step

1. I will not talk about downloading and installing MySQL. Here I will show the operations on the installation page as shown in the figure:

2. now, you need to install MySQL in the theme step by step. You must operate it in order. Otherwise, the installation process becomes cumbersome when an error is reported, here I post some problems about the installation process and the error. The operation is as follows:

3. Scroll down and select the button under MySQL Community Edition (GOL) to go To the download connection page (scroll down the page:

4. select a download version based on your computer system. You need to log on to the Oracle account when downloading the version. If you do not have a small partner, you can register the version by yourself. After registration, you will jump out of the download connection and choose your preferred DIY path, I chose to download an edisk.

5. download after self decompression, decompression will lack of my-default.ini files and data files, great god level of existence are directly configured built-in my-default.ini files, small make up can only honestly new my. the INI file is then configured in my. INI file. Do not forget to create a new empty data file.

6. The configuration of my. ini file is as follows:

[Client] port = 3306default-character-set = utf8 [mysqld] # Set the mysql installation directory basedir = E: \ MySQL \ mysql-5.7.20-winx64 \ mysql-5.7.20-winx64 # Set the mysql data directory datadir = E: \ MySQL \ mysql-5.7.20-winx64 \ mysql-5.7.20-winx64 \ datacharacter_set_server = utf8sql_mode = NO_ENGINE_SUBSTITUTION, NO_AUTO_CREATE_USER # enable query cache explicit_defaults_for_timestamp = trueskip-grant-tables

7. after performing the above steps as shown in the figure, it is estimated that you are a little impatient. Do not worry about configuring the MySQL path: Right-click the desktop icon> Properties (R)> advanced System Settings> environment variables (N)> Find Path copy download unzip Path, take my For example:; E: \ MySQL \ mysql-5.7.20-winx64 \ mysql-5.7.20-winx64 \ bin; note to add; Separate

Method/step 2

1. mySQL-5.7.20 unzip version installation requires cmd run as Administrator this step is very important, if you do not run the dos command as an administrator, the system reports "this command file cannot be found" or "it is not an internal specified command or an external command ", you must enter the MySQL path dos command as the cmd administrator to enter the binfile under the MySQL decompression directory to perform the following operations: Here I will take the path on the elastic drive as an example:

E: Enter (Press Enter) E: \> cd MySQL \ mysql-5.7.20-winx64 \ mysql-5.7.20-winx64 \ bin Enter (Press Enter) E: \> MySQL \ mysql-5.7.20-winx64 \ mysql-5.7.20-winx64 \ bin> mysqld-install (this step is to install MySQL, press Enter) The Service successfully installed indicates that the MySQL Service has been installed, it is worse to start. E: \> MySQL \ mysql-5.7.20-winx64 \ mysql-5.7.20-winx64 \ bin> net start mysql

It indicates that the MySQL server has been installed successfully.

Set Password address: http://blog.csdn.net/JLongSL/article/details/56484762

2. when the unzipping version is installed, the most common error is my. the INI file and data file do not exist. We need to manually configure and create them, and my. the INI file and data file are to be created under the path you extracted, and my. if the INI file is not created but the data file is not created, an error will be reported if the data file cannot be found, the error is reported because you have not created an empty data file in the specified path or created the data file, as shown in:

3. at this time, we will go back to MySQL and create an empty data file under the system disk when you download and decompress the file. Then, we will execute the doscommand: net start mysql (which should be executed on the original operation) you will find that there are some accessory folders in the data file, and the operation is successful, for example:

4. the ERROR 2003 <HY000>: Can't to MySQL server on 'localhost' (10061) or a statement similar to the preceding one, it indicates that the local server is not started. In this case, we start the server (open the computer --> Manage --> services and applications --> services) and find MySQL to start, but an error will still be reported, this is because our MySQL port is occupied by other programs, but this problem still occurs when xiaobian closes the occupied program, so I spent a lot of time looking for it, there are many ways to solve the problem on the Internet, but I still used the most stupid method in my final summary. I used the mysqld-remove command on the doscommand port to remove the newly installed MySQL, shut down all programs and restart your computer.

5. After the restart, install the tool again based on the information on the Internet. The installation is successful. Start the server again (open the computer --> Manage --> services and applications --> services) and find MySQL to start, but now it is in the starting status, I will test whether my visual tool Navicat for MySQL can be connected normally, as shown in the following figure:

Summary

The above is a detailed explanation of mysql 5.7.20 decompression installation steps (two methods). I hope to help you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!