[mythtv-users] Ubuntu/Mythbuntu update problem

[Damian]

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