a month ago
Issue: I am receiving ER_ACCESS_DENIED_ERROR (1045) for my root user from both internal (IPv6) and external connections.
Details: I have updated the MYSQLPASSWORD environment variable in the dashboard, but the change has not propagated to the internal MySQL user table. My server is unable to connect despite the variables matching.
Ask: Is there a way I can synchronize my internal MySQL root user password with the current MYSQLPASSWORD variable in my environment or provide a temporary root reset?
4 Replies
a month ago
If you wish to change database credentials, you need to do so through the database tab.
Click on your service, go to the database tab, click Config, then Regenerate Password.
Redeploy after, and you should be able to log in with a new password.
a month ago
Thanks for the response. Unfortunately, I've already regenerated a password and changed all my variables to match the password multiple times. There seems to be a larger issue at play here.
ryannieds107
Thanks for the response. Unfortunately, I've already regenerated a password and changed all my variables to match the password multiple times. There seems to be a larger issue at play here.
a month ago
I would recommend using reference variables instead of "actual" variables.
To do this, use the template ${{ Servicename.Variablename }}$
For example, if you wish to use the MySQL password in another service, you would do: ${{ MySQL.MYSQLPASSWORD }}
a month ago
Thanks, I actually already tried that. I think I'm going to reset MySQL service