# Can't create database in MySQLWorkbench

**URL:** <https://forum.codewithmosh.com/t/cant-create-database-in-mysqlworkbench/10088>\
**Category:** SQL\
**Created:** [January 20, 2022, 5:51pm UTC](https://forum.codewithmosh.com/t/cant-create-database-in-mysqlworkbench/10088 "2022-01-20T17:51:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![daka2](https://avatars.discourse-cdn.com/v4/letter/d/22d042/32.png) [@daka2](https://forum.codewithmosh.com/u/daka2)\
**Post date:** [January 20, 2022, 5:51pm UTC](https://forum.codewithmosh.com/t/cant-create-database-in-mysqlworkbench/10088/1 "2022-01-20T17:51:45Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![evaldeslacasa](https://avatars.discourse-cdn.com/v4/letter/e/3e96dc/32.png) [@evaldeslacasa](https://forum.codewithmosh.com/u/evaldeslacasa)\
**Post date:** [November 23, 2022, 9:07pm UTC](https://forum.codewithmosh.com/t/cant-create-database-in-mysqlworkbench/10088/2 "2022-11-23T21:07:56Z")

</div>

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