[mythtv-users] Mysql Wierd Behavior

[Rick Laity]

is it as simple as putting a semi-colon ; at the end of the command?



> Aleaxander wrote:
> > I'm trying to setup a remote frontend, so on the backend server I'm
> > trying to use the following commands:
> > 
> > $ mysql -u root -p mythconverg
> > mysql> grant all on mythconverg.* to mythtv@"10.0.1.%" identified by
> > "mythtv"; mysql> flush privileges; mysql> quit
> > 
> > However, when I actually enter:
> > mysql> grant all on mythconverg.* to mythtv@"10.0.1.%" identified by
> > "mythtv";
> > 
> > It just returns a this:
> >     ">
> > 
> > (note that this is an indented ">)
> > 
> > If at that point I try to do:
> >     "> flush privileges;
> > 
> > It just gives me another
> >     ">
> > 
> > The "quit" command doesn't work either, and I have to hit CTRL+c to
> > get out, at which point it says:
> >     ">Aborted
> > 
> > And I'm back to the $ prompt.
> > 
> > Anyone have an idea why Mysql would be behaving like this or what I
> > could have done to break it?
> 
> You've got an extra quote in there somewhere.  The "> prompt indicates
> that you're "inside" some quotes.  None of the following commands were
> interpreted as commands because Mysql figures they're part of a
> string...
> 
> Try it again, and count to make sure your quotes are balanced.
> 
> -- 
> Matt White                          whitem at arts.usask.ca
> Arts and Science Computer Labs      University of Saskatchewan
> 
> It sure is Monday... Ain't it a sin
> I've gotta work my way thru the week again.
>  - Mark Chesnutt..."Sure Is Monday"
> 
> 

Rick VE1GN
laity at nb.sympatico.ca