Hello, I am having an Error connecting to the database from my cPanel, I even copied the MySQL connection string from the Aiven Console, and tried it on the terminal, but it still did not work.
I am always getting “ERROR 2002 (HY000): Can’t connect to server on ‘----------.i.aivencloud.com’ (115)”
My Public IP filter is set to “Open to all”
Note: I am using a shared hosting, I don’t know if this could be the problem.
If this issue is still unresolved… would you mind providing the step-by-step of what you did in cPanel (for example: are you using the Remote MySQL Connection option? What specifically did you put in each field?)
Yes, I was able to resolve the issue, the problem was that my hosting blocked the port by default and I could not connect to the DB since it was blocked.
I contacted them to unblock the port, and I was able to connect.