[mythtv-users] Can't grant remote permissions in mysql
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.
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
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?
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
More information about the mythtv-users