Error Message in DBeaver connecting using jdbc: Public Key Retrieval is not allowed

Fixing “Public Key Retrieval is not allowed” Error in MySQL with DBeaver

 

If you are trying to connect MySQL 8+ with DBeaver and suddenly see this frustrating error:

❌ Public Key Retrieval is not allowed

Don’t worry — this is a very common issue and the fix is simple once you understand why it happens.

---

🔍 Why This Error Occurs

MySQL 8 uses a new authentication method called:

caching_sha2_password

For security reasons, Java-based tools like DBeaver (which use JDBC drivers) refuse to automatically fetch the public key from the server unless you explicitly allow it.

So when DBeaver tries to connect, it fails with:

Public Key Retrieval is not allowed

This is not a server crash, not a firewall issue, and not a wrong password problem — it’s just a security restriction in the driver.

---

✅ The Quick & Easy Fix (Recommended for Local/LAN Use)

Step 1: Open your connection in DBeaver

• Right-click your MySQL connection → Edit Connection

Step 2: Go to Driver Properties

Add or set these two properties:

Property	Value
allowPublicKeyRetrieval	true
useSSL	false

Step 3: Click Test Connection → Finish

That’s it. Your connection should work immediately.

---

🧠 What This Setting Does

• allowPublicKeyRetrieval=true → Allows the client to fetch the MySQL public key securely.

• useSSL=false → Disables SSL (fine for local or LAN setups).

---

🛡️ Permanent & Cleaner Fix (Server Side – Best for Production)

Instead of changing client settings everywhere, you can switch the MySQL user to the old compatible authentication method:

Login to MySQL:

sudo mysql

Run:

ALTER USER 'shashwat'@'%' IDENTIFIED WITH mysql_native_password BY 'YourPassword';
ALTER USER 'shashwat'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourPassword';
FLUSH PRIVILEGES;

Now you can connect from DBeaver without any special options.

---

🔎 Check Which Auth Plugin Your User Uses

SELECT user, host, plugin FROM mysql.user WHERE user='shashwat';

If it shows:

mysql_native_password

You’re fully compatible with all tools.

---

⚠️ Security Note

• Using allowPublicKeyRetrieval=true is safe on local network

• Do NOT expose MySQL directly to the internet without:

  • Firewall

  • SSL

  • IP restrictions

---

🏁 Conclusion

This error looks scary, but it’s actually:

✅ A client-side security restriction, not a server failure.

Once you fix it, MySQL + DBeaver works perfectly.

#MySQL #DBeaver #Database #SQL #BackendDevelopment #Java #JDBC #DevOps #Linux #Ubuntu #ServerManagement #WebDevelopment #ErrorFix #TechTips #Programming #DatabaseAdministration #FullStack #Coding #Troubleshooting #SelfHosted

How to add "Copy to" and "Move to" options to the right-click context menu in Windows:

Method 1: Registry Editor (Manual)

Note: Back up your registry first or create a system restore point.

Add "Copy to" Option:

1. Press Win + R, type regedit, press Enter
2. Navigate to:

text

HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex\ContextMenuHandlers

3. Right-click ContextMenuHandlers → New → Key
4. Name it: Copy To
5. Double-click (Default) on the right
6. Enter this value:

text

{C2FBB630-2971-11D1-A18C-00C04FD75D13}

Add "Move to" Option:

1. In the same ContextMenuHandlers folder
2. Right-click → New → Key
3. Name it: Move To
4. Double-click (Default) and enter:

text

{C2FBB631-2971-11D1-A18C-00C04FD75D13}

Method 2: Using Free Tools (Easier)

Create two text files with these contents:

CopyTo.reg:

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex\ContextMenuHandlers\Copy To]

@="{C2FBB630-2971-11D1-A18C-00C04FD75D13}"

MoveTo.reg:

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex\ContextMenuHandlers\Move To]

@="{C2FBB631-2971-11D1-A18C-00C04FD75D13}"

Save as .reg files and run them.

To Remove (if needed):

Simply delete the Copy To and Move To keys you created in the registry.

How it works:

• After adding, when you right-click a file/folder:
• Copy to → Lets you choose a destination folder to copy to
• Move to → Lets you choose where to move the file/folder
• Both show a folder browser dialog for destination selection

Safety Note: If using registry method, always back up your registry first. The tools mentioned in Method 2 are safer for most users. 

#NVIDIA #Studio vs #GameReady #Drivers: Complete Comparison

 

🔹 1. NVIDIA Game Ready Driver (GRD)

