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

Kirk Davis Kirk.Davis at epsb.ca
Sun May 9 14:58:25 EDT 2004


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


More information about the mythtv-users mailing list