Mucking about with the Greek Magical Papyri a bit. I don't have the lovely book
Hans Dieter Betz (ed.), The Greek Magical Papyri in Translation Including the Demotic Spells, Chicago: The University of Chicago Press, 1986, but various excerpts are available around on the web.
An ancient version of Viagra
xxxiii. To Get an Erection When You Want Grind up a Pepper with some Honey and coat your Thing. [PGM VII.186]Something I desperately needed at conferences and receptions
xxxi. To be Able to Drink a Lot and Not Get Drunk Eat a baked Pig's Lung. [PGM VII.181]Cure for Social Anxiety (presumably, you're too busy worrying about the crap on your face?)
For migraine (totally trying this one)
xxx. To Let Those Who Have Difficulty Intermingling
[i.e. Socializing] Perform Well Give Gum mixed with Wine and Honey to be smeared on the Face. [PGM VII.179-80]
xix. Spell for Migraine HeadacheA Contraceptive. I assume the operative principle is that you are so busy collecting everything and mixing it that you have no time for sex.
Take Oil in your Hands and utter the Spell: "Zeus sowed a Grape Seed: it parts the Soil; He does not sow it; it does not sprout." [PGM VII.199-201]
xxi. A Contraceptive, the Only One in the World
Take as many Bittervetch Seeds as you want for the Number of Years you wish to remain Sterile. Steep them in the Menses of a Menstruating Woman. Let them steep in her own Genitals. And take a Frog that is alive and throw the Bittervetch Seeds into its Mouth so that the Frog swallows them, and release the Frog alive at the place where you captured him. And take a Seed of Henbane, steep it in Mare's Milk; and take the Nasal Mucus of a Cow, with Grains of Barley, put these into a Leather Skin made from a Fawn and on the outside bind it up with Mulehide Skin, and attach it as an Amulet during the Waning of the Moon in a Female Sign of the Zodiac on a Day of Kronos or Hermes [i.e., Saturn or Mercury]. Mix in also, with the Barley Grains, Cerumen from the Ear of a Mule. [PGM XXXVI.320-32]