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

Stephen Worthington stephen_agent at jsw.gen.nz
Wed Aug 10 04:24:24 UTC 2022

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    MySQL    161    Server 
>Greeting  proto=10 version=8.0.30-0ubuntu0.22.04.1
>16    1.025226    MySQL    232    Login 
>Request user=mythtv db=mythconverg
>18    1.025295    MySQL    114    Auth 
>Switch Request
>19    1.028374    TCP    66    48516 ? 
>3306 [FIN, ACK] Seq=167 Ack=144 Win=87616 Len=0 TSval=873179 
>Compared with what I see from Linux
>42    12.653131    MySQL    161    Server 
>Greeting  proto=10 version=8.0.30-0ubuntu0.22.04.1
>44    12.656729    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.

More information about the mythtv-users mailing list