#!/bin/bash
 
srvstatus=$(systemctl is-active mysqld)
if [[ "$srvstatus" != "active" ]]; then printf "\nMariaDB is not running on this server...\n\n"; exit ; fi ; printf "\n"
 
mysql -e "SELECT DB,USER,HOST,STATE FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY DB DESC;" ; printf "\n"