Can't create database in MySQLWorkbench

SQL
1

Following a tutorial and attempted to create database using a supplied file but it fails.

ignore the special word characters they don’t show up that way in MySQLWorkbech

Error Code: 1273. Unknown collation: ‘utf8mb4_0900_ai_ci’

CREATE TABLE offices ( office_id int(11) NOT NULL, address varchar(50) NOT NULL, city varchar(50) NOT NULL, state varchar(50) NOT NULL, PRIMARY KEY (office_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci Error Code: 1273. Unknown collation: ‘utf8mb4_0900_ai_ci’ 0.064 sec

1 Like
2

I had the same problem. It could be that the MySQL version is older.