Unknown MySQL server host 'localhost' (0) after Remote Desktop Services installation

[Juan Sierra Pons]

Hi

I had a working 5.6.38 MySQL Community Server database installed on a windows Server 2016 standard OS.

It was working OK till the RDS service was installed. the RDS is used to manage licenses so more than 2 user can login using RDP.

After the RDS installation I cannot connect using ODBC to the localhost but I can connect to the 127.0.0.1. With the HeidiSQL client I get the same error:

Unknown MySQL server host 'localhost' (0)


If I use the native mysql client it works with both localhost and 127.0.0.1

telneting to the localhost or 127.0.0.1 on port 3306 is ok. the mysql daemon is listening on both.

Any Idea what is happening?

Thanks for your time

Best regards