Test out the showerhead with your hand tightening first. If it still leaks, you may need to wrench on it a bit to seal things up.

Again, use the rag trick if your showerhead is shiny and you could scratch off the finish.

Be careful not to overtighten, as you could very easily damage the showerhead, shower arm, or plumbing within the shower wall.