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.
- 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