Skip to content

Instantly share code, notes, and snippets.

@matsubo
Created May 19, 2024 03:13
Show Gist options
  • Save matsubo/cb875c98b3fd740abb24dd9f8f33d8a0 to your computer and use it in GitHub Desktop.
Save matsubo/cb875c98b3fd740abb24dd9f8f33d8a0 to your computer and use it in GitHub Desktop.
mysql 8.4に対応するためにパスワードのプラグインを変更する方法
# dockerコンテナの場合は手動で立ち上げて、そのコンテナにexecで入ってローカルに接続して変更する
ALTER USER 'root'@'localhost' IDENTIFIED with caching_sha2_password BY 'xxxxxxxxx'
ALTER USER 'root'@'%' IDENTIFIED with caching_sha2_password BY 'xxxxxxxxx'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment