Windows Client Connection

[Samuel Sum]

Dear all,

Actually, I am trying to install a MySQL client (HeidiSQL) to connect to an AWS MySQL - connection. However, I have found that the username will automatically append my public IP hostname.

It returns an error like :-
Connection has failed.
Access denied for user 'dbuser1'@'gw.mydomain.com' (using password: YES)

Even I have tried dbuser1@very_long_aws_hostname, but it returns the same result.

However, this problem will not appear in "MySQL Workbench" but prompt at any other clients like ToadEdge, HeidiSQL, etc. So, it proves that the username and password should be fine. I think it should be generic for the username / password parameters as "MySQL Workbench".

Should you any clues, please kindly share.

Thanks.
Sam