MySQL – Simple Queries using date datatype

Background Here I am trying to follow a blog post, but not quite sure whether all of its thoughts are still true. I have access to a MySQL instance and so let us see if I am able to follow more closely. BTW, I might have a later version of MySQL.   Code Outline Create … Continue reading MySQL – Simple Queries using date datatype

MySQL – Connectivity – Error – “Unable to load authentication plugin ‘caching_sha2_password’. “

Background Another error encountered while trying to connect to a MySQL instance. Error Error Text Unable to load authentication plugin 'caching_sha2_password'. Error Image Troubleshooting Outline Review Installation Configuration Options Options Authentication Method Use Strong Password Encryption for Authentication Our Choice Use Legacy Authentication Method Review Available MySQL Driver Versions Generic Review the versions of MySQL … Continue reading MySQL – Connectivity – Error – “Unable to load authentication plugin ‘caching_sha2_password’. “

MySQL – Connectivity – Error – “Public Key Retrieval is not allowed”

Background Trying to connect to a MySQL instance, but ran into an error. Error Error Text Public Key Retrieval is not allowed Error Image Remediation Outline General Set Attribute Set attribute AllowPublicKeyRetrieval to true DBeaver Window - Connect to Database Connection Settings Tab - "Driver Properties" Toggle Property "AllowPublicKeyRetrieval" Change from false to true Images … Continue reading MySQL – Connectivity – Error – “Public Key Retrieval is not allowed”