Vagina tightness

I am going to have sex for the first time with my boyfriend soon. I don’t wear tampons and he hasn’t fingered me before (bad experience). We have had sex once, which was really painful and I bled a lot. Is the vagina always tight or does it loosen overtime? How can I relax my vagina? Is it all in my head as well? Thanks in advance x