[mythtv-users]Help needed -- cant run setup on Mandrake
9.1,getting qt-MySQL error
Mike Miller
miller44 at optonline.net
Mon Jul 7 03:25:32 EDT 2003
Ok I FINALLY got it working, thanks to EVERYONE who helped, I think I
somehow messed up my mc.sql file by doing the wrong arrow one of the
times. Then I tried extracting just that file from the tar but that
didn't work. What did work was deleting the directory, unratting again,
./configure again, make, make install.
Im goin to bed now, im sure ill have some more problems tomorrow lol
Thanks again
-----Original Message-----
From: mythtv-users-bounces at snowman.net
[mailto:mythtv-users-bounces at snowman.net] On Behalf Of Cedar McKay
Sent: Monday, July 07, 2003 12:50 AM
To: Discussion about mythtv
Subject: Re: [mythtv-users]Help needed -- cant run setup on Mandrake
9.1,getting qt-MySQL error
> On Sunday, July 6, 2003, at 09:07 PM, Mike Miller wrote:
>
> Thanks, I think im getting somewhere lol
> Ok I did what you said, turns out I do not have a PW set, however when
> I
> did show databases, this is what came up
> +-----------+
> | Database |
> +-----------+
> | mysql |
> | test |
> +-----------+
> 2 rows in set (0.03 sec)
>
> could this be my problem?
ok, now we are getting somewhere. You do not have your myth database
installed. Since you don't have a password set, navigate to your
install directory then into the database directory. Then do:
$ mysql -u root < mc.sql
make sure the mc.sql you have was not destroyed by having a ">" instead
of a "<" in that command earlier. You can test this by doing
% less mc.sql
you should see a bunch of crap that you don't understand like this:
> CREATE DATABASE mythconverg;
> GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv";
>
> USE mythconverg;
>
> #
> # The version number of the database schema is set by the
> # first INSERT command after all tables have been created.
> #
>
> CREATE TABLE IF NOT EXISTS recordingprofiles
> (
> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
> name VARCHAR(128),
>
etc etc etc
that means your mc.sql file is good.
then check what databases you have as you did before. You want to see
"mythconverg" there. If you don't you have a problem.
best,
cedar
_______________________________________________
mythtv-users mailing list
mythtv-users at snowman.net
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users
More information about the mythtv-users
mailing list