Execute failed: Access denied for user 'sql7765752'@'46.21.188.41' (using password: YES)

Hello everyone,
I’m new to KNIME and I’m trying to connect to a FreeSQLDatabase MySQL server. However, I keep getting the following error:

Access denied for user ‘sql7765752’@‘46.21.188.41’ (using password: YES)

I followed the standard procedure:

  • I used sql7.freesqldatabase.com as the hostname.
  • I entered the correct username and password.
  • I set port 3306 as required.

However, the strange thing is that only I am experiencing this issue. Some of my friends tried the same credentials on the same Wi-Fi, following the same steps, and it worked for them.

Could this be related to a specific setting in my KNIME installation? Or maybe my computer?

Thanks in advance :woozy_face:

It seems the account in MySQL is not allowed to connect from this IP address.

1 Like

Hi Thor, thank you for your answer.
Is it even possible in this case? Shouldn’t the SQL be “free”? I didn’t think there would be any restrictions.
Thank you for your time

Not sure what you mean. In MySQL when you create an account, the administrator can restrict access to certain databases and client IP addresses. The latter seems to be the case. This is something your database administrator should be able to answer or fix.

3 Likes

Your user account can only connect MySQL through the localhost (local system) or any other IP(s) associated to that user but not yours.

The above issue is related to MySQL. Please follow the solution below to make it work (if you are also a DB administrator or trying to learn and have admin privilege also replace IP address in the example with the public IP address of the system that is trying to login if the server is outside your LAN):

If you are not a DB Admin ask the DB Admin to add your system IP as well.

1 Like