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.
3
Answers
If you don’t have a bunch of user accounts connecting to your database server, then you may be able to get away with one of the two following options:
Option 1 — Change the Password Policy
Your password policy is currently set to
MEDIUM
. You can easily change this toLOW
in order to handle easily-cracked passwords. In MySQL, as root (or an equivalent), execute this statement:Option 2 — Remove the Password Validation Module
This is very much a Rod-from-God approach, but it gets the job done for local environments:
In the event of an error, use:
I had the same problem with my students. We fixed this by creating the phpmyadmin user before installing phpmyadmin:
Then:
When prompted for the password, enter the password provided when creating the user (Phpmy@dm1n).
I found another solution here.
sudo mysql -p
mysql> UNINSTALL COMPONENT "file://component_validate_password";
mysql> exit
sudo apt install phpmyadmin
mysql> INSTALL COMPONENT "file://component_validate_password";