Encountering Issues with Initial MySQL Setup for Django Project on Ubuntu: Need Clarification

[new-php]

I recently followed a comprehensive guide to set up MySQL and integrate it into a Django project, but I encountered several challenges. Initially, I went through the installation process on Ubuntu 20.04 using guide on DigitalOcean. While the steps were clear for installation and initial database setup, I ran into issues during later stages, particularly when connecting the database to my Django project and running migrations.

Some of the problems I faced:

1. Database Configuration Challenges:
   After creating the user and database, Django wouldn’t authenticate properly with the parserx user I had set up. I kept receiving 1045: Access denied for user errors, despite following all the recommended configurations.

2. Performance Issues During API Requests:
   When running batch requests on the API for sig parsing, the database queries seemed slow, leading to timeout errors. I suspect the database isn’t optimized for high-volume queries, but I’m unsure how to address this.

3. Frontend-Backend Synchronization:
   Even after setting up the backend API, the front-end components failed to load parsed data consistently. This could be due to database misconfiguration or improperly seeded test data.

Given these challenges, I stumbled upon this guide for installing MySQL on Ubuntu 24.04]. The Vultr guide looks detailed and promising for resolving these issues, especially regarding database configuration and optimization on Ubuntu systems. Has anyone used this guide for similar setups? Should I go through it for a cleaner installation and better performance for my Django project?