Question
Is there any other ways to connect to DB cluster under Ubuntu 16.04 MySQL 5.x ?
- Posted on September 14, 2019
- MySQLDatabasesUbuntu 16.04
Asked by mangprangstore
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 ?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
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