Hi guys, Im facing multiple problems trying importing cacti.sql schema on my new datatabase.
I tested same command on my old mysql server (ver 5.6) and worked ok.
Now on my mysql server version 8.0.11 import script doesnt work.
First attempt was:
Code:
[
[email protected] cacti-1.1.38]$ mysql cacti -p < cacti.sql
Enter password:
ERROR 1231 (42000) at line 6: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
After that I tried commenting this line but other errors apeared.
Is there some way to solve this ?
Should I downgrade my mysql server ?
Any idea would be welcome.
Regards,
Leo.