[mythtv-users] Advice on Partitions

[jarpublic at gmail.com]

> jonno at jonno-mythbuntu:~$ cat /etc/mythtv/mysql.txt
> DBHostName=localhost
>
> # By default, Myth tries to ping the DB host to see if it exists.
> # If your DB host or network doesn't accept pings, set this to no:
> #
> DBHostPing=no
>
> DBUserName=
> DBPassword=
> DBName=
> DBType=
>

Sometimes there is a copy of this file stored elsewhere. Look in
~/.mythtv/mysql.txt. Or try 'locate mysql.txt' and see if you can find
a copy that has the password. Mythbuntu sets a random password by
default during install. If you can't track down the password you can
change it manually. There are instructions on this page on how to
manually change the mythtv user's password to 'mythtv':
http://www.mythtv.org/wiki/Category:MySQL. Lots of scripts have the
password set to 'mythtv' by default and it will be easy to remember
when you are settings other frontends up etc. As long as you don't
have mysql exposed outside of your network you shouldn't need to worry
about the security. This will require logging into mysql using the
mysql root user. Usually this the root mysql password is blank unless
you set it.

If that doesn't work, sometimes you can get things back on track by
using dpkg to re-setup the mythtv database, like this:

sudo dpkg-reconfigure mythtv-database
sudo dpkg-reconfigure mythtv-common

Just keep in mind that there are two usernames for the mysql server
'root' and 'mythtv'. The root user sets up the database and sets up
the mythtv user. Then mythbackend and mythfrontend log in as user
mythtv whenever they do anything with the database. Often people get
confused by which user or password is wanted when they are setting
these things up. When you get things sorted. You can test them out buy
making sure you can log in from the command line. If that works then
make sure you have the right credentials in /etc/mythtv/mysql.txt and
then you should be fine.