MySQL clients ask for a password when the client program is invoked with the --password or -p option without the password value. The following is the command:
> mysql -u user_name -pEnter password:
On a few systems, it may happen that the password works fine when specified in an option file or on the command line. But it does not work when entered interactively on the Command Prompt at the Enter password: prompt. It occurs because the system-provided library to read the passwords limits the password values to a small number of characters (usually eight). It is an issue with the system library and not with MySQL. As a workaround to this, change the MySQL password to a value that is eight or fewer characters ...
