Installation: use "1-click" installer to install mytop
OpenSuSe 11.1 - here
OpenSuSe 11.0 - here
Others: Download the latest version of mytop - here and follow the below instruction to compile and install mytop
tar -zxvf mytop-Using mytop:
You can directly use the mytop by typing “mytop” on your console screen initially you will get a message that “Unable to connect to Mysql” you will need to provide the host name, database name, username, password
To connect to the MySql database using Mytop you will need to give all your MySql details as a parameter:
-u - username of the database
-p - password for connecting to the database
-h - Host Name
-d - database name
Example: mytop -u root -p password -h localhost -d test
Instead of always using bulky command-line parameters, you can also use a config file in your home directory (~/.mytop). If present, mytop will read it automatically. It is read before any of your command-line arguments are processed, so your command-line arguments will override directives in the config file.
Here is a sample config file ~/.mytop which implements the defaults described above.
user=rootUsing a config file will help to ensure that your database password isn't visible to users on the command-line. Just make sure that the permissions on ~/.mytop are such that others cannot read it., now go to console and type command: # mytop and you should see something like ...