access denied for user 'proxyadmin'@'127.0.0.1' (using password: YES)

[arun chakrapani rao]

Hi all,

Sorry a basic question, setting up proxysql on a 3 node galera cluster.

i have configured 2 users as per docs

proxyadmin with 'proxyadmin'@'%' on the cluster.

i have confiured the proxysql to ocnnect to these server setting the hostgroup for all the servers same as 10

i am trying to connect from proxysql with the abov user name it is throwing error as 

mysql -uproxyadmin -p123 -P6033 --prompt='ProxySQLClient'

ProxySQL Error: Access denied for user 'monitor'@'127.0.0.1' (using password: YES)

where as the same user user when doing a remote connecting directlry with port 3306 it is working fine.

where have i gone wrong please do let me know

thanks in advance

arun

[René Cannaò]

Hi Arun, 

Unfortunately there is so much wrong going on here.

For example:

1)

According to the error you reported, you are using "monitor" user, while according to your prompt you are using proxyadmin : there is clearly a copy/paste issue.

2)

According to your mysql prompt , you are not specifying any host, so according to your prompt it will try to connect to a Unix socket and not to TCP port 6033 : again, probably a copy/paste mistake.

3)

You are not giving evidence you configured the user in ProxySQL 

Point 3 will clarify if you configured ProxySQL correctly, but the first two points are an indicator that probably you are doing something wrong while copy/pasting the instructions

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/proxysql/8b4cb7b2-1f84-4f57-b76b-076da211e26bn%40googlegroups.com.

[arun chakrapani rao]

I reinstalled the whole os and the proxysql it is working fine now. not sure what was the issue exactly.

Thanks for the help