Skip to content

Instantly share code, notes, and snippets.

@haujoe

haujoe/mysql.sh

Created June 14, 2018 14:00
Show Gist options
  • Save haujoe/98645f4a72ad431f9ec91b91915ed2da to your computer and use it in GitHub Desktop.
Save haujoe/98645f4a72ad431f9ec91b91915ed2da to your computer and use it in GitHub Desktop.
Download ZIP
mysql 8.0.11 ：第三方客户端连接 caching-sha2-password 问题
Raw
mysql.sh
# mysql 8.0.11 ：第三方客户端连接 caching-sha2-password 问题
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; # 修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; # 更新用户的密码
FLUSH PRIVILEGES; # 刷新权限
ALTER USER 'root'@'localhost' IDENTIFIED BY '1234567890'; # 重置密码
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment