Question

MySQL ACCESS information

Posted February 11, 2020 273 views
DigitalOcean Managed MySQL Database

How do I get access to MySQL since there is no PHP myadmin available here

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.

×
1 answer

Hello, @avinashkrishnani

The managed databases can be accessed via MySQL database client like MySQL Workbench or SQL pro. In order to access a Digital Ocean Managed MySQL database, you will need to install version 8.0 or above. Also make sure to allow your IP in the trusted hosts for the database.

You can follow the official step by step instructions on how to connect to the managed MySQL servers here:

https://www.digitalocean.com/community/tutorials/how-to-connect-to-managed-database-ubuntu-18-04#connecting-to-a-managed-mysql-database

Regards,
Alex

by Mark Drake
If you're new to working with managed databases, the best way to perform certain tasks, like connecting to the database, may not be self-evident. In this guide, we will go over how to install client programs for a variety of database management systems, including PostgreSQL, MySQL, and Redis, on an Ubuntu 18.04 server. We'll also explain how to use these programs to connect to a managed database instance.
Submit an Answer