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.
whats the exact solution for this issue. I has downloaded version 8.0 demo project from Inductive automation and trying to import the database.
I am using Mysql 8.0
So what is the final resolution for this?
I am getting similar error:
ERROR 3554 (HY000) at line 2266: Access to data dictionary table ‘mysql.index_stats’ is rejected.