MySQL managed database password policy
What is the password policy for MySQL (Linode managed database)?
Where is it documented?
This happened:
MySQL [(none)]> create user 'aaa'@'%' identified by 'Qe2lm90f4b8fAIxXWFxNnX5yZ2xfGh9ibDhuCQHImPxESxRbhuPv1GUpIEeSLyI' require ssl;
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
2 Replies
✓ Best Answer
The password policy for our Managed MySQL Databases are the same as the default for MySQL. Their documentation shows the following requirements:
- The password must be a minimum length of 8 characters long and contain at least 1 of each of the following:
- 1 numeric character
- 1 lowercase character
- 1 uppercase character
- 1 special (nonalphanumeric) character.
It appears the password you shared is missing a nonalphanumeric character.
I have also passed along a suggestion that we include this requirement in our documentation in the future.
I fired up a new server and installed MySQL 8.0. The password was accepted, so Linode's setup is not the default.
(Debian 11, https://dev.mysql.com/get/mysql-apt-config_0.8.22-1_all.deb)