Revit- MySQL link

It is not clear what you are trying to achieve.

The Dynamo graph is chopped off- but it looks like you are concatenating 3 SQL queries to create a database, create tables, & populate the tables with data from Revit/Dynamo

I would suggest breaking it down into separate steps that you can check (and understand) before trying to do everything in one go using Dynamo.

Using MySQL is also quite complicated and only necessary if you have gazillions of records. It would be much simpler to use SQLite- you just point it at a file rather than worrying about ports, authentication modes etc

The steps I would take are

  1. Create a database (Dynamo not needed, use Workbench)
  2. Create a test table in this database with just one column, and check you can connect to it with something simple like Excel
  3. Check you can connect to it from Dynamo using the same connection string and a simple SELECT FROM query
  4. Create one table, say Rooms (Dynamo not needed) and populate it with data from Dynamo INSERT INTO…
  5. Do the same for the other table (Specialty Equipment)
    and so on.

This way you will understand how it is working, and be able to determine where it is going wrong.

Andrew