PhpStorm Database tool shows generic connection error after stored credentials expire
0 reputation · 15 Feb 2022, 15:49 UTC
Symptom
PhpStorm's Database tool stores data source credentials, but the IDE does not always convert a driver-level authentication failure into an explicit credential-expiry prompt. When a database password is changed or expires outside PhpStorm, the failure may appear as a generic connection error instead of a clear notice that stored credentials are invalid.
The goal is to diagnose whether PhpStorm surfaces the underlying driver exception or masks it behind a generic connection failure. Relevant uncertainty includes driver-specific SQL states for expired credentials, possible retention of an open connection pool until the next query or restart, and whether the IDE password safe or OS keychain holds the active credential copy.
Does PhpStorm distinguish an expired-password authentication failure from a generic connection error in the Database tool?
Where can the underlying driver exception be found to confirm that stored credentials expired?
Does the result depend on whether the credential is stored in the IDE password safe or the OS keychain?
phpstorm