Jump to content


Connecting to MYSQL CLUSTER

digitalocean mysql cluster

2 replies to this topic

#1 princechrisvic

    Member

  • Members
  • PipPip
  • 13 posts

Posted 07 September 2019 - 08:15 AM

Good day,

I am trying to install livezilla but database cannot connect because I am not using localhost. I am using digitalocean mysql database cluster. The host is not Localhost. It is db-mysql-nno2-1973-do-user-3137922-0.db.ondigitalocean.com

I keep getting this error

Can't connect to database. Invalid host or login! (2002: Connection timed out)

Edited by princechrisvic, 07 September 2019 - 08:16 AM.


#2 Patrick Keil

    Administrator

  • Administrators
  • 3854 posts
  • LocationSingen, Germany

Posted 09 September 2019 - 01:16 PM

Hi,

Did you check this FAQ entry?

https://chat.livezil...-access-denied/

Hope that helps.

#3 princechrisvic

    Member

  • Members
  • PipPip
  • 13 posts

Posted 11 September 2019 - 03:19 AM

View PostPatrick Keil, on 09 September 2019 - 01:16 PM, said:

Hi, Did you check this FAQ entry? https://chat.livezil...-access-denied/ Hope that helps.

I connected to the same database using phpstorm, navicat, datagrid. All connected without issue. I think the issue might be from the connection port. Mysql on most cases uses port 3306 to connect. However, the Digitalocean mysql uses port 25060. I noticed this when trying to connect with Navicat and also Phpstorm. If I use port 3306, it won't connect but if I switched to 25060, it will connect.

In Livezilla, there is no where to change the port

Please can you test it on digitalocean to see if it will connect





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users