Some caveats and errors (but nothing horrible)

from 7.4 to 7.4.1 -> fatal error if you don’t define opcache user so be aware of that

Mysql 8 is using a new recommended auth and you should probably use it as well, however, prestashop will not like it.
When installing mysql 8 you can still use the new native auth and change prestashop users to use the old (sha2) password:

ALTER USER ‘user’@” IDENTIFIED WITH caching_sha2_password BY ‘xxxxxxx’;