Was unable to do the first option. Got this error
SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION'
MySQL said:
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation.
However, I fixed it by simply running a new installation and using the database I used in xampp development.
And also credentials, I copied the settings in the previous .env file and pasted it in the new one. And also product photos, I copied all of it from public/upload/all to the new corresponding file.
Hopes this solves someone's problem too