How to change mysql password.
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.
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.
- whiteknuckleairlines
- Joomla! Intern
- Posts: 76
- Joined: Fri Jan 13, 2006 8:39 pm
- Location: Atlanta, GA
- Contact:
How to change mysql password.
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!
- whiteknuckleairlines
- Joomla! Intern
- Posts: 76
- Joined: Fri Jan 13, 2006 8:39 pm
- Location: Atlanta, GA
- Contact:
Re: How to change mysql password.
Nevermind. I think I got it...
Computers, Airplanes.. I can crash it all!
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sat Mar 04, 2006 7:37 am
Re: How to change mysql password.
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
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
- Peter Clements
- Joomla! Enthusiast
- Posts: 172
- Joined: Tue Nov 08, 2005 12:58 pm
- Location: England
- Contact:
Re: How to change mysql password.
You'd need to manually edit the configuration.php file: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
Code: Select all
$mosConfig_password = 'NEWPASSWORD';
-
- Joomla! Explorer
- Posts: 434
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Re: How to change mysql password.
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.Peter Clements wrote:You'd need to manually edit the configuration.php file: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
before Joomla! will start working again!Code: Select all
$mosConfig_password = 'NEWPASSWORD';
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
www.cavespider.co.uk
-
- Joomla! Explorer
- Posts: 443
- Joined: Fri Jul 03, 2009 5:38 pm
Re: How to change mysql password.
You can edit the passwords manually in the MySQL database:
http://docs.joomla.org/Resetting_a_user_password
http://docs.joomla.org/How_you_reset_an ... assword%3F
http://docs.joomla.org/Resetting_a_user_password
http://docs.joomla.org/How_you_reset_an ... assword%3F
-
- Joomla! Explorer
- Posts: 443
- Joined: Fri Jul 03, 2009 5:38 pm
Re: How to change mysql password.
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.
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.
- Noob13
- Joomla! Apprentice
- Posts: 46
- Joined: Tue Jul 12, 2016 4:23 pm
- Location: Toronto, Canada
Re: How to change mysql password.
Where?!!! That's exactly what I need to do...!whiteknuckleairlines wrote:Nevermind. I think I got it...
- ribo
- Joomla! Virtuoso
- Posts: 3507
- Joined: Sun Jan 03, 2010 8:47 pm
- Contact:
Re: How to change mysql password.
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