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:
- root mysql pass
- admin mysql pass
- 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
They are database passwords for various database users you have installed in the VM. The root mysql pass is obviously the password the the mysql superuser which can do anything.
https://www.a2hosting.com/kb/developer-corner/mysql/managing-mysql-databases-and-users-from-the-command-line