CODEWITHSUNDEEP
mysqlphpmyadminubuntu-20.04
jacc_01
jacc_01

Reputation: 360

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

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

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

enter image description here

And now the error itself

enter image description here

Here is the result when I run the following command:

SHOW VARIABLES LIKE 'validate_password%';

enter image description here

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

For my own sanity, a breakdown of the password:

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.

Upvotes: 18

Views: 20084

Answers (3)

Black
Black

Reputation: 20252

I found another solution here.

  1. Select 'abort'
  2. sudo mysql -p
  3. mysql> UNINSTALL COMPONENT "file://component_validate_password";
  4. mysql> exit
  5. sudo apt install phpmyadmin
  6. mysql> INSTALL COMPONENT "file://component_validate_password";

Upvotes: 6

Lluís Delgado
Lluís Delgado

Reputation: 456

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).

Upvotes: 44

matigo
matigo

Reputation: 1461

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 to LOW in order to handle easily-cracked passwords. In MySQL, as root (or an equivalent), execute this statement:

SET GLOBAL validate_password.policy=LOW;

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:

  1. Connect to the server as root
  2. Remove the plug-in: 
    UNINSTALL PLUGIN validate_password;
    In the event of an error, use: 
    UNINSTALL COMPONENT 'file://component_validate_password';
  3. Get on with your work

These solutions are not recommended for a production or Internet-accessible instance. Please don’t expose yourself to unnecessary risk.

Upvotes: 1

Related Questions