Report this

What is the reason for this report?

MySQL one click app: Which password to use for what?

Posted on October 14, 2018

Hello, I’ve created a droplet with the one click app option and selected MySQL. It created a droplet with preinstalled MySQL and phpMyAdmin as it should, so everything is working smoothly, but I have a question. It saved 3 passwords in the file located at: /root/.digitalocean_password. There are three passwords:

  1. root mysql pass
  2. admin mysql pass
  3. app mysql pass What are theese passwords for? (I know, they’re passwords from different users from the database) But which password should I use for what?

Thanks for every reply, Best Regards - Jumpak



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.

Hi @jumpak33,

As @X40C has mentioned the root password is for your root user for MySQL. The root user is how to say, the most powerful user on a Linux Machine.

The admin password is for your phpMyAdmin installation. You can reach it by typing in the following

http://YourServerIp/phpmyadmin

There you can use the user admin with the admin_mysql_pass from the /root/.digitalocean_password file

Regards, KDSys

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.