mysql 8.0.11 登录 mycat 1.6.5 时报密码错误,但用户密码配置没有问题
After completing the deployment of mycat, it is in a normal running state. Use the mysql8.0.11 client version to log in to mycat. After multiple login attempts, it is not possible to access the database, and the following error message is displayed: Access denied for user 'user', because password is error. MySQL -uuser -puser -h127.0.0.1 -P3306 MySQL: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (HY000): Access denied for user 'user', because password is error MySQL --version MySQL Ver 8.0.11 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL) After replacing MySQL with 5.7.20, it is possible to access the mycat 1.6.5 version normally. MySQL -uuser -puser -h127.0.0.1 -P3306 MySQL: [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 1015 Server version: 5.6.29-mycat-1.6.5-release-20180122220033 MyCat Server (OpenCloundDB) Copyright (c) 2000, 2017, 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> exit MySQL --version MySQL Ver 14.14 Distrib 5.7.20, for linux-glibc2.12 (x86_64) using EditLine wrapper
内容来源: MyCATApache/Mycat-Server