Can't connect to DB (Mageia system)

[bill6502]

Let's concentrate on the: ss -n -o 'sport = :mysql' results. It suggests that MariaDB isn't running.

Does: systemctl status mysqld.service still show it running?

[wesnewell]

Leave the d off.

wes@mythfe0:~$ systemctl status mysql
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Fri 2019-10-11 23:56:20 CDT; 5 days ago

[blm-ubunet]

The OP early posts show database server running & user interacting via the cmd line.
MythTV logs show database server running initially & then disappearing

One possible explanation is that dB server crashes because of mythtv.

I would tail the systemd journal logs while starting backend or mythtv-setup from another terminal.

[bill6502]

@wesnewell, fun fact: the service likely has an Alias in the [Install] section.
Try: systemctl show --property=Names mariadb.service. It may be necessary
to disable/enable the service to create the symlinks though (I had to.)

@anp66, @blm-ubunet is spot on, and journalctl --unit mariadb limits the output to the service
of interest (Aliases don't work with journalctl.) Also, cat /var/log/mysql/error.log may have more
information.