Changing SQL Database Password with HeidiSQL

This is used for general discussion that is not necessarily server-related.
Post Reply
sgtcookie
New to forums
New to forums
Posts: 4
Joined: Wed Apr 04, 2018 12:56 pm

Changing SQL Database Password with HeidiSQL

Post by sgtcookie » Wed Apr 04, 2018 1:06 pm

Hi,
I'm trying to change the password on my sql database i'm using heidi,
from what i understood, you need to go to user manager and change it here, but i have many "hosts" :
-local host
-::1
-%
-127.0.0.1
-win-*****

So my question is more if i want to change the password which host do i choose ? Just one or all of them ?
and should i put the same password ?

User avatar
Juski
Staff
Staff
Posts: 145
Joined: Sun Dec 07, 2014 5:04 pm
Location: Seattle, WA

Re: Changing SQL Database Password with HeidiSQL

Post by Juski » Wed Apr 04, 2018 1:43 pm

Are you trying to change the password on a database hosted on our website hosting, or on a database you have set up on an unmanaged system (VDS/dedicated machine)?
[9-13-15] [18:10] <@TimeX-NFo> My muskrat brings all the boys to the yard!
[5-20-16] [12:57] <@Kraze^NFo> Juski has a very valid point

sgtcookie
New to forums
New to forums
Posts: 4
Joined: Wed Apr 04, 2018 12:56 pm

Re: Changing SQL Database Password with HeidiSQL

Post by sgtcookie » Wed Apr 04, 2018 1:45 pm

Dedicated Machine

User avatar
Vanderburg
Staff
Staff
Posts: 1056
Joined: Sat Nov 13, 2010 7:27 am
Location: Houston, TX

Re: Changing SQL Database Password with HeidiSQL

Post by Vanderburg » Thu Apr 05, 2018 11:12 am

The MySQL documentation has instructions for this for various operating systems, here: https://dev.mysql.com/doc/refman/5.7/en ... sions.html

sgtcookie
New to forums
New to forums
Posts: 4
Joined: Wed Apr 04, 2018 12:56 pm

Re: Changing SQL Database Password with HeidiSQL

Post by sgtcookie » Thu Apr 05, 2018 2:03 pm

Is there a way to do that with HeidiSQL ?

hnltransportation
New to forums
New to forums
Posts: 1
Joined: Thu Apr 05, 2018 4:20 pm

Re: Changing SQL Database Password with HeidiSQL

Post by hnltransportation » Thu Apr 05, 2018 4:30 pm

Im late to the game but I changed mysql passcode recently on nfoservers, now my website is off line. How do i get the website back up if I cant even log into the website (wordpress) from the backend?

Anyone know what this means"You would need to do this my modifying the files in FTP. You can access the FTP of your website using an FTP client, like FileZilla, using the credentials listed on the File manager tab of your webhosting control panel."

User avatar
Edge100x
Founder
Founder
Posts: 11858
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: Changing SQL Database Password with HeidiSQL

Post by Edge100x » Sun Apr 29, 2018 10:14 pm

That instruction appears correct, hnltransportation. With WordPress specifically, the file that you'd be looking for is called wp-config.php. There will be a line that looks like this that would need to be changed:

define('DB_PASSWORD', 'OldPassword');

sgtcookie
New to forums
New to forums
Posts: 4
Joined: Wed Apr 04, 2018 12:56 pm

Re: Changing SQL Database Password with HeidiSQL

Post by sgtcookie » Fri May 18, 2018 1:15 am

well i guess my server will stay with the same password thank you anyway ^^

User avatar
Edge100x
Founder
Founder
Posts: 11858
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: Changing SQL Database Password with HeidiSQL

Post by Edge100x » Fri May 18, 2018 9:39 pm

Your DB password is the same for any database that you use from the same account, if that is what you mean. Changing the password means updating it in each application. This is usually easy to do, as with the WordPress example here, with a configuration file edit.

Post Reply