ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number;

RPM installs version of MySQL 5.6

Problems encountered

1. The hint is in conflict with version 5.1. The solution is the rpm--FORCE-IVH rpm package. RPM for forced installation

2. After MySQL is started, the MySQL 5.6 version cannot be logged in with a blank password.

Workaround: When the MySQL 5.6 installation is complete, a random password will be generated and the password can be '/root/.mysql_secret '. Found in the. The first connection must change the password and only use the ' SET PASSWORD ' command

eg ' SET PASSWORD = ' your password ';

3. When using other statements, always prompt for ERROR 1820 (HY000): Must SET PASSWORD before executing this statement. It means that a password must be set first

and set the password when prompted by error 1372 (HY000): Password hash should be a 41-digit hexadecimal number;

This is because the password you entered is plaintext and is not allowed to be entered. You can use Select Password (' Password you want to enter ') on other terminals that have already installed MySQL, query the string that corresponds to your password, and replace your password with this string.

ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number;