Problem with connect to MySQL

[Shamy]

Hi, I want to connect to a MySQL database in order to show the sun hours in the sunplot graphic.
I created such a database in my provider's admin panel (OVH.com) and there is a problem because Cumulus returns an error:
"Error: Unable to connect to any of the specified MySQL hosts."

the problem is that all data are entered correctly, I can normally log in to the database via a browser and PhpMyAdmin...

settings.jpg

[mcrossley]

By default, most MySQL logins do not allow remote login, it is something you have to configure either when you create the user, or afterwards by altering the login details directly.

Also, the MySQL instance itself may have a setting that disables remote login globally.

[Nossie]

that hostname does not look right to me :-/

and as an FYI remote login hostnames can be different

EDIT: to add to what Mark said, default port for mysql is 3306

[mcrossley]

Also 8080 would be an unusual port number - is that correct?

[mcrossley]

that hostname does not look right to me :-/

True!

[Shamy]

Okay, I changed port to 3306.

The rest is entered correctly, 100%. From control panel:

mysql.jpg

I haven't seen an option to set up a remote connection - although the connection to the database is established through php scripts

[mcrossley]

As above, that is not an internet resolvable server name, it looks like an instance name, possibly?

[mcrossley]

What do you get from the (?) on the "server address"?

[Nossie]

Shamy - I haven't looked into this much but I did find this that concerns me with what you are trying to do.


https://stackoverflow.com/questions/617 ... ame-in-ovh

This database is on a private network, accessible only from your OVH WebHosting offer through OVH internal DNS.

As OVH WebHosting offer can only host PHP apps, and as the error message you are providing seems to be a Java one, I suppose you are trying to connect to this database from outside your WebHosting offer, which cannot work.

If you need a database accessible from everywhere, you need an OVH CloudDB, not a private DB as you currently have.

Also note that it is really advised to use the hostname of your database, and not the IP directly, as it can change over the time, as stated in your OVH Manager:

[Shamy]

Ohhh ;( Thanks @Nossie