<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Dec 11, 2021 at 1:18 PM Bill Meek <<a href="mailto:keemllib@gmail.com">keemllib@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">> SET GLOBAL validate_password.policy=LOW;<br>
> ALTER USER 'mythtv'@'%' IDENTIFIED BY 'mythtv';<br>
<br>
Try dot policy where I had an underscore. Fixed above.<br></blockquote><div><br></div><div>Still no luck </div></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div class="gmail_quote">mysql> SET GLOBAL validate_password.policy=LOW;</div><div class="gmail_quote">Query OK, 0 rows affected (0.00 sec)</div></blockquote><div class="gmail_quote"><br></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div class="gmail_quote">mysql> ALTER USER 'mythtv'@'%' IDENTIFIED BY 'mythtv';</div><div class="gmail_quote"><div>ERROR 1819 (HY000): Your password does not satisfy the current policy requirements </div></div></blockquote><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br>
Another stab at finding a .cnf file:<br>
<br>
sudo updatedb;sudo grep --recursive validate_password /etc/mysql $(locate ".cnf")<br></blockquote><div><br></div><div>unfortunately this also returns a null response.</div><div> <br></div><div>Digging for anything with password in it yields:</div></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div class="gmail_quote"><div>/etc/mysql/mysql.conf.d/mysqld.cnf:default_authentication_plugin= mysql_native_password</div></div></blockquote><div class="gmail_quote"><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
And, the Note just above here: <a href="https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html#option_mysqld_validate-password" rel="noreferrer" target="_blank">https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html#option_mysqld_validate-password</a><br>
may be of interest. Do you somehow have the validate_password plugin installed?<br>
<br>
When I do: SHOW PLUGINS, I don't have the validate_password one. The link in the Note above<br>
also mentions the validate_plugin being deprecated and replaces by a component of the same<br></blockquote><div><br></div><div>Here's my SHOW PLUGINS output - I don't see validate_password in there anywhere:</div>mysql> SHOW PLUGINS;<br>+---------------------------------+----------+--------------------+----------------+---------+<br>| Name | Status | Type | Library | License |<br>+---------------------------------+----------+--------------------+----------------+---------+<br>| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |<br>| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL |<br>| sha256_password | ACTIVE | AUTHENTICATION | NULL | GPL |<br>| caching_sha2_password | ACTIVE | AUTHENTICATION | NULL | GPL |<br>| sha2_cache_cleaner | ACTIVE | AUDIT | NULL | GPL |<br>| daemon_keyring_proxy_plugin | ACTIVE | DAEMON | NULL | GPL |<br>| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |<br>| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |<br>| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |<br>| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_CMP_PER_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_CMP_PER_INDEX_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_TEMP_TABLE_INFO | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_FT_DEFAULT_STOPWORD | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_FT_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_FT_BEING_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_FT_CONFIG | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_FT_INDEX_CACHE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_FT_INDEX_TABLE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_VIRTUAL | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_CACHED_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| INNODB_SESSION_TEMP_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |<br>| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |<br>| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |<br>| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL |<br>| TempTable | ACTIVE | STORAGE ENGINE | NULL | GPL |<br>| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |<br>| BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |<br>| FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL |<br>| ngram | ACTIVE | FTPARSER | NULL | GPL |<br>| mysqlx_cache_cleaner | ACTIVE | AUDIT | NULL | GPL |<br>| mysqlx | ACTIVE | DAEMON | NULL | GPL |<br>| auth_socket | ACTIVE | AUTHENTICATION | auth_socket.so | GPL |<br>+---------------------------------+----------+--------------------+----------------+---------+<br>46 rows in set (0.37 sec)<br><br><div> </div></div></div>