#!/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"