Cannot access mySQL database

  • 87Views
  • Last Post 21 November 2017
  • Topic Is Solved
0
votes
Bart De Kimpe posted this 14 November 2017

Hi,

I added my mySQL connection but I receive the following error message:

Host '40.118.246.204' is not allowed to connect to this MariaDB server

Kind Regards,

Bart

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 15 November 2017

40.118.246.204


Skyvia uses the following static IP address to access your MySQL database. This IP should be whitelisted.

When working with MySQL connections, the main requirement is that your MySQL database must be available through the Internet.
If connecting to database on the local computer, it is required to allow such connections in your firewall. 
If connecting to a computer in the local network, it is necessary to use port forwarding.

Please also refer to: https://skyvia.com/resources/docs/index.html?mysql_connections.htm

If we can assist you any further, don't hesitate to contact us.

0
votes
Bart De Kimpe posted this 15 November 2017

Hey Mariia,

I already did that also and still the same error. It is a database on a website.

Kr,

Bart

0
votes
Simon Bubnov posted this 15 November 2017

Can you connect to your MariaDB server from other place, for example your computer?

Please also take a look at https://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server. Does any solution described in this topic help you?

0
votes
Bart De Kimpe posted this 15 November 2017

Hi,

I also have problems connecting it through my PC.

 

I had a look at that stackoverflow but it seems I don't enough permissions to execute that SQL statement.

Kr,

Bart

0
votes
Simon Bubnov posted this 16 November 2017

 I also have problems connecting it through my PC.

It means that your server do not allow connecting from outside. The stackoverflow link describes various ways of solving this problem on the server side. Unfortunately, this is a MySQL issue, not Skyvia's. Thus, you should configure MySQL server on your side. And if you do not have required permissions, contact your database administrator to make your server available from the Internet.

0
votes
Bart De Kimpe posted this 21 November 2017

There was something wrong on the providerside. This is solved and works

Close