How to change the navicat password

This article is about how to change navicat password. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

Method 1: Use the SET PASSWORD command

Log in to MySQL first.

Format: mysql> set password for username @localhost = password ('new password');

mysql> set password for root@localhost = password ('123 ');

Method 2: Use mysqladmin

Format: mysqladmin -u username-p old password new password

Example: mysqladmin -uroot -p123456 password 123

Method 3: Edit user table directly with UPDATE

Log in to MySQL first.

mysql> use mysql; mysql> update user set password=password('123') where user='root' and host='localhost'; mysql> flush privileges;

Method 4: When forgetting the root password, you can do this

Take Windows for example:

1. Shut down the MySQL service that is running.

2. Open a DOS window and go to the mysql\bin directory.

3. Type mysqld -skip-grant-tables Enter. - Skip-grant-tables means to skip permission table authentication when starting MySQL services.

4. Open another DOS window (because that DOS window is no longer moving) and go to the mysql\bin directory.

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

6. Connection permissions database: use mysql;.

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

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

8. quit.

9. Log out of the system and log in again using the username root and the new password 123 you just set.

Thank you for reading! About "how to modify navicat password" this article is shared here, I hope the above content can be of some help to everyone, so that everyone can learn more knowledge, if you think the article is good, you can share it to let more people see it!