[mythtv-users] Ubuntu/Mythbuntu update problem

[Thomas Mashos]

On Tue, May 22, 2012 at 10:07 AM, Damian <myth at surr.co.uk> wrote:
> On 20/05/2012 21:50, Thomas Mashos wrote:
>>
>> On Sun, May 20, 2012 at 1:41 PM, Damian<myth at surr.co.uk>  wrote:
>>>
>>> On 20/05/2012 21:16, Igor Cicimov wrote:
>>>>
>>>>
>>>> Didnt you say its a new database? Do you think mysql comes with myth
>>>> user by default?
>>>
>>>
>>>
>>> Hi Igor,
>>>
>>> I've installed the Mythbuntu OS, so with the whole system based around
>>> MythTV, yes I had assumed that everything would be set up by default.
>>>
>>> If I'm mistaken, can you enlighten me?
>>>
>>>
>>> Damian
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>
>>
>> The default root password for mysql on a Ubuntu system is the same
>> password you used during installation.
>>
>> I recommend using the provided utility to backup and restore the database.
>> http://www.mythtv.org/wiki/Database_Backup_and_Restore
>>
>> Since we're past that, did you try inserting the database using the
>> root user? You dropped the mythconverg database, so it sound like it
>> removed any permissions you would have with the mythtv user on it.
>> Since the mythtv user likely doesn't have permission to create a new
>> database you will need to either create one and give the mythtv user
>> permission, or use root to restore the database (and then give the
>> mythtv user access again)
>>
>> Thanks,
>>
>> Thomas Mashos
>
>
> Thanks for that Thomas,
>
> I used the 'root' user instead of 'mythtv' to restore the database and I
> think it all got restored ok.
>
> How can I add the 'mythtv' user now and grant required privileges?
>
> Thanks a lot,
> Damian

You'll want to take a look at
http://www.mythtv.org/wiki/Category:MySQL

Thanks,

Thomas Mashos