[mythtv-users] Mysql startup issue

[Bill Meek]

On 06/11/2018 02:26 PM, Jack McGee wrote:
> mythuser at amethi:~$ cat /etc/mysql/my.cnf

...

> 
> !includedir /etc/mysql/conf.d/
> !includedir /etc/mysql/mysql.conf.d/
> 
> [mysqld]
> bind-address    = 192.168.1.105
> 
> 
> 
> where is it getting the 192.168.0.105 address?

Probably from your config.xml file(s.) See:

     https://www.mythtv.org/wiki/Config.xml#Troubleshooting

In the above my.cnf, everything after the 2nd includedir should be
removed.

Then in a file named (for example) /etc/mysql/mysql.conf.d/mythtv.cnf
add your all of your modification like this:

     [mysqld]
     bind-address=192.168.1.105

That way if a package manager changes /etc/mysql/my.cnf, your
change won't get overwritten.

Restart mysql.

-- 
Bill