Home Database navicat What is the reason for the 1251 error when navicat connects to mysql8?

What is the reason for the 1251 error when navicat connects to mysql8?

Feb 20, 2021 pm 01:54 PM
mysql8 navicat mistake

What is the reason for the 1251 error when navicat connects to mysql8?

Problem description:

The recently installed mysql8 always gives the following error when trying to connect using navicat.

What is the reason for the 1251 error when navicat connects to mysql8?

2. Searching the Internet for the reason, it was found that the encryption rule in the previous version of mysql8 was mysql_native_password, but after mysql8, the encryption rule was caching_sha2_password. There are two ways to solve the problem. One is One is to upgrade the navicat driver, and the other is to restore the mysql user login password encryption rule to mysql_native_password. Since the cracked version of navicat is used, the second method can only be used to solve it;

3. First, use the cracked version of navicat. Run cmd as administrator and then use the command to enter mysql.

What is the reason for the 1251 error when navicat connects to mysql8?

#Then enter the root password you set when installing mysql to enter. After entering, the interface is as follows

What is the reason for the 1251 error when navicat connects to mysql8?

Note: If you enter mysql -u root -p, cmd prompts that mysql is not an internal or external command, nor is it an operable program or batch. Process the file, indicating that you did not add the path to mysql in the environment variable PATH after installing mysql before. This method is suggested at the end of the article;

4. Then change the encryption method in mysql first. The instructions are as follows:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
Copy after login

5. Then change the password. Since the encryption rules have changed, you need to re- Set the password;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
Copy after login

6. Finally, refresh the database;

FLUSH PRIVILEGES;
Copy after login

Finally, write down how to add the path to mysql in the environment variable PATH;

(Learn Video sharing: mysql video tutorial)

1. Win r-->services.msc-->Right-click the mysql service-->Properties-->Find the executable Path and copy it;

2. Right-click "My Computer"-->Properties-->Advanced System Settings-->Environment Variables-->System Variables-->PATH- ->Edit-->New-->The "executable path" above, as shown below;

What is the reason for the 1251 error when navicat connects to mysql8?

What is the reason for the 1251 error when navicat connects to mysql8?

## Related recommendations:

navicat

The above is the detailed content of What is the reason for the 1251 error when navicat connects to mysql8?. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Nordhold: Fusion System, Explained
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1671
14
PHP Tutorial
1276
29
C# Tutorial
1256
24
How to use navicat keygen patch How to use navicat keygen patch Apr 09, 2025 am 07:18 AM

Navicat Keygen Patch is a key generator that activates Navicat Premium, allowing you to use the full functionality of the software without purchasing a license. How to use: 1) Download and install Keygen Patch; 2) Start Navicat Premium; 3) Generate the serial number and activation code; 4) Copy the key; 5) Activate Navicat Premium, and Navicat Premium can be activated.

How to see if navicat is activated How to see if navicat is activated Apr 09, 2025 am 07:30 AM

How to check if Navicat is activated: View the Registration Information section in the "About Navicat" of the Help menu: Activated: Show valid registration information (name, organization, expiration date) Not activated: Show "Not Registered" or "Register Information Not Available" Check the activation icon in the toolbar: The green icon indicates that the active observation trial period countdown: The trial version will show the countdown at startup, the activated version will not view feature limitations: The trial version may limit advanced features, and the activated version will unlock all functions

How to import sql file into navicat How to import sql file into navicat Apr 09, 2025 am 06:24 AM

How to import SQL files using Navicat? Open Navicat and connect to the database. Open the SQL Editor. Import SQL files. Set import options (optional). Perform import. Check the import results.

How to create stored procedures with navicat How to create stored procedures with navicat Apr 08, 2025 pm 11:36 PM

You can use Navicat to create a stored procedure, the steps are as follows: Open the database object list and expand the "Procedures" node. Right-click the Procedures node and select Create Procedure. Enter the stored procedure name and body and set the parameters (if required). Select Compile in the File menu to compile the stored procedure. By executing a query or using "E in the "Procedures" list

How to execute sql in navicat How to execute sql in navicat Apr 08, 2025 pm 11:42 PM

Steps to perform SQL in Navicat: Connect to the database. Create a SQL Editor window. Write SQL queries or scripts. Click the Run button to execute a query or script. View the results (if the query is executed).

How to export the results of a navicat query How to export the results of a navicat query Apr 09, 2025 am 06:21 AM

Export query results with Navicat can be performed step by step: 1. Select the data to export 2. Select the export format: CSV, Excel, XML, or JSON 3. Configure the export options: Select columns, separators, and filters 4. Select the save location 5. Start exporting 6. Verify the results

How to roll back navicat How to roll back navicat Apr 09, 2025 am 06:15 AM

Navicat provides rollback functionality to undo database changes. The rollback steps are as follows: Connect the database to expand the database to be rolled back in the object browser. Right-click the table and select "Rolleepback" to select the rollback time point. Click "OK"

What to do if the error is running sql file in navicat What to do if the error is running sql file in navicat Apr 09, 2025 am 09:09 AM

To resolve errors when Navicat runs SQL files, follow these steps: 1. Check for SQL syntax errors; 2. Make sure the database connection is established; 3. Check file encoding; 4. Adjust server settings; 5. Check temporary space; 6. Disable certain plugins; 7. Contact Navicat Support if necessary.

See all articles