In Terminal, I run the code: mysql_secure_installation
, then it asks me for this:
Enter current password for root (enter for none):
It said earlier: The passwords for MySQL have been saved to: /root/.digitalocean_password
So I typed this in: cat /root/.digitalocean_password
to retrieve that password.
But then I got this: cat: /root/.digitalocean_password: No such file or directory
I’m really lost. How do I get the MySQL password if I get the error of “No such file or directory?” All help is appreciated, thanks
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 @confused5000
I’ve just tried to spin up a LAMP 16.04 (on NYC2), and it shows the password in that file. If you run this:
You should get a list of 4 files and 2 directories:
Otherwise you can reset the MySQL root password by following this tutorial: https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password