Debian install mytop for monitoring mysql
This is very simple but ideally requires two steps:
apt-get install mytop
And then create a new file called nano ~/.mytop
which should contain the following snippet, adding your password where defined below:
user=root pass= host=localhost db= delay=5 port=3306 socket= batchmode=0 header=1 color=1 idle=1
Now when you run mytop
on the command line it should start showing something like: