Magento does not accept new database data

Question

They just moved the magento installation to the local server so I can work on it a bit.

Changed the data of my database in /app/etc/local.xml

Cleared cache and session by deleting / var / cache / * and / var / session / *

Magento still throws an error saying that it cannot connect to the database using theolduser @localhost.

It drives me crazy. What can I lose.

Answer 1

I encountered the same problem once that eats for many hours. Finally, I found that my database was not completely migrated. The database table score was mapped on the local and demo server. Due to limitations, a part of the database error was not imported.

SET FOREIGN_KEY_CHECKS=0; // top of your exported sql file //Your database queries SET FOREIGN_KEY_CHECKS=1; // bottom of your exported sql file 

The Magento community wiki contains an article on migrating a Magento server to a server

You can check the database connection by the main php file mysql connection.create as the db.php file in the root directory and add the following code with your db configuration and execute this file to check for the connection or not.

example: -

$ conn = mysql_connect ("Your_Host", "User_Name", "Password"); if (mysql_select_db ("Your_DB_name", $ conn)) echo "yes"; else echo "no";

It can help you.