[mythtv-users] Can't grant remote permissions in mysql

[Nowhere]

Hi everyone. I need to bring this back up. I am still unable to grant
remote permissions and I am quite stumped now. I have tried fixing the
missing quote, tried single quotes but something is still wrong. Here is
the latest attempt and as you see it says OK but 0 rows affected.

mysql> grant all on mythconverg.* to mythtv@'192.168.1.%' identified by
'mythtv';
Query OK, 0 rows affected (0.00 sec)

Any clues?

(Thanks to Kirk for the original response a long time ago)...

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, 2.4.2x kernel, ivtv-0.1.9, myth 0.15.20040505.1

> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-
> bounces at mythtv.org] On Behalf Of Kirk Davis
> Sent: Sunday, May 09, 2004 11:58 AM
> To: 'Discussion about mythtv'
> Subject: RE: [mythtv-users] Can't grant remote permissions in mysql
> 
> Try using single quotes instead of the double quotes and I assume it
was
> just a copy past error but you missed a quote in from of the password.
> 
> ---- Kirk
> 
> -----Original Message-----
> From: Nowhere [mailto:nowhere at cox.net]
> Sent: May 4, 2004 11:42 PM
> To: mythtv-users at mythtv.org
> Subject: [mythtv-users] Can't grant remote permissions in mysql
> 
> 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).
> 
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users