ERROR 2049 (HY000): Connection using old

最新推荐文章于 2021-08-20 10:37:40 发布

lwei_998

最新推荐文章于 2021-08-20 10:37:40 发布

阅读量2.4k

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/lwei_998/article/details/38495815

版权

MySQL 专栏收录该内容

123 篇文章 1 订阅

订阅专栏

MySQL 5.6 客户端访问 MySQL4.0.20 遇到如下错误

ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

$mysql -h10.0.149.13 -uroot -p123456 -P3306
Warning: Using a password on the command line interface can be insecure.
ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

$ mysql --help|grep secure-auth
--secure-auth       Refuse client connecting to server if it uses old
                      (Defaults to on; use --skip-secure-auth to disable.)
secure-auth                       TRUE

<span style="color:#333333;">$mysql -h10.0.149.13 -uroot -p123456 -P3306  --skip-secure-auth
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3356
Server version: 4.0.20-standard

Copyright (c) 2000, 2013, 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> select version();
+-----------------+
| version()       |
+-----------------+
| 4.0.20-standard |
+-----------------+
1 row in set (0.05 sec)</span>