[mythtv-users] Mysql Wierd Behavior

[Aleaxander]

No, it was the extra quote.  I got it working.  Thanks for the reply though!

-Alex

Rick Laity wrote:

> 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
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users