[mythtv-users] Help! MythTV Backend not starting

[Karl Newman]

On Sat, Dec 31, 2016 at 1:51 PM, <jeff at lotussevencars.com> wrote:

>
> Quoting Karl Newman <newmank1 at asme.org>:
>
> On Sat, Dec 31, 2016 at 11:52 AM, <jeff at lotussevencars.com> wrote:
>>
>
>
>> It's a change made in MySQL 5.7. The short answer is use
>> "authentication_string" instead of "password". See here:
>> http://stackoverflow.com/questions/30692812/mysql-user-db-
>> does-not-have-password-columns-installing-mysql-on-osx
>> Or even better, use the ALTER USER function. That appears to be the more
>> "approved" way of doing it and doesn't involve directly modifying the user
>> tables.
>>
>> Karl
>>
>
> Thanks - that moved me forward.  I was able to change the authentication
> string by following the instructions in your link, and it appears that my
> system is a little happier.  The mythbackend setup window no longer fails,
> and I'm back to my regular visual theme on the setup windows, implying that
> my system can access mysql.
>
> Starting mythbackend still gives me an error on connecting to the database
> (presumably a permission problem with accessing mythconverg?).  Is there a
> second password that I need to set before the backend can connect to the
> database?
>
> Search your system for config.xml. Depending on how your distro sets it
up, it might be in /etc/mythtv or (most commonly) /home/mythtv/.mythtv  (or
whatever user is starting mythbackend). Make sure you're using the correct
one and that the password in it matches what you set in mysql.

Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20161231/28f26db2/attachment.html>