Bug 2372292 - Cannot connect to an caching_sha2_password account
Summary: Cannot connect to an caching_sha2_password account
Keywords:
Status: NEW
Alias: None
Product: Fedora EPEL
Classification: Fedora
Component: opendbx
Version: epel8
Hardware: All
OS: Linux
unspecified
unspecified
Target Milestone: ---
Assignee: Jonathan Wright
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2025-06-11 13:56 UTC by ryan.vanherwijnen
Modified: 2026-07-03 14:28 UTC (History)
1 user (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed:
Type: Bug
Embargoed:

Attachments (Terms of Use)

Description ryan.vanherwijnen 2025-06-11 13:56:18 UTC 
Description of problem:
I cannot connect to a MySQL account that uses caching_sha2_password authentication

Version-Release number of selected component (if applicable):
opendbx-1.4.6-38.el8.x86_64
opendbx-mysql-1.4.6-38.el8.x86_64
opendbx-utils-1.4.6-38.el8.x86_64

How reproducible:
Install opendbx and opendbx-mysql and try to connect to a database account in MySQL, that is configured using caching_sha2_password

Steps to Reproduce:
1. Create a database account with caching_sha2_password
2. Use odbx-sql to connect with to a database with that account

Actual results:
Nothing, the command seems to be hanging.

Expected results:
Getting a sql> prompt

Additional info:
Switching the database account back to mysql_native_password makes it connect successfully.
Comment 1 ryan.vanherwijnen 2026-07-03 14:28:28 UTC 
This is on the MySQL Reference Manual (https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html)
The mysql_native_password authentication plugin is deprecated as of MySQL 8.0.34, disabled by default in MySQL 8.4, and removed as of MySQL 9.0.0.
MySQL 9+ will not be able to use opendbx-mysql anymore.
Note You need to log in before you can comment on or make changes to this bug.