# How to link mysql with temporal v28 and java SDK

**URL:** <https://community.temporal.io/t/how-to-link-mysql-with-temporal-v28-and-java-sdk/373>\
**Category:** Community Support\
**Tags:** java-sdk, mysql\
**Created:** [August 6, 2020, 5:33am UTC](https://community.temporal.io/t/how-to-link-mysql-with-temporal-v28-and-java-sdk/373 "2020-08-06T05:33:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![techFool](https://avatars.discourse-cdn.com/v4/letter/t/dbc845/32.png) [@techFool](https://community.temporal.io/u/techFool)\
**Post date:** [August 6, 2020, 5:33am UTC](https://community.temporal.io/t/how-to-link-mysql-with-temporal-v28-and-java-sdk/373/1 "2020-08-06T05:33:26Z")

</div>

Experts ,  
How can we link the mysql of local with the temporal. Where can we provide our db configurations. I placed my changes in docker-compose-mysql.yml like following  
environment:  
- “AUTO\_SETUP=true”  
- “DB=mysql”  
- “MYSQL\_USER=root”  
- “MYSQL\_PWD=admin”  
- “MYSQL\_SEEDS=mysql”  
- “DYNAMIC\_CONFIG\_FILE\_PATH=config/dynamicconfig/development.yaml”

but when i am trying to start the temporal server like “docker-compose -f docker-compose-mysql.yml up”. Following exception is showing

2020-08-06T05:31:08.646661Z 9 [Note] Access denied for user ‘root’@‘172.18.0.3’ (using password: YES)  
temporal\_1 | 2020/08/06 05:31:08 sql schema version compatibility check failed: unable to create SQL connection: Error 1045: Access denied for user ‘root’@‘172.18.0.3’ (using password: YES)

Where exactly can i place my sql config. The documentation is lagging all these info.

I am trying to add the Prometheus so that i can enable the Metrics so i am trying to link the mySQL

TIA

---

<div class="post-metadata">

**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.temporal.io/u/madhu)\
**Post date:** [August 6, 2020, 6:01am UTC](https://community.temporal.io/t/how-to-link-mysql-with-temporal-v28-and-java-sdk/373/2 "2020-08-06T06:01:53Z")

</div>

most likely this is a privilege issue in mysql ,i dont think its related to temporal per say!

can you try creating a user who can connect from any where, and try configuring that user in tempral.

> CREATE USER ‘username’@‘ **%’** IDENTIFIED BY ‘password’;  
> GRANT ALL PRIVILEGES ON _._ TO ‘username’@’%’ WITH GRANT OPTION;  
> FLUSH PRIVILEGES;

---

<div class="post-metadata">

**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.temporal.io/u/madhu)\
**Post date:** [September 11, 2020, 8:24am UTC](https://community.temporal.io/t/how-to-link-mysql-with-temporal-v28-and-java-sdk/373/3 "2020-09-11T08:24:11Z")

</div>

if your question was to how to point temporal to my own sql instance  
you will have to provide the host name in MYSQL\_SEEDS.  
not very intuitive name ,but that’s where you provide mysql host name