[mythtv-users] Problems with new setup???

[James Crow]

On Thu, 2008-10-16 at 12:45 +0100, David Watkins wrote:
<snip>
> > >>>>
> > >>>>
> > >>>>>> Afterwards I'm testing the DB - with this command:
> > >>>>>> # mysql -p -u mythtv
> > >>>>>> Enter password:
> > >>>>>> ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
> > >>>>>> password: YES)
> > >>>>>>
> > >>>>>>
> > >>>>>>
> > >>>>>>
> > >>>>> You need to get this working.
> > >>>>>
MySQL needs two grant statements. One for localhost and one for your
subnet.

mysql> GRANT ALL PRIVILEGES ON mythconverg.* to 'mythtv'@'172.16.20.%'
IDENTIFIED BY 'mypassword';

The second statement is identical except for the host portion

mysql> GRANT ALL PRIVILEGES ON mythconverg.* to 'mythtv'@'localhost'
IDENTIFIED BY 'mypassword';

Lastly you should flush privileges before attempting to connect.

mysql> FLUSH PRIVILEGES;

After that try connecting from localhost
bash$ mysql -h localhost -u mythtv -pmypassword mythconverg

If that works then try again from one of the FE machines but use -h <ip
of MySQL Box> instead of -h localhost on the command line.

Cheers,
James