Bug 2372292

Summary:	Cannot connect to an caching_sha2_password account
Product:	[Fedora] Fedora EPEL	Reporter:	ryan.vanherwijnen
Component:	opendbx	Assignee:	Jonathan Wright <jonathan>
Status:	NEW ---	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	epel8	CC:	jonathan
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	---
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:		Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

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.