Opened 9 years ago

Closed 9 years ago

Last modified 9 years ago

#9226 closed defect (Invalid)

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

Reported by: neal@… Owned by: Robert Kulagowski
Priority: minor Milestone: unknown
Component: Documentation Version: Unspecified
Severity: medium Keywords:
Cc: Ticket locked: no

Description

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)

Change History (2)

comment:1 Changed 9 years ago by robertm

Resolution: Invalid
Status: newclosed

comment:2 Changed 9 years ago by 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

Note: See TracTickets for help on using tickets.