[mythtv-users] Mysql Wierd Behavior

[Matt White]

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"