Skip to content

Instantly share code, notes, and snippets.

@Justintime50

Justintime50/laravel-upgrade-mysql-from-v5-to-v8-password.md

Created February 7, 2020 07:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Justintime50/2eff2afebdecee4739e142164974bb96 to your computer and use it in GitHub Desktop.
Save Justintime50/2eff2afebdecee4739e142164974bb96 to your computer and use it in GitHub Desktop.
Download ZIP
Upgrading MySQL from v5 to v8 breaks passwords
Raw
laravel-upgrade-mysql-from-v5-to-v8-password.md

Upgrading MySQL from v5 to v8 breaks passwords

Frameworks such as Laravel will no longer work with the native mysql passwords when upgraded. Follow these steps to correct:

Usage

docker exec -it database_container bash
mysql -u root -p
ALTER USER username IDENTIFIED WITH caching_sha2_password BY 'MYPASSWORDHERE';
exit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment