[mythtv-users] [mythtv] segfault in libmysqlclient.so.21

[Stephen Worthington]

On Tue, 16 Jun 2020 10:19:02 -0500, you wrote:


>The "crazy password" is the encrypted value of the real password.
>For example, if the password is mythtv:
>
>MariaDB [mythconverg]> SELECT PASSWORD('mythtv');
>+-------------------------------------------+
>| PASSWORD('mythtv')                        |
>+-------------------------------------------+
>| *CC8F35F587CA5A556B4132C2407E556D92172FFC |
>+-------------------------------------------+
>
>The above doesn't work in MySQL v8.

The password has to match the password in your config.xml file -
mythconverg_restore.pl defaults to looking there for a password to
access the database.  The password hashing is such that it should not
be reversible, so you can not retrieve the password from the database.
You can take the password in the config.xml file and generate a hashed
one from it using the PASSWORD() function and you can then see if that
hashed password matches the one in the database, as above.

Passwords and GRANTs are an area where MySQL and MariaDB now have some
differences.  As I have been using MariaDB for quite a few years, I am
not up to date with how MySQL is doing it.