Bnjoroge1
commented
4 years ago the vscode-database extension deosnt seem to support newer versions of mysql clients(which have changed their password storing mechanism from the native(my_sql native password) to use a more secure hashing algorithm(caching_sha2_password). https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html. the best bet is to either downgrade your mysql client to a supported version and loose the added security capabilities or to use a wrapper.
SO i'm trying to connect to my MySQL db with both the root and a user but it's not connecting. Does anyone know why this is happening? i'm pretty sure my credentials are accurate