Forgot MySQL password

ℹ️ Support
1

Hello,

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.

2

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

3

Thanks I will give it a look.

4

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.

5

No, that is a cleartext password.

6

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

https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

1 Like
7

Thanks for the help.

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

8

Where did you find the root password?

9

He found the root password - as he wrote - 5 years ago in his notes.
What is your concern and the reason why you are reopening this 5 year old solved topic?
There is even a link to the description, how to reset the root password

Here a slightly newer Version:
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html

ernolf

10

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.