Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Why i can't create database for installing WordPress? Question Question
After updating bind-address in /etc/msql/my.cnf file MySQL stops working Question Question

Question

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

Posted September 14, 2019 2.3k 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

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Why i can't create database for installing WordPress? Question Question
After updating bind-address in /etc/msql/my.cnf file MySQL stops working Question Question

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.

×
Submit an Answer
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

Related

Looking for something else?

Ask a new question Search for more help