[mythtv-users] Need help with mysql syntax

[Craig Huff]

Finally got back to this [too busy doing more important things like
watching new shows ;-)].

I had tried the command as described by Karl (without the FLUSH PRIVILEGES,
BTW), but was thrown of by two things.  One, the password matched the one
for 'mythtv'@'%', and two, the command SQL system response of "Query OK, 0
rows affected (0.00 sec)" made me think that nothing changed.

This time, I made the password something entirely bogus, literally setting
it to be mythtv_pwd.  I got the same SQL response, but when I queried for
the values with the command:
        mysql> SELECT host, user, password FROM user;
I got different values reported for @'%' and @'localhost'.  When I put the
password value I actually wanted in place of mythtv_pwd and checked again,
the encrypted password values matched, so, I guess that 1) I got it set and
2) it didn't need setting in the first place.

Don't mind the noob.  Time to move along.  Sigh...

Thanks for the help.

--
Craig.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131009/0c98687d/attachment.html>