Related

Product Now Available: Managed MySQL Databases Product
Managed MySQL, Redis, Postgres on DigitalOcean Product
Why i can't create database for installing WordPress? Question Question
PHP Error Log: authz_core:error - For files that don't exists on my server Question Question

Question

Is there any other ways to connect to DB cluster under Ubuntu 16.04 MySQL 5.x ?

Posted September 14, 2019 799 views
MySQLUbuntu 16.04Databases

We are just done adding DB cluster, but according to this article https://www.digitalocean.com/docs/databases/mysql/how-to/connect/ we can only connect to DB cluster if we use MySQL 8.x

Currently we are using MySQL 5.x under Ubuntu 16.04 and don’t want to risk our production server with update process.

We are trying to connect through ssh terminal and the connection always failed with error message :
ERROR 2026 (HY000): SSL connection error: unknown error number

Is there any other ways to connect to DB cluster ?

Add a comment
mangprangstore
By:
mangprangstore
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 September 14, 2019

Hello,

You could use a client like TablePlus that you install on your PC/Mac and connect to the cluster remotely from your local machine.

Another option would be to just create a small droplet and install MySQL 8.x client there and use the droplet as a hub to connect to your managed database cluster.

Hope that this helps!
Regards,
Bobby

Reply Report
mangprangstore November 14, 2019

Case Closed :)
Finally i had to deploy new droplet with Ubuntu 18.04.3, PHP7.3, MySQL 8.0 and use it to connect into the DB Cluster.
I’m Also installing PhpMyAdmin for easily managing the databases on the DB Cluster.

@see [https://www.digitalocean.com/community/questions/how-to-connect-into-db-cluster-with-phpmyadmin](http://)

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help