question

DavidAMADOU-9626 avatar image
0 Votes"
DavidAMADOU-9626 asked SaurabhSharma-msft commented

Can't connect to MySQL database using a specific user - Servername resolved to an unknow IP address

Hi,

I have the same issue here and don't know how to do. I use the service Azure Database for MySQL server.
My database is only on a private network.

I created a user and when I try to connect with it using the format username@servername, Keycloak (I use it for authentication), is giving me a NO with something unusual, the format username@IP. But the IP that is giving to me is not the IP address of the server !

The IP address of the server : 10.22.0.39
The IP I have : 10.22.0.42

I already checked, this IP don't exist at all.

141416-image.png




I don't understand from where this IP come from and I tried everything I can, nothing is working.
The strange thing is that I can connect with MySQL Workbench using this specific user. It's really using Keycloak that I have this resolving of my server name to the IP 10.22.0.39.

I put here the server name : ex-integration-db1

Hope there is nothing to do with characters or anything linked to it.

Any help would be appreciated.

azure-database-mysql
image.png (88.4 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @davidamadou-9626,
Thanks for using Microsoft Q&A !!
By looking at the error message it looks like authentication issue at Keycloak end. Did you check this IP if this is related to Keycloak server ?
141760-image.png

Thanks
Saurabh



0 Votes 0 ·
image.png (22.6 KiB)

Hi @davidamadou-9626,
We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh

0 Votes 0 ·

Hi @davidamadou-9626,
Please let me know if you still needs help on this issue.

Thanks
Saurabh

0 Votes 0 ·

0 Answers