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...") |
|||
(3 intermediate revisions by the same user not shown) | |||
Line 4: | Line 4: | ||
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 18:29, 29 October 2023
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
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