[Python] Mysql 5.5..33 : (5010, "Authentication plugin 'mysql_old_password' couldn't be found...

When I am trying to connect the MySQL db that hosted in remote via the python library MySQLdb, I am getting the following error.

(5010, "Authentication plugin 'mysql_old_password' couldn't be found in restricted_auth plugin list.")

Python Code

import MySQLdb

try:
mydb = MySQLdb.connect(
host = "test.corp.com",
user = "testuser",
passwd = "test2025",
db = "testingdb"
)
print("Database connection successful.")
except MySQLdb.Error as err:
print (err)


I couldn't find the support anywhere. Share solution if anyone knows. Thanks in advance.

Continue reading...