[mythtv-users] [mythtv-commits] Ticket #9742: Mythtv-setup fails to create the initial database

[Michael T. Dean]

On 04/19/2011 03:12 PM, Michael T. Dean wrote:
> On 04/19/2011 02:58 PM, MythTV wrote:
>> #9742: Mythtv-setup fails to create the initial database
>>
>>    I have installed mythtv, and mysql. After creating the initial database,
>>    mythtv-setup can not find the tables it needs.
> We /think/ this is an issue with MySQL 5.5 (but don't know what's
> causing it, yet).  I'll try to install MySQL 5.5 and do some testing soon.

OK, it's definitely not a MySQL 5.5 issue.  I upgraded to MySQL 5.5 and 
was able to create an initial database using mythtv-setup from 
0.24-fixes and unstable.  I even tried 0.24-fixes from before the MySQL 
5.5 fixes (which went in on Apr 16), but still using MySQL 5.5, and it 
was still able to create the initial DB.  (Regardless, any user who has 
MySQL 5.5 /must/ install a version of MythTV that has MySQL 5.5 
support--0.24-fixes or unstable from Apr 17 or later.)

Therefore, it must be some problem caused by the configuration.  I'd 
like to see a MySQL my.cnf (usually, /etc/my.cnf or /etc/mysql/my.cnf) 
from a system that had this issue.

Thanks,
Mike