[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