For local database manipulation I still use Sequel Pro. Why? Well, all the derivatives (Like Sequel Ace) have a smaller feature set, and alternatives (like MySQL WorkBench) are too complex, and even limited. (How hard is it to provide a socket based connection, or an SSH tunnel TCP connection…)
Anyhoo, a quick note to myself for fixing the error
Double-check that the socket path is correct and that you have the necessary privileges, and that the server is running.
MySQL said: Authentication plugin ‘caching_sha2_password’ cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 0x0002): tried: ‘/usr/local/mysql/lib/plugin/caching_sha2_password.so’ (no such file), ‘/System/Volumes/Preboot/Cryptexes/OS/usr/local/mysql/lib/plugin/caching_sha2_password.so’ (no such file), ‘/usr/local/mysql/lib/plugin/caching_sha2_password.so’ (no such file)
The solution is simple; just roll back the user to the old password hashing. Remember, we’re doing this on LocalHost for Development purposes, no need to get angry in the comments ;)
$ wp db query "ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY 'root';"NOTE: this is only relevant when using LocalWP. For different systems, you will need different credentials, but the principle is the same.
