[mythtv-users] Advice on Partitions

[Jonno]

On Wed, Mar 4, 2009 at 8:12 AM,  <jarpublic at gmail.com> wrote:
>> 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.

Thanks for all the help. I'll try some of this out later today.
Fingers crossed the mysql login is the only problem.

By the way, what is the point of the install setting a mysql password
for user mythtv if the root account doesn't have one?