How do you make music to open the door on Mythology Island?

You can get a reed pipe (Flute) from the Temple of Muses in the Grove of Temples (to the right of Main Street). You can also learn the song that lulls Cerberus : go to the statue of Euterpe in the temple.