First or third person past tense, either is good.
As was already said, unless you're writing a choose your own adventure type thing, don't write in second person.
Similarly, unless you're doing experimental stream-of-consciousness stuff, don't write longer works in present/future tense.
The readers only know what my character know so it's more understandable for me to pull some plot point out of my ass that was never mentioned before just because the mc didn't know about it. I only switch to third person if I'm giving more of an infodump chapter for world building.
You can write in tight third person, and you can write in a non-tight first (e.g. if your narrator is specifically the MC in the future telling the story knowing how it ended. It's kind of a Victorian way of writing, but some modern authors have pulled it off - the first set of Amber books by Zelazny* are almost all tight first person but break that occasionally in ways that initially seem old fashioned but are explained internally if you get through to the end.
(* and for those who like western fantasy and
haven't read his stuff, the first 5 Chronicles of Amber books, Jack of Shadows, and Lord of Light are all "run, don't walk" works; the first two are also really great examples of how to use first person effectively.)