It's often used to describe plants or flowers that are a source of nectar for bees, but can also be used more broadly to refer to anything that produces a sweet substance resembling honey.
For example:
* "The melliferous clover fields attracted swarms of bees."
* "The author's writing was full of melliferous prose." (Here, "melliferous" is used figuratively to describe writing that is sweet and pleasing.)