[mythtv-users] mysql permissions problem (long lines of mysql data quoted)

[Craig Huff]

In trying to add a standalone FE to access my existing combined FE/BE, I have run into a snag.

I can't get the FE's mythtv user account to successfully access the mysql db on the BE.

I have probably bollixed up the GRANT ALL command to mysql and need help.

When I dump the contents of the database on the BE, I have to specify the mysql user as root in order to dump the mysql db, but not the mythconverg db.  I couldn't find anything in the mythconverg db dump associated with the GRANT ALL command, but found the following looooong lines in the mysql dump.  What I could use is instructions on what to tell mysql at the mysql command prompt to fix this.  Beware that you tell me if something must be upper case.  I think that's what got me in this mess to begin with because I didn't realize some of the syntax was case sensitive and I don't even know enough mysql syntax to know when I'm dangerous ;-)

Anyway, here are the snippets from the contents of the 'db' table in the 'mysql' db (linewraps and blank lines added):
('localhost','mythconverg','mythtv','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'),

('%','mythconverg','mythtv','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'),

('192.168.1.%','mythconverg','mythtv','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');



And here are the snippets from the contents of the 'user' table in the 'mysql' db (linewraps and blank lines added):
('localhost','root','0476fc026afffe24',
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
'','','','',0,0,0,0),

('penguin','root','0476fc026afffe24',
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
'','','','',0,0,0,0),

('penguin','','0476fc026afffe24',
'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N',
'','','','',0,0,0,0),

('localhost','','0476fc026afffe24',
'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N',
'','','','',0,0,0,0),

('localhost','mythtv','0476fc026afffe24',
'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N',
'','','','',0,0,0,0),

('%','mythtv','0476fc026afffe24',
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
'','','','',0,0,0,0),

('192.168.1.%','mythtv','0476fc026afffe24',
'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N',
'','','','',0,0,0,0);


I suppose I _might_ get away with deleting the mythtv entries in both tables in the dump and then dropping the mysql db and reloading from the dump, but I consider that _if even possible_ to be A) bad form, and B) risky.

FWIW, I am behind a firewall and this is not a high security setup, but since I _might_ someday like to be able to get in from "outside", it would probably be best to limit it to the 192.168.1.% subnet for now.  Given that, what is an _appropriate_ way to fix this?

Craig.




       
____________________________________________________________________________________
Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. 
http://answers.yahoo.com/dir/?link=list&sid=396545433