Access Denied message when importing employee schema

Question

I am using a macbook. I've downloaded the employees.sql file but when I try to import the schema in to MySql workbench, I'm getting error message.

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Operation failed with exitcode 1

Can you help me resolve this.

Answer 1

Hi Tracy!
Thanks for reaching out.

Have you managed to successfully set up a connection first? We show how this can be done in this video:
https://learn.365datascience.com/courses/sql/setting-up-a-connection/

Please ensure to have set up a connection first and then try to run the given file.

Note - please make sure to have completed all lectures and exercises until you get to the section about loading the employees.sql file. Thank you!

Hope this helps.
Best,
Martin

Submit an answer