search

sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6.03k stars 981 forks source link

DB connection type is uncerertain for mysql 8 DB user through proxySQL #2541

Open debashismallick opened 4 years ago

debashismallick commented 4 years ago

I am facing a strange issue , not sure where is my error . while connecting mysql db user some time it connect and sometime it failed with access denied for same user password .. Here is my configuration. 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.

When I run this script mysql -h 10.5.0.80 -u -p -P 6033 -e myscript. But some time it executed and some time it failed wit access denied error . I checked it by running individual nodes by using same credential with corresponding host ip . But for proxy SQL some time it connected , some time it failed .

renecannao commented 4 years ago

What is the exact error you receive? It should distinguish between a backend error or a proxysql error. Also, please share error log