[mythtv-users] Help! MythTV Backend not starting

[jeff at lotussevencars.com]

I have set up and got working a standalone mythtv box.  In the process  
of trying to open up the access to the database for a second remote  
frontend, I have broken the primary backend and don't know how.

The mysql database is running:

● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled;  
vendor preset: enabled)
     Active: active (running) since Fri 2016-12-30 17:32:35 EST; 16h ago
    Process: 2531 ExecStartPost=/usr/share/mysql/mysql-systemd-start  
post (code=exited, status=0/SUCCESS)
    Process: 2527 ExecStartPre=/usr/share/mysql/mysql-systemd-start  
pre (code=exited, status=0/SUCCESS)
   Main PID: 2530 (mysqld)
     CGroup: /system.slice/mysql.service
             └─2530 /usr/sbin/mysqld

Dec 30 17:32:34 MythBuntu-Server systemd[1]: Starting MySQL Community  
Server...
Dec 30 17:32:35 MythBuntu-Server systemd[1]: Started MySQL Community Server.

The mythTV backend, however, is not
● mythtv-backend.service - MythTV Backend
     Loaded: loaded (/lib/systemd/system/mythtv-backend.service;  
enabled; vendor preset: enabled)
     Active: inactive (dead) (Result: exit-code) since Sat 2016-12-31  
09:40:24 EST; 14s ago
       Docs: https://www.mythtv.org/wiki/Mythbackend
    Process: 9026 ExecStart=/usr/bin/mythbackend --quiet --syslog  
local7 $ADDITIONAL_ARGS (code=exited, status=130)
   Main PID: 9026 (code=exited, status=130)

Dec 31 09:40:23 MythBuntu-Server systemd[1]: mythtv-backend.service:  
Unit entered failed state.
Dec 31 09:40:23 MythBuntu-Server systemd[1]: mythtv-backend.service:  
Failed with result 'exit-code'.
Dec 31 09:40:24 MythBuntu-Server systemd[1]: mythtv-backend.service:  
Service hold-off time over, scheduling restart.
Dec 31 09:40:24 MythBuntu-Server systemd[1]: Stopped MythTV Backend.
Dec 31 09:40:24 MythBuntu-Server systemd[1]: mythtv-backend.service:  
Start request repeated too quickly.
Dec 31 09:40:24 MythBuntu-Server systemd[1]: Failed to start MythTV Backend.

The database server settings are
Hostname 127.0.0.1
Port 3306
Database name mythconverg
User mythtv

I've tried disabling and enabling mysql service on ethernet interfaces  
from mythbuntu control center, but neither option resolves my problem.

Here are the results of journalctl -xe

-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit systemd-hostnamed.service has finished starting up.
-- 
-- The start-up result is done.
Dec 31 09:56:02 MythBuntu-Server sudo[2945]:     jeff : TTY=pts/0 ;  
PWD=/home/jeff ; USER=root ; COMMAND=/etc/init.d/mythtv-backend restart
Dec 31 09:56:02 MythBuntu-Server sudo[2945]: pam_unix(sudo:session):  
session opened for user root by jeff(uid=0)
Dec 31 09:56:02 MythBuntu-Server systemd[1]: Stopped MythTV Backend.
-- Subject: Unit mythtv-backend.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mythtv-backend.service has finished shutting down.
Dec 31 09:56:02 MythBuntu-Server systemd[1]: mythtv-backend.service:  
Start request repeated too quickly.
Dec 31 09:56:02 MythBuntu-Server systemd[1]: Failed to start MythTV Backend.
-- Subject: Unit mythtv-backend.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mythtv-backend.service has failed.
-- 
-- The result is failed.
Dec 31 09:56:02 MythBuntu-Server sudo[2945]: pam_unix(sudo:session):  
session closed for user root

It's possible that it may be a password problem.
I can get into mysql as root, using mysql -u root mythconverg -p
When I use the password embedded into the setup screen, and the  
command mysql -u mythtv mythconverg -p, I get password denied.

If this is the problem, how do I reset the password for mythconverg in  
the mysql database?

Thanks in advance.

Jeff