Hi!
I am suddenly having DB connection problems from my MySQL resource without having done any changes whatsoever. Is anyone havning similar issues?
Hi @mustardJohnny,
Lots of ways you can debug this. It can be a misalignment on the password and authentication in Retool because something on the MySQL end changed. But you'd have to provide the exact error codes or what's going on to debug properly.
What specifically are you seeing that is wrong?
It suddenly started connecting to my db again. I believe I have narrowed it down to being something with the use on environment variables. Could there be some disturbances related to that going on today? I am using config variables to store separate prod/staging credentials and it seems that if I use
{{ environment.variables.my_special_secret }}
the connection fails:
Access denied for user 'my-user'@'my-ip' (using password: YES)
But If I input the password in clear text, it works.
This has been very stable until today. The weird thing is, the app using the resource (which again is using config vars) is working - but if I go into the resource and try to test the connection, it fails. Very confusing😄
Appreciate any help!
Thanks.
Hello @mustardJohnny!
Is the issue still going on?
I had recently tested a MySQL resource and it was giving a false error Access denied for user 'my-user'@'my-ip' (using password: YES) even with my password typed in plain text. But the queries and resource still worked fine.
If it was working previously without any changes then my guess is this might be due to a bug in a patch that we have either fixed or are working on fixing 
If it is still going on and I can reproduce it, I can file a bug report for the Resource testing!
Hi! Yes, it's working now. You're probably correct in your assumption there👍 Thanks for following up anyway!