Advertisement:

Author Topic: I'm worried about resetting my database password  (Read 4687 times)

Offline Sethv2

  • Semi-Newbie
  • *
  • Posts: 44
I'm worried about resetting my database password
« 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.

Offline CoreISP

  • Server Admin
  • Server Team
  • SMF Super Hero
  • *
  • Posts: 18,578
  • Gender: Male
  • Liroy van Hoewijk
Re: I'm worried about resetting my database password
« Reply #1 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.
((U + C + I)x(10 − S)) / 20xAx1 / (1 − sin(F / 10))
President/CEO of Simple Machines - Server Manager
Please do not PM for support - anything else is usually OK.

Offline Kindred

  • The Mean One
  • Lead Support Specialist
  • SMF Legend
  • *
  • Posts: 60,427
  • Gender: Male
    • Kindred-999 on GitHub
Re: I'm worried about resetting my database password
« Reply #2 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...
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Offline Sethv2

  • Semi-Newbie
  • *
  • Posts: 44
Re: I'm worried about resetting my database password
« Reply #3 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.

Offline CoreISP

  • Server Admin
  • Server Team
  • SMF Super Hero
  • *
  • Posts: 18,578
  • Gender: Male
  • Liroy van Hoewijk
Re: I'm worried about resetting my database password
« Reply #4 on: October 01, 2014, 12:27:35 PM »
That makes no sense at all. But glad you sorted it. :/
((U + C + I)x(10 − S)) / 20xAx1 / (1 − sin(F / 10))
President/CEO of Simple Machines - Server Manager
Please do not PM for support - anything else is usually OK.

Offline Sethv2

  • Semi-Newbie
  • *
  • Posts: 44
Re: I'm worried about resetting my database password
« Reply #5 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.

Offline CoreISP

  • Server Admin
  • Server Team
  • SMF Super Hero
  • *
  • Posts: 18,578
  • Gender: Male
  • Liroy van Hoewijk
Re: I'm worried about resetting my database password
« Reply #6 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.
((U + C + I)x(10 − S)) / 20xAx1 / (1 − sin(F / 10))
President/CEO of Simple Machines - Server Manager
Please do not PM for support - anything else is usually OK.

Offline Sethv2

  • Semi-Newbie
  • *
  • Posts: 44
Re: I'm worried about resetting my database password
« Reply #7 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).

Offline Kindred

  • The Mean One
  • Lead Support Specialist
  • SMF Legend
  • *
  • Posts: 60,427
  • Gender: Male
    • Kindred-999 on GitHub
Re: I'm worried about resetting my database password
« Reply #8 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)
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."