Question

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

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

Show comments

Submit an answer

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!

Sign In or Sign Up to Answer

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.

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