# IgnitionDemoV8 all\_databases.sql

**URL:** <https://forum.inductiveautomation.com/t/ignitiondemov8-all-databases-sql/39238>\
**Category:** Ignition\
**Created:** [September 30, 2020, 9:25pm UTC](https://forum.inductiveautomation.com/t/ignitiondemov8-all-databases-sql/39238 "2020-09-30T21:25:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jim\_lapratt](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\
**Post date:** [September 30, 2020, 9:25pm UTC](https://forum.inductiveautomation.com/t/ignitiondemov8-all-databases-sql/39238/1 "2020-09-30T21:25:45Z")

</div>

On a clean install of Ubuntu 18.04 and MYSQL 5.7.31 you can restore the “all\_databases.sql” file through workbench just fine.

On a clean install of Ubuntu 20.04 and MYSQL 8.0.21 you get:

* * *

Preparing…  
Importing all\_databases.sql…  
Finished executing script  
ERROR 3554 (HY000) at line 2266: Access to data dictionary table ‘mysql.index\_stats’ is rejected.  
Operation failed with exitcode 1

* * *

Demo downloaded here: [https://inductiveautomation.com/downloads/extra-material](https://inductiveautomation.com/downloads/extra-material)

---

<div class="post-metadata">

**Author:** ![Herbie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/herbie/32/65288_2.png) [@Herbie](https://forum.inductiveautomation.com/u/Herbie)\
**Post date:** [September 30, 2020, 11:19pm UTC](https://forum.inductiveautomation.com/t/ignitiondemov8-all-databases-sql/39238/2 "2020-09-30T23:19:43Z")

</div>

There were significant changes in MySQL 8 and this is likely causing you the problems you are seeing, particularly in the ‘mysql’ database. However, it also looks like they dumped “all databases” and should probably dump only the items they use in the demo. This is also true for users upgrading MariaDB from 10.3 to 10.4.

I was able to remove all lines from “CREATE DATABASE mysql” to just before where it started “CREATE DATABASE oil” and could get it to import all the tables ok. It’s a little tedious, but you should be successful.

---

<div class="post-metadata">

**Author:** ![jim\_lapratt](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\
**Post date:** [October 1, 2020, 12:32pm UTC](https://forum.inductiveautomation.com/t/ignitiondemov8-all-databases-sql/39238/3 "2020-10-01T12:32:24Z")

</div>

Oh ya that is what I did. I was just wanting IA to know, if they didn’t. I Don’t think it looks good if Demo is not working out of box. Permissions get whacked also if you just pick and choose lines throwing errors.

---

<div class="post-metadata">

**Author:** ![gopalsrini76](https://avatars.discourse-cdn.com/v4/letter/g/35a633/32.png) [@gopalsrini76](https://forum.inductiveautomation.com/u/gopalsrini76)\
**Post date:** [February 26, 2021, 3:28pm UTC](https://forum.inductiveautomation.com/t/ignitiondemov8-all-databases-sql/39238/4 "2021-02-26T15:28:39Z")

</div>

I too sail on the same boat. I have Mysql 8.0 and Ignition Demo for Version 8.0

Let me try to check the solution given by you.

---

<div class="post-metadata">

**Author:** ![Lalillo1](https://avatars.discourse-cdn.com/v4/letter/l/a6a055/32.png) [@Lalillo1](https://forum.inductiveautomation.com/u/Lalillo1)\
**Post date:** [May 4, 2022, 11:14pm UTC](https://forum.inductiveautomation.com/t/ignitiondemov8-all-databases-sql/39238/5 "2022-05-04T23:14:26Z")

</div>

> [@Herbie](#):
>
> rom “CREATE DATABAS

Can you please upgrade the new "all\_databases.sql" file which would work for "MySQL Workbenchv 8.0" ?