Here is a link to the start up of my Mythtv Backend. It is not connecting to the database. There is the scrolling terminal window. Can some look at it and tell me what the issue is and possible fix?
lines 1-19/19 (END)...skipping...
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
Active: active (running) since Sun 2017-11-19 21:50:50 CST; 25min ago
Docs: man:systemd-sysv-generator(8)
CGroup: /system.slice/mysql.service
├─7760 /bin/bash /usr/bin/mysqld_safe
├─7904 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error --pid-file=/var/run/mysqld/mysqld.p
└─7905 logger -t mysqld -p daemon error
Nov 19 21:50:49 chuck-OptiPlex-9010 mysqld[7905]: 171119 21:50:49 [Note] InnoDB: 128 rollback segment(s) are active.
Nov 19 21:50:49 chuck-OptiPlex-9010 mysqld[7905]: 171119 21:50:49 [Note] InnoDB: Waiting for purge to start
Nov 19 21:50:49 chuck-OptiPlex-9010 mysqld[7905]: 171119 21:50:49 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1616867
Nov 19 21:50:49 chuck-OptiPlex-9010 mysqld[7905]: 171119 21:50:49 [Note] Plugin 'FEEDBACK' is disabled.
Nov 19 21:50:49 chuck-OptiPlex-9010 mysqld[7905]: 171119 21:50:49 [Note] Server socket created on IP: '127.0.0.1'.
Nov 19 21:50:50 chuck-OptiPlex-9010 mysqld[7905]: 171119 21:50:50 [Note] /usr/sbin/mysqld: ready for connections.
Nov 19 21:50:50 chuck-OptiPlex-9010 mysqld[7905]: Version: '10.0.31-MariaDB-0ubuntu0.16.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Ubuntu 16.04
Nov 19 21:50:50 chuck-OptiPlex-9010 mysql[7725]: ...done.
Nov 19 21:50:50 chuck-OptiPlex-9010 systemd[1]: Started LSB: Start and stop the mysql database server daemon.
Nov 19 21:50:50 chuck-OptiPlex-9010 /etc/mysql/debian-start[7953]: Upgrading MySQL tables if necessary.
Here is the running printout:
This was at the end.
LINE EDITING
These keys can be used to edit text being entered
on the "command line" at the bottom of the screen.
Cannot write to "ptiPlex-9010 /etc/mysql/debian-start[7953]: Upgrading MySQL tables if nece
-w ........ --hilite-unread
Highlight first new line after forward-screen.
-W ........ --HILITE-UNREAD
Highlight first new line after any forward movement.
-x [N[,...]] --tabs=[N[,...]]
Set tab stops.
-X ........ --no-init
Don't use termcap init/deinit strings.
-y [N] .... --max-forw-scroll=[N]
Forward scroll limit.
-z [N] .... --window=[N]
Set size of window.
-" [c[c]] . --quotes=[c[c]]
Set shell quote characters.
-~ ........ --tilde
Don't display tildes after end of file.
-# [N] .... --shift=[N]
Horizontal scroll amount (0 = one half screen width)
........ --no-keypad
Don't send termcap keypad init/deinit strings.
........ --follow-name
The F command changes files if the input file is renamed.
........ --use-backslash
Subsequent options use backslash as escape char.
---------------------------------------------------------------------------
LINE EDITING
These keys can be used to edit text being entered
on the "command line" at the bottom of the screen.
RightArrow ..................... ESC-l ... Move cursor right one character.
LeftArrow ...................... ESC-h ... Move cursor left one character.
ctrl-RightArrow ESC-RightArrow ESC-w ... Move cursor right one word.
HELP -- Press RETURN for more, or q when done
/var/log/mythtv/mythbackend.log
) would be more useful than a video capture of your screenAccess denied for user 'mythtv'@'localhost' (using password: YES)
- is the mysql server running (service mysql status
)? Can you log in to it from a terminal usingmysql -u mythtv -p mythconverg
with theDBPassword
that you should find in the/etc/mythtv/mysql.txt
file?