[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