No subject
Wed Jun 24 15:02:31 UTC 2009
"To specify quoted values, quote database, table, column, and routine
names as identifiers, using backticks (=E2=80=9C`=E2=80=9D). Quote user nam=
es and host
names as identifiers or as strings, using either backticks (=E2=80=9C`=E2=
=80=9D),
single quotes (=E2=80=9C'=E2=80=9D), or double quotes (=E2=80=9C"=E2=80=9D)=
. Quote passwords as
strings, using single quotes. "
If using the same MySQL username for all MythTV clients, I would add
one wildcard rule based on IP, and another based on domain name. E.g.:
mysql> grant all on mythconverg.* to 'mythtv'@'192.168.5.%' identified
by 'mythtv';
mysql> grant all on mythconverg.* to 'mythtv'@'%.local' identified by 'myth=
tv';
Cheers,
Nick
--=20
Nick Morrott
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users
"An investment in knowledge always pays the best interest." - Benjamin Fran=
klin
More information about the mythtv-users
mailing list