By way of introduction, you have your own login keychain, which is where OS X stores your own passwords and your own certificates, your secure notes, and related — and that keychain has a password. The default password for your login keychain is your login password, but that's not a requirement.
There are cases I've encountered where a password change didn't (also) change the keychain password, and you had to use the old password to access the keychain and change the password there; here is a related support note.
Each separate login has its own keychain, with its own password, etc.
If the keychain password is not the login password for the target account, then the account or the keychain has a problem, and — if you cannot remember the old password — you will have to recreate the keychain using the Keychain Access tool. Here is the Keychain reset sequence.
Here is a very quick overview of the Keychain, from the developer documentation. (The developer documentation will get dense, but that particular section has a concise overview of what Keychain provides.)
And FWIW, reentering a password repeatedly is how you get locked out. With various security systems, that sort of repeated activity will potentially even lock you out if (when?) you do remember the correct password.