• Client does not support authentication protocol requested by server; consider upgrading MySQL client


    1、在使用navicat11连接mysql8时报如下错误:

    1251-Client does not support authentication protocol requested by server; consider upgrading MySQL client

    2、问题分析:

    根据提示:客户端版本太低

    3、解决问题:

    问题是navicat如何升级mysql连接客户端的版本呢?
    有没有其他的办法呢?
    网上有网友给出的解决办法:
    USE mysql;
    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
    FLUSH PRIVILEGES;
    
    root是用户名,localhost是ip地址127.0.0.1都是特指本机,mysql_native_password是旧的密码验证机制

    但是我们公司的数据库,别人都可以连上,为啥我的就不行呢?

     一起来看看navicat官方给的文档:

    Use OLD_PASSWORD encryption  
    The password hashing mechanism was updated in MySQL 4.1 to provide better security and to reduce the risk of passwords being intercepted. However,
    this new mechanism is understood only by MySQL 4.1 (and newer) servers and clients, which can result in some compatibility problems.
    A 4.1 or newer client can connect to a pre-4.1 server, because the client understands both the old and new password hashing mechanisms. However,
    a pre-4.1 client that attempts to connect to a 4.1 or newer server may run into difficulties. Enable this option if you wish to maintain backward compatibility with pre-4.1 clients under circumstances where the server would otherwise generate long password hashes.
    The option does not affect authentication (4.1 and later clients can still use accounts that have long password hashes),
    but it does prevent creation of a long password hash in the user table as the result of a password-changing operation.
    大致意思是说:
    连接到4.1或更高版本服务器的4.1之前的客户端可能会遇到困难。
    如果希望在服务器将生成长密码散列的情况下保持与4.1版之前的客户端的向后兼容性,请启用[OLD_PASSWORD]此选项

    4、既然如此,那就换个新版本的navicat.

    5、

  • 相关阅读:
    请求的详细资料级别没有事实表
    BIEE汇总数据如何放在后面
    Biee仪表盘中提示空值如何去掉
    UFT测试本地应用程序登陆小实例(描述性编程)
    Mysql找回丢失密码
    linux下Mysql多实例实现
    如何从零安装Mysql
    Linux系统下yum源配置(Centos 6)
    Linux系统管理常用命令用法总结(2)
    Linux系统管理常用命令用法总结(1)
  • 原文地址:https://www.cnblogs.com/ywf520/p/12394431.html
Copyright © 2020-2023  润新知