MySQL Authentication Plugin Issues on macOS

I’m working on a blog project using Python and Flask, and I’m using the MySQL database from XAMPP for user registration. The project worked perfectly on my Windows machine, but after switching to macOS, I’ve been encountering various issues with the registration process. I’ve managed to resolve most of the issues, but I’m still struggling with one particular error. I’ve been working on this for a week now and could use some help.

Error Details:

MySQLdb.OperationalError: (2059, "Authentication plugin ‘mysql_native_password’ cannot be loaded: dlopen(/opt/homebrew/Cellar/mysql/9.0.1/lib/plugin/mysql_native_password.so, 0x0002): tried: ‘/opt/homebrew/Cellar/mysql/9.0.1/lib/plugin/mysql_native_password.so’ (no such file), ‘/System/Volumes/Preboot/Cryptexes/OS/opt/homebrew/Cellar/mysql/9.0.1/lib/plugin/mysql_native_password.so’ (no such file), ‘/opt/homebrew/Cellar/mysql/9.0.1/lib/plugin/mysql_native_password.so’ (no such file)")

enter image description here

Context:

•   The application is running on macOS using XAMPP.
•   The database is configured correctly, and I can connect to it using other tools.
•   I’ve tried various solutions like asking chatgpt or searching on google

Has anyone encountered this issue or have any suggestions on how to resolve it?

Thanks in advance for your help!