MySQL 5.7.21 decompression version installation Navicat database operation tool installation

Installation of MySQL decompression version and Navicat database operation tool, as follows

1. Download MySQL

1. You can download the required MySQL version here.

2. Unzip the downloaded file to the path where you want to install MySQL.

2. Installation of MySQL

1. Command installation. Use the cd command to go to the decompressed directory and use: mysqld -install to install MySQL.

2. Create a data directory and use the command:

mysqld --initialize-insecure --user=mysql 

3. Start the service

The following error may occur during startup.

Or the service cannot be started successfully under Computer - Management - Services - MySQL.

Service activation guide:

The error occurred:

(1) Check whether the data directory exists and contains correct data. If it does not contain or you are not sure whether the data is correct, delete the directory and generate it again according to the previous method.

(2) Create a new my.ini file with the following contents:

[client] 
port=3306 
default-character-set=utf8 
[mysqld] 
skip-grant-tables //The current statement does not need to add port=3306 
character_set_server=utf8 
basedir=D:\soft\mysql-5.7.21-winx64 //Decompression directory [If an error occurs during operation, you can try to change the slash to a double slash] 
#Unzip directory datadir=D:\soft\mysql-5.7.21-winx64\data 
#Unzip the data directory in the directory sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
[WinMySQLAdmin] 
D:\soft\mysql-5.7.21-winx64\bin\mysqld.exe

4. Login to MySQL

Possible login error:

In the newly created my.ini file, add the statement under [mysqld]: skip-grant-tables

There is no password for the first login, and you can log in successfully without a password. Run the following statement to change the root user login password.

update user set password=password('new password') where user='root'; 

Possible errors:

ERROR 1054 (42S22): Unknown column 'password' in 'field list'

Use the following statement instead, it will succeed:

update mysql.user set authentication_string=password('new password') where user='root' and Host ='localhost'; 

If you quit immediately and log in again, you may get an error:

You must SET PASSWORD before executing this statement 

After updating the password statement, execute the following code to confirm the new password:

SET PASSWORD = PASSWORD('new password');

You can then log in normally. You may find that you may fail to log in using the password, but you can log in successfully without using the password. Please remove the statements added in the my.ini file before, and then restart the service, and you can log in using the password.

5. Configure environment variables

6. When faced with an error, we need more information to better determine the scope and cause of the error. Looking at the Windows error log is also a good option.

3. Download Navicat

It is not always comfortable to just install MySQL and use it in a DOS window. Navicat is a great tool for us to operate MySQL database.

1. Download Navicat

This allows downloading, but there is a limitation. Here is a registration code for everyone, which can be used so far.

NAVH-WK6A-DMVK-DKW3

Of course, you can also come here, it is cracked here.
Link: https://pan.baidu.com/s/1cSaL9G Password: 5drv

4. Installation of Navicat

1. Double-click the obtained exe file to install it with the default options. [Choose the installation directory according to your own habits]

2. Cracking

If you choose to download the version directly from the Baidu website, please register using the registration code. If the registration code is invalid, just Baidu the cracking method. You can even download the cracked version directly. Generally, don’t rush to click the Now button on a web page. Check the lower left corner for a jump link. Generally, only buttons with the suffix zip are valid.

If you downloaded a cracked version of Baidu Netdisk, after installation, simply copy the non-installation exe file to replace the file in the installation path and restart.

3. Link: Open the main page --- Link to mysql --- View and use MySQL

I wish you all a happy use~_~

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.