Related

Product Now Available: Managed MySQL Databases Product
Need help to troubleshoot mysqlnd_ms setup on PHP72 with php-fpm Question Question
Hi, I am not familiar with droplets and linux whats the easiest way to access my files Question Question

Question

How to connect to a database on DATABASE CLUSTERS

Posted June 4, 2020 282 views
MySQLCentOS 8

I just created a droplet on Centos 8 and a data cluster to store MySQL database

How do I access the database from centos?

Add a comment
cpeters5
By:
cpeters5
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers
bobbyiliev June 4, 2020

Hi there @cpeters5,

I would recommend using the mysql client command-line tool. You could follow the steps on how to do that here:

https://digitalocean.com/docs/databases/mysql/how-to/connect/

Hope that this helps!
Regards,
Bobby

Reply Report
  • cpeters5 June 4, 2020

    I followed the instruction in the tutorial you gave. After installing mysql on local machine (centos 8), I started mysql and ran the command

    mysql -u doadmin -p <doadmin password> -h db-mysql-nyc3-77401-do-user-7579068-0.a.db.ondigitalocean.com -P 25060 -D defaultdb

    I got connection error
    ERROR 2003 (HY000): Can’t connect to MySQL server on ‘db-mysql-nyc3-77401-do-user-7579068-0.a.db.ondigitalocean.com’ (110)

    I tried various things: allow port 25060, turned off firewalld but still cannot connect.

    Any idea how to resolve this?

    Reply Report
    • cpeters5 June 4, 2020

      It is strange that I am able to access the database from my desktop, using the same information (doadmin, password, port, host)
      BUT I cannot connect to mysql on Centos from desktop. Got the same error 2003

      On the contrary, @Centos I have no problem accessing the local mysql, but cannot connect to Mysql on the cluster

      Reply Report
cpeters5 June 4, 2020

I solved connection problem. I forgot to update trusted sources after deleting and recreating the current droplet.

But now I get a different error code. I will post this error in a new question.
Thanks!

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help