Install MRTG in Ubuntu
By: Onno W. Purbo

# apt-get install mrtg mrtg-contrib mrtg-ping-probe cfgstoragemaker checkservice cacti ap-utils




mysql
mysql> SET PASSWORD FOR root@localhost=PASSWORD('password');

alternatively

# mysql -u root -p
Enter password:
mysql> create database cacti;
mysql> grant INSERT,SELECT on root.* to cacti@localhost;
mysql> SET PASSWORD FOR cacti@localhost=PASSWORD('cacti');
mysql> grant CREATE, INSERT, SELECT, DELETE, UPDATE on cacti.* to cacti@localhost;
mysql> grant CREATE, INSERT, SELECT, DELETE, UPDATE on cacti.* to cacti;
mysql> exit