Related
Now Available: Managed MySQL Databases
Product
Install MySQL on New Droplet
Question
Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"
Question
Question
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:
- 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
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.
×
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