Simple Machines Community Forum

SMF Support => Server Performance and Configuration => Topic started by: Sethv2 on September 28, 2014, 03:07:19 PM

Title: I'm worried about resetting my database password
Post by: Sethv2 on September 28, 2014, 03:07:19 PM
I want to look around in my current database. I'm also playing with the idea of setting up a second SMF installation using the user database from the first to have a single login for both. However, I don't have the password for the database my current SMF installation is using. I checked in settings.php, but that password doesn't work with the db_user it's assigned to. I can reset the password for the MySQL database easily enough. However, I'm concerned that simply typing the new password into settings.php may not work and I wanted to check here first.
Title: Re: I'm worried about resetting my database password
Post by: CoreISP on September 28, 2014, 04:01:49 PM
Quote
I checked in settings.php, but that password doesn't work with the db_user it's assigned to.

That sounds a bit strange, as your forum wouldn't be functioning if those login details are incorrect...
You're not including the quotes right? eg if it says the password is 'hello123'; then the password is: hello123.
If you change the password and update Settings.php to reflect the change, it should work just fine.
Title: Re: I'm worried about resetting my database password
Post by: Kindred on September 28, 2014, 06:25:20 PM
also...

setting up a second SMF installation using the user database from the first to have a single login for both.

What you suggest is NOT the way to do it and won't work...
if you want two sites with the same login, look into the pmx-subforums ir split forums mods...
Title: Re: I'm worried about resetting my database password
Post by: Sethv2 on October 01, 2014, 11:27:00 AM
Thanks for the heads up about how to share the log in. I figured out I needed to enter the $db_server as my username instead of $db_user.
Title: Re: I'm worried about resetting my database password
Post by: CoreISP on October 01, 2014, 12:27:35 PM
That makes no sense at all. But glad you sorted it. :/
Title: Re: I'm worried about resetting my database password
Post by: Sethv2 on October 01, 2014, 12:32:59 PM
Basically, this:

$db_server = '<user log in>';
$db_name = '<not user log in>';
$db_user = '<not user log in>';
$db_passwd = '<password>';

I had been trying to use what was entered in for $db_user as my username when logging into the database with phpMyAdmin. So I was using the correct password, but the wrong log in name.
Title: Re: I'm worried about resetting my database password
Post by: CoreISP on October 01, 2014, 12:34:49 PM
$db_user is supposed to be the username you need to login with.
And it apparently works just fine from your SMF install; otherwise you'd constantly have a connection error displaying instead of a forum.
Not sure what you're doing, or how you're logging in, but the way you explain it sounds rather bizarre.
Title: Re: I'm worried about resetting my database password
Post by: Sethv2 on October 01, 2014, 12:40:15 PM
I always thought I used the name of the database as my log in as well. Dunno. Maybe it's got something to do with godaddy (my host).
Title: Re: I'm worried about resetting my database password
Post by: Kindred on October 01, 2014, 02:29:09 PM
no...   the database name is NOT the same as the username (at least not typically - and almost certainly not on GoDaddy)