Skip to content

Instantly share code, notes, and snippets.

@younthu

younthu/gist:4f4f8448c0ed8104fe70b50cddb64b22

Created May 12, 2019 16:23
Show Gist options
  • Save younthu/4f4f8448c0ed8104fe70b50cddb64b22 to your computer and use it in GitHub Desktop.
Save younthu/4f4f8448c0ed8104fe70b50cddb64b22 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
解决办法：
$ mysql -uroot
$ update mysql.user set plugin = 'mysql_native_password';
Query OK, 1 row affected (0.08 sec)
Rows matched: 4 Changed: 1 Warnings: 0
重启mysql, 问题解决，参考：https://taruchan.com/2018/06/22/cant-connect-to-mysql-from-sequel-pro/
D
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment