<html><head></head><body><span class="viv-signature"></span><div><font
face="monospace">On Saturday 28 October 2023 10:11:06 PM (-05:00), Stephen
Worthington wrote:</font></div><div><font
face="monospace"><br></font></div><div><font
face="monospace">...</font></div><div><font
face="monospace"><br></font></div><div><font face="monospace">> If
MariaDB is listening properly, my guess would be that the
problem<br></font></div><div><font face="monospace">> is that MariaDB
has been upgraded and some new option is causing<br></font></div><div><font
face="monospace">> problems. The sort of thing that comes to mind is
the method used to<br></font></div><div><font face="monospace">> encrypt
the login data. If it is now set to a method that MythTV
does<br></font></div><div><font face="monospace">> not support, that
could cause this problem. To see the method
being<br></font></div><div><font face="monospace">> used, run
this:<br></font></div><div><font face="monospace">>
<br></font></div><div><font face="monospace"><br></font></div><div><font
face="monospace">FYI.</font></div><div><font
face="monospace"><br></font></div><div><font face="monospace">I've tried
using caching_sha2_password on my MySQL server (so
far):</font></div><div><font face="monospace"><br></font></div><div><font
face="monospace">SELECT Host,User,plugin FROM user WHERE
User='mythtv';</font></div><div><font
face="monospace"><br></font></div><div><font face="monospace">I didn't
print the authentication_string because it messes up the output,
but</font></div><div><font face="monospace">this is working on my
production backend:</font></div><div><font
face="monospace"><br></font></div><div><div><font
face="monospace">+-----------+--------+-----------------------+</font></div><div><font
face="monospace">| Host | User |
plugin
|</font></div><div><font
face="monospace">+-----------+--------+-----------------------+</font></div><div><font
face="monospace">| % | mythtv |
caching_sha2_password |</font></div><div><font face="monospace">| localhost
| mythtv | caching_sha2_password |</font></div><div><font
face="monospace">+-----------+--------+-----------------------+</font></div></div><div><font
face="monospace"><br></font></div><div><font face="monospace">The "Note"
right at the beginning here:</font></div><div><font
face="monospace"><br></font></div><div><font
face="monospace"> https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html</font></div><div><font
face="monospace"><br></font></div><div><font
face="monospace">says:</font></div><div><font
face="monospace"><br></font></div><div><font face="monospace">
<font size="3"><span style="color: rgb(85, 85, 85); background-color:
rgb(239, 246, 254);">As of MySQL 8.0.34, the </span><code
style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px;
outline: 0px; vertical-align: baseline; background: rgb(239, 246, 254);"
class="literal">mysql_native_password</code><span style="color: rgb(85, 85,
85); background-color: rgb(239, 246, 254);"> authentication plugin is
deprecated and subject to removal in a future version of
MySQL.</span></font></font></div><div><span style="color: rgb(85, 85, 85);
background-color: rgb(239, 246, 254);"><font face="monospace"
size="3"><br></font></span></div><div><span style="color: rgb(85, 85, 85);
background-color: rgb(239, 246, 254);"><font face="monospace" size="3">I
haven't tried MariaDB yes.</font></span></div><div><span style="color:
rgb(85, 85, 85); font-size: 14.256px; background-color: rgb(239, 246,
254);"><font face="monospace"><br></font></span></div><span
class="viv-signature-below"><font
face="monospace">-- <br>Bill</font></span></body></html>