Error 1819 when setting up phpmyadmin on Nginx Ubuntu 20.04

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

dbconfig-common

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

mysql_secure_installation

option then?

Regards, KFSys

I got this issue on the process of phpmyadmin installation.

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 ‘validate_password%’; If it is, you will see something similar to below: ±-------------------------------------±------+ | Variable_name | Value | ±-------------------------------------±------+ | validate_password.check_user_name | ON | | validate_password.dictionary_file | | | validate_password.length | 6 | | validate_password.mixed_case_count | 1 | | validate_password.number_count | 1 | | validate_password.policy | LOW | | validate_password.special_char_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 validate_password component with command: UNINSTALL COMPONENT ‘file://component_validate_password’;

Step 3: Reinstall phpmyadmin.

Step 4: Install the validate_password component with command: INSTALL PLUGIN validate_password SONAME ‘validate_password.so’;