Not the answer you need?
Register and ask your own question!

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

debashis_mallickdebashis_mallick EntrantCurrent User Role Novice
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 <password> -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

Comments

  • vaibhav_upadhyay40vaibhav_upadhyay40 Contributor Current User Role Patron
    edited June 12
    Hi @debashis_mallick
     access denied ERROR 1045 (28000): ProxySQL Error: Access denied for user 'app_user'@'10.5.0.80' (using password: YES):
    1)  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;"
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.