[mythtv-users] Ver 31 frontend cannot connect to the database

Bill Meek keemllib at gmail.com
Tue Nov 24 01:25:53 UTC 2020

On 11/23/20 6:57 PM, Mike Carron wrote:
> I've gone over everything and I have to conclude that port 3306 on the
> backend being closed is the culprit. Since mythfrontend wants to use
> port 3306 to communicate with the backend I'm not going to get anywhere
> until port 3306 is opened. Unfortunately I do not know how to do that.
> How do I open port 3306?

The SQL server will open the port. The default is 3306.

Do this, command and output please:

  sudo grep --recursive --ignore "port.*=" /etc/mysql

I can't agree with your assumption though. Need the fresh
command and output of this:

  mysql --host= --user=mythtv --password=<from config.xml>

The reset time to live output of nmap is unusual:

3306/tcp closed mysql   reset ttl 64

I'm wondering if the SQL server is failing and restarting. Full output of

  systemctl status mysql # or mysqld or mariadb, I forgot which works for you


More information about the mythtv-users mailing list