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”

DBeaver – Database Connection Configuration – IBM – DB2 / UDB JDBC Driver

Background As always coming back to DBeaver. This time to connect to a UDB Instance running on Linux. BTW, UDB means Universal Database. UDB JDBC Driver Artifacts DB2 JDBC Driver Versions and Downloads The URL for DB2 JDBC Drivers is Link. Here is a current snapshot. v11.1 FP0 ( GA ) We chose the v11 … Continue reading DBeaver – Database Connection Configuration – IBM – DB2 / UDB JDBC Driver

DBeaver – Database Connection Configuration – Oracle – Oracle JDBC Driver

Background Towards a couple of sample Oracle Database sample exercises that we have in mind wanted to make sure that our all purpose database client, DBeaver, is able to communicate with an Oracle Database.   Preparation Oracle Java Version Objective The version of JDBC Client that we need will be based on the version of … Continue reading DBeaver – Database Connection Configuration – Oracle – Oracle JDBC Driver