[mythtv-users] Problem with myth database after configuring amarok database

Robin Hill myth at robinhill.me.uk
Sat Dec 16 22:50:29 UTC 2006


On Sat Dec 16, 2006 at 10:24:55PM +0000, j.robert.buchanan at comcast.net wrote:

> Hello,
> 
> I recently tried to install and configure amarok on my myth box. I never had any trouble with the mysql database before, but after set up all my recordings in myth have disappeared and mythbackend keeps quitting on me.
> 
> During the configuration for amarok I followed the
> instructions at
> 
> http://amarok.kde.org/amarokwiki/index.php/MySQL_HowTo#MySQL_Setup
> 
> for configuring amarok to use mysql.
> 
> I set this up using
> 
> $ mysql -p -u root
> CREATE DATABASE amarok;
> USE mysql;
> GRANT ALL ON amarok.* TO mythtv at localhost IDENTIFIED BY 'secret';
> FLUSH PRIVILEGES;
> quit;
> 
> Note that I used mythtv at localhost since there is no amarok at localhost on
> my myth box.
> 
> Long story short I don't seem to be able to build my music collection in
> amarok, but even worse than that when I start the mythtv frontend, all
> my previous recordings have disappeared and the mythbackend process
> keeps stopping on me.
> 
> What have I done wrong? How can I put things back the way they were? How
> should I be configuring amarok to use mysql without impacting
> mythconverg?
> 
From what you've said here, the most likely thing is that you've changed
the mysql password for your mythtv user (the GRANT command you used).
If you change the password in ~mythtv/.mythtv/mysql.txt to the 'secret'
value you used above, then it should all work again.

HTH,
        Robin
-- 
     ___        
    ( ' }     |       Robin Hill        <myth at robinhill.me.uk>  |
   / / )      | Little Jim says ....                            |
  // !!       |      "He fallen in de water !!"                 |
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20061216/76efcf79/attachment.pgp 


More information about the mythtv-users mailing list