Is there anything that I could do for a little red sore spot in my mouth?

Watch it. Topical anesthetics for the mouth are over-the-counter -- they have a sticky, wax-like composition that allows them to stick to the moist surfaces. If the lesion is not gone in two weeks, have it seen.
Have it checked. Dentist should rule out any major problems and then give you proper solution.