Special characters in MySql Password [closed]

Question

Our app continues to have problem with MySql passwords. We would like to create a function to test for password validity before it is presented to the database.

Can anyone direct me to guidelines for MySql passwords involving these 2 topics:

1. password max length (hash is stored as 16 bit varchar which does not mean 16 is max length)
2. which punctuation / special characters can be used in a MySql password?

Answer 1

I'm using MariaDB 10.0.13 - the '\' character is a bit special. If defining a password using PASSWORD('text'), make sure to escape use of '\'.

Example: set password for user@localhost = PASSWORD('\\');

You can then use a single '\' for the password with mysql: mysql -u user --password='\'