Skip to main content
Participant
April 22, 2006
Question

Different local & remote MySQL server names

  • April 22, 2006
  • 1 reply
  • 544 views
My local test server is "localhost" and my remote MySQL server is "abc.defgh.co.uk". Connections to both work OK, but I need to change the MySQL Server name in the MySQL Connection dialogue box depending which server I'm using, as there's only room for one of the server. I can't change the remote MySQL server name to "localhost" and the remote serve won't accept connections from elsewhere. I don't want to have to change the server name everytime I change between testing and uploading. Any suggestions?

Thanks
This topic has been closed for replies.

1 reply

Inspiring
April 22, 2006
Andrew__C wrote:
> My local test server is "localhost" and my remote MySQL server is
> "abc.defgh.co.uk". Connections to both work OK, but I need to change the MySQL
> Server name in the MySQL Connection dialogue box depending which server I'm
> using, as there's only room for one of the server. I can't change the remote
> MySQL server name to "localhost" and the remote serve won't accept connections
> from elsewhere. I don't want to have to change the server name everytime I
> change between testing and uploading. Any suggestions?

Open your local connection file and edit the values. Save the file with
a different name, and upload it to your remote server. On the remote
server rename it to use the same name as locally. That gives you
different connection parameters, but keeps the file names and relative
links the same on different servers.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/
Andrew__CAuthor
Participant
April 22, 2006
Thanks for the response. I'd already thought about this solution, however, everytime you want to upload dependent files - including new recordsets etc, the connection details are also overwritten.