Knowledge map advanced must read: read how large-scale map data efficient storage and retrieval>>>

When MySQL creates a user (including password), it will prompt error 1372 (HY000): password hash should be a 41 digital hexadecimal number

Problem reason: the password you entered is clear text. This is not allowed

Solution: use Select password (‘the password you want to enter ‘); Find out the string corresponding to your password

Then use this string to replace your password in the create user command