[mythtv-users] Mysql Wierd Behavior

[Aleaxander]

Matt White wrote:

> 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.

Thanks for the information!  I was in fact missing a set of quotes, and 
now that I've added them, everything is working fine.

-Alex