Tags » Dbeaver

DBeaver v7.2

#DBeaver is a free, multi-platform and universal database manager for developers, SQL programmers, database administrators and analysts. This software tool supports many databases including but not limited to: 374 more words

Windows

DBeaver v7.1.5

#DBeaver is a free, multi-platform and universal database manager for developers, SQL programmers, database administrators and analysts. This software tool supports many databases including but not limited to: 326 more words

Windows

MySQL - Insert/Ignore

Background

In our last post, we touched on a duplicate key error.

Here is another quick workaround around the same issue.

Lineage

  1. MySQL – Insert/On Duplicate Key Update…
  2. 305 more words
DBeaver

MySQL - Insert/On Duplicate Key Update

Background

There is a slight ditch one can fall into in MySQL.

Thankfully it is easy to address.

Error

Error Message

Text

Error occurred during SQL script execution

Reason:
SQL Error  : Duplicate entry '2-3-1' for key 'order.unique_Sales_Order_CustomerID_ProductID_numberofEntries'

… 124 more words
DBeaver

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… 252 more words

Technical

DBeaver v7.1.4

#DBeaver is a free, multi-platform and universal database manager for developers, SQL programmers, database administrators and analysts. This software tool supports many databases including but not limited to: 438 more words

Windows

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… 152 more words

Technical