[mythtv-users] My MySql hell :-)

[Damian Surr]

I've checked every mysql.txt file on the system and they all have 
'mythtv' as the password.

I think I (or something) has screwed up the master mysql password and 
that's why I can't get in to it. I've followed tutorials to reset the 
password, but that hasn't worked. That's why I resorted to uninstalling 
mysql-server and putting it back, but the problem persists!

Damian

Jean-Marc Melchior wrote:
> the problem is, that Mythtv creates a text file with a random  
> password mysql besides the password you setup in mythtv-setup, I  
> don't remember exactly where it is located but its name is mysql.txt,  
> i think it is /etc/mythtv/mysql.txt if you edit that file and change  
> the password to your actual Mysql password then it should work...
> the edgy installation sets the password to mythtv, so usually you  
> just change user and password to mythtv, do the same mythtv-setup and  
> it should work
>
> JMM
>
> On 11 mars 07, at 19:05, Damian Surr wrote:
>
>   
>> I'm still getting nowhere with this.
>>
>> The last time I went through trying to instal mythtv, i the mysql
>> password was blank (enter), but it doesn't seem to be now.
>> I've tried everything to reset it (found a few different pages on it,
>> but nothing worked)
>> decided to remove mysql-server using synaptic package manager, then
>> reinstatl it. Still didn't seem to work.
>> Then tried taking everything away using synaptic
>> (mysql-sever, mythtv-frontend, mythtv-backend and mythtv-database)
>> rebooting
>> then putting them all back
>> after I did that, I got this error message
>> dpkg-reconfigure --force mythtv-database
>> dpkg: error processing mythtv-database (--configure):
>> subprocess post-instillation script returned error exit status 1
>> Errors were encounted while processing:
>> myth-database
>>
>> but I think that's still just to do with not being able to accesss the
>> mysql database.
>>
>> How the hell do I reset the mysql password in Edgy 6.10? I don't
>> remember changing it and it's not blank, 'mythtv' or any of my login
>> passwords. I'm close to formatting and starting again, please help.
>>
>> Damian
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>     
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070312/df2fbad3/attachment-0001.htm