# Error configuring mysql with keycloak 20.0.3?

**URL:** <https://forum.keycloak.org/t/error-configuring-mysql-with-keycloak-20-0-3/20030>\
**Category:** Configuring the server\
**Created:** [February 3, 2023, 8:50am UTC](https://forum.keycloak.org/t/error-configuring-mysql-with-keycloak-20-0-3/20030 "2023-02-03T08:50:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![coolrb](https://yyz2.discourse-cdn.com/free1/user_avatar/forum.keycloak.org/coolrb/32/7616_2.png) [@coolrb](https://forum.keycloak.org/u/coolrb)\
**Post date:** [February 3, 2023, 8:50am UTC](https://forum.keycloak.org/t/error-configuring-mysql-with-keycloak-20-0-3/20030/1 "2023-02-03T08:50:05Z")

</div>

Hello Group, I am new to keycloak and just following steps mentioned in the configuration to setup with mysql. I am using keycloak v 20.0.3 and mysql v 15.1

> > bin/kc.sh build --db=mysql - works fine  
> > bin/kc.sh start-dev --db mysql --db-url-host 127.0.0.1 --db-username keycloak --db-password xxxx - Generates following error  
> > 2023-02-03 08:47:30,434 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: liquibase.exception.MigrationFailedException: Migration failed for change set META-INF/jpa-changelog-1.2.0.Beta1.xml::1.2.0.Beta1::psilva@redhat.com:  
> > Reason: liquibase.exception.DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ’ NAME VARCHAR(255) NOT NULL)’ at line 1 [Failed SQL: (1064) CREATE TABLE PROTOCOL\_MAPPER\_CONFIG (PROTOCOL\_MAPPER\_ID VARCHAR(36) NOT NULL, VALUE CLOB, NAME VARCHAR(255) NOT NULL)]

Can anybody help me?