Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

access proxysql 6033 using mysql client sometimes success,sometimes failed? #3185

Closed
lddlww opened this issue Dec 9, 2020 · 1 comment

Comments

@lddlww
Copy link

lddlww commented Dec 9, 2020

sometimes success like follow

mysql -h10.5.111.11 -P6033 -uprog_admin -p1234
mysql>

but sometimes failed return the follow error:

mysql -h10.5.111.11 -P6033 -uprog_admin -p1234
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): ProxySQL Error: Access denied for user 'prog_admin'@'172.20.1.241' (using password: YES)

and i can't found any exception or error in proxysql.log,
i use mysql client access mysqld directly always return success,
what happend to it?

proxysql version:

ProxySQL version 2.0.10-27-g5b31997, codename Truls

mysqld version

Server version: 5.7.26

mysql client version

mysql  Ver 14.14 Distrib 5.7.26, for el7 (x86_64) using  EditLine wrapper
@renecannao
Copy link
Contributor

Hi,

The backend is not relevant in this issue.
It is proxysql that is returning an error, saying that the client is (probably) providing an incorrect credential.
Can you reproduce this with the latest version of ProxySQL ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants