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 ?
Changing SQL Database Password with HeidiSQL
-
- New to forums
- Posts: 4
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Wed Apr 04, 2018 12:56 pm
Re: Changing SQL Database Password with HeidiSQL
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
[5-20-16] [12:57] <@Kraze^NFo> Juski has a very valid point
Re: Changing SQL Database Password with HeidiSQL
Dedicated Machine
- Vanderburg
- Former staff
- Posts: 1253
- Joined: Sat Nov 13, 2010 7:27 am
- Location: Dallas, TX
Re: Changing SQL Database Password with HeidiSQL
The MySQL documentation has instructions for this for various operating systems, here: https://dev.mysql.com/doc/refman/5.7/en ... sions.html
Re: Changing SQL Database Password with HeidiSQL
Is there a way to do that with HeidiSQL ?
-
- New to forums
- Posts: 1
- Joined: Thu Apr 05, 2018 4:20 pm
Re: Changing SQL Database Password with HeidiSQL
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."
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."
Re: Changing SQL Database Password with HeidiSQL
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');
define('DB_PASSWORD', 'OldPassword');
Re: Changing SQL Database Password with HeidiSQL
well i guess my server will stay with the same password thank you anyway ^^
Re: Changing SQL Database Password with HeidiSQL
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.