Full disclosure. I have never upgraded a database. I have a MySQL Community that is not the latest @5.6.31 ( latest is 8 ?) to the paid, Enterprise version. We will ask Tech Support once purchase of Enterprise is fully approved... but really trying to find a clear upgrade path online has proven difficult. I'm a novice, so feel free to be very details in replies.
- Upgrade to 5.7. Follow all the steps there, including testing
- Test your code against 5.7.
- Then embark on upgrading from 5.7 to 8.0; it's more complex but still doable.