Hello,
I am seeking clarification regarding the requirements for managed accounts in MySQL DB assets. Specifically, I am encountering an issue when attempting to reset the password for a MySQL account that is restricted to (Localhost) access.
When I initiate a password change for an account that only has (Localhost) access, I receive the following error message:
"Searching for unrestricted MySQL user account 'user'@'%' - Account Not Found"
This leads me to question whether managed accounts for MySQL DB assets require wildcard (%) access to function correctly. Does the password reset functionality depend on having an account with unrestricted access (i.e., 'user'@'%')?
Any insights, recommendations, or best practices regarding this would be greatly appreciated.
Thank you in advance for your assistance.