Install Demo Project

Hello,

I tried to install the Demo Project following the instructions. But I got this error when I was Importing "all_databases.sql " in MySql.

ERROR 3554 (HY000) at line 2266: Access to data dictionary table ‘mysql.index_stats’ is rejected.

If someone could help me I would appreciate it.

Thanks.

Hi, having the same issue myself. I’ve tried to play with settings in MySQL Workbench to no avail. Were you able ot get it going? It would be helpful if Ignition could dump the DB as other blogs suggest so it will load…

Just figured it out… Go to commandline and enter something similar:
In my case I had to get to the MySQL Bin directory:
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql.exe --force --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=mysql --password=“adminpassword” < “Path to file\all_databases.sql”

After I did that, however, I could not log into the root, and tried all kinds of ways to reset the password. The next morning I realized all I needed to do was to install MySQL version 5.7 and try again.