Unable to Import the default Cacti database

[skv8995]

Hi,

I have installed Cacti 1.2.8 in Server 2019 Datacenter Edition
I have sucessfully create MYSQL database
I am facing an error when i try to import default cacti database
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqladmin --user=root --password cacti < C:\Apache2\Apache24\htdocs\cacti\cacti-1.2.8
Access is denied.

I looked for a solution and found that i need to disable MSQL strict mode incase it is enabled but I m unable to find my.ini file in MYSQL folder location (tried viewing the hidden files)

Can anyone help me regarding this?

Thanks!

[camerabob]

You are using the wrong command to import. That command just sets the password for the MYSQL admin.

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqladmin --user=root --password cacti

The correct syntax should be

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -u root cacti -p < C:\Apache2\Apache24\htdocs\cacti\cacti-1.2.8\cacti.sql

(At least that's the command in Linux...)

Between the two, you will need to create the cacti database and assign privileges:

# mysql -u root -p
Enter password: YOUR-PASSWORD-HERE <--****replace with your own password, of course****
MariaDB [(none)]> create database cacti;
MariaDB [(none)]> GRANT ALL ON cacti.* TO cacti@localhost IDENTIFIED BY 'cacti';
MariaDB [(none)]> GRANT SELECT ON mysql.time_zone_name TO cacti@localhost IDENTIFIED BY 'cacti';
MariaDB [(none)]> FLUSH privileges;
MariaDB [(none)]> quit;

[skv8995]

Thanks you! I successfully imported the default cacti database.

[camerabob]

Good to hear!