Opera features an excellent password manager - Opera Wand, but provides no means to see saved password in Wand, I found myself into similar trouble and had to use a simple trick to recover saved password in Opera, we will be using the old school javascript trick to reveal hidden passwords in Opera.

1. Open the site you want to see saved password off in Opera.
2. Login using Wand button and press ESC key immediately, this will make Wand fill the password but stop auto-login so you stay on current page.
3. Follow hidden asterisk password reveal trick and you will have your password.