【 TiDB 使用环境`】测试环境
【 TiDB 版本】5.4
【遇到的问题】
【复现路径】在我部署的测试集群上使用 mysql -uroot -p -h127.0.0.1 -P4000 提示1045错误
【问题现象及影响】
无法使用tidb连接数据库,单独的使用mysql -uroot -p -h127.0.0.1 输入密码的后正常进入mysql5.7
如代码显示:
[root@vdeGvJ1018471 data]# mysql -h127.0.0.1 -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.37-log Source distribution
Copyright © 2000, 2022, Oracle and/or its affiliates.
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> ERROR 1045 (28000): Access denied for user ‘root’@‘127.0.0.1’ (using password: YES^C
mysql> exit
Bye
[root@vdeGvJ1018471 data]# mysql -uroot -p -h127.0.0.1 -P 4000
Enter password:
ERROR 1045 (28000): Access denied for user ‘root’@‘127.0.0.1’ (using password: YES)
[root@vdeGvJ1018471 data]# mysql -uroot -p -P4000 -h127.0.0.1
Enter password:
ERROR 1045 (28000): Access denied for user ‘root’@‘127.0.0.1’ (using password: YES)
[root@vdeGvJ1018471 data]#
【附件】
请提供各个组件的 version 信息,如 cdc/tikv,可通过执行 cdc version/tikv-server --version 获取。