/etc/mysql/conf.d/mythtv-tweaks.cnf: table_cache = 128

[James Sinton]

When running mysqld 5.7.12-0ubuntu1 on 16.04, the config file /etc/mysql/conf.d/mythtv-tweaks.cnf has a deprecated variable. As a result, mysqld fails to start, as seen from this error.log excerpt:

2016-04-27T01:05:43.561013Z 0 [ERROR] unknown variable 'table_cache=128'
2016-04-27T01:05:43.561034Z 0 [ERROR] Aborting

Commenting this variable out or replacing it with "table_open_cache = 128" fixes it.

[Richard Kershenbaum (richard-dblhouse)]

I had done a clean install of MythBuntu 16.04, bringing across the database and recordings from my old installation. Everything worked fine until I updated the installation using the MythTV fixes branch and Mythbuntu updates. When I rebooted, the backend failed to start.

[Mark Hamblin (5-mark-8)]

I to adapted the clean 16.04 build,.. and imported a 0.27 database,... everything went smoothly until I applied the SQL tweaks,.. and the pc rebooted,... SQL then failed to start...

Editing the mythtv-tweaks.cnf file fixed it for me,.. comment out the table_cache line and add table_open_cache.

You can confirm this is your error by looking in the /var/log/mysql/error.log,....

tx guys for the simple fix