No, the MRI scan is not painful, just loud. If you are claustrophobic the tech will put a towel over your eyes, and they will give you headphones to help with the loud noise.

If it is a scan with contrast, the only discomfort will be when they place a peripheral IV in your arm if you are not comfortable with needles.