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
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Wed Apr 04, 2018 12:56 pm

Changing SQL Database Password with HeidiSQL

Post by sgtcookie »

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
Former staff
Former staff
Posts: 147
Joined: Sun Dec 07, 2014 5:04 pm
Location: Seattle, WA

Re: Changing SQL Database Password with HeidiSQL

Post by Juski »

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 »

Dedicated Machine
User avatar
Vanderburg
Former staff
Former staff
Posts: 1253
Joined: Sat Nov 13, 2010 7:27 am
Location: Dallas, TX

Re: Changing SQL Database Password with HeidiSQL

Post by Vanderburg »

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 »

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 »

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: 12945
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: Changing SQL Database Password with HeidiSQL

Post by Edge100x »

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 »

well i guess my server will stay with the same password thank you anyway ^^
User avatar
Edge100x
Founder
Founder
Posts: 12945
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: Changing SQL Database Password with HeidiSQL

Post by Edge100x »

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