how we can access of database for website and reset the logins

Posted August 10, 2020 585 views
Data AnalysisDigitalOcean Managed PostgreSQL DatabaseDigitalOcean Managed MySQL Database

I am new to digital ocean. Old developer did not leave the database link and login details. I need to access the database.

How i can do it?

Please help me.

Thank you

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
1 answer

Hi there @developer17,

If you are using the DigitalOcean managed databases, you can follow the steps on how to manage your database users via this link here:

If you are using a database instance that is installed on your Droplet, you can follow the steps here on how to reset your root password here:

Hope that this helps!

by Mateusz Papiernik
Forgetting passwords happens to the best of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still gain access and reset the password if you have access to the server and a sudo-enabled user account. This tutorial will cover how to...