Forums / Basic Configuration / How do I change the MySQL "localhost" address in my Admin to something else?

How do I change the MySQL "localhost" address in my Admin to something else?

Results 1 to 2 of 2

24 Jun 2012, 3:58 PM

fretty

New Zenner

Join Date:: Sep 2010
Posts:: 59
Plugin Contributions:: 0

How do I change the MySQL "localhost" address in my Admin to something else?

Hi everyone,

My hosting provider is changing their setup and has let all their clients know that we will no longer be able to use "locahost" as our hosting address for any/all MySQL databases.

I have looked everywhere in ZenCart Admin with no luck. Where can I change the host from "localhost" to the new hosting address?

Thanks in advance for any help.

Fretty

24 Jun 2012, 6:15 PM

schoolboy

Totally Zenned

Join Date:: Jun 2005
Location:: Cumbria, UK
Posts:: 10,327
Plugin Contributions:: 0

Re: How do I change the MySQL "localhost" address in my Admin to something else?

Fretty:

Hi everyone,

My hosting provider is changing their setup and has let all their clients know that we will no longer be able to use "locahost" as our hosting address for any/all MySQL databases.

I have looked everywhere in ZenCart Admin with no luck. Where can I change the host from "localhost" to the new hosting address?

Thanks in advance for any help.

Fretty

They appear to be "moving" the databases to a separate server... not a very good move, I don't think. In fact, its a RETROGRESSIVE move - probably doing this so they can stuff their servers with more sites.

I would consider finding a different host if I were you.

In any event... the location of the database is set in your two configure.php files, so you will need to edit these files to point to the new location.

/includes/configure.php
and
YOUR_ADMIN-FOLDER/includes/configure.php

The PERMISSIONS (CHMOD) of these files could be 0444 meaning they will need to be given WRITE permissions before they can be edited. (0644).

When you have edited the files, CHMOD them back to 0444.