He is famous because he was mortal and a lover of the goddess Aphrodite ( and in Roman mythology , the lover of Venus ) . His major claim to fame in Greek mythology is that he was a mortal lover of the goddess Aphrodite ( and in Roman mythology , the lover of Venus ) .