Shulou(Shulou.com)05/31 Report--

Editor to share with you how to install mysql 5.7.21 decompressed version and Navicat, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Download MySQL

1. You can download the required MySQL version here.

2. Extract the download file to the path where you want to install MySQL.

II. Installation of MySQL

1. Command installation. Use the cd command to the unzipped directory and install MySQL using: mysqld-install.

2. Create a data directory and use the command:

Mysqld-initialize-insecure-user=mysql

3. Start the service

The following figure may make an error during startup.

Or it is not successful to start the service under: computer-manage-Service-MySQL.

Service opening guidelines:

An error occurred:

(1) check that the data directory exists and contains the correct data. If it does not contain or is not sure whether the data is correct, delete the directory and generate it again as previously done.

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

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

4. Login link MySQL

There may be an error in login:

Add a statement under [mysqld] in the newly created my.ini file: skip-grant-tables

Login for the first time without a password, normal can be password-free login success. Use the following statement to change the root user login password.

Update user set password=password ('new password') where user='root'

An error may occur:

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

You can succeed by swapping the following statement:

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

If you quit and log back in now, 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')

After that, you can log in normally. You will find that the login may not be successful with the current password, but the login will be successful without using the password. Please remove the statement added in the previous my.ini file, and then restart the service, and you can log in with a password.

5. Configure environment variables

6. In the face of errors, we need more information to better determine the scope and causes of errors. Viewing the Windows error log is also a good option.

III. Download of Navicat

It's not always comfortable just to install MySQL and use it under the dos window. Navicat is a good tool for us to manipulate MySQL databases.

1. Download Navicat

This makes it possible to download, but there is a limitation. Here is a registration code, which can be used so far.

NAVH-WK6A-DMVK-DKW3

Of course, you can also come here, here is cracked.

Link: https://pan.baidu.com/s/1cSaL9G password: 5drv

IV. Installation of Navicat

1. Double-click on the obtained exe file and you can install it with the default option. [choose the installation directory according to your own habits]

2. Cracking

If you choose to download the version directly from the Baidu web page, please use the registration code to register. If the registration code fails, Baidu cracked the method directly. You can even download the cracked version directly. The general web page now button is not in a hurry to click, check the lower left corner prompt jump link. Generally, buttons with the suffix zip are valid.

If you download the Baidu network disk cracked version, after installation, directly copy the non-installation file exe file to replace the installation path of the file, restart.

3. Link: open the main page-link mysql-view and use MySQL

The above is all the contents of the article "how to install mysql 5.7.21 decompressed version and Navicat". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow 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.