Get the App
SLTechnology News&Howtos  ›  Database  › 

How to deal with the 1045 error in navicat connection mysql

Shulou Source: shulou.com Published: 2022-06-01 01:00:32 11月17日 Update

This article mainly introduces the navicat connection mysql 1045 error how to deal with, has a certain reference value, friends in need can refer to. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

1045 error occurred in Navicat connection mysql

There is 1045 using Navicat to connect to mysql, possibly because you forgot your password.

The following methods can help you reset your password:

1. Run the cmd program with administrator privileges

2. Cd C:\ Program Files (x86)\ MySQL\ MySQL Server 5.7\ bin

3. Close the mysqld process

> > tasklist | findstr mysqld command can be used to check whether mysqld is running, and its PID can be found when it is running.

> > taskkill / F / PID xxxx xxxx is the pid value obtained from the previous command

4. Skip permissions to log in to the MySQL server

> > mysqld-- skip-grant-tables

Close cmd and run cmd again with administrator privileges

5. Change the password

> > cd C:\ Program Files (x86)\ MySQL\ MySQL Server 5.7\ bin

> > mysql

> > update mysql.user set authentication_string=password ('123456') where user = 'root'

> > flush privileges

> > SELECT * from mysql.user\ G

Find the authentication_string entry of the root user and write down its value

> > update mysql.user set authentication_string ='* 6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' where user = 'root';here user =' root'

> > flush privileges

> > quit

6. Restart mysql

> > net start mysql

7. Try to connect. If prompted by 1862, change the password and connect again.

> > mysqladmin-uroot-p password

Connect the test again

The great task has been completed!

Thank you for reading this article carefully. I hope the editor will share the 1045 errors in navicat connection mysql and how to deal with the content. At the same time, I also hope you can support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Tags: Password run error permission article again command method administrator help management done value content reason at the same time great merit friend server user Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Information vpn macOS Linux Docker