error installation cacti on ubuntu 16.04

[boukaribadreddine]

Please guide me to add a feature that i didn't find it in the nagios Core 4.2.1 on Ubuntu LTS 16.04.

i installed nagios core succesfly to morinitor an Oracle database in a windows machine, i have to install cacti (and cacti -spine) on the same machine ubuntu 16.04
i have installed elements with apt-get install apache2 mysql-server-5.6 php libapache2-mod-php
also (apt-get install snmp snmpd rrdtool)
but when i try to install cacti with (apt-get install cacti cacti-spine), i get this error (it's related with mysql database i think !!)
"
Configuration de cacti
Une erreur s'est produite lors de la création de la base de données.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) "

i have follow this link to install cacti on Linux ubuntu 16.04 LTS : https://linoxide.com/ubuntu-how-to/inst ... ntu-16-04/
my objective in the end is to show the dashboards for my services in nagios. i like to add some feauture to display the dashboards for excelent view ( cacti tool for interface)
help me please.
thanks so much.

[netniV]

i think the problem is that the package install seems to doing this without specifying a root password. This when trying to import the database that is failing. Probably because you have a root password set after running the mysql_secure_installation script. The answer would be to temporarily allow root login without specifying a password and then make sure to remove that again later.

[boukaribadreddine]

thanks a lot, i have installed this with setting the root root password in a configuration file of cacti in the path /etc/mysql/debian.cnf
=======================================
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = root
password = root ======> it was no password, and i have set it manually
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = root
password = root ======> it was no password, and i have set it manually
socket = /var/run/mysqld/mysqld.sock
========================================

Just to help other people who have the same problem.
Thanks a lot.

[paulgevers]

thanks a lot, i have installed this with setting the root root password in a configuration file of cacti in the path /etc/mysql/debian.cnf
=======================================
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = root
password = root ======> it was no password, and i have set it manually
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = root
password = root ======> it was no password, and i have set it manually
socket = /var/run/mysqld/mysqld.sock
========================================


Just to help other people who have the same problem.
Thanks a lot.

But this is wrong. It should use the socket.

Was the database server running when you installed cacti?

[boukaribadreddine]

yes of course, my sql database was running during and after installation.