id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
9226	Error in section: Modifying access to the MySQL database for multiple systems	neal@…	Robert Kulagowski	"The section ""Modifying access to the MySQL database for multiple systems"" of ""Installing and using MythTV"" says to do the following:

  $ mysql -u root mythconverg
  mysql> grant all on mythconverg.* to mythtv@""192.168.1.%"" identified by ""mythtv"";
  mysql> flush privileges;

In my experience, that's only half the story.  One also needs to set the password.  I wanted it to be the same as for mythtv@localhost so I ran the following to get the encrypted password:

mysql> SHOW GRANTS FOR 'mythtv'@'localhost';
  +--------------------------------
  | Grants for mythtv@localhost                                                \
                                   |
  +--------------------------------
  | GRANT USAGE ON *.* TO 'mythtv'@'localhost' IDENTIFIED BY PASSWORD '*4B...' |
  | GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'localhost'            \
                                   |
  +--------------------------------

And then set copied it as follows:

  mysql> set password for 'mythtv'@'192.168.%.%' = '*4B...';
  Query OK, 0 rows affected (0.00 sec)
"	defect	closed	minor	unknown	Documentation	Unspecified	medium	Invalid			0