The Guns N’ Roses bassist on meeting Sir Paul McCartney, and a life-changing encounter with Prince