PHPMyAdmin: ERROR 1819 (HY000) - Password does not satisfy the current policy requirements

Question

Firstly, please do not link me to any of these posts as I have already read them in their entirety and nothing helped:

• mysql cannot grant privilege to user, getting error: ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
• Your password does not satisfy the current policy requirements
• mysql - ERROR 1819 (HY000) Your password does not satisfy the current policy requirements

I keep getting the above error (in the title) when setting up or reconfiguring PHPMyAdmin on Ubuntu Server 20.04.

To be clear, this is the the terminal view when entering the password that prompts the error

And now the error itself

---

Here is the result when I run the following command:

SHOW VARIABLES LIKE 'validate_password%';

I enter the following password (obviously fake but still meets the password requirements above): JoeBloggs2018$

For my own sanity, a breakdown of the password:

• Length: 14 Chars
• Uppercase Count: 2 (Mixed Case = true)
• Number Count: 4
• Special Char Count: 1

This then results in the error which I do not understand. I didn't want to lower the password requirements however I did just for troubleshooting purposes and it still didn't work.

If anyone could help I would greatly appreciate it.

Answer 1

I had the same problem with my students. We fixed this by creating the phpmyadmin user before installing phpmyadmin:

CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED WITH 'caching_sha2_password' BY 'Phpmy@dm1n';
GRANT ALL PRIVILEGES ON phpmyadmin.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;

Then:

sudo apt install phpmyadmin

When prompted for the password, enter the password provided when creating the user (Phpmy@dm1n).