How to install MyTop on Lubuntu 17.10

MyTop is a command line tool for monitoring mysql database query, very handy if you want to see what's going on behind the scene on your mysql database server. In this article i will show you how to install and how to use mytop on lubuntu 17.10 artful.

How to install MyTop on Lubuntu 17.10

• open command line/terminal on your lubuntu, simply press CTRL + ALT + T
• run update command 

sudo apt-get update

• install mytop

sudo apt-get install mytop

• done!

How to use MyTop?

If you try to run mytop without any parameter, you probably get an error, if turns out mytop is working then must be you have mysql database that has no password whatsoever which is not safe in production.

In order to use mytop you need to specify username, hostname and password of mysql database you wish to access, just like when you use mysql client command line interface.

mytop -u [username] -h [hostname/ip] -p [password]

Example:

mytop -u root -h localhost -p abc123

mytop -u john -h 192.168.0.1 -p abcde