A user must have a password to be able to connect to the database. Passwords are case sensitive and they cannot:

• begin with white space, single quotes, or double quotes
• end with white space
• contain semicolons
• be longer than 255 bytes in length

When passwords are created or changed, they are converted to UTF-8 before being hashed and stored in the database. If the database is unloaded and reloaded into a database with a different character set, existing passwords continue to work. If the server cannot convert from the client's character set to UTF-8, then it is recommended that the password be composed of 7-bit ASCII characters as other characters may not work correctly.