Ayesha reported,

The Prophet ﷺ used to stay with Zaynab bint Jahsh and drink honey at her place. So Hafsa and I agreed that whichever of us the Prophet ﷺ came to would say, "I smell a foul gum on you. Have you been eating gum resin?"He went in to one of us, and she said that to him.He replied, "No, I drank honey at Zaynab bint Jahsh's place, and I will never do it again."Then came the revelation, "Prophet, why do you forbid yourself what Allah has made lawful for you" [Tahrim 66:1] up to "If you two turn in repentance to Allah" [Tahrim 66:4], this last part addressed to Ayesha and Hafsa.In another narration, he added, "But you had sworn not to tell anyone about that."

Azami 13583

Sahih

عن عائشة

أن النبي ﷺ كان يمكث عند زينب ابنة جحش ويشرب عندها عسلا، فتواصيت أنا وحفصة أن أيتنا دخل عليهاالنبي ﷺ فلتقل: إني أجد فيك ريح مغافير، أكلت مغافير؟ فدخل على إحداهما، فقالت له ذلك، فقال: بل شربت عسلا عند زينب بنت جحش، ولن أعود له فنزلت: {يأيها النبي لم تحرم ما أحل الله لك} إلى {إن تتوبا إلى الله} لعائشة وحفصة. وفي رواية: وقد حلفت لا تخبري بذلك أحدا.

الأعظمي 13583صحيح
Contents
Reference
Commentary
Ayat
Collection
Jami al-Kamil
Book
Tafsir of the great Quran
Chapter
Tafsir of Surah Tahrim
Section
His saying, "O Prophet, why do you prohibit what Allah has made lawful for you, seeking the approval of your wives? And Allah is Forgiving and Merciful. Allah has already ordained for you the dissolution of your oaths. And Allah is your protector, and He is the Aleem, the Wise. And when the Prophet confided to one of his wives a statement, and when she informed another of it and Allah disclosed it to him, he made known part of it and avoided part. And when he informed her about it, she said, 'Who told you this?' He said, 'The Aleem informed me.'"
Numbering
Jami al-Kamil 13583 (2nd edition)
Azami 13583