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

[Bill Meek]

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=192.168.0.222 --user=mythtv --password=<from config.xml>

The reset time to live output of nmap is unusual:

 PORT     STATE  SERVICE REASON
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

-- 
Bill