The Prophet ﷺ used to stay with Zaynab bint Jahsh and drink honey there. So Hafsa and I agreed that whichever of us the Prophet ﷺ came in to would say, "I smell maghafir gum on you. Have you been eating maghafir?"He went in to one of them, and she said this to him.He replied, "No, I drank honey at Zaynab bint Jahsh's, and I will never do it again."Then this was revealed, "Prophet, why do you forbid what Allah has made lawful for you, seeking to please your wives? And Allah is Forgiving, Merciful" [Tahrim 66:1], concerning Ayesha and Hafsa, and "And when the Prophet confided a matter to one of his wives" [Tahrim 66:3], concerning his words, "No, I drank honey."
أن النبي ﷺ كان يمكث عند زينب بنت جحش ويشرب عندها عسلا، فتواصيت أنا وحفصة أن أيتنا دخل عليها النبي ﷺ فلتقل: إني أجد فيك ريح مغافير، أكلت مغافير؟ فدخل على إحداهما، فقالت له ذلك، فقال: بل شربت عسلا عند زينب بنت جحش، ولن أعود له فنزلت: {يأيها النبي لم تحرم ما أحل الله لك تبتغي مرضات أزواجك والله غفور رحيم} [التحريم: ١] لعائشة وحفصة {وإذ أسر النبي إلى بعض أزوجه} [التحريم: ٣] لقوله بل شربت عسلا.
Bukhari related it in "Divorce" (5267), and Muslim in "Divorce" (20:1474), both through the route of Hajjaj bin Muhammad, from Ibn Jurayj, who said, Ataa claimed that he heard Ubayd bin Umayr say, I heard Ayesha, and he mentioned it.