Purpose:
Optimized for gaming and new game releases.

Characteristics:

• Best performance and compatibility for latest games

• Gets updates very frequently

• Optimized for:

  • New AAA games

  • DLSS updates

  • Ray tracing profiles

  • Day-1 game launch optimizations

• Slightly less tested for professional apps

Best for:

• Gaming

• Casual streaming

• General use

---

🔹 2. NVIDIA Studio Driver (SD)

Purpose:
Optimized for creative and professional workloads.

Characteristics:

• Extensively tested with:

  • Adobe Premiere Pro

  • After Effects

  • Blender

  • DaVinci Resolve

  • Unreal Engine

  • Stable Diffusion

  • AI / ML tools

• Updates less frequently

• Focus on:

  • Stability

  • Reliability

  • Fewer crashes

  • Predictable behavior in professional software

Best for:

• Video editing

• 3D rendering

• AI / ML (YOLO, Stable Diffusion, LLMs, etc.)

• Content creation

• Production machines

---

🔹 3. Can You Install Both at the Same Time?

❌ No. You can only have ONE driver installed at a time.
They replace each other.

But…

✅ You can switch between them anytime using NVIDIA App / GeForce Experience.

---

🔹 4. How to Switch Between Them (Very Easy)

1. Open NVIDIA App or GeForce Experience

2. Go to Drivers

3. Click the 3-dot menu (top right)

4. Choose:

   • Game Ready Driver

   • OR Studio Driver

5. Click Download & Install

It takes ~3–5 minutes.

---

🔹 5. Which One YOU Should Keep (Based on Your Use)

You:

• Run YOLO

• Use AI models

• Do video content

• Test OS, software, tools

• Also probably do some gaming

✅ Recommendation:

Keep NVIDIA Studio Driver installed.

Because:

• It is more stable

• Works perfectly fine for games too (95–99% same performance)

• Much better for:

  • AI frameworks (CUDA, TensorRT, PyTorch)

  • Blender

  • Video editing

  • LM Studio / Jan / Stable Diffusion

---

🔹 6. When Should You Switch to Game Ready?

Only switch to Game Ready if:

• A new game is released and has performance/bug issues

• NVIDIA specifically recommends a GRD for that game

• You are gaming heavily for some time

Then you can switch back to Studio after.

---

🔹 7. Simple Rule

Work / AI / Editing → Studio Driver
Heavy Gaming / New Game → Game Ready Driver

---

🔹 8. Important Tip

Both drivers:

• Use the same core driver

• Same CUDA support

• Same RTX features

• Difference is testing, certification, and stability focus

#NVIDIA, #StudioDriver, #GameReady, #NVIDIADrivers, #GPUDrivers, #NVIDIAGeForce, #GamingPC, #PCGaming, #StudioVsGameReady, #DriverComparison, #NVIDIAvsNVIDIA, #GPUOptimization, #PCPerformance, #GamingPerformance, #FPS, #GamingSetup, #GamingRig, #GamingCommunity, #PCGamers, #GamingTips, #GamingTech, #ContentCreation, #VideoEditing, #3DRendering, #CreativeWork, #AdobeCreative, #Blender3D, #CreativeSuite, #DigitalArt, #GPU, #GraphicsCard, #RTX, #NVIDIARTX, #DriverUpdate, #PCSetup, #Hardware, #TechGuide, #TechTips, #WhichDriver, #ChooseWisely, #PCGuide, #TechDecisions, #OptimizationGuide, #PerformanceTips, #HowToSwitch, #DriverInstallation, #PCSetupGuide, #TechTutorial, #StepByStep, #DriverGuide, #PCMasterRace, #BuildAPC, #PCBuilding, #TechCommunity, #GamingCommunity, #CreatorCommunity, #2024Guide, #2024Tech, #LatestDrivers, #CurrentGen, #DriverIssues, #PCProblems, #TechSolutions, #FixYourPC, #PerformanceFix, #Stability, #Reliability, #PerformanceBoost, #OptimalSettings, #MaxPerformance, #BeginnerGuide, #EasyGuide, #SimpleExplanation, #TechForBeginners, #PCTips, #AdvancedSettings, #Optimization, #PerformanceTuning, #Customization, #Tweaking, #GeForceExperience, #NVIDIAControlPanel, #DLSS, #RayTracing, #NVIDIABroadcast, #WindowsPC, #Windows10, #Windows11, #PCOptimization, #DesktopPC, #TechReview, #ComparisonVideo, #Tutorial, #Explainer, #Guide, #TechContent