MyTop is a great tool for monitoring mysql database, but it's not good if you have to enter username, password and hostname every time you want to use it. Is there a better way to do this? why can't we just run mytop without any parameter?
There is a solution for this problem, mytop is actually can read a config file, so basically you need to specify username, hostname and password inside this config file, then you can run mytop without any parameter at all.
The config file for mytop should be named mytop which is a hidden file and located at your home directory, so it would be ~/.mytop, whereas ~ is shorthand for home directory.
How to create Mytop config file
- open command line/terminal on lubuntu
- use leafpad to create the config file
-
leafpad ~/.mytop - enter this for the configuration
-
user=root
pass=
host=localhost
db=
delay=5
port=3306
slow=10
socket=
batchmode=0
header=1
color=1
idle=1
long=120 - save and exit leafpad
- run mytop to see if it's working or not
-
mytop - done!
0 comments:
Post a Comment