2

I'm trying to move the database from a magento store to a separate server, but i have problems connection to it. I know I've got to edit the local.xml in /app/etc, but i am not sure about the syntax.

<host><![CDATA[localhost]]></host>

Can you give me an example according to the line above?

arserbin3
  • 6,010
  • 8
  • 36
  • 52
user1230718
  • 21
  • 1
  • 2

1 Answers1

5

Domains: 

<host><![CDATA[mydatabaseserver.com]]></host>

IP's

<host><![CDATA[192.168.1.1]]></host>
Bart Vangeneugden
  • 3,436
  • 4
  • 33
  • 52
  • Thanks for your response. This sounds quite reasonable, this was also my attempt. Surprisingly that doesn't do it. I get following error-report from the store system. `a:4:{i:0;s:71:"SQLSTATE[HY000] [2003] Can't connect to MySQL server on '10.1.0.9` – user1230718 Feb 27 '12 at 14:38
  • Did you delete everything in `var/cache`? http://www.magentocommerce.com/boards/viewthread/12883/ – Bart Vangeneugden Feb 27 '12 at 14:41
  • Yes, after every change i deleted the whole cache to make that sure. – user1230718 Feb 27 '12 at 14:57
  • You need to make sure your MySQL server also allows connections from remote IPs. Use bind-address = 0.0.0.0 for all addresses in my.cnf or set the specific IP using the same syntax. – scampbell Jun 07 '13 at 15:56