sourcefuse / loopback4-starter

Loopback 4 starter application. Multi-tenant architecture supported. Authentication, Authorization, Soft deletes, environment vars, Audit logs, included.
MIT License
159 stars 60 forks source link

need help with mysql db flow #117

Open Rajamalli opened 1 year ago

Rajamalli commented 1 year ago

Hello, I am trying to get it to work with MySql Server. I am stuck with migration and am getting error ifError got unwanted exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CASCADE; CREATE SCHEMA demo; GRANT ALL ON SCHEMA demo TO public; DROP SCHEMA IF' at line 1 I installed "loopback-connector-mysql" I installed "db-migrate-mysql" I modified .env to include connection information I also tried to execute by converting the sql script to mysql it still throws the same error Kindly help.