[mythtv-users] Advice on Partitions

[Jonno]

On Wed, Mar 4, 2009 at 7:33 AM,  <jarpublic at gmail.com> wrote:

> It says that the username and password were not set in mysql.txt.
> Usually there is a file with the mythtv login info located in
> /etc/mythtv/mysql.txt. Check if that file is there and if it has the
> correct information in it it. You can also try logging in from the
> command line like: 'mysql -u mythtv -p mythconverg'. That will prompt
> you for your mythtv mysql password. If you can log in from the command
> line. Then you just need to make sure that the same username and
> password are in the mysql.txt file.
>
> Also if they database is up and you can log int then you can use
> mythweb to see if there are problems with mysql. Open up mythweb and
> go to the settings page there is a database section. You can ask it to
> check the mythtv tables. You can also tell it to repair them if
> something minor got corrupt.

You're right. It looks like this file was replaced (see below). If my
actual database is still ok how would I find out the password? Or
alternatively how do I start over with the MySQL database without
reinstalling everything.

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=

# Set the following if you want to use something other than this
# machine's real hostname for identifying settings in the database.
# This is useful if your hostname changes often, as otherwise you
# will need to reconfigure mythtv (or futz with the DB) every time.
# TWO HOSTS MUST NOT USE THE SAME VALUE
#
#LocalHostName=my-unique-identifier-goes-here

# If you want your frontend to be able to wake your MySQL server
# using WakeOnLan, have a look at the following settings:
#
#
# The time the frontend waits (in seconds) between reconnect tries.
# This should be the rough time your MySQL server needs for startup
#
#WOLsqlReconnectWaitTime=0
#
#
# This is the number of retries to wake the MySQL server
# until the frontend gives up
#
#WOLsqlConnectRetry=5
#
#
# This is the command executed to wake your MySQL server.
#
#WOLsqlCommand=echo 'WOLsqlServerCommand not set'