Error 1819 when setting up phpmyadmin on Nginx Ubuntu 20.04

Posted November 1, 2020 2.2k views
MySQLPHPLEMPUbuntu 18.04

As I was following this tutorial, I immediately got an error after this step in the first paragraph:

*Next, you’ll be prompted whether to use dbconfig-common for configuring the application database. Select Yes. *

This is the error:

mysql said: ERROR 1819 (HY000) at line 1: Your password does not satisfy the current policy requirements. 

I find this quite odd, since I didn’t even enter a password yet. I think maybe this has something to do with me installing on Ubuntu 20.04 and not 18.04.

Any word of advice on how to proceed?

1 comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
3 answers

Hi @katovonkatz,

It’s okay to use it on both Ubuntu 20.04 and 18.04. Having said that, can you let me know if this message appeared right after you ran the command


One other thing, before following this tutorial I take it you’ve had MySQL installed, did you run the


option then?


I got this issue on the process of phpmyadmin installation.

  • hey im currently facing the same issue! were u able to fix it?

    • Besides @KFSys giving me great instructions, I decided to quit this configuration. I tried this several times, including a couple of times of completely re-installing the web server and doing quite some troubleshooting on the existing web server.

      The conclusion of my inquiries is eventually that Nginx can better be installed with other applications than phpmyadmin. The combination of Nginx with MongoDB and NoSQL makes more sense.

      @KFSys, what do you think? Would you agree?

      • Hi @katovonkatz,

        As long as it works for your situation and application, you can use anything even more so if it’s convenient for you to use it.

        I’ve used Nginx with MongoDB and I can say I was impressed and it felt right so, I do agree using it!

A quick and incorrect solution is to remove MYSQL password validation, install phpmyadmin, then install password validation.

Step 1: Log into MYSQL as root and verify it’s installed with command: SHOW VARIABLES LIKE ‘validatepassword%’; If it is, you will see something similar to below:
| Variablename | Value |
| validatepassword.checkusername | ON |
| validate
password.dictionaryfile | |
| validate
password.length | 6 |
| validatepassword.mixedcasecount | 1 |
| validate
password.numbercount | 1 |
| validate
password.policy | LOW |
| validatepassword.specialchar_count | 1 |

*Note - You may wish to copy this output so you can reconfigure the component when you reinstall it in step 4.

Step 2: Uninstall the validatepassword component with command: UNINSTALL COMPONENT 'file://componentvalidate_password’;

Step 3: Reinstall phpmyadmin.

Step 4: Install the validatepassword component with command: INSTALL PLUGIN validatepassword SONAME '’;