The Weather Out There Is Frightful

Our Sun is an active star. It may even be a variable star. Sunspots, flares, coronal mass ejections, all are signs of its activity. What kind of effect does it have on Earth? Other than the occasional sunburn, could it be dangerous? Has it been dangerous in the past? What can we expect in the near future?