The most convenient way to setup your system to use mtop is to create a database user called mysqltop which has no password. For security pur‐
poses, this user should have all privileges set to N except Process_priv which must be set to Y.
To grant these privileges, execute the following from the MySQL command prompt
For mysql 4.0.2 and greater:
mysql> grant super, reload, process on *.* to mysqltop;
mysql> grant super, reload, process on *.* to mysqltop@localhost;
mysql> flush privileges;
The installer still fails on hardy!
From the man file:
The most convenient way to setup your system to use mtop is to create a database user called mysqltop which has no password. For security pur‐
poses, this user should have all privileges set to N except Process_priv which must be set to Y.
To grant these privileges, execute the following from the MySQL command prompt
For mysql 4.0.2 and greater:
mysql> grant super, reload, process on *.* to mysqltop;
mysql> grant super, reload, process on *.* to mysqltop@localhost;
mysql> flush privileges;