[mythtv-users] Problems with DB after installing MythDVD rpm

[ray cielencki]

At 16:04 11/12/2003, W Jason McMillon wrote:
>When I try to run mythbackend, I get this:
>
>Unable to read configuration file mysql.txt
>Unable to connect to database!
>Driver error was [1/-1]:
>QMYSQL3: Unable open database ''
>Database error was:
>No Database Selected

this is referring to the file that has all relevant info for connecting to 
your database, including hostname, username, password, and database name. 
its usually installed under
/usr/share/mythtv/mysql.txt or /usr/local/share/mythtv/mysql.txt
if you don't have that file, its available in the source at
mythtv/programs/mythfrontend/mysql.txt
though i suspect that its probably just a permissions issue since this file 
*should* be installed when you make install.

>I manually installed mythtv and successfully got it up
>and running.  I
>was having difficulty installing mythdvd so I used
>Thac's RPM.  However
>after installing the RPM, I was prompted to run:
>
>mysql -u mythtv -p <
>/usr/share/doc/mythdvd-0.12/dvddb/metadata.sql
>
>which would give me this error:
>
>ERROR 1045: Access denied for user: 'mythtv at localhost'
>(Using password:
>NO)
>
>I have no password for mysql, so i tried the same
>command without the
>-p
>to no avail.  I then ran:
>
>mysql -u root < metadata.sql
>
>which i got from the mythtv website.  I understand
>that the problems
>lies with the mysql usernames and passwords, but am
>too ignorant with
>mysql to fix it.  Any help to get my DB back so I can
>start using
>mythtv
>again would be greatly appreciated.
>
>thanks for your time,
>jason

your mythtv password is likely the default, found in the file mentioned 
above. i would encourage you to set up a mysql root password since much 
damage can be done by the root mysql user.

$ mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('specify_root_password_here') 
WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

/rayc