# mysql db user frequently get access denied issue while connection through proxysql

**URL:** <https://forums.percona.com/t/mysql-db-user-frequently-get-access-denied-issue-while-connection-through-proxysql/7434>\
**Category:** Other Tools\
**Created:** [February 19, 2020, 8:52am UTC](https://forums.percona.com/t/mysql-db-user-frequently-get-access-denied-issue-while-connection-through-proxysql/7434 "2020-02-19T08:52:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![debashis\_mallick](https://avatars.discourse-cdn.com/v4/letter/d/e95f7d/32.png) [@debashis\_mallick](https://forums.percona.com/u/debashis_mallick)\
**Post date:** [February 19, 2020, 8:52am UTC](https://forums.percona.com/t/mysql-db-user-frequently-get-access-denied-issue-while-connection-through-proxysql/7434/1 "2020-02-19T08:52:39Z")

</div>

Here is my environment :  
Azure ubuntu 18.4 instance with three mysql 8.018 version of mtaster slave  
xxx.xxx.xxx.73 (mysql slave)  
xxx.xxx.xxx.75 (mysql master )  
xxx.xxx.xxx.79 (mysql slave)  
Proxy sql version is  
proxysql --version ProxySQL version 2.0.6-73-gc746bf7f, codename Truls  
mysql client is mysql Ver 8.0.19 for Linux on x86\_64 (MySQL Community Server - GPL).  
I also change password authentication value in all mysql node config parameter to

collation-server = utf8mb4\_general\_ci  
default-authentication-plugin = mysql\_native\_password

Still I get access issue from proxy sql connecting to DB server node for same user id and  
password sometime it get access to mysql some time it giving access denied .

mysql -h 10.5.0.80 -u \<mysql\_user \> -p -P 6033 -e "SELECT @@hostname ; ".

this script some time gets connected and sometime it won’t access and getting message access denied ERROR 1045 (28000): ProxySQL Error: Access denied for user ‘app\_user’@‘10.5.0.80’ (using password: YES) "`I am breaking my head for last three days … need help urgently

---

<div class="post-metadata">

**Author:** ![vaibhav\_upadhyay40](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vaibhav_upadhyay40/32/9_2.png) [@vaibhav\_upadhyay40](https://forums.percona.com/u/vaibhav_upadhyay40)\
**Post date:** [June 12, 2020, 1:44pm UTC](https://forums.percona.com/t/mysql-db-user-frequently-get-access-denied-issue-while-connection-through-proxysql/7434/2 "2020-06-12T13:44:15Z")

</div>

Hi @debashis_mallick   
_&nbsp;access denied ERROR 1045 (28000): ProxySQL Error: Access denied for user ‘app\_user’@‘10.5.0.80’ (using password: YES):_   
1)&nbsp; Verify user is present and user creation was done using proper mysql commands, and ensure at the end ‘flush privileges;’ was executed.  
  
2) Also check for typo and use quotes for password.  
mysql -h ‘xxx’ -u ‘yyy’ -p **‘** zzz **’** -P 6033 -e “select xxxx;”