Please make sure that the mysqld database service is started as given by Start System Services for Cacti.

By default, the mysql root password is not set. For security reasons, it is required to set a password for the MySQL root user

  shell> mysqladmin --user=root password somepassword
  shell> mysqladmin --user=root --password reload

Consult MySQL Documentation for details.