[mythtv-users] Error creating mythconverg databaseafterfresh.16install...

[Dave Johnson]

if you look at the sql commands being run, it looks like the "mythtv" user 
is first given all privs on the mythconverg.* tables, and then explicitedly 
given create temp table privs on it... not being an sql expert, i would only 
be guessing, but perhaps the create temp table privs on the db is a subset 
of "ALL" and hence the error ?  (some strict privs checking mode ?)

here is the code being ran...

[code]
CREATE DATABASE mythconverg;
GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv at localhost 
IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
[/code]

-=dave



>From: "Graham W. Mitchell" <gmitch at woodlea.com>
>Reply-To: Discussion about mythtv <mythtv-users at mythtv.org>
>To: "Discussion about mythtv" <mythtv-users at mythtv.org>
>Subject: RE: [mythtv-users] Error creating mythconverg 
>databaseafterfresh.16install...
>Date: Sat, 18 Sep 2004 15:02:07 -0400
>
>I am trying this on a fresh FC2 install too, and I am getting the same
>error.... I've had a dig about, but can't seem to find a solution.
>
>
>Graham
>
>-----Original Message-----
>From: mythtv-users-bounces at mythtv.org
>[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Nate Thompson
>Sent: Sunday, September 12, 2004 11:08 AM
>To: 'Discussion about mythtv'
>Subject: RE: [mythtv-users] Error creating mythconverg database
>afterfresh.16install...
>
>Sorry, I thought I had Outlook configured for plain text... Just did a
>fresh
>install of Outlook this weekend as I built a new PC for myself as well.
>I
>will let you know if I figure anything out.
>
>Nate
>
>-----Original Message-----
>From: mythtv-users-bounces at mythtv.org
>[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of William
>Sent: Sunday, September 12, 2004 10:09 AM
>To: 'Discussion about mythtv'
>Subject: RE: [mythtv-users] Error creating mythconverg database after
>fresh.16install...
>
><gripe>Please use text mode when posting to the list.</gripe>
>
><snip>
>I decided to format and install FC2 and .16 following Jarod's guide. I
>got
>through most of it without any serious issues (after upgrading the
>kernel
>and enabling the at.testing repo), but am having a problem when I go to
>create the database. Entering the line 'mysql -u root -p <
>/usr/share/doc/mythtv-0.16/database/mc.sql'  results in the following
>error
>message:
>ERROR 1064 at line 4: You have an error in your SQL syntax near
>'TEMPORARY
>TABLES ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv"' at
>line
>1
>Anyone have any thoughts as to what could be causing this error? I'm
>usually
>pretty good at working through these kind of issues, but it's getting
>late
>and I'm tired. :) Thanks, Nate Thompson </snip>
>
>I ran into the same problem. I just finished switching back to FC1 and
>was
>going to try again but the darn apt repository is down. Will try again
>once
>I can download some needed updates. Let me know if you fix it, I would
>rather use FC2.
>
>Bill
>
>
>
>
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to 
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement