MySQL Problems

MySQL Password Fails When Entered Interactively

MySQL client programs prompt for a password when invoked with a –password or -p option that has no following password value:

shell> mysql -u user_name -p
Enter password:

On some systems, you may find that your password works when specified in an option file or on the command line, but not when you enter it interactively at the Enter password: prompt. This occurs when the library provided by the system to read passwords limits password values to a small number of characters (typically eight). To work around this, change your password to a value that is eight or fewer characters long.