Do more on the web, with a fast and secure browser!
Download Opera browser with:
@hebbex Thank you so much! This worked for me!
In my case, there were 3 different Opera Safe Storage entries, so deleted all of them and then signed back again into Opera account. Then I selected Sync everything and voila!
Unfortunately, yesterday I switched to Firefox and I must say the UX on that browser is leagues ahead. I will possibly not be using Opera anymore 
@DiZzy123 Sorry, I forgot to add the error. So when I open this url opera://sync-internals, I get the following error for password sync (every thing else syncs successfully)
Error: MergeSyncData@components/password_manager/core/browser/sync/password_sync_bridge.cc:590, datatype error was encountered: Failed to add an entry in the password store.
Same here. Everything syncs, except the password. I am gettting the following error in opera://Sync-Internals