Mytop: Difference between revisions
From DWIKI
(Created page with "MySQL top =Configuration= In ~/.mytop user=foo #make it prompt? # pass=s3cr37 host=localhost =FAQ= ==Unknown database 'test'== That's the default database, add to ~/.mytop...") |
mNo edit summary |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
MySQL top | MySQL top, a bit outdated. Check [[Innotop]] | ||
=Configuration= | =Configuration= | ||
In ~/.mytop | In ~/.mytop | ||
user=foo | user=foo | ||
#make it prompt? | # make it prompt? | ||
# pass=s3cr37 | # pass=s3cr37 | ||
host=localhost | host=localhost | ||
| Line 12: | Line 12: | ||
That's the default database, add to ~/.mytop | That's the default database, add to ~/.mytop | ||
db=mysql | 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 | |||
Latest revision as of 14:32, 18 November 2024
MySQL top, a bit outdated. Check Innotop
Configuration
In ~/.mytop
user=foo # make it prompt? # pass=s3cr37 host=localhost
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
