A user must have a password to be able to connect to the database. Passwords cannot be more than 255 bytes in length, and cannot contain semicolons, leading spaces, or trailing spaces. Passwords are case sensitive.
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. It is recommended that the password be composed of 7-bit ASCII characters as other characters may not work correctly if the server cannot convert from the client's character set to UTF-8.