There are a couple of commands that require passing a password as a parameter:

wp core config
wp core install

If the parameter is not passed, we should prompt for the password instead of just throwing an error.

This seems to be a common pattern. For an example, see the mysql command.