[mythtv-users] moving database from FC4 to gentoo (mysql 4 to 5)

[David Campbell]

Brad Fuller wrote:
> 
> David Campbell wrote:
>> Brad Fuller wrote:
>>   
>>> Thanks David, that worked!
>>> However, if I go to mythtvsetup, none of the cards are setup. I've setup 
>>> several MythTVs, but never moved a database (always did it from scratch) 
>>> so this is new to me.
>>>
>>> I would have figured that mythtv-setup would have all the cards, 
>>> channels, etc filled in. I see that I have channel data, but no card or 
>>> input source data. Why would this be?
>>>     
>> Could it because the hostname of the server has changed?
>>   
> 
> Yep, now it almost works. User "root" works ok, but when I'm in user 
> "mythtv" I get a constant barrage of error messages that the host 
> (called 'killtivo') is not allowed to connect to the MySql server. I 
> looked in /etc/mysql/my.conf but I don't see anything out of the 
> ordinary. Probably need to add "killtivo" to some file somewhere!

Not quite.

in mysql

mysql>grant all on *.mythconverg to mythtv at localhost identified by 
'somepassword';

somepassword will be the value in mysql.txt

Dave