[mythtv-users] Android client can't login to mysql

[Stephen Worthington]

On Tue, 9 Aug 2022 17:28:50 -0400, you wrote:

>My Android mythfrontend client fails to login to mysql. I haven't used 
>it in a while, probably since the server updated to ubuntu 22.04. The 
>Linux remote client frontends are fine. What I see on the wire from 
>android is:
>
>14    1.023796    192.168.10.10 192.168.10.104    MySQL    161    Server 
>Greeting  proto=10 version=8.0.30-0ubuntu0.22.04.1
>
>16    1.025226    192.168.10.104 192.168.10.10    MySQL    232    Login 
>Request user=mythtv db=mythconverg
>
>18    1.025295    192.168.10.10 192.168.10.104    MySQL    114    Auth 
>Switch Request
>
>19    1.028374    192.168.10.104 192.168.10.10    TCP    66    48516 ? 
>3306 [FIN, ACK] Seq=167 Ack=144 Win=87616 Len=0 TSval=873179 
>TSecr=2776942670
>
>Compared with what I see from Linux
>
>42    12.653131    192.168.10.10 192.168.10.22    MySQL    161    Server 
>Greeting  proto=10 version=8.0.30-0ubuntu0.22.04.1
>
>44    12.656729    192.168.10.22 192.168.10.10    MySQL    102    Login 
>Request user=
>
>This succedes, the mysql is invisible after this because of encryption.
>
>So my guess is that the mysql server on 22.04 has some option turned on 
>that is forcing a secure login protocol that the android client doesn't 
>handle. Any idea what that is?

Is it real MySQL or MariaDB that you are running?  The do differ a bit
now and authentication is a place where they can be different.

You are correct, my recollection is that there was a change in the
default authentication a while ago, and a new method became the
default.  There was discussion here on the mailing list (or maybe the
developers' list), but I can not find it again at the moment.  The old
authentication used by MySQL is "mysql_native_password" and I think
you need to revert to that, or maybe just make the user name that your
Android device is using to revert to that.