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.
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.

Postby 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.

Postby 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.

Postby 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: 168
Joined: Tue Nov 08, 2005 12:58 pm
Location: Kent, England, UK
Contact:

Re: How to change mysql password.

Postby 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: 276
Joined: Fri May 30, 2008 12:36 pm
Location: Redhill
Contact:

Re: How to change mysql password.

Postby 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.

Postby jdavis74 » Wed Oct 21, 2009 11:36 pm

Joseph Davis
Technical Support Representative
jdavis@hosting.com
http://hosting.com

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

Re: How to change mysql password.

Postby 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
jdavis@hosting.com
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.

Postby 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: 3082
Joined: Sun Jan 03, 2010 8:47 pm
Contact:

Re: How to change mysql password.

Postby 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


Return to “Security - 1.0.x”

Who is online

Users browsing this forum: No registered users and 4 guests