XF 2.1 MYSQL Password issues

[FDudeH]

I'm trying to log onto mysql as root and the password isn't working, and I'm afraid we may have lost it. If I shut down mysql so I can reset the password will that cause any problems with Xenforo when I restart mysql?

 

[Anomandaris]

Not really, just update the password in config.php once you have the new password

if you wanna be really cautious:

• Set your forum to inactive in the ACP
• stop apache or nginx
• stop mysql
• reset password
• update password in config.php
• start mysql
• start apache/nginx
• turn forum back on in ACP

 

[FDudeH]

The root password was not stored in the config.php file. That was the first place I looked for it.

Is there any reason it needs to be there?

 

[Paul B]

The config file only requires the user and password for the database XF is associated with.

 

[Anomandaris]

ah, didn't see the "root" part nevermind the config.php part