Troubleshoot Database Password Expiration

Troubleshoot Database Password Expiration

MyUse localthis machine'schecklist SQLwhen passwordAIQ gotcannot connect to the database and logs indicate an expired or invalid password.

Recommended guidance

• Confirm the failing account and Idatabase didendpoint changebefore itchanging fromcredentials.
• Follow Workbench,the butapproved AIQcredential stillrotation thinks that it isprocess.
• Do not changed,paste Ipasswords triedinto restartingdocumentation, bothtickets, or shared output.
• Restart or refresh only the affected services after credential updates.

Validation workflow

1. Review AIQ and MYSQLdatabase services,logs but no luck.

   

   
   

   In order to reactivatefor the instance,exact Youauthentication musterror.

2. Coordinate gocredential toreset with the promptdatabase orowner.
3. Update MYSQLthe Workbenchapproved secure configuration location.
4. Validate AIQ connectivity and executedocument the below.change without exposing secrets.

mysql -u<user> -p<password> --connect-expired-password

then

ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

and

ALTER USER 'utp'@'localhost' PASSWORD EXPIRE NEVER;

inmy.cnf

It would be necessary to replace

[mysqld]

default_password_lifetime = 180

to

[mysqld]

default_password_lifetime = 0

or

issuingSET GLOBAL default_password_lifetime = 0;

when you are logged in as root in mysql tool, this would set this param for all the schema.