@gingler None of the topics about it helped?
After have reset the passphrase in www.sync.opera.com, you go to opera://settings/syncSetup and change the passphrase or disable it.
By the way, if you have changed your Opera account password then it's possible that Sync is asking for the old one.