Magento News

 

Resetting the MySQL Database Password

Hello,

I’ve inherited a Magento v1.3.2.4 store and would like to make a backup of it for testing purposes.  I’ve followed the steps here:

Moving Magento To Another Server

My problem arises when I go to dump the MySQL database -I don’t know the password, nobody does.  SSH does not give an error, but instead makes a 1k file that is useless.  Looking in /app/etc/local.xml I see:


<host><![CDATA[localhost]]></host>
                    <username><![CDATA[magento_iTAYXma]]></username>
                    <password><![CDATA[C3d7EwRIlM7WS]]></password>
                    <dbname><![CDATA[magento_iTAYXma]]></dbname>
                    <active>1</active>

… that password does not work (makes a 1k file from a 700MB database), but I can get into phpMyAdmin to reset the password, which leads me to my question:

What will need to be changed on the Magento side after resetting the MySQL password?

The existing site works just fine, I don’t want to screw anything up.  Do I just change the password line in local.xml to the new password?  Too easy, that can’t be it.  Maybe I am going about this all wrong (?), I don’t know.  Help!

Resetting the MySQL Database Password

Possibly Related Posts:


 

Leave a Reply