✓ Solved

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)

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct