<p><br>
On Mar 21, 2012 10:25 AM, "Science Technician" <<a href="mailto:SCITECH2@combebank.kent.sch.uk">SCITECH2@combebank.kent.sch.uk</a>> wrote:<br>
><br>
> I really hope someone can help me with what is a stupid problem of my<br>
> own making.<br>
><br>
> I was looking to set a password for a recording group and have managed<br>
> to set the password for 'All Recordings'<br>
><br>
> What is now worse is that despite the fact that I always use the same<br>
> password across the MythTV system<br>
> I must have made a typo (possibly I had caps lock on) and having tried<br>
> over 20 possible variants have drawn a blank.<br>
><br>
> So I googled for a reset command and found<br>
><br>
> mysql -umythtv -p mythconverg -e 'SELECT * FROM recgrouppassword;'<br>
><br>
> But all I get is a request for a password which when I use the standard<br>
> password I set for the system is<br>
><br>
> ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using<br>
> password: YES)<br>
><br>
> I also found the following command to use with mysql:<br>
><br>
> delete recgrouppassword where recgroup = 'thenameofthegroupyouwanttoreset';<br>
><br>
> typing this just gives me a mysql Syntax error.<br>
><br>
> So my questions are<br>
><br>
> Is it likely the mysql password would be different to the root password<br>
> and is there any way to find out/reset it if that<br>
> is what is causing the first problem?</p>
<p>In my setup, the mysql password is different from the root password. However ~/.mythtv/mysql.txt contains the mysql password. I do not know if the sql statments above will work, but at least you should be able to log in to mysql.</p>
<p>><br>
> If it isn't that causing the first problem what is?<br>
><br>
> Am I completely misunderstanding the second command and if so what<br>
> should I be typing?<br>
><br>
> Is there an easy(ish) way to recover or rest the password?<br>
><br>
> Finally is there a place idiots like me can go to ask these sorts of<br>
> questions that is better than here.<br>
><br>
> The only saving grace is that I can still change the filter to any of<br>
> the other groups and see all the recordings<br>
> it is just somewhat of a pain.<br>
</p>