[mythtv-users]Help needed -- cant run setup on Mandrake 9.1,
getting qt-MySQL error
Cedar McKay
cedarmckay at mac.com
Sun Jul 6 22:50:12 EDT 2003
> 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
More information about the mythtv-users
mailing list