SQL - Creating Database (5th video)

SQL
1

Hi guys.

I am new here and try to get a hang of SQL.

I am having troubles with the lesson is in the ‘creating database video’. I have loaded an run all the sql script, but I am not seeing any table under the databases. This makes it difficult for me to progress. Please assist.

image
image1802×945 347 KB

2

Have you tried clicking the refresh icon in the navigator (circular arrows on the right side of SCHEMAS) or restarting Workbench?

3

Dear Sam,

Yes I have. I think the problem is because challenges with executing the script from the databases I uploaded. I keep seeing the error below;

image
image1601×64 17.4 KB

Any idea on how to solve this?

4

Are you using a MySQL server older than 8.0 or MariaDB? If so, you could try to replace utf8mb4_0900_ai_ci by utf8mb4_general_ci.