July 3, 2006
Using mytop to monitor your MySQL usage
Instructions for installing mytop along with additional perl modules.
I had an error message,
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’
Once I specified a database, any database on the server, mytop worked as expected. Here’s the command I used, mytop -d user_database




























