Error in section: Modifying access to the MySQL database for multiple systems

[neal@…]

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)

[anonymous]

Thanks for verifying I've done something wrong! Can you give me a clue as to what the right thing to do is?

Thanks,

Neal