Fix for XBMC MythTV script database connection failure after MythTV upgrade on (K)Ubuntu

November 24, 2007
mythtv

I don’t understand why the password for the mythtv MySQL database user is reset whenever the MythTV package is updated in Ubuntu (and it’s derivatives like Kubuntu). When this happens the Xbox Media Center (XBMC) fails to connect to the database. It’s somehow related to the password authentication mechanism that the MySQL libraries use on the XBox within XBMC. Here are the instructions from one of my older posts to get the XBMC MythTV script to be able to connect to the MythTV database again. These steps are performed on the MythTV server.

  1. Login to MySQL as the root user - mysql -u root -p
  2. SET PASSWORD for mythtv = OLD_PASSWORD('mythtv');

Use the appropriate password for the mythtv user - the default is mythtv.

comments powered by Disqus