Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Change MySQL password
 
skitpt
Jr. Member
 
Total Posts:  17
Joined:  2008-05-09
 

Hello there,

I have a store already in use and all configured. I would like to change the mysql password without having to reisntall the whole thing again, is it possible ?

I have read that i should change the local.xml i have changed the password there but i get a lot of erros after that. I’m sure the password i use in the local.xml is the same as in the phpmyadmin. If i change it back to the original (in booth phpmyadmin and local.xml) everything is good again.

What am i doing wrong ? Is there any other file that keeps the mysql password ?

Thank you,
André Costa

 
Magento Community Magento Community
Magento Community
Magento Community
 
skitpt
Jr. Member
 
Total Posts:  17
Joined:  2008-05-09
 

Anyone ? This is really important!

 
Magento Community Magento Community
Magento Community
Magento Community
 
skitpt
Jr. Member
 
Total Posts:  17
Joined:  2008-05-09
 

This should be something easy to do.

I really like the Magento product but i have to say the support team is useless.
I need an answer for only two questions, should i pay 500$ ( ! ) for that ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
magento-marie
Member
 
Avatar
Total Posts:  37
Joined:  2008-06-01
France
 

Hello people,

I’m refreshing this thread.
Does anyone can help us and tell where we can find the informations about sql database and password?

Thanks a lot!
Marie

 
Magento Community Magento Community
Magento Community
Magento Community
 
spabhat
Jr. Member
 
Avatar
Total Posts:  7
Joined:  2008-05-22
 

I am not sure whether you already got this information.

These settings are located in a XML file which can be located at /app/etc/local.xml

You need to change the information in the following tags:

<default_setup>
                <
connection>
                    <
host><![CDATA[localhost]]></host>
                    <
username><![CDATA[username]]></username>
                    <
password><![CDATA[mydbpassword]]></password>
                    <
dbname><![CDATA[mydbname]]></dbname>
                    <
active>1</active>
                </
connection>
            </
default_setup>
 
Magento Community Magento Community
Magento Community
Magento Community
 
issa
Jr. Member
 
Total Posts:  1
Joined:  2008-07-16
 

Hello,

I’m also interested in the solution for this case even if I’m dealing with a slightly different problem that is how to change database name used by magento.

spabhat - 15 July 2008 09:06 PM

I am not sure whether you already got this information.

These settings are located in a XML file which can be located at /app/etc/local.xml

You need to change the information in the following tags:

<default_setup>
                <
connection>
                    <
host><![CDATA[localhost]]></host>
                    <
username><![CDATA[username]]></username>
                    <
password><![CDATA[mydbpassword]]></password>
                    <
dbname><![CDATA[mydbname]]></dbname>
                    <
active>1</active>
                </
connection>
            </
default_setup>

I already tried that in my case but that doesn’t seem to work for me.

thans in advance for your help wink

 
Magento Community Magento Community
Magento Community
Magento Community
 
guillaume14
Jr. Member
 
Total Posts:  2
Joined:  2008-04-07
 

Worked like a charm for me.

Thanks
Guillaume

 
Magento Community Magento Community
Magento Community
Magento Community
 
nikefido
Guru
 
Avatar
Total Posts:  481
Joined:  2008-07-11
New Haven, CT
 

that is changing the mysql database password that magento uses to attempt to connect to the DB.

If you are trying to change the actual password, that is not done via Magento, but is usually done with a control panel provided for you by your web hosting.

The above solution should work if you want to change the password that magento uses to connect to the DB. If it does not, the problem may be a misspelled password (or host, or username, etc), or it could be that you have not properly set up a user to control your magento database in your hosting control panel.

 
Magento Community Magento Community
Magento Community
Magento Community
 
dantecor
Jr. Member
 
Total Posts:  1
Joined:  2009-03-12
 

Hope this will help someone as it seems that this forum is useless.

Magento creates a cached file with the old passowrd stored inside:

var/cache/mage--c/mage---CONFIG_GLOBAL

Just remove that file and problem solved.

If you cannot find that file and you are using Linux, just write this command to find the file that holds your password:
grep -H yourpassword magneto/* -R | cut -d: -f1

DanteCor.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Chris S
Jr. Member
 
Total Posts:  1
Joined:  2009-02-21
 

Thank you guys sooooo much for posting this thread...you saved me HOURS AND HOURS of more searching. local.xml worked like a charm for me. Thank you so much.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Thejosh13
Sr. Member
 
Total Posts:  252
Joined:  2008-06-23
 

Had to delete cache twice and it worked thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Roc
Jr. Member
 
Total Posts:  6
Joined:  2009-08-07
China-SZ
 

Thanks guys! It worked!

And in case someone like me,try to find config-global in other mage folders if you cant find it in mage-c.

Good luck!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top