How to link mysql with temporal v28 and java SDK

Community Support
,
1

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

2

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;

1 Like
3

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