How to Configure MySQL on Linux for Cacti

Configure MySQL
Run these commands as root
cd /cacti-install
group-add cacti
useradd -g cacti cactiuser
/usr/local/mysql/bin/mysql
mysql> set password for root@localhost=password('rootpw');
mysql> create database cactidb;
mysql> grant all on cactidb.* to root;
mysql> grant all on cactidb.* to root@localhost;
mysql> grant all on cactidb.* to cactiuser;
mysql> grant all on cactidb.* to cactiuser@localhost;
mysql> set password for cactiuser@localhost=password('cactipw');
mysql> exit
MySQL Configure Script