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

Editor to share with you the solution to the 1862 error in navicat. I hope you will get something after reading this article. Let's discuss it together.

Problem description: using navicat to connect to the local database reported an error, connecting to the remote server is normal.

Method 1:

1. Shut down the running MySQL service.

two。 Open the DOS window and change to the mysql\ bin directory.

3. Enter mysqld-skip-grant-tables to enter. -skip-grant-tables means to skip authorization table authentication when starting the MySQL service

4. Open another DOS window (because the DOS window just now cannot be moved), and change to the mysql\ bin directory.

5. Enter mysql enter, and if successful, the MySQL prompt > will appear.

6. Connect permissions database: use mysql;.

6. Change the password: update user set authentication_string=password ("123") where user=" root "; (don't forget to add the semicolon at last).

7. Refresh permissions (required): flush privileges;.

8. Exit quit.

Result: unable to start the mysql service normally, and there is still a 1862 error, hitting the street.

Method 2:

From a command prompt, go to the bin directory of mysql and run this line: mysqladmin-u username-p old password password new password

Result: although there is a warning, it does not look like a success, but the new connection password "123" can indeed be connected.

After reading this article, I believe you have a certain understanding of "the solution to the 1862 error in navicat". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

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.