Page 1 of 1

How to change mysql password.

Posted: Fri Mar 03, 2006 5:48 pm
by whiteknuckleairlines
Is there a document or can someone tell me how to change the mysql pw for my joomla installation...

Re: How to change mysql password.

Posted: Fri Mar 03, 2006 5:57 pm
by whiteknuckleairlines
Nevermind.  I think I got it...

Re: How to change mysql password.

Posted: Sat Mar 04, 2006 7:55 am
by jeffr
Hi

Im new to this, I changed the password on my mysql database now Joomla doesnt work. I get a screen that tells me it is under maintenance.
To run joomla I had to remove the password from the site. Can someone explain how this works and what I should do

thanks

J

Re: How to change mysql password.

Posted: Sat Mar 04, 2006 10:51 am
by Peter Clements
jeffr wrote: Hi

Im new to this, I changed the password on my mysql database now Joomla doesnt work. I get a screen that tells me it is under maintenance.
To run joomla I had to remove the password from the site. Can someone explain how this works and what I should do

thanks

J
You'd need to manually edit the configuration.php file:

Code: Select all

$mosConfig_password = 'NEWPASSWORD';
before Joomla! will start working again!

Re: How to change mysql password.

Posted: Tue Mar 17, 2009 4:18 pm
by Donethat
Peter Clements wrote:
jeffr wrote: Hi

Im new to this, I changed the password on my mysql database now Joomla doesnt work. I get a screen that tells me it is under maintenance.
To run joomla I had to remove the password from the site. Can someone explain how this works and what I should do

thanks

J
You'd need to manually edit the configuration.php file:

Code: Select all

$mosConfig_password = 'NEWPASSWORD';
before Joomla! will start working again!
I changed the password in the config file as suggested here and it didn't have any effect and was still working with the old password. I suspect it is something else that isn't correct.

I do have another concern that the config file would appear to be something of a security risk sitting in the root folder. When doing my own stuff I have always placed files like this outside the root folder. I mention this as I have just had my site badly hacked and the form script used to send spam. I've had to restore the whole site and thus the need to change passwords.

All the best

Donethat

Re: How to change mysql password.

Posted: Wed Oct 21, 2009 11:36 pm
by jdavis74

Re: How to change mysql password.

Posted: Wed Oct 21, 2009 11:38 pm
by jdavis74
Didn't read the whole post...

How did you change the MySQL password? You should have used the GRANT command:

GRANT ALL ON db_name.* TO user@'%' IDENTIFIED BY 'password';

FLUSH PRIVILEGES;

If you don't flush privileges the password won't update until you restart MySQL.

Re: How to change mysql password.

Posted: Tue Aug 02, 2016 3:28 pm
by Noob13
whiteknuckleairlines wrote:Nevermind.  I think I got it...
Where?!!! That's exactly what I need to do...!

Re: How to change mysql password.

Posted: Tue Aug 02, 2016 3:35 pm
by ribo
This can be done from your host control panel. You edit the password of user that assign in your database