mysql8.0client_navicat 连接mysql8.0 报错client does not support authentication

navicat 连接mysql8.0 报错client does not support authentication,解决方法：

打开windows Powershell,输入以下命令 ，加红加粗的为录入的内容

Windows PowerShell

版权所有 (C) Microsoft Corporation。保留所有权利。

PS C:\WINDOWS\system32> cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"

PS C:\Program Files\MySQL\MySQL Server 8.0\bin> mysql -uroot -p

mysql : 无法将“mysql”项识别为 cmdlet、函数、脚本文件或可运行程序的名称。请检查名称的拼写，如果包括路径，请确保路径正

确，然后再试一次。

所在位置 行:1 字符: 1

+ mysql

+ ~~~~~

+ CategoryInfo          : ObjectNotFound: (mysql:String) [], CommandNotFoundException

+ FullyQualifiedErrorId : CommandNotFoundException

Suggestion [3,General]: 找不到命令 mysql，但它确实存在于当前位置。默认情况下，Windows PowerShell 不会从当前位置加载命令 。如果信任此命令，请改为键入“.\mysql”。有关详细信息，请参阅 "get-help about_Command_Precedence"。

PS C:\Program Files\MySQL\MySQL Server 8.0\bin> .\mysql -uroot -p

Enter password: ******

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 14

Server version: 8.0.12 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

Query OK, 0 rows affected (0.03 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Query OK, 0 rows affected (0.10 sec)

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.00 sec)

总结

以上是生活随笔为你收集整理的mysql8.0client_navicat 连接mysql8.0 报错client does not support authentication的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。