[mythtv-users] mythtv-backend service stops

[Bill Meek]

On 11/16/2014 12:08 AM, Roger Searle wrote:
...
> Thanks - progress.  I can confirm there were no such options being passed, --nologserver was not present, subsequent starting of the backend via
> CLI as below now reveals I have a mysql issue. mysql service is running, and netstat -tan shows 127.0.0.1:3306 LISTEN. Do I need to reset
> permissions on the database? I can do a "mysql -u root -p" but what would the command be to give access to the mythtv user?

Try connecting to the DB as the same user that mythbackend uses. It should
appear in ~mythtv/.mythtv/config.xml and is likely 'mythtv', not 'root'.

...
> Would you like to configure the database connection now? [no] 2014-11-17 05:57:48.786477 E  Unable to connect to database!
> 2014-11-17 05:57:48.786493 E  Driver error was [1/2003]:
> QMYSQL: Unable to connect
> Database error was:
> Can't connect to MySQL server on '192.168.1.200' (111)

A BE should use a hostname of 'localhost' or 127.0.0.1 for DB access because then a
socket will be used rather than TCP, which should be faster. A remote FE would use
the hostname of the BE.

-- 
Bill