For users using the command line version of SFTP on unix or linux, if you have existing connections that use keys, and want to ignore your keys/keyfile for a connection (for password only), the following parameter will do it.
-o PubkeyAuthentication=no
example:
sftp -o PubkeyAuthentication=no myaccount@yourhost.com