Forgot MySQL password


I setup Nextcloud over a year ago, currently running 14.0.3, and set it up with MySQL, 10.1.26 (originally, now using 10.1.37-MariaDB).

My cloud is working great! 3 cheers for nextcloud!!

However, I forgot my mySQL password, when I originally set it up, and would like to setup another database.

All the while, NOT disrupting my wonderfully flowing nextcloud.

Any hints, idea about the best way to proceed?

I am getting the common: “Error 1045 (28000): Access denied for user root” message.

Thanks in advance.

You can find the MySQL password for Nextcloud in nextclouds configuration file config.php.

Thanks I will give it a look.

I found what appears to be a hashed value, but it could very well be the password, in which case, it didn’t resolve my issue. I am clearing nextcloud from any culpability =9 and will bear down more on some mysql particular quirk.

No, that is a cleartext password.

If nothing else works… MySQL does offer a way to reset the root password at startup, as described in the documentation:

1 Like

Thanks for the help.

After scouring my notes more thoroughly, I found the root password!