Mytop: Difference between revisions
From DWIKI
mNo edit summary Tag: wikieditor |
mNo edit summary Tag: wikieditor |
||
| (One intermediate revision by the same user not shown) | |||
| Line 7: | Line 7: | ||
# pass=s3cr37 | # pass=s3cr37 | ||
host=localhost | host=localhost | ||
==Minimal privileges required== | |||
grant select,usage,process on *.* to 'mytop'@'%' identified by 'mypassword'; | |||
=FAQ= | =FAQ= | ||
| Line 21: | Line 24: | ||
or | or | ||
socket=/var/run/mysqld/mysqld.sock | socket=/var/run/mysqld/mysqld.sock | ||
==make mytop ask for password== | |||
mytop --prompt | |||
Latest revision as of 10:41, 8 August 2025
MySQL top, a bit outdated. Check Innotop
Configuration
In ~/.mytop
user=foo # make it prompt? # pass=s3cr37 host=localhost
Minimal privileges required
grant select,usage,process on *.* to 'mytop'@'%' identified by 'mypassword';
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
