Skip to content

Instantly share code, notes, and snippets.

@PraneethKarnena

PraneethKarnena/fix_mysql_caching_sha2_password.sql

Created March 23, 2020 08:00
Show Gist options
  • Save PraneethKarnena/fafad6cbc74cee18b8ebec00c9a9a966 to your computer and use it in GitHub Desktop.
Save PraneethKarnena/fafad6cbc74cee18b8ebec00c9a9a966 to your computer and use it in GitHub Desktop.
Download ZIP
Fix MySQL Unable to load authentication plugin 'caching_sha2_password'
Raw
fix_mysql_caching_sha2_password.sql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment