mytop

[ptez]

I am having some problem on my server since mysql will cause server over-loaded.

Then I found mytop from:
http://forums.cpanel.net/showthread.php?t=41138

and get it at:
http://jeremy.zawodny.com/mysql/mytop/

But after installation, while I try to run mytop,
I get:

Cannot connect to MySQL server. Please check the:

* database you specified "test" (default is "test")
* username you specified "root" (default is "root")
* password you specified "" (default is "")
* hostname you specified "localhost" (default is "localhost")
* port you specified "3306" (default is 3306)
* socket you specified "" (default is "")

The options my be specified on the command-line or in a ~/.mytop
config file. See the manual (perldoc mytop) for details.

Here's the exact error from DBI. It might help you debug:

Unknown database 'test'

Can anyone help?

[bmcgrail]

use vi or pico to create a file called /root/.mytop and add:

user=root
pass=
host=localhost
db=mysql
delay=5
port=3306
socket=
batchmode=0
header=1
color=1
idle=1

then run mytop as root again and it should work.