0

Where is the cache for the new default authentication plugin caching_sha2_password in MySQL 8 stored? I want to know for future reference how to clear it in case I ever run into any problems using it.

2 Answers 2

1

'when there exists a cached copy of the password hash in memory' (ref).

So its all in memory.

FLUSH PRIVILEGES can clear it

-1
  • Open MySQL from System Preferences > Initialize Database >
  • Type your new password.
  • Choose 'Use legacy password'
  • Start the Server again.
  • Now connect the MySQL Workbench

Please read full Answer here

1
  • Is this an answer to how to clear the cache used by the caching_sha2_password plugin or how to gain access while dealing with the popular incompatibility issue with MySQL 8 and the caching_sha2_password plugin? Sep 20, 2018 at 18:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.