[mythtv-users] database access denied for user 'mythtv'@'localhost' (using password: YES)

[Fred Hamilton]

Hi,

I've got myth 0.28 working well on the latest xenial beta, except I have to
manually start mythbackend.  After that it's great.

I looked at the logs and it's clear that the system tries to start it on
boot about 8 or 9 times before it gives up.  Relevant errors are:

E CoreContext mythdbcon.cpp:229 (OpenDatabase) [DBManager0] Unable to
connect to database!

E CoreContext mythdbcon.cpp:230 (OpenDatabase) Driver error was
[1/1045]:#012QMYSQL: Unable to connect#012Database error was:#012Access
denied for user 'mythtv'@'localhost' (using password: YES)

So apparently I can launch it as user 'fred', but it can't connect to the
database as user 'mythtv'.

When I list users in mysql, I get:
mysql> SELECT user FROM mysql.user;
+------------------+
| user             |
+------------------+
| mythtv           |
| root             |
| root             |
| debian-sys-maint |
| mythtv           |
| root             |
+------------------+
6 rows in set (0.00 sec)

Is it normal to have 3 root and 2 mythtv users?

I imagine I need to change permissions somewhere or add (delete?) users
somewhere, but I'm at the end of my very limited understanding, so thought
I'd ask here before I start flailing.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160327/4c84381c/attachment.html>