Question
Is there any other ways to connect to DB cluster under Ubuntu 16.04 MySQL 5.x ?
- Posted September 14, 2019
- MySQLDatabasesUbuntu 16.04
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 ?
Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Sign in to AnswerThese 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.
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
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