First time?

My SO and I have started getting more comfortable with each other and he asked if we could have sex sometime. We have been together for about a year and a half I'm just scared. Does it hurt? Or is it really painfull after? Please comment