CODEWITHSUNDEEP
mariadbproxysql
Faiz Ahmed
Faiz Ahmed

Reputation: 415

ProxySQL giving me the error Access denied for user

I installed ProxySQL in my server.

Server details : CentOS Linux release 7.5.1804 (Core)

ProxySQL version : proxysql-2.0.2-1-centos7.x86_64.rpm MaridaDB version : Distrib 10.3.7-MariaDB

Everything is working fine, but i am getting the following problem randomly. 

 MySQL_Session.cpp:3966:handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKE(): [ERROR] ProxySQL Error: Access denied for user 'user'@'*.*.*.*' (using password: YES)

Upvotes: 3

Views: 7092

Answers (3)

Anup_Tripathi
Anup_Tripathi

Reputation: 2817

I was facing the same problem and searched on the internet but could not get any workable solution. Then I downgraded the ProxySql from version 2.4.x to 2.2.x and it worked. It is now working perfectly fine. I tested it with sysbench too. Not a single connection loss (or Access denied error) was observed.

Upvotes: 1

Saksham Bhushan
Saksham Bhushan

Reputation: 1

Timezone difference with the connected server and the user can also be a reason for such ProxySQL errors, try setting the correct timezone.

PHP example:

date_default_timezone_set(“YOUR_TIME_ZONE”);

I was facing a similar problem and this helped me.

Upvotes: 0

Rahul Tokase
Rahul Tokase

Reputation: 1218

Make sure you create the same user in the underlying database server as well and from the application, you are connecting to proxy sql server on port 6033. Let me know if you face any issues.

Upvotes: 0

Related Questions