How to connect to a database on DATABASE CLUSTERS

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

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!

Use the MySQL client to connect to your database with the information you’ve gathered:

mysql -h hostname_or_IP -u username -p -D database_name`

You will be prompted to enter the password for the username you specified. Replace hostname_or_IP, username, and database_name with your actual data cluster’s details.

Interact with the Database:

Once connected, you can run SQL queries to interact with your database. For example:

SHOW TABLES; SELECT * FROM table_name;`

Replace table_name with the name of the table you want to query.

Always ensure that your database credentials are kept secure and never expose them publicly. Additionally, consider using encrypted connections (SSL/TLS) when connecting to your database, especially if the connection is over the internet.