How to change mysql password.

Discussion regarding Joomla! security issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Security Checklist
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
User avatar
whiteknuckleairlines
Joomla! Intern
Joomla! Intern
Posts: 76
Joined: Fri Jan 13, 2006 8:39 pm
Location: Atlanta, GA
Contact:

How to change mysql password.

Post by whiteknuckleairlines » Fri Mar 03, 2006 5:48 pm

Is there a document or can someone tell me how to change the mysql pw for my joomla installation...
Computers, Airplanes.. I can crash it all!

User avatar
whiteknuckleairlines
Joomla! Intern
Joomla! Intern
Posts: 76
Joined: Fri Jan 13, 2006 8:39 pm
Location: Atlanta, GA
Contact:

Re: How to change mysql password.

Post by whiteknuckleairlines » Fri Mar 03, 2006 5:57 pm

Nevermind.  I think I got it...
Computers, Airplanes.. I can crash it all!

jeffr
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sat Mar 04, 2006 7:37 am

Re: How to change mysql password.

Post by jeffr » Sat Mar 04, 2006 7:55 am

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

User avatar
Peter Clements
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 172
Joined: Tue Nov 08, 2005 12:58 pm
Location: England
Contact:

Re: How to change mysql password.

Post by Peter Clements » Sat Mar 04, 2006 10:51 am

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!

Donethat
Joomla! Explorer
Joomla! Explorer
Posts: 434
Joined: Fri May 30, 2008 12:36 pm
Location: Redhill
Contact:

Re: How to change mysql password.

Post by Donethat » Tue Mar 17, 2009 4:18 pm

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
Perfection is a state of mind, not reality
www.cavespider.co.uk

jdavis74
Joomla! Explorer
Joomla! Explorer
Posts: 443
Joined: Fri Jul 03, 2009 5:38 pm

Re: How to change mysql password.

Post by jdavis74 » Wed Oct 21, 2009 11:36 pm

Joseph Davis
Technical Support Representative
[email protected]
http://hosting.com

jdavis74
Joomla! Explorer
Joomla! Explorer
Posts: 443
Joined: Fri Jul 03, 2009 5:38 pm

Re: How to change mysql password.

Post by jdavis74 » Wed Oct 21, 2009 11:38 pm

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.
Joseph Davis
Technical Support Representative
[email protected]
http://hosting.com

User avatar
Noob13
Joomla! Apprentice
Joomla! Apprentice
Posts: 46
Joined: Tue Jul 12, 2016 4:23 pm
Location: Toronto, Canada

Re: How to change mysql password.

Post by Noob13 » Tue Aug 02, 2016 3:28 pm

whiteknuckleairlines wrote:Nevermind.  I think I got it...
Where?!!! That's exactly what I need to do...!

User avatar
ribo
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3507
Joined: Sun Jan 03, 2010 8:47 pm
Contact:

Re: How to change mysql password.

Post by ribo » Tue Aug 02, 2016 3:35 pm

This can be done from your host control panel. You edit the password of user that assign in your database
chat room spontes : http://www.spontes.com


Locked

Return to “Security - 1.0.x”