[mythtv-users] Separate Frontends Wont Connect
Tortise
tortise at paradise.net.nz
Wed Aug 26 11:04:53 UTC 2009
> Looking around it seems
> http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2 might be what I need.
>
> I can log into sql using mysql -u mythtv -p mythconverg
> however commands such as
>
> mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified by
> "mythtv";
> give
> ERROR 1044 (42000): Access denied for user 'mythtv'@'localhost' to
> database 'mythconverg'
>
First place to look is the /etc/my.cnf file and see if it has a line in it
that restricts connections to localhost only with the following
bind-address = 127.0.0.1
If it does then put a '#' at the start of the line to comment it out and
restart mysql
Go from there...
--
Robin Gilks
Thanks Robin, found it (mythbuntu 9.04 JYA release) at
sudo pico /etc/mysql/my.cnf
Seemed a great idea, did not fix it though.
More information about the mythtv-users
mailing list