Install the latest MySQL and improve security

The latest MySql Version now presently as of Oct 15, 2024 is 8.4.3 , which was released as an LTS (Long Term Support) version: 

These are the earlier issues 

8.4.2: Released on April 30, 2024, this is the latest LTS version. 

8.4.0: Released on April 30, 2024, this LTS release includes a default setting that rejects attempts to use a nonstandard key as a foreign key. 

 In general, MySQL 8.0 introduced several performance-enhancing features, such as:

Improved query optimizer   

Faster JSON handling   

Enhanced security features 

Better scalability and high availability options   

It is always a good practice to work on the latest versions for reasons of improved and optimized performance and security