Problem connecting to MySQL 8 using version 0.3.1

[eyosiardi-vt]

Hi,

I was wondering if anyone has seen this before, or have any advise regarding this issue: I could not connect to a MySQL 8 server from connectorx v0.3.1

import connectorx as cx
import urllib.parse
u = 'fubar'
u = urllib.parse.quote_plus(u)
p = 'barfoo'
p = urllib.parse.quote_plus(p)
url = 'redacted-12345.amazonaws.com'
url = urllib.parse.quote_plus(url)
print(url)
replica_conn = f"mysql://{u}:{p}@{url}:3306"
df = cx.read_sql(replica_conn, "SELECT COUNT(*) FROM mydb.test_table")
print(df.to_string())

This is what I get:
[2024-12-03T01:39:34Z ERROR r2d2] MySqlError { ERROR 1045 (28000): Access denied for user 'fubar'@'[ip_address]' (using password: YES) }

I am able to connect using mysql-connector-python just fine.

import mysql.connector
mydb = mysql.connector.connect(
host="redacted-12345.rds.amazonaws.com",
user="fubar",
password="barfoo"
)
print(mydb)
mycursor = mydb.cursor()
mycursor.execute("SELECT COUNT(*) FROM global.g_users")
myresult = mycursor.fetchall()
for x in myresult:
print(x)

I get:

<mysql.connector.connection.MySQLConnection object at 0x7ff92f945430>
(927221,)

Furthermore, I can get connectorx v0.3.1 to connect to my MySQL 5 server just fine, using the same code.

So I'm guessing v0.3.1 has some issues with MySQL 8, but I could be wrong.

PS: I wanted to try a newer connectorx version but due to the OS I'm using, I am limited to v0.3.1 at the moment.

Distributor ID: Ubuntu
Description: Ubuntu 16.04.7 LTS
Release: 16.04
Codename: xenial

Any ideas?

Thank you,
Ed