I installed MythTV on my existing kUbuntu 8.04 (Hardy Heron) desktop, but kept getting error messages about not being able to connect to the database. On looking more closely, I got messages like:
Access denied for user: 'root@localhost'
or
Access denied for user: 'mythtv@localhost'
I obtained some useful information from the following wiki guide, but it did not (yet) solve my problem:
https://help.ubuntu.com/community/My...roubleshooting
I finally realized the problem after hours. As you know, MythTV sets up a MySQL database to keep track of TV program listings and when to record, etc, and that was where my trouble was coming from. It turns out that I already had the music player program Amarok installed, and it had already set up a MySQL database, but not in a way compatible with MythTV. The solution was to remove Amarok, remove (and purge) the MySQL software, and then re-install MythTV, which would re-install MySQL in a way compatible with MythTV.
This can be done in Synaptic (or Adept) or in a terminal, as follows:
Code:
sudo apt-get remove amarok
sudo apt-get purge mysql-common
sudo apt-get install mythtv
The first command "
sudo apt-get remove amarok" removes Amarok but keeps the configuration files; substitute the name of any installed programs which you know depend on MySQL and for which you want to keep the configuration. If you forget to do this for any programs (or skip this step), things will still work, but when you re-install your Amarok or other programs, they will be like new installations and not retain any of your previous settings.
The second command "
sudo apt-get purge mysql-common" removes MySQL and removes any configuration files, so that when you re-install, you have a chance to set your own root password (or leave blank). It will also remove MythTV (which needs MySQL). The third command "
sudo apt-get install mythtv" does the actual reinstallation (re-installing MythTV will automatically re-install MySQL). If you removed Amarok or any other programs, you might want to re-install them with a fourth command "
sudo apt-get install amarok", etc.
I updated the info in the Ubuntu wiki guide given above, so now it should appear there.
This took hours of searching, and I would love to blame someone at Ubuntu for not properly setting up the MythTV package to detect when MySQL is not correctly set up, but right now I'm just glad that I have something working on MythTV.
Not sure if I should put this under "success stories" but I think it's specific to Ubuntu.
