no

How to Fix Lost Connection to Mysql Server in Magento

After I have successfully dumped my database in our hosting server, I've encountered the above error when I open the magento page. Sol...

After I have successfully dumped my database in our hosting server, I've encountered the above error when I open the magento page.

Solution:
1.) Open the file, app/etc/local.xml, and look for the following line:


<default_setup>
<connection>
<host><![CDATA[yourhostname]]></host>
<username><![CDATA[username]]></username>
<password><![CDATA[password]]></password>
<dbname><![CDATA[databasename]]></dbname>
<active>1</active>
</connection>
</default_setup>


Just fill out with your host database settings.

Also, you must make changes in your database:
1.) Open your database using any tool (phpmyadmin, sqlyog, etc)
2.) Explore core_config_data table
3.) Find these path column values:
a.) web/unsecure/base_url
b.) web/secure/base_url
And change the value column to your actual hosted url.

Related

web-platform 2358536403230918188

Post a Comment Default Comments

Outsourcing

Are you looking for freelancers in the Philippines? Get in touch.

Donations

If you like what I do, you can support this channel by buying me a coffee. I would be grateful for your contribution! Your donations will help me create more FREE online courses and learning materials for programmers and remote workers.

item