Question

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

Posted October 14, 2018 1k views
MySQL

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

1 comment

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

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 adminmysqlpass from the /root/.digitalocean_password file

Regards,
KDSys

Submit an Answer