[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