【mysql日常运维】navicat连接mysql8.0数据库提示2059错误

最新推荐文章于 2024-06-25 18:26:15 发布

MambaCloud

最新推荐文章于 2024-06-25 18:26:15 发布

阅读量328

点赞数

分类专栏： MySQL 文章标签：数据库 mysql oracle

本文链接：https://blog.csdn.net/weixin_49756466/article/details/126797733

版权

MySQL 专栏收录该内容

25 篇文章 0 订阅

订阅专栏

navicat连接mysql8.0数据库提示2059错误

原因：

mysql8 之前的版本中加密规则是mysql_native_password,而在mysql8之后,加密规则是caching_sha2_password

解决方法：

更改加密规则

root@afa4561c2aec:/# mysql -h localhost -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.11 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 'mofang_user'@'%' IDENTIFIED BY 'mofang' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.01 sec)

mysql> ALTER USER 'mofang_user'@'%'  IDENTIFIED WITH mysql_native_password BY 'mofang';
Query OK, 0 rows affected (0.10 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)