[mythtv-users] Mythbuntu upgrade error - mysql8
John Hoyt
john.hoyt at gmail.com
Sat Dec 11 19:32:30 UTC 2021
On Sat, Dec 11, 2021 at 1:18 PM Bill Meek <keemllib at gmail.com> wrote:
> > SET GLOBAL validate_password.policy=LOW;
> > ALTER USER 'mythtv'@'%' IDENTIFIED BY 'mythtv';
>
> Try dot policy where I had an underscore. Fixed above.
>
Still no luck
mysql> SET GLOBAL validate_password.policy=LOW;
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER USER 'mythtv'@'%' IDENTIFIED BY 'mythtv';
ERROR 1819 (HY000): Your password does not satisfy the current policy
requirements
> Another stab at finding a .cnf file:
>
> sudo updatedb;sudo grep --recursive validate_password /etc/mysql
> $(locate ".cnf")
>
unfortunately this also returns a null response.
Digging for anything with password in it yields:
/etc/mysql/mysql.conf.d/mysqld.cnf:default_authentication_plugin=
mysql_native_password
> And, the Note just above here:
> https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html#option_mysqld_validate-password
> may be of interest. Do you somehow have the validate_password plugin
> installed?
>
> When I do: SHOW PLUGINS, I don't have the validate_password one. The link
> in the Note above
> also mentions the validate_plugin being deprecated and replaces by a
> component of the same
>
Here's my SHOW PLUGINS output - I don't see validate_password in there
anywhere:
mysql> SHOW PLUGINS;
+---------------------------------+----------+--------------------+----------------+---------+
| Name | Status | Type | Library
| License |
+---------------------------------+----------+--------------------+----------------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL
| GPL |
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL
| GPL |
| sha256_password | ACTIVE | AUTHENTICATION | NULL
| GPL |
| caching_sha2_password | ACTIVE | AUTHENTICATION | NULL
| GPL |
| sha2_cache_cleaner | ACTIVE | AUDIT | NULL
| GPL |
| daemon_keyring_proxy_plugin | ACTIVE | DAEMON | NULL
| GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL
| GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL
| GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL
| GPL |
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_CMP_PER_INDEX | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_CMP_PER_INDEX_RESET | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_TEMP_TABLE_INFO | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_FT_DEFAULT_STOPWORD | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_FT_DELETED | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_FT_BEING_DELETED | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_FT_CONFIG | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_FT_INDEX_CACHE | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_FT_INDEX_TABLE | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_TABLES | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_VIRTUAL | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_CACHED_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| INNODB_SESSION_TEMP_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL
| GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL
| GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL
| GPL |
| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL
| GPL |
| TempTable | ACTIVE | STORAGE ENGINE | NULL
| GPL |
| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL
| GPL |
| BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL
| GPL |
| FEDERATED | DISABLED | STORAGE ENGINE | NULL
| GPL |
| ngram | ACTIVE | FTPARSER | NULL
| GPL |
| mysqlx_cache_cleaner | ACTIVE | AUDIT | NULL
| GPL |
| mysqlx | ACTIVE | DAEMON | NULL
| GPL |
| auth_socket | ACTIVE | AUTHENTICATION |
auth_socket.so | GPL |
+---------------------------------+----------+--------------------+----------------+---------+
46 rows in set (0.37 sec)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20211211/2f0a7473/attachment-0001.htm>
More information about the mythtv-users
mailing list