[mythtv-users] Can't grant remote permissions in mysql
Nowhere
nowhere at cox.net
Wed May 5 01:42:09 EDT 2004
I am trying to grant access to the database from a remote system and
restrict by IP subnet. Here is what happens:
[mythtv at localhost mythtv]$ mysql -u root mythconverg -p
<typed in password>
mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified by
mythtv";
Query OK, 0 rows affected (0.10 sec)
You see I have 0 rows affected and flushing privs and trying to access
remotely results in failed connection to the database.
What am I doing wrong?
Thanks,
Eric
My MythBox:
Athlon XP 2000+, MSI K7N2GM-L, 512MB Kbyte, 80GB Seagate Single Platter,
2xPVR250 Coolmax CX300B Silent PSU, Coolermaster ATC-610BX1 Case, Fedora
Core 1, myth 0.14 no CVS (yet).
More information about the mythtv-users
mailing list