Mykonos is a temperate place, so October is actually an excellent time to visit. It will be beautiful, but not as busy as during the summer tourist season.
The weather during October is pretty good. You should search to see when they have the most activities going on, so you can get the most out of your trip.