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

Robert RobertCL at iname.com
Fri Aug 3 22:01:07 UTC 2007


Craig Huff wrote:
> 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'd say the line above is your problem.  It seems to say mythtv from 
192.168.1. and lots of N's.  Meaning it's probably denying access to 
logins from your local lan for the mythtv users

You _should_ be able to drop the mythtv user (but keep the mythconverg 
database) and recreate it.

I'm certainly no expert with mysql permissions, but I find that 
phpmyadmin makes it much easier than trying to get the right GRANT's 
typed in.


<insert standard disclaimer about backing up your databases before 
messing around, etc, etc>

> 
> 
> 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.

I would say that if you aren't sure what you are doing, you probably 
shouldn't drop the mysql database as that contains all you permissions. 
  I'm not sure how mysql would cope without it....  Of course it may be 
fine.


Robert.


More information about the mythtv-users mailing list