Mytop

MySQL top, a bit outdated. Check Innotop

Configuration

In ~/.mytop

user=foo
# make it prompt?
# pass=s3cr37
host=localhost

FAQ

Unknown database 'test'

That's the default database, add to ~/.mytop

db=mysql

Connection error: port cannot be specified when host is localhost or embedded

* hostname you specified "localhost" (default is "localhost")
* port you specified "3306" (default is 3306)

Someone needs spanking. Simple fix in .mytop

host=127.0.0.1

(this is not a joke) or

socket=/var/run/mysqld/mysqld.sock

make mytop ask for password

mytop --prompt