[mythtv] [PATCH] MySQL Documentation Updates

[Ramon Redondo]

This patch adds two clarifications to the docs

1)  Adds the command the following command for updating MySQL to allow 
remote access:
 flush privileges;

2)  Adds an additional troubleshooting item to the 'MySQL not connecting 
correctly.

(by nice, this is my first patch)

-------------- next part --------------
? mysqldoc.diff
Index: mythtv-HOWTO.sgml
===================================================================
RCS file: /var/lib/mythcvs/mythtv/docs/mythtv-HOWTO.sgml,v
retrieving revision 1.220
diff -u -r1.220 mythtv-HOWTO.sgml
--- mythtv-HOWTO.sgml	27 Feb 2004 02:53:01 -0000	1.220
+++ mythtv-HOWTO.sgml	1 Mar 2004 21:32:03 -0000
@@ -1432,6 +1432,7 @@
 <tscreen><verb>
 $ mysql -u root mythconverg
 mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
+mysql> flush privileges;
 </verb></tscreen>
 
 For a more secure setup, you can restrict which machines or subnets have
@@ -1440,12 +1441,14 @@
 <tscreen><verb>
 $ mysql -u root mythconverg
 mysql> grant all on mythconverg.* to mythtv@"%.mydomain.com" identified by "mythtv";
+mysql> flush privileges;
 </verb></tscreen>
 
 Finally, if you just want to restrict by IP subnet:
 <tscreen><verb>
 $ mysql -u root mythconverg
 mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified by "mythtv";
+mysql> flush privileges;
 </verb></tscreen>
 
 <sect>Configuring Sound.
@@ -4541,7 +4544,9 @@
 <sect1>MySQL not connecting correctly.
 <p>Your <bf>MySQL</bf> installation may have networking turned off. 
 Check that <tt>/etc/mysql/my.cnf</tt> <em>does not</em> contain
-<tt>skip-networking</tt>.  If it does, remove it, and restart
+<tt>skip-networking</tt>.  If it does, remove it.  Also verify that 
+<tt>bind-address</tt> is set to your ip-address instead of 
+<tt>127.0.0.1</tt>.  If you change either of these items, restart 
 <bf>MySQL</bf>.
 <sect1>My screen goes black when I try to play something.
 <p>MythTV prints error and status messages to the shell that was used